Can anyone see why this wouldn't return a result?
UPDATE lsql_Links SET isValidated = 'No' WHERE Mod_Date = '2003-01-28' AND AdLength = 28
I've tried taking out the 'AND AdLength = 28, and it works fine (returns one affected row) ... it seems to be the AdLength = .. part thats screwing it up
I've tried changing it to;
AdLength = '28'
and
AdLength = "28"
Can anyone see why this wont work? I've been staring and playing with it for ages...and its quite honestly just pissing me off
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
UPDATE lsql_Links SET isValidated = 'No' WHERE Mod_Date = '2003-01-28' AND AdLength = 28
I've tried taking out the 'AND AdLength = 28, and it works fine (returns one affected row) ... it seems to be the AdLength = .. part thats screwing it up
I've tried changing it to;
AdLength = '28'
and
AdLength = "28"
Can anyone see why this wont work? I've been staring and playing with it for ages...and its quite honestly just pissing me off
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!