From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 10:28 AM
To: CF-Talk
Subject: Problems with Nulls
Hello All,
I am running in to a problem on something that I do locally on our intranet.
I query one database(SYBASE) then load the data that I need in to an access
database for a CF app that I have created.
There is section on the sysbase database where notes are entered then notes
tables looks like this
AccountNumber
NoteDate
Notetime
Note
Then I loop over all these records and insert them in to my access database
it works fine until I hit a record that has no date
I get this error
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
_expression_.
SQL = "Insert into Client_comm (AccountNumber, Act_date, Act_time, Comments)
Values (1081729, '','', '+----Match Search (by SIN Number)-------')"
In my access database the fields are as follows AccountNumber(Number),
Act_date(date) Act_Time(text), Comments(text)
My Insert statment looks like this
<cfquery name="Act_InsetNotes" datasource="#dsn#">
Insert into Client_comm
(AccountNumber, Act_date, Act_time, Comments)
Values
(#AccountNumber#, '#dateformat(act_date,
"mm/dd/yyyy")#','#timeformat(act_time, "hh:mm:ss")#', '#comments#')
</cfquery>
Thanks
Mike
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
