SQL error Divide by Zero from ASP

[SpriteInMe]

I use SQL 7.0 with my ASP and simply do a select statement.
Here is a snippet of my code:

cmd = "Select HolidayDate from HolidayMaster where HolidayDate = " & ShipDate & " and TerminalId = " & OrigTerminal
rs.Open cmd,cn
if rs.EOF then
ok = true
else

...

The following error appears on the "rs.open cmd,cn" line in my browsers window:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Divide by zero error encountered.

/TransitTimeCalc.asp, line 117


When I use the Query Analyzer to run the select statement, it is fine. A duplicate site on another server works fine.

Any suggestions would be greatly appreciated!!!

 

[foxdev]

You can try [tt]Set Arithabort Off[/tt], if possible, to see if that prevents the abend.

Robert Bradley

http://www.foxdev.com/

 

[SpriteInMe]

Sorry, forgot to mention that I had already tried the "Set Arithabort Off" without success.

 

[TomSark]

Hi, put the shipdate field in quotes like this:

"Select HolidayDate from HolidayMaster where HolidayDate = '" & ShipDate & "' and TerminalId = " & OrigTerminal


I believe that should do it...

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com