'Division by zero(null)' error

Results 1 to 2 of 2

Thread: 'Division by zero(null)' error

  1. #1
    Join Date
    Dec 1969

    Default 'Division by zero(null)' error

    I get this error message with the following sql statement:<BR>SQL = "INSERT INTO OLD_COMPANY_NAME VALUES (" & Company_No & ", " & todays_date & ", &#039" & Company_Name & "&#039)"<BR> RecordSet.open sql, DataConnection, 3, 3<BR><BR>Does any one have any idea why or what I can do?<BR>Thank you<BR>(also: the &#039todays_date&#039 field is obviously a field of type &#039date&#039

  2. #2
    Matt Jacyno Guest

    Default RE: 'Division by zero(null)' error

    Looks to me like you need single-quotes around todays_date. The database knows it&#039s a date field, but ASP doesn&#039t. All it sees is something like 7/21/00, and it will try to evaluate that as a mathematical expression.<BR><BR>Just slap some single-quotes around it, and see how that works.<BR><BR>Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts