Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: GT::SQL acting odd :/

Oct 24, 2003, 8:29 AM

Andy

Veteran / Moderator (18441 posts)

Oct 24, 2003, 8:29 AM

Post #1 of 4

Shortcut

GT::SQL acting odd :/

Hi. Anyone got any ideas why the following code;

Code:
GT::SQL::error = Failed to execute query: 'SELECT * FROM lsql_AddLinkSession  WHERE FriOct240818592003 IS NULL AND SessionID = ?    
	LIMIT 1' Reason: Unknown column 'FriOct240818592003' in 'where clause'

..gives me the following error message;

GT::SQL::error = Failed to execute query: 'SELECT * FROM lsql_AddLinkSession WHERE FriOct240818592003 IS NULL AND SessionID = ?
LIMIT 1' Reason: Unknown column 'FriOct240818592003' in 'where clause'

The .def file looks ok :/

Cheers

Andy (mod)
andy@ultranerds.co.uk

Oct 24, 2003, 8:36 AM

Andy

Veteran / Moderator (18441 posts)

Oct 24, 2003, 8:36 AM

Post #2 of 4

Shortcut

Re: [Andy] GT::SQL acting odd :/ In reply to

Very odd. Changed it to the following;

Code:
       my $_date = $IN->param('SessionDate'); 
       $sth = $table->select( { SessionID => $_date  } );

... and it works fine now!

Cheers

Andy (mod)
andy@ultranerds.co.uk

Oct 24, 2003, 9:53 AM

Alex

Administrator (9387 posts)

Oct 24, 2003, 9:53 AM

Post #3 of 4

Shortcut

Re: [Andy] GT::SQL acting odd :/ In reply to

You didn't post what the original code was..

Cheers,

Alex
--
Gossamer Threads Inc.

Oct 25, 2003, 2:14 AM

Andy

Veteran / Moderator (18441 posts)

Oct 25, 2003, 2:14 AM

Post #4 of 4

Shortcut

Re: [Alex] GT::SQL acting odd :/ In reply to

Original code was;

Code:
$sth = $table->select( { SessionID => $IN->param('SessionDate')  } );

Cheers

Andy (mod)
andy@ultranerds.co.uk