hopefully a simple one -
can anyone tell me if theres anything wrong with this SQL string?
INSERT INTO Customers (FirstName, LastName, Email, Phone, CompanyName)
VALUES (wrtwrt, wrtw, wrtwrt, wrtwert, ertwrt)
(all fields are text)
heres the code that generates it:
String sql = "INSERT INTO Customers (" +
"FirstName, LastName, Email, Phone, CompanyName) "
+
"VALUES (" + req.getParameter("fname") + ", " +
req.getParameter("lname") + ", " +
req.getParameter("email") + ", " +
req.getParameter("phone") + ", " +
req.getParameter("company") + ")";
for some reason the update isn't working, just want to check theres nothing
wrong with the sring.
I'm accessing an access db via ODBC, I'm getting a connection to the db ok.
thanks,
Paul
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
