need help : error in asp

[moshe]

after "objConn.execute(sql)" the page got error
how can i show the error? there is an Object error ?

regards,
yuval

 

[Tim Williams]

Well, what was the "error" you got?
Show code. There is an error object, but how you use it will depend
what language you're using.

Tim.

 

[Brian Staff]

My guess is that objConn is not an object and that tells me that your
connection string is incorrect and you did not make a connection to your
database.

Did you do any error checking after trying to connect?

As Tim says..."show us your code"

Brian

 

[Phill. W]

after "objConn.execute(sql)" the page got error
how can i show the error? there is an Object error ?

On Error Resume Next
objConn.execute(sql)
If Err.Number <> 0 Then
Response.Write "Error #" & Err.Number _
& " : " & Err.Decription
Response.End
End If

HTH,
Phill W.

 

[Roland Hall]

in message : : > after "objConn.execute(sql)" the page got error
: > how can i show the error? there is an Object error ?
:
: On Error Resume Next
: objConn.execute(sql)
: If Err.Number <> 0 Then
: Response.Write "Error #" & Err.Number _
: & " : " & Err.Decription
: Response.End
: End If

and then...
On Error Goto 0
?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp