Forums

This topic is locked

Help W/ Insert SQL

Posted 17 May 2002 17:37:15
1
has voted
17 May 2002 17:37:15 David Hayes posted:
Hello all,

I'm making a schedule page where different users(volunteers) login and add time to the schedule everything works great except when I try to insert a record. This is the error I get along with the SQL statement. I'm using Access 2000 and Ultradev 4. All of the columns are using text format and all the code was written by UD4.
<b><pre id=code><font face=courier size=2 id=code>
insert into vtimes (date,start_time,end_time,volunteer) values ('5/16/2002','5:00:00','6:00:00','Volunteer_1')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/sNs2/staff/inserttime.asp, line 130
</font id=code></pre id=code></b>

Any help will be greatly appreciated this is due by the end of may!

Replies

Replied 17 May 2002 20:07:14
17 May 2002 20:07:14 Owen Eastwick replied:
Date is a reserved word, try changing the field name in the database to something else e.g. volunteer_date

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Reply to this topic