PDA

Click to See Complete Forum and Search --> : SQL Divide by zero


Dec 8th, 2000, 08:26 AM
I have an application that works on my development server, but not on my production one. In the process of deploying my application, I have copied the ASP pages & the SQL data base. All but one of my processes works. This one causes a divide by zero error.

The following is the section of code causing the error in my ASP page:

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


My problem is that I get a Divide by Zero error on the rs.Open statement.

I have run this selection using the SQL Analyzer on both servers and all is fine.

Any suggestions would be appreciated!