Sounds like you are missing some single quotes in your query statement.
Maybe you can paste it here.
Also, date is probably not the best unique identifier, depending on your
application. It is always possible that two users could submit and have the
form processed at the exact same time.
Scott M. Berry :: [Staff Developer]
annex.com, Inc. - http://www.annex.com/
----- Original Message -----
From: "Kylie Lovelock" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 20, 2000 8:35 AM
Subject: deleting records
> Evening all
> The continuing saga of my learning curve kinda goes like this ....
> I'm using UltraDev & have a page displaying all of the records in a
table,
> at the end of each record a have a form with a 'delete' button -
everything
> displays beautifully. In theory, after I deleting a record, you return to
> the same page. But I am getting this error after clicking the delete
button.
>
> Error Diagnostic Information
> ODBC Error Code = 22005 (Error in assignment)
>
> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
> expression.
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (26:1) to (26:88).
>
> My date field is the unique identifier (access general date format, time
etc
> included as not to double up). Any ideas where I'm going wrong?
>
> Thanks for your time
>
> Cheers
> Kylie Lovelock
>
> When confronted by a difficult problem, you can solve it easily by
> reducing the question to, "How would the Lone Ranger handle this?"
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
