Ask a Question related to ASP Database, Design and Development.
-
Adam Knight #1
Seeing If Recordset Object Exists !
The property statement below will aim to identify whether a recordset object
(rs) exists, and is not eof; and set its value the the recordset data.
Is this possible. Any suggestions on how to do this..would be appreciated.
Public Property Value (str)
If ??? Then Element_Data = rs(str)
End Property
AK
Adam Knight Guest
-
adodb.recordset object and the IIS session object
I was looking through the registry of a Windows 2000 Adv. Server I just built and noticed that the adodb.recordset object had been set to "both"... -
check if a recordset exists
in asp is there a way to determine wether a recordset exists or not . the problem is i have On Error Resume Next on my page and if duff data is... -
Command Object and RecordSet ASP
I am very knew to asp and Im having problems returning the results from my stored procedure in the browser. The asp code and the html form code is... -
Can I re-use a recordset object?
I read the following somewhere: 'ADO lets you reuse a recordset as long as you close it first' So, presumeably I can do this: SQL1 = "...."... -
FindControl() returns NULL when object exists in Template?
I have seen the following behavior: when issuing a Page.FindControl() for a control which exists in an item template (from within an... -
vivek #2 Re: Seeing If Recordset Object Exists !
if rs.eof or rs.bof then
.....your stuff if its not rs.eof or if rs exists
end if
Vivek
"Adam Knight" <aj.knight@optusnet.com.au> wrote in message
news:eBgcKRnWDHA.2328@TK2MSFTNGP12.phx.gbl...object> The property statement below will aim to identify whether a recordset> (rs) exists, and is not eof; and set its value the the recordset data.
> Is this possible. Any suggestions on how to do this..would be appreciated.
>
> Public Property Value (str)
>
> If ??? Then Element_Data = rs(str)
>
> End Property
>
> AK
>
>
vivek Guest
-
Manohar Kamath [MVP] #3 Re: Seeing If Recordset Object Exists !
' Check to see if the recordset is a valid object
If Not Rs Is Nothing Then
' Make sure it is not empty
If NOT (RS.EOF And Rs.BOF) Then
... your code here
End IF
End If
--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]
"Adam Knight" <aj.knight@optusnet.com.au> wrote in message
news:eBgcKRnWDHA.2328@TK2MSFTNGP12.phx.gbl...object> The property statement below will aim to identify whether a recordset> (rs) exists, and is not eof; and set its value the the recordset data.
> Is this possible. Any suggestions on how to do this..would be appreciated.
>
> Public Property Value (str)
>
> If ??? Then Element_Data = rs(str)
>
> End Property
>
> AK
>
>
Manohar Kamath [MVP] Guest
-
vivek #4 Re: Seeing If Recordset Object Exists !
oops i meant the other way
if rs.eof or rs.bof then
....then whatever u want to put for eof...
else
...the stuff u want to write if its not eof...
end if
Vivek
"vivek" <vivsandela@yahoo.com> wrote in message
news:sxzXa.245018$BA.59024694@twister.columbus.rr. com...appreciated.> if rs.eof or rs.bof then
>
> ....your stuff if its not rs.eof or if rs exists
>
> end if
>
> Vivek
>
> "Adam Knight" <aj.knight@optusnet.com.au> wrote in message
> news:eBgcKRnWDHA.2328@TK2MSFTNGP12.phx.gbl...> object> > The property statement below will aim to identify whether a recordset> > (rs) exists, and is not eof; and set its value the the recordset data.
> > Is this possible. Any suggestions on how to do this..would be>> >
> > Public Property Value (str)
> >
> > If ??? Then Element_Data = rs(str)
> >
> > End Property
> >
> > AK
> >
> >
>
vivek Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
