lecosson / assql

Automatically exported from code.google.com/p/assql
0 stars 0 forks source link

syntax error(insert statment) #85

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.
  st.sql = "INSERT INTO ZIPCODE (sido, gugun) VALUES  
(?, ?)";                
  st.setString(1, inputDescription.text);
  st.setString(2, inputPrice.text);
  var token:MySqlToken = st.executeQuery(); 
2. inputDescription.text = 'aa'
3. inputPrice.text = ''

What is the expected output? What do you see instead?

Error: SQL Error #10244: 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 ')' at line 1

The following statements are sent to the mysql server.

"INSERT INTO ZIPCODE (sido, gugun) VALUES  ('aa',)" 

Original issue reported on code.google.com by kwono...@gmail.com on 21 Jun 2009 at 2:51