you probably need to convert your date string to something like
{d 'yyyy-M-d'} if the definition of the "Date" field in your database is
date, or {ts 'yyyy-M-d H:m:s"} if it's daytime type.
----Original Message Follows----
From: Oguz Baktir <[EMAIL PROTECTED]>
Hi!
I want to enter a row of data into my database and a field has autoincrement
value. How can I do the insertion without getting the
Number of query values and destination fields aren't the same. at
sun.jdbc.odbc.JdbcOdbc.createSQLException(Compiled Code
error? The code I use for insertion is below:
Works table has the WorkID field with autoincrement value. By the way, I'm
using MsAccess97
Thanks in advance.
String submit="INSERT INTO Works (Username, Type, Title, Date, Work,
Approved) VALUES ('"+username+"'"+
", "+"'"+type+"'"+", "+"'"+
title+"'"+", "+"'"+date+"'"+", "+"'"+ work+"'"+", "+"'No')";
___________________________________________________________________________
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
_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
___________________________________________________________________________
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
