Re: division by zero error?
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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: division by zero error?
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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: division by zero error?
I had this problem once... it is caused by the statement in your code... #dateformat(Now(), 'mm/dd/yy')# Try using double quotes around the date mask... #dateformat(Now(), "mm/dd/yy")#, or remove the slashes... they are what is producing the error. Jay -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 15, 2000 12:40 PM 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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: division by zero error?
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=listsbody=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=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: division by zero error?
It is your date! It is probably formated like 09/00/00 This would look like division. Make sure there are not quotes around yor date field. Also using the CreatODBCDate() is a good function to use when inserting dates. - Original Message - From: "Terri Stocke" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 15, 2000 11:39 AM 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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: division by zero error?
This is a multi-part message in MIME format. --=_NextPart_000_009B_01C01F38.A0432B00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit division by zero error?This right here: #dateformat(Now(), 'mm/dd/yy')#, Is what is causing your problem. That would result in this value for today: 09/15/00 since you do not have it surrounded by quotes. If it is in fact a datetime field why not just use the ACCESS function NOW() to populate the date, or the CF function #NOW()#? In either case a true datetime value would be sent to the database, as opposed to the string representation of the date. DC -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 15, 2000 16:40 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_009B_01C01F38.A0432B00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEdivision by zero error?/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD BODY DIVFONT color=3D#ff face=3DArial size=3D2SPAN = class=3D241151417-15092000This=20 right here:/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D241151417-15092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D241151417-15092000#dateformat(Now(),=20 'mm/dd/yy')#,nbsp;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;F= ONT=20 size=3D2nbsp;nbsp;/FONT/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN = class=3D241151417-15092000Is=20 what is causing your problem.nbsp; That would result in this value for = today:=20 09/15/00 since you do not have it surrounded by quotes. If it is in fact = a=20 datetime field why not just use the ACCESS function NOW() to populate = the date,=20 or the CF function #NOW()#?nbsp; In either case a true datetime value = would be=20 sent to the database, as opposed to the string representation of the=20 date./SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D241151417-15092000/SPAN/FONTnbsp;/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D241151417-15092000DC/SPAN/FONT/DIV DIVFONT color=3D#ff face=3DArial size=3D2SPAN=20 class=3D241151417-15092000/SPAN/FONTnbsp;/DIV BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px" DIV align=3Dleft class=3DOutlookMessageHeader dir=3DltrFONT = face=3DTahoma=20 size=3D2-Original Message-BRBFrom:/B Terri Stocke=20 [mailto:[EMAIL PROTECTED]]BRBSent:/B Friday, September 15, = 2000=20 16:40BRBTo:/B [EMAIL PROTECTED]BRBSubject:/B = division by=20 zero error?BRBR/DIV/FONT PFONT size=3D2Can anyone tell me what may be causing this = error?/FONT /P PFONT size=3D2Error Diagnostic Information/FONT /P PFONT size=3D2ODBC Error Code =3D 22012 (Division by zero)/FONT = /P PFONT size=3D2[Microsoft][ODBC Microsoft Access 97 Driver]Division = by zero=20 (null)/FONT /P PFONT size=3D2I am not performing any mathematical operations,
