MS Access field called "date"
- From: "Stephen Gray" <srgray99@xxxxxxxxxxxx>
- Date: Tue, 30 May 2006 22:11:10 -0400
I have a field in my access database called "date" ( because the client
wants it that way (and because Access allows me to create a field called
date(the "date" field is of type text in this case))).
I get a syntax error with this ->
INSERT INTO FecEmail
(Title,Organization,Description,Facilitator,Date,Time,Place,Cost,Childcare,C
ontact,Type,phoneNumber,email) VALUES( then I put in all the appropriate
values )
I understand the reasoning for not allowing a reserved word being used as a
field name in an sql statement, but Access allows me to name a field "date".
So there must be a way to populate it from an asp page .
Does anyone have any ideas on how I can insert data into my "date" field
from asp, using "Server.CreateObject("ADODB.Connection");"
Any help will be greatly appreciated.
sg.
--
Stephen Gray
srgray99@xxxxxxxxxxxx
.
- Follow-Ups:
- Re: MS Access field called "date"
- From: Bob Barrows [MVP]
- Re: MS Access field called "date"
- From: Bob Lehmann
- Re: MS Access field called "date"
- Prev by Date: Re: Set the value of a textbox
- Next by Date: Re: MS Access field called "date"
- Previous by thread: Set the value of a textbox
- Next by thread: Re: MS Access field called "date"
- Index(es):
Relevant Pages
|
Loading
