need help : error in asp

6 Mar 2005 7:10 PM

moshe

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

regards,
yuval

6 Mar 2005 7:49 PM

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.

Show quote

"moshe" <yuval***@gmail.com> wrote in message
news:f4a9785d.0503061110.50d0c8fb@posting.google.com...
> after "objConn.execute(sql)" the page got error
> how can i show the error? there is an Object error ?
>
> regards,
> yuval

6 Mar 2005 8:25 PM

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
Show quote

"moshe" <yuval***@gmail.com> wrote in message
news:f4a9785d.0503061110.50d0c8fb@posting.google.com...
> after "objConn.execute(sql)" the page got error
> how can i show the error? there is an Object error ?
>
> regards,
> yuval

7 Mar 2005 4:02 PM

Phill. W

"moshe" <yuval***@gmail.com> wrote in message
news:f4a9785d.0503061110.50d0c8fb@posting.google.com...
> 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.

7 Mar 2005 9:41 PM

Roland Hall

"Phill. W" wrote in message news:d0htjo$96q$1@yarrow.open.ac.uk...
: "moshe" <yuval***@gmail.com> wrote in message
: news:f4a9785d.0503061110.50d0c8fb@posting.google.com...
: > 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