Failed SQL Query
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62739
interpreted = N
texte = I'm trying to query a MySQL database containing a table named transaction. The transaction table has numerous fields some of which are items, itemquantity, and prices. The items field contains data that looks like this: 104->123->130 This is part of a PHP shopping cart, so I can't answer questions regarding their database/table structures. The following query returns 5 records via phpMyAdmin: SELECT items,itemquantity,prices FROM transaction WHERE (items like '123->%' OR items like '%->123->%' OR items like '%->123' OR items='123') ORDER BY orderstamp; When executing the query via WebDNA's SQL contexts, I get the following error: ERROR: SQL COMMAND FAILED. COMMAND TEXT: SELECT items,itemquantity,prices FROM transaction WHERE (items like '123->%' OR items like '%->123->%' OR items like '%->123' OR items='123') ORDER BY orderstamp; ERROR TEXT: 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 '>14R items like '>123' OR items='123') ORDER BY orderstamp' at ERROR: COULD NOT FIND SQLRESULT "rs4". - Subsequent SQL commands attempting to use that result ID will fail. The WebDNA looks like this (with sensitive data removed): [sqlconnect dbtype=MySQL&host=216.168.63.56&database=sunshop-benelliusa&uid=NunYaBidness &pwd=NunYaBidness&conn_var=conn1][/sqlconnect] [sqlexecute conn_ref=conn1&result_var=rs4] SELECT items,itemquantity,prices FROM transaction WHERE (items like '123->%' OR items like '%->123->%' OR items like '%->123' OR items='123') ORDER BY orderstamp; [/sqlexecute] [sqlresult result_ref=rs4] [founditems] [items] | [itemquantity] | [prices]
[/founditems] [/sqlresult] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I'm trying to query a MySQL database containing a table named transaction. The transaction table has numerous fields some of which are items, itemquantity, and prices. The items field contains data that looks like this: 104->123->130 This is part of a PHP shopping cart, so I can't answer questions regarding their database/table structures. The following query returns 5 records via phpMyAdmin: SELECT items,itemquantity,prices FROM transaction WHERE (items like '123->%' OR items like '%->123->%' OR items like '%->123' OR items='123') ORDER BY orderstamp; When executing the query via WebDNA's SQL contexts, I get the following error: ERROR: SQL COMMAND FAILED. COMMAND TEXT: SELECT items,itemquantity,prices FROM transaction WHERE (items like '123->%' OR items like '%->123->%' OR items like '%->123' OR items='123') ORDER BY orderstamp; ERROR TEXT: 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 '>14R items like '>123' OR items='123') ORDER BY orderstamp' at ERROR: COULD NOT FIND SQLRESULT "rs4". - Subsequent SQL commands attempting to use that result ID will fail. The WebDNA looks like this (with sensitive data removed): [sqlconnect dbtype=MySQL&host=216.168.63.56&database=sunshop-benelliusa&uid=NunYaBidness &pwd=NunYaBidness&conn_var=conn1][/sqlconnect] [sqlexecute conn_ref=conn1&result_var=rs4] SELECT items,itemquantity,prices FROM transaction WHERE (items like '123->%' OR items like '%->123->%' OR items like '%->123' OR items='123') ORDER BY orderstamp; [/sqlexecute] [sqlresult result_ref=rs4] [founditems] [items] | [itemquantity] | [prices]
[/founditems] [/sqlresult] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Clint Davis
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Date sorting (2000)
limit to listwords (2001)
[WebDNA] OLD list archives? (2010)
FM 4.1 and Webcat? (1998)
Not really WebCat (1997)
Getting total number of items ordered (1997)
Grant, please help me ... (1997)
[WebDNA] Just drop the Server version (2015)
Counting LineItems (2000)
hierarchy question... (2000)
formatting dates from a field ... (1997)
emailer (1997)
Replace context problem ... (1997)
listfiles-looking for slick solution (1997)
Trouble serving graphics on protected templates (1998)
Need WebDNA that crashes server for testing (2000)
HomePage Caution (1997)
taxrate (1999)
Get Cookie problem..... (2000)
WebCatalog2 Feature Feedback (1996)