Type: Posts; User:
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]
I think it should be
IFNULL(column1,column2) AS finalcolumn
WHERE IFNULL(column1,column2) like '%s'",...
insert into B(color_id)
left join B
where b.color_id is null
did you check
if you on SQL server this will work
select ISNULL(a.dfcode, b.dfcode) as dfcode,
ISNULL(a.diagcode, b.diagcode) as diagcode,
ISNULL(a.times_testing, b.times_testing) as times_testing,...
try something like that
select * from
(SELECT ID, Job, Category
SELECT ID, Job, Category
ORDER BY RAND()
If you cares about both server load and response time save add another field in database and store html formatted textx and original text for search use original for display formatted... it is takes...
It is SQL forum... It looks like your question about PHP...
THAT SQL WILL GIVE WHAT YOU NEED. IN MY CASE YOUR DATA IN #T TABLE
select distinct Event,Date_Start,
COUNT(Event) as evtNum
group by Event,Date_Start
SELECT uploads.ufile,tags_uploads.tid, t.TagsNum
INNER JOIN tags_uploads
ON uploads.uid = tags_uploads.uid
inner join (select distinct tags_uploads.tid, COUNT(*)...
Are you still have error on the same line?
try just add before line with error
if should print on screen false
if it is
Just make sure all values you assigned is valid (check for missing value in not null fields, numeric fields must have numeric values - empty is not a numeric, length of value must be less them field...
1. ASP and PHP is 2 different languages and has 2 different compilers, so you can not mix php and asp inside the same page, but you can mix them inside website if your server configured to run php...
you trying to read value from recordset, but your recordset is empty....
you should always chaeck for end of file property on recordset as below
Dim doc1, doc2, doc3, doc4, doc5
from SQL server something like. YOu can change selection criteria
;WITH Descendants AS (
, 0 AS HLevel