Friday, June 01
Aargh! (Part 97 Of A Continuing Series)
Spend two hours debugging a 25-line SQL query only to find out that it is syntactically correct, but that one of the parameters is being passed as a string instead of an int, which causes the interface library to quote it.
The information is there in the error message, but it wouldn't hurt for it to be a little less... delphic:
Blahs.
Comments are disabled.
Post is locked.
Spend two hours debugging a 25-line SQL query only to find out that it is syntactically correct, but that one of the parameters is being passed as a string instead of an int, which causes the interface library to quote it.
The information is there in the error message, but it wouldn't hurt for it to be a little less... delphic:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''30'' at line 1.The program generates the query as a single line; it only became 25 lines after I broke it down for readability.
Blahs.
Posted by: Pixy Misa at
01:02 AM
| Comments (2)
| Add Comment
| Trackbacks (Suck)
Post contains 117 words, total size 1 kb.
1
Durrrr... I like pie.
Posted by: Wonderduck at Friday, June 01 2007 12:08 PM (R/R0E)
2
heh... can't tell you how many times I've had similar things happen to me. You'd think I'd learn - well, I guess I should say that the "same" errors seldom happen twice - but it still doesn't make me more careful reading error messages on new errors. *grin*
Posted by: Teresa at Sunday, June 03 2007 12:39 AM (gsbs5)
46kb generated in CPU 0.0157, elapsed 0.2818 seconds.
56 queries taking 0.2709 seconds, 328 records returned.
Powered by Minx 1.1.6c-pink.
56 queries taking 0.2709 seconds, 328 records returned.
Powered by Minx 1.1.6c-pink.