Date Time syntax for saving

S

skc

Hi,

I have two asp pages - one is a form with hidden fields
called manualDate with value <%=Date()%> and ManualTime
with value <%=Time()%>

The next page contains a DRW with the INSERT INTO
SQL...trouble is, I am getting problems with the dates.

Here is my code:

INSERT INTO table (a,b,c) Values ('::a::',::b::,::c::)

It is the b,c that are causing the problem as a is a text
box field.

I think I have to use @ or # but I have forgotten - can
someone please help??

Skc
 
K

Kevin Spencer

If you're using an Access database, date/times are delimited with '#'
characters.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Top