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!
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!