Could you post the actual cfquery statement? I am thinking it's probably
quotes i nthe wronf place or something similar.
jon
----- Original Message -----
From: "Kylie Lovelock" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 20, 2000 11: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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
