Access database getting mismatch data on criteria

[KimMazz]

Hello,

It's been a while since I used ad Access DB with CF so, forgive my memory
lapse. But, can anyone explain why this query is throwing the error of
mismatch data type in criteria at the line
where id ='#id#'

I am setting all my variables at the top of the page from a form.

<cfquery datasource="#request.datasource#">
UPDATE Sponsorships
SET
spnsr_details ='#spnsr_details#',
spnsr_Type ='#spnsr_Type#',
spnsr_pricing ='#spnsr_pricing#'
WHERE
id ='#id#'
</cfquery>

Kim

[E43509TS]

Typically ID is number, especially if you are using autonumber in MsAccess.
You don't need the quotes
id =#id#
Also check the data types for your other values, I would think that pricing is
a float and should not be considered a string.

[KimMazz]

taking out the quotes did it. thanks
Kim

"E43509TS" <webforumsuser@macromedia.com> wrote in message
news:du5cfm$oog$1@forums.macromedia.com...

> Typically ID is number, especially if you are using autonumber in
> MsAccess.
> You don't need the quotes
> id =#id#
> Also check the data types for your other values, I would think that
> pricing is
> a float and should not be considered a string.
>