RE: division by zero error?

2000-09-15 Thread David E. Crawford
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

Re: division by zero error?

2000-09-15 Thread Kevin Schmidt
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:

Re: division by zero error?

2000-09-15 Thread Mary_Baotic
You need to take the single quotes (') off the number fields: #variables.studentphone# #variables.studentfax# Mary |+---> || "Terri | || Stocke" | || | || | ||

RE: division by zero error?

2000-09-15 Thread Jay Wigginton
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:

RE: division by zero error?

2000-09-15 Thread Shane Pitts
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] Subj

Re: division by zero error?

2000-09-15 Thread Terri Stocke
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]>