One of the easiest ways to debug SQL statements is to print the final
statement to the output whether it is a web page, a text field, or the
command line. I catch 90% of my errors this way. Otherwise if you're
getting an exception print a stack trace, again to whatever output, and let
us know what it returns.
Matt
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]] On Behalf Of Paul
Foxton
Sent: Friday, May 04, 2001 9:43 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL string
thanks John,
yes I tried that too.
I'm thinking I must have an error somewhere else now.
the servlet gets right up to: stmt.executeUpdate(sql);
and throws an exception.
Ho hum, back to the drawing board :)
-----Original Message-----
From: John Johnson [mailto:[EMAIL PROTECTED]]
Sent: 04 May 2001 17:47
To: [EMAIL PROTECTED]
Subject: Re: SQL string
Hi Paul,
Don't you need single quotes surrounding the values which you are
inserting??
for example: INSERT INTO table (field1,field2) VALUES
('value1','value2')
Cheers,
-john
Paul Foxton wrote:
>
> 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
--
John Johnson
Software Engineer
Supply Chain Logic, Inc.
301-210-7400, x217
___________________________________________________________________________
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
___________________________________________________________________________
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
___________________________________________________________________________
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
