You need to take the single quotes (') off the number fields:
#variables.studentphone#
#variables.studentfax#
Mary
|--------+----------------------->
| | "Terri |
| | Stocke" |
| | <tstocke@hotm|
| | ail.com> |
| | |
| | 09/15/2000 |
| | 12:39 PM |
| | Please |
| | respond to |
| | cf-talk |
| | |
|--------+----------------------->
>----------------------------------------------------------------------------|
| |
| To: [EMAIL PROTECTED] |
| cc: (bcc: Mary Baotic/na/Hyperion) |
| 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.