Turn on debugging and output your QUERY statement; that should help you find
the problem.  Your date format may be incorrect.

-----Original Message-----
From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 20, 2000 10:36 AM
To: CF-Talk
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

Reply via email to