«

I am trying to insert a date into a date field through my website. The date
is pre-populated with todays date. I am getting a type mismatch error. The
Access DB is setup as a Date/Time Short Date field.

Here is the SQL string. Any ideas?

Conn.execute ("INSERT INTO PrinterMaintenance (MaintDate, SA, Maintenance,
PrinterName, UserName) VALUES ('MaintDate', 'SA', 'Maintenance',
'PrinterName', 'UserName')")

dthmtlgod wrote:
> I am trying to insert a date into a date field through my website.
> The date is pre-populated with todays date. I am getting a type
> mismatch error. The Access DB is setup as a Date/Time Short Date
> field.
>
> Here is the SQL string. Any ideas?
>
> Conn.execute ("INSERT INTO PrinterMaintenance (MaintDate, SA,
> Maintenance, PrinterName, UserName) VALUES ('MaintDate', 'SA',
> 'Maintenance', 'PrinterName', 'UserName')")

This statement is attempting to put the word 'MaintDate' into a field that
will only accept date/time values.

Check out these posts:
http://www.google.com/groups?hl=en&l...TNGP12.phx.gbl

http://www.google.com/groups?hl=en&l...%3D10%26sa%3DN

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

With what you have, you're trying to insert the literal text, "MaintDate."
You want to insert a date, i.e.

Conn.Execute "INSERT INTO PrinterMaintenance (MaintDate, SA, Maintenance,
PrinterName, UserName) VALUES (#" & Date & "#,'SA'......)"

Also, do you mean to insert the literal text of SA, Maintenance,
Printername, etc.? Or are they variables? If those are variables in your
code, they are not going to be evaluated when you execute your INSERT. All
you'll see is the actual literal text, MaintDate, SA, etc. Remember, you're
just building a string here, so if you want to concatenate variable values,
you have to do just that - concatenate the values.

sSQL = "INSERT INTO.... VALUES (#" & Date & "#,'" & SA & "','" & Maintenance
& "','" & PrinterName & "','" & Username & "')"

Response.Write sSQL

Ray at home

"dthmtlgod" <> wrote in message
news:ui9$...
>I am trying to insert a date into a date field through my website. The
>date
> is pre-populated with todays date. I am getting a type mismatch error.
> The
> Access DB is setup as a Date/Time Short Date field.
>
> Here is the SQL string. Any ideas?
>
> Conn.execute ("INSERT INTO PrinterMaintenance (MaintDate, SA, Maintenance,
> PrinterName, UserName) VALUES ('MaintDate', 'SA', 'Maintenance',
> 'PrinterName', 'UserName')")
>
>
>

"dthmtlgod" <> wrote in message
news:ui9$...
>I am trying to insert a date into a date field through my website. The
>date
> is pre-populated with todays date. I am getting a type mismatch error.
> The
> Access DB is setup as a Date/Time Short Date field.
>
> Here is the SQL string. Any ideas?
>
> Conn.execute ("INSERT INTO PrinterMaintenance (MaintDate, SA, Maintenance,
> PrinterName, UserName) VALUES ('MaintDate', 'SA', 'Maintenance',
> 'PrinterName', 'UserName')")

Use parameters

Set cmd.ActiveConnection = conn
cmd.CommandText = "insert into blah (dt) values(?)" ' simplified sample
cmd.CommandType = adCmdText
cmd.Parameters.Append cmd.CreateParameter(, adDBDate, 1, , Date)
cmd.Execute ,, adExecuteNoRecords


>
>
>