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=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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>division 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>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D241151417-15092000>This=20
right here:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D241151417-15092000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D241151417-15092000>#dateformat(Now(),=20
'mm/dd/yy')#, <BR> <F=
ONT=20
size=3D2> </FONT></SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D241151417-15092000>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.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D241151417-15092000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D241151417-15092000>DC</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D241151417-15092000></SPAN></FONT> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Terri Stocke=20
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Friday, September 15, =
2000=20
16:40<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> =
division by=20
zero error?<BR><BR></DIV></FONT>
<P><FONT size=3D2>Can anyone tell me what may be causing this =
error?</FONT> </P>
<P><FONT size=3D2>Error Diagnostic Information</FONT> </P>
<P><FONT size=3D2>ODBC Error Code =3D 22012 (Division by zero)</FONT> =
</P>
<P><FONT size=3D2>[Microsoft][ODBC Microsoft Access 97 Driver]Division =
by zero=20
(null)</FONT> </P>
<P><FONT size=3D2>I am not performing any mathematical operations, nor =
do I have=20
anything in </FONT><BR><FONT size=3D2>my CF code that would cause CF =
to think=20
that that is what I am trying to do. </FONT><BR><FONT size=3D2>This is =
really a=20
very simple two-page app. I have also tested this by NOT =
</FONT><BR><FONT=20
size=3D2>utilizing the phone and fax fields, with the same =
result.</FONT> </P>
<P><FONT size=3D2>Here's the query (with their respective data types =
in=20
brackets):</FONT> </P>
<P><FONT size=3D2><CFQUERY name=3D"SaveReq" =
datasource=3D"TrainReg"></FONT>=20
<BR><FONT size=3D2> INSERT INTO Request</FONT> <BR><FONT=20
size=3D2> (ClassID,</FONT>=20
<BR> <FONT size=3D2> =20
Request_Date, [datetime]</FONT> =
<BR> =20
<FONT size=3D2> Student_Name, [text]</FONT>=20
<BR> <FONT size=3D2> =20
Student_Location, [text]</FONT> =
<BR> =20
<FONT size=3D2> Student_Department, [number]</FONT>=20
<BR> <FONT size=3D2> =20
Student_Phone, [number]</FONT> =
<BR> =20
<FONT size=3D2> Student_Fax, [number]</FONT>=20
<BR> <FONT size=3D2> =20
Manager_Name, [text]</FONT> =
<BR> =20
<FONT size=3D2> SendTo_Email) [text]</FONT> <BR><FONT =
size=3D2> =20
VALUES</FONT> <BR><FONT size=3D2> =20
(#Form.ClassID#,</FONT> <BR> =
<FONT=20
size=3D2> #dateformat(Now(), 'mm/dd/yy')#,</FONT>=20
<BR> <FONT =
size=3D2> =20
'#Variables.StudentName#',</FONT>=20
<BR> <FONT =
size=3D2> =20
'#Variables.StudentLoc#',</FONT>=20
<BR> <FONT =
size=3D2> =20
#Form.DeptNo#,</FONT> <BR> =
<FONT=20
size=3D2> '#variables.studentphone#',</FONT>=20
<BR> <FONT =
size=3D2> =20
'#variables.studentfax#',</FONT>=20
<BR> <FONT =
size=3D2> =20
'#form.managername#',</FONT> =
<BR> =20
<FONT size=3D2> '#form.m_ta_email#')</FONT> <BR><FONT=20
size=3D2></cfquery></FONT> <BR><FONT=20
=
size=3D2>________________________________________________________________=
_________</FONT>=20
<BR><FONT size=3D2>Get Your Private, Free E-mail from MSN Hotmail at =
<A=20
href=3D"http://www.hotmail.com" =
target=3D_blank>http://www.hotmail.com</A>.</FONT>=20
</P>
<P><FONT size=3D2>Share information about yourself, create your own =
public=20
profile at </FONT><BR><FONT size=3D2><A =
href=3D"http://profiles.msn.com"=20
target=3D_blank>http://profiles.msn.com</A>.</FONT> </P>
<P><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_009B_01C01F38.A0432B00--
------------------------------------------------------------------------------
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.