Hello,
I am using access database in aspx.
I did something like this :
....
currParam = new oleDbParameter("@create_date", OleDbType.DBTimeStamp)
currParam.value = Now
cmd.parameters.add(currParam)

In the sql I wrote :
insert into mytable ( ... , create_date , ....)
values( ..., @create_date, ...)

When execute the query I get an error :
Data type mismatch in criteria expression.

What is the problem ?

Thanks

Thanks
This doen't work,
but I did paid attention to something strange, that may be the reason to the
problem :

I am trying doing the follow :
Insert into mytable(col1, col2, col3, col4, ... col10)
values(@par1, @par2, @par3, @par4, ... @par10)

I have notice that the row is not inserted as I wish to,
and columnt : col9 i.e is set to parameter : par5 (and not to par9
respectively).
And this is not the only column that is inserted not as the sql command is
asking to.

(colomns doesn't get the right parameters, even I change the order of the
columns and the parameters).

Why is this problem ?

Thanks

"Cindy Meister -WordMVP-" <CindyMeister (AT) swissonline (DOT) ch> wrote

First, you are using the @ symbol for param names, and in Access, I don't
think that'll work for you --- you need to use the ? insert into
mytable(..., create_date, ...) values (?, ?, ?)

check out this link here, he goes into the whole process, but I think that's
the main problem. Also, you can just use a DateTime field instead of
Timestamp unless your db field is marked as such.

Let me know if you have any problems.

Bill
"Mr. x" <a@b.com> wrote

Thanks
Now it's clear.

The name after the insert ( ....) value (@par1, ...)
par1 for parameter 1 - the name is ignored by the asp interperter, so I can
use @xyz and it has the same result.
(It doesn't seem to be the parameter currParam = new oldDBParameter("@xyz",
OleDBType.Date)
The thing that what is metter is the order of the paramerter and not what I
called it at the insert command.
I don't know why can I write any name I like after @ in the insert command -
maybe it is for another purpose - I would like to know for what ?
And suppose I don't want to use ? instead, but the name of the parameter
itself - can I do it ?

Thanks

"William Ryan" <dotnetguru (AT) nospam (DOT) comcast.net> wrote

Since you can't name the parameters if you use the ?, then order is
absolutely critical. With named params, it doesn't matter, but if you don't
have them, it's critical. So, did this fix your problem or is it still
happening?

Let me know


Bill
"Mr. x" <a@b.com> wrote

Thanks
I see by the time of your massege that you spending nights in the internet -
thank you for any of your efforts.

I see that with named params or with ? the order is critical.
With named params - even a named that doesn't exists - aspx runs with no
problem, but the order is critical.

Anyway - everything works now, since I have paid attention to the order of
creation of the parameters.

Thanks

"William Ryan" <dotnetguru (AT) nospam (DOT) comcast.net> wrote