I believe it is in your dateformat, but I could be wrong. Try using full ""
instead of '' around the formating.
or use use CreateODBCDate(now())
Shane
-----Original Message-----
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 10:40 AM
To: [EMAIL PROTECTED]
Subject: division by zero error?
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.
------------------------------------------------------------------------------
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.
