Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Another weird SQL error...

Quote Reply
Another weird SQL error...
Mmm.. the following code;

$DB->table('SpiderURLS')->update( { AlreadyChecked => "1" }, { URL => "$_" } ) or die $GT::SQL::error;

.. gives me the following error;

Failed to execute query: 'UPDATE lsql_SpiderURLS SET WHERE URL = ?' Reason: You have an error in your SQL syntax near 'WHERE URL = 'http://www.skydivelinks.com/index.php?PHPSESSID=4e823509fd4b27a74e3' at ...

Note the AlreadyChecked = 1 bit seems to be missing :/

Any ideas?

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!
Subject Author Views Date
Thread Another weird SQL error... Andy 1886 Sep 11, 2003, 3:40 AM
Post Re: [Andy] Another weird SQL error...
Andy 1792 Sep 11, 2003, 8:08 AM