Type: Posts; User: gk53
Search took 0.01 seconds.
why not just simple as...
get every thing from SQL in once
declare @question as table
the problem is new line after
sql="INSERT INTO Users (Email,Password,Role)
it is creates unterminated string...
change sql="INSERT INTO Users (Email,Password,Role)
VALUES ('" & email &...
it is something like that
plat.title AS p_title,
plat.initial AS p_init,
builder.title AS p_builder,
address.city AS p_city,
it is problem there
when you open file as http://site.com/somefolder/file.xls
you open file from your website and you will not be able to save file, becouse excel in local computer does not have...
do you have any specific error? what does in meen its not working...
in dot.net all your configuration in web.config file which must be in your virtual application folder...
set debug="true" inside...
Guys, do you know dot.net? :) I gess yes, so is that version in 3 and higher ajax is build in
after fix your query
$requests_q = mysql_query("
SELECT cnt, id, ord FROM (
SELECT count(*) AS cnt, ava_users.*, 0 AS ord
LEFT JOIN ava_users ...
I think your problem there
$sql = "insert into $table_name values(",'$page_name', '$Page_desc', '$date_added')";
you building sql statement like
insert into myTable values(",'login.php', 'secure...
Just copy your files into virtual folder or root and it is all
I found a problem with your page
You need to remove ; on
str_ini = "SELECT Numero, Nazione, Nome, Wp_date AS [Work Proposal], Ris AS Ris_C, Rev FROM t_mrg WHERE Numero Like '2013044' ORDER BY...
did you tried to print full query and see what you have?
str_last = 'SELECT str_ini.Numero, str_ini.Nazione, str_ini.Nome, str_ini.[Work Proposal], str_ris.Ris_C AS Ris, str_ini.Rev FROM ("...
that is really depence from how youdesign your page. you can reload all posts with number of posts increased or just add more posts on existing page (preferred). :)
you need to keep track of number...
You should understand your str_ini, str_ris, str_last is asp variables and access does not know that variables... so where you send to access query
SELECT str_ini.Numero, str_ini.Nazione,...
2013-12-03 should be in single quotes or in # depense from what database you have
this is template for SQL server
-- Create T-SQL Trigger Template
USE <database_name, sysname,...
select count(*) in SQL 2008 did not count actual record it is read header record it is read data from system table, you can use script below to get your statistics from database
something like that
DECLARE count INT DEFAULT 1;
WHILE count < 2000 DO
insert into youtTable (dateValue) values(DATE_ADD('12/1/2013',count 45 MONTH))
SET count = count + 1;
both options has pros and cons, I have experience in both and huge number of website already written on both. I would say you should look on your internet provider the big reason which drive to...
and where is the question? Yes you can have files written on different languages in the same website...
the line Set objExec = Conn.Execute(strSQL) <------ Line 20
if wrong you executing insert statement, it will not return recordset, so it should be
you should use set only if...
it is giving me
Include file not found
/shop$db.asp, line 5
check if you have shop$db.asp in right location...
when you naming columns try to avoid reserve words like index, primary, user....it will help
how you relate your tables?
users (ID, name)
fields (ID, title)
you tables not related... it is does not make sense....
Of cause if you creating thousands records...
so, add table BuildingRooms with biuldingId, RoomId and it is unique compbination
This is it
select [user_name], max(l.date_time_last_login)
from users_tbl u
inner join users_access_log_tbl l
group by [user_name]