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): 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#') _ 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. --=_NextPart_000_009B_01C01F38.A0432B00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable division by zero error? This=20 right here: #dateformat(Now(),=20 'mm/dd/yy')#, Is=20 what is causing your problem. 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()#? In either case a true datetime value = would be=20 sent to the database, as opposed to the string representation of the=20 date. DC -Original Message-From: Terri Stocke=20 [mailto:[EMAIL PROTECTED]]Sent: Friday, September 15, = 2000=20 16:40To: [EMAIL PROTECTED]Subject: = division by=20 zero error? Can anyone tell me what may be causing this = error? Error Diagnostic Information ODBC Error Code =3D 22012 (Division by zero) = [Microsoft][ODBC Microsoft Access 97 Driver]Division = by zero=20 (null) I am not performing any mathematical operations, nor = do I have=20 anything in my CF code that would cause CF = to think=20 that that is what I am trying to do. This is = really a=20 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=20 brackets): <CFQUERY name=3D"SaveReq" = datasource=3D"TrainReg">=20 INSERT INTO Request (ClassID,=20 =20 Request_Date, [datetime] = =20 Student_Name, [text]=20 =20 Student_Location, [text] = =20 Student_Department, [number]=20 =20 Student_Phone, [number] = =20 Student_Fax, [number]=20 =20 Manager_Name, [text] = =20 SendTo_Email) [text] =20 VALUES =20 (#Form.ClassID#, = #dateformat(Now(), 'mm/dd/yy')#,=20 =20 '#Variables.StudentName#',=20 =20 '#Variables.StudentLoc#',=20 =20 #Form.DeptNo#, = '#variables.studentphone#',=20 =20 '#v
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): > > >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#') > > _ > 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.
Re: division by zero error?
You need to take the single quotes (') off the number fields: #variables.studentphone# #variables.studentfax# Mary |+---> || "Terri | || Stocke" | || | || | || 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): 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#') _ 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.
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): > > >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#') > > _ > 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.
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): 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#') _ 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.
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): 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#') _ 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.
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): 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#') _ 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.