Gossamer Forum
Home : Products : Others : MySQLMan :

MySQL Syntax error

Quote Reply
MySQL Syntax error
Your script uploaded and worked perfectly the first go. Well done.
When trying to edit a table I got the following message:
Error

MySQL said: You have an error in your SQL syntax near '(0x102b2430)' at line 1.

Query: SELECT * FROM cc_object WHERE CGI=HASH(0x102b2430)

I found a semi-colon seemed to be missing on line 789 of the cgi file
elsif ($action eq 'update') { &update_record($in) }

but that did not fix the problem.

Also, I when I try to delete a record I get:

Error

MySQL said: You have an error in your SQL syntax near '(0x102b21d8) LIMIT 1' at line 1.

Query: DELETE FROM delphi_cats WHERE CGI=HASH(0x102b21d8) LIMIT 1


Thanks for a great script - hope you can help me get this small problem working.

Richard

Subject Author Views Date
Thread MySQL Syntax error chesher 3009 Sep 5, 2000, 4:45 PM
Post Re: MySQL Syntax error
steven_chen 2931 Sep 6, 2000, 6:18 PM