| Author |
SQL syntax error
|
Donna Harrington
Ranch Hand
Joined: Aug 08, 2003
Posts: 31
|
|
Hey all, I have a syntax error and i want to update both tables customerdetails table and order table. but my join is wrong or something. can anybody see my error. thank u! PreparedStatement p = con.prepareStatement("INSERT INTO customerdetails JOIN order(Title,Username,Password,FirstName,Surname,Address,City,Email,TelephoneNum,cardType,cardNum,date,month,year,shipTitle,shipSurname,shipAddress,shipCity,shipCountry,shipPostalCode)"+" VALUES('"+radio+"','"+Username+"','"+Password+"','"+FirstName+"','"+Surname+"','"+Address+"','"+City+"','"+Email+"','"+telephoneNum+"','"+radio1+"','"+cardNum+"','"+date+"','"+month+"','"+year+"','"+radio2+"','"+shipName+"','"+shipSurname+"','"+shipAddress+"','"+shipCity+"','"+shipCountry+"','"+shipPostalCode+"')"); p.executeUpdate();
|
 |
Donna Harrington
Ranch Hand
Joined: Aug 08, 2003
Posts: 31
|
|
sorry put this message in wrong place!
|
 |
 |
|
|
subject: SQL syntax error
|
|
|