FYI, I just noticed that there are quotes around some of the numeric fields.
I changed this in my app, and I'm still getting the error...
(I inherited this app from someone else, so I'm still cleaning some of it
up)...
----Original Message Follows----
From: "Terri Stocke" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: division by zero error?
Date: Fri, 15 Sep 2000 16:39:52 GMT
Can anyone tell me what may be causing this error?
Error Diagnostic Information
ODBC Error Code = 22012 (Division by zero)
[Microsoft][ODBC Microsoft Access 97 Driver]Division by zero (null)
I am not performing any mathematical operations, nor do I have anything in
my CF code that would cause CF to think that that is what I am trying to do.
This is really a very simple two-page app. I have also tested this by NOT
utilizing the phone and fax fields, with the same result.
Here's the query (with their respective data types in brackets):
<CFQUERY name="SaveReq" datasource="TrainReg">
INSERT INTO Request
(ClassID,
Request_Date, [datetime]
Student_Name, [text]
Student_Location, [text]
Student_Department, [number]
Student_Phone, [number]
Student_Fax, [number]
Manager_Name, [text]
SendTo_Email) [text]
VALUES
(#Form.ClassID#,
#dateformat(Now(), 'mm/dd/yy')#,
'#Variables.StudentName#',
'#Variables.StudentLoc#',
#Form.DeptNo#,
'#variables.studentphone#',
'#variables.studentfax#',
'#form.managername#',
'#form.m_ta_email#')
</cfquery>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
