|
 |
asp_databases thread: Re: Cursor Issue
Message #1 by "Vaishnavi" <mail2vaish@y...> on Fri, 19 Jul 2002 15:11:11
|
|
Hello,
Your problem is not very clear but for sanity's sake ......let me try to
answer it :-)
Are you trying to return a record set from within a stored procedure?
A stored procedure can only have multiple return values and I quite doubt
it will return a record set. Thats as far as my knowledge goes, limited as
it may be...I would love to know if thats really possible...
However if my asumption of what u r doing is not right, do post in a
little more detail
Regards,
> Hi all,
I wondered if you could help me with a problem that is driving me to the
brink of insanity!!!
I have an ASP page with some embedded SQL. I have set the cursor to move
back and forth and perform a find and filter on the record set and all is
well. see code below:-
-------------------------------------------------------------
set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
SecurityMappingsRS.CursorType = adOpenStatic
SecurityMappingsRS.Open "SELECT * FROM TB_SEC_ACE WHERE RESOURCENODE_URN ="
& Request.Form("LowLevel"), Conn
SecurityMappingsRS.Filter = "RESOURCENODE_URN = " & Request.Form
("LowLevel")
While Not SecurityGroupRS.EOF
SecurityMappingsRS.Find ("GROUPNODE_URN = " &
SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
-------------------------------------------------------------
My problem is occurring when I try to switch over to using a stored
procedure (embedded SQL being evil and all). I have created a Stored
Procedure that returns the same data and tried running it in multiple
different ways but it just doesn't seem to get the message that I want a
cursor that goes backwards and forwards. see code below:-
-------------------------------------------------------------
set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Conn
objCommand.CommandText = "ap_sec_get_ace"
objCommand.CommandType = adCmdStoredProc
set objParam = objCommand.CreateParameter("@I_ResourceNode", adInteger,
adParamInput)
objCommand.Parameters.Append objParam
objCommand.Parameters("@I_ResourceNode") = Request.Form("LowLevel")
set objParam = objCommand.CreateParameter("@I_GroupNode", adInteger,
adParamInput)
objCommand.Parameters.Append objParam
objCommand.Parameters("@I_GroupNode") = NULL
' Recordset to provide security mapping details for resources
set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
SecurityMappingsRS.Open objCommand, , adOpenStatic
SecurityMappingsRS.Filter = "RESOURCENODE_URN = " &
Request.Form("LowLevel")
While Not SecurityGroupRS.EOF
SecurityMappingsRS.Find ("GROUPNODE_URN = " &
SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
---------------------------------------------------------------
I get a nasty error message when I remove the filter saying "Rowset
position cannot be restarted".
I have tried doing..
SecurityMappingsRS.Open objCommand, , adOpenStatic
SecurityMappingsRS.CursorType = adOpenStatic
SecurityMappingsRS.Open objCommand.Execute
..and I get the same message.
Any help/suggestions would be gratefully received!
Regards
Jon
Message #2 by "Jonathan Charlton" <jcharlton@e...> on Fri, 19 Jul 2002 15:14:32 +0100
|
|
I am calling a stored procedure and then putting its contents into a ADO
recordset within the ASP. You are completely right that Stored Procedures
cannot pass back recordsets. My problem is that I dont seem to be able to
set the cursor direction of the recordset. It is always set to forwards
only.
Thanks for trying anyway!
-----Original Message-----
From: Vaishnavi [mailto:mail2vaish@y...]
Sent: 19 July 2002 15:11
To: ASP Databases
Subject: [asp_databases] Re: Cursor Issue
Hello,
Your problem is not very clear but for sanity's sake ......let me try to
answer it :-)
Are you trying to return a record set from within a stored procedure?
A stored procedure can only have multiple return values and I quite doubt
it will return a record set. Thats as far as my knowledge goes, limited as
it may be...I would love to know if thats really possible...
However if my asumption of what u r doing is not right, do post in a
little more detail
Regards,
> Hi all,
I wondered if you could help me with a problem that is driving me to the
brink of insanity!!!
I have an ASP page with some embedded SQL. I have set the cursor to move
back and forth and perform a find and filter on the record set and all is
well. see code below:-
-------------------------------------------------------------
set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
SecurityMappingsRS.CursorType = adOpenStatic
SecurityMappingsRS.Open "SELECT * FROM TB_SEC_ACE WHERE RESOURCENODE_URN ="
& Request.Form("LowLevel"), Conn
SecurityMappingsRS.Filter = "RESOURCENODE_URN = " & Request.Form
("LowLevel")
While Not SecurityGroupRS.EOF
SecurityMappingsRS.Find ("GROUPNODE_URN = " &
SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
-------------------------------------------------------------
My problem is occurring when I try to switch over to using a stored
procedure (embedded SQL being evil and all). I have created a Stored
Procedure that returns the same data and tried running it in multiple
different ways but it just doesn't seem to get the message that I want a
cursor that goes backwards and forwards. see code below:-
-------------------------------------------------------------
set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Conn
objCommand.CommandText = "ap_sec_get_ace"
objCommand.CommandType = adCmdStoredProc
set objParam = objCommand.CreateParameter("@I_ResourceNode", adInteger,
adParamInput)
objCommand.Parameters.Append objParam
objCommand.Parameters("@I_ResourceNode") = Request.Form("LowLevel")
set objParam = objCommand.CreateParameter("@I_GroupNode", adInteger,
adParamInput)
objCommand.Parameters.Append objParam
objCommand.Parameters("@I_GroupNode") = NULL
' Recordset to provide security mapping details for resources
set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
SecurityMappingsRS.Open objCommand, , adOpenStatic
SecurityMappingsRS.Filter = "RESOURCENODE_URN = " &
Request.Form("LowLevel")
While Not SecurityGroupRS.EOF
SecurityMappingsRS.Find ("GROUPNODE_URN = " &
SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
---------------------------------------------------------------
I get a nasty error message when I remove the filter saying "Rowset
position cannot be restarted".
I have tried doing..
SecurityMappingsRS.Open objCommand, , adOpenStatic
SecurityMappingsRS.CursorType = adOpenStatic
SecurityMappingsRS.Open objCommand.Execute
..and I get the same message.
Any help/suggestions would be gratefully received!
Regards
Jon
Message #3 by "Jonathan Charlton" <jcharlton@e...> on Tue, 16 Jul 2002 13:20:22 +0100
|
|
Hi all,
I wondered if you could help me with a problem that is driving me to the
brink of insanity!!!
I have an ASP page with some embedded SQL. I have set the cursor to move
back and forth and perform a find and filter on the record set and all is
well. see code below:-
-------------------------------------------------------------
set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
SecurityMappingsRS.CursorType = adOpenStatic
SecurityMappingsRS.Open "SELECT * FROM TB_SEC_ACE WHERE RESOURCENODE_URN ="
& Request.Form("LowLevel"), Conn
SecurityMappingsRS.Filter = "RESOURCENODE_URN = " & Request.Form("LowLevel")
While Not SecurityGroupRS.EOF
SecurityMappingsRS.Find ("GROUPNODE_URN = " &
SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
-------------------------------------------------------------
My problem is occurring when I try to switch over to using a stored
procedure (embedded SQL being evil and all). I have created a Stored
Procedure that returns the same data and tried running it in multiple
different ways but it just doesn't seem to get the message that I want a
cursor that goes backwards and forwards. see code below:-
-------------------------------------------------------------
set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Conn
objCommand.CommandText = "ap_sec_get_ace"
objCommand.CommandType = adCmdStoredProc
set objParam = objCommand.CreateParameter("@I_ResourceNode", adInteger,
adParamInput)
objCommand.Parameters.Append objParam
objCommand.Parameters("@I_ResourceNode") = Request.Form("LowLevel")
set objParam = objCommand.CreateParameter("@I_GroupNode", adInteger,
adParamInput)
objCommand.Parameters.Append objParam
objCommand.Parameters("@I_GroupNode") = NULL
' Recordset to provide security mapping details for resources
set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
SecurityMappingsRS.Open objCommand, , adOpenStatic
SecurityMappingsRS.Filter = "RESOURCENODE_URN = " &
Request.Form("LowLevel")
While Not SecurityGroupRS.EOF
SecurityMappingsRS.Find ("GROUPNODE_URN = " &
SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
---------------------------------------------------------------
I get a nasty error message when I remove the filter saying "Rowset
position cannot be restarted".
I have tried doing..
SecurityMappingsRS.Open objCommand, , adOpenStatic
SecurityMappingsRS.CursorType = adOpenStatic
SecurityMappingsRS.Open objCommand.Execute
..and I get the same message.
Any help/suggestions would be gratefully received!
Regards
Jon
Message #4 by "Ken Schaefer" <ken@a...> on Mon, 22 Jul 2002 11:55:49 +1000
|
|
You be able to set the cursor type like so:
objRS.Open objCommand,,adOpenStatic
-or-
you can force an adOpenStatic cursor by changing the cursor location to
adUseClient:
<%
objRS.CursorLocation = adUseClient
%>
Do you have Option Explicit in your code? Perhaps adOpenStatic is not
defined, hence you are getting the default cursor type?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jonathan Charlton" <jcharlton@e...>
Subject: [asp_databases] Re: Cursor Issue
: I am calling a stored procedure and then putting its contents into a ADO
: recordset within the ASP. You are completely right that Stored Procedures
: cannot pass back recordsets. My problem is that I dont seem to be able to
: set the cursor direction of the recordset. It is always set to forwards
: only.
:
: Thanks for trying anyway!
:
: -----Original Message-----
: From: Vaishnavi [mailto:mail2vaish@y...]
: Sent: 19 July 2002 15:11
: To: ASP Databases
: Subject: [asp_databases] Re: Cursor Issue
:
:
: Hello,
: Your problem is not very clear but for sanity's sake ......let me try to
: answer it :-)
: Are you trying to return a record set from within a stored procedure?
: A stored procedure can only have multiple return values and I quite doubt
: it will return a record set. Thats as far as my knowledge goes, limited as
: it may be...I would love to know if thats really possible...
:
: However if my asumption of what u r doing is not right, do post in a
: little more detail
:
: Regards,
:
: > Hi all,
:
: I wondered if you could help me with a problem that is driving me to the
: brink of insanity!!!
:
: I have an ASP page with some embedded SQL. I have set the cursor to move
: back and forth and perform a find and filter on the record set and all is
: well. see code below:-
:
: -------------------------------------------------------------
:
: set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
: SecurityMappingsRS.CursorType = adOpenStatic
: SecurityMappingsRS.Open "SELECT * FROM TB_SEC_ACE WHERE RESOURCENODE_URN
="
: & Request.Form("LowLevel"), Conn
:
: SecurityMappingsRS.Filter = "RESOURCENODE_URN = " & Request.Form
: ("LowLevel")
: While Not SecurityGroupRS.EOF
: SecurityMappingsRS.Find ("GROUPNODE_URN = " &
: SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
:
: -------------------------------------------------------------
:
: My problem is occurring when I try to switch over to using a stored
: procedure (embedded SQL being evil and all). I have created a Stored
: Procedure that returns the same data and tried running it in multiple
: different ways but it just doesn't seem to get the message that I want a
: cursor that goes backwards and forwards. see code below:-
:
: -------------------------------------------------------------
:
: set objCommand = Server.CreateObject("ADODB.Command")
: objCommand.ActiveConnection = Conn
: objCommand.CommandText = "ap_sec_get_ace"
: objCommand.CommandType = adCmdStoredProc
:
: set objParam = objCommand.CreateParameter("@I_ResourceNode", adInteger,
: adParamInput)
: objCommand.Parameters.Append objParam
: objCommand.Parameters("@I_ResourceNode") = Request.Form("LowLevel")
:
: set objParam = objCommand.CreateParameter("@I_GroupNode", adInteger,
: adParamInput)
: objCommand.Parameters.Append objParam
: objCommand.Parameters("@I_GroupNode") = NULL
:
: ' Recordset to provide security mapping details for resources
: set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
: SecurityMappingsRS.Open objCommand, , adOpenStatic
:
: SecurityMappingsRS.Filter = "RESOURCENODE_URN = " &
: Request.Form("LowLevel")
: While Not SecurityGroupRS.EOF
: SecurityMappingsRS.Find ("GROUPNODE_URN = " &
: SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
:
: ---------------------------------------------------------------
:
: I get a nasty error message when I remove the filter saying "Rowset
: position cannot be restarted".
:
: I have tried doing..
: SecurityMappingsRS.Open objCommand, , adOpenStatic
:
: SecurityMappingsRS.CursorType = adOpenStatic
: SecurityMappingsRS.Open objCommand.Execute
:
: ..and I get the same message.
:
: Any help/suggestions would be gratefully received!
:
: Regards
:
: Jon
Message #5 by "Jonathan Charlton" <jcharlton@e...> on Mon, 22 Jul 2002 11:01:10 +0100
|
|
Cheers Ken,
I did have Option Explicit defined and I could set the cursor type using the
adOpenStatic variable with embedded SQL. Neither of the two options below
worked alone however if I force an adOpenStatic cursor using
objRS.CursorLocation = adUseClient and then execute the recordset using
objRS.Open objCommand,,adOpenStatic then it seems to do the trick.
Thanks for the advice I have been going round in circles on this one for
ages.
Jon
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 22 July 2002 02:56
To: ASP Databases
Subject: [asp_databases] Re: Cursor Issue
You be able to set the cursor type like so:
objRS.Open objCommand,,adOpenStatic
-or-
you can force an adOpenStatic cursor by changing the cursor location to
adUseClient:
<%
objRS.CursorLocation = adUseClient
%>
Do you have Option Explicit in your code? Perhaps adOpenStatic is not
defined, hence you are getting the default cursor type?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jonathan Charlton" <jcharlton@e...>
Subject: [asp_databases] Re: Cursor Issue
: I am calling a stored procedure and then putting its contents into a ADO
: recordset within the ASP. You are completely right that Stored Procedures
: cannot pass back recordsets. My problem is that I dont seem to be able to
: set the cursor direction of the recordset. It is always set to forwards
: only.
:
: Thanks for trying anyway!
:
: -----Original Message-----
: From: Vaishnavi [mailto:mail2vaish@y...]
: Sent: 19 July 2002 15:11
: To: ASP Databases
: Subject: [asp_databases] Re: Cursor Issue
:
:
: Hello,
: Your problem is not very clear but for sanity's sake ......let me try to
: answer it :-)
: Are you trying to return a record set from within a stored procedure?
: A stored procedure can only have multiple return values and I quite doubt
: it will return a record set. Thats as far as my knowledge goes, limited as
: it may be...I would love to know if thats really possible...
:
: However if my asumption of what u r doing is not right, do post in a
: little more detail
:
: Regards,
:
: > Hi all,
:
: I wondered if you could help me with a problem that is driving me to the
: brink of insanity!!!
:
: I have an ASP page with some embedded SQL. I have set the cursor to move
: back and forth and perform a find and filter on the record set and all is
: well. see code below:-
:
: -------------------------------------------------------------
:
: set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
: SecurityMappingsRS.CursorType = adOpenStatic
: SecurityMappingsRS.Open "SELECT * FROM TB_SEC_ACE WHERE RESOURCENODE_URN
="
: & Request.Form("LowLevel"), Conn
:
: SecurityMappingsRS.Filter = "RESOURCENODE_URN = " & Request.Form
: ("LowLevel")
: While Not SecurityGroupRS.EOF
: SecurityMappingsRS.Find ("GROUPNODE_URN = " &
: SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
:
: -------------------------------------------------------------
:
: My problem is occurring when I try to switch over to using a stored
: procedure (embedded SQL being evil and all). I have created a Stored
: Procedure that returns the same data and tried running it in multiple
: different ways but it just doesn't seem to get the message that I want a
: cursor that goes backwards and forwards. see code below:-
:
: -------------------------------------------------------------
:
: set objCommand = Server.CreateObject("ADODB.Command")
: objCommand.ActiveConnection = Conn
: objCommand.CommandText = "ap_sec_get_ace"
: objCommand.CommandType = adCmdStoredProc
:
: set objParam = objCommand.CreateParameter("@I_ResourceNode", adInteger,
: adParamInput)
: objCommand.Parameters.Append objParam
: objCommand.Parameters("@I_ResourceNode") = Request.Form("LowLevel")
:
: set objParam = objCommand.CreateParameter("@I_GroupNode", adInteger,
: adParamInput)
: objCommand.Parameters.Append objParam
: objCommand.Parameters("@I_GroupNode") = NULL
:
: ' Recordset to provide security mapping details for resources
: set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
: SecurityMappingsRS.Open objCommand, , adOpenStatic
:
: SecurityMappingsRS.Filter = "RESOURCENODE_URN = " &
: Request.Form("LowLevel")
: While Not SecurityGroupRS.EOF
: SecurityMappingsRS.Find ("GROUPNODE_URN = " &
: SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
:
: ---------------------------------------------------------------
:
: I get a nasty error message when I remove the filter saying "Rowset
: position cannot be restarted".
:
: I have tried doing..
: SecurityMappingsRS.Open objCommand, , adOpenStatic
:
: SecurityMappingsRS.CursorType = adOpenStatic
: SecurityMappingsRS.Open objCommand.Execute
:
: ..and I get the same message.
:
: Any help/suggestions would be gratefully received!
:
: Regards
:
: Jon
Message #6 by "Ken Schaefer" <ken@a...> on Tue, 23 Jul 2002 16:33:30 +1000
|
|
Just as a followup, use of adOpenStatic cursors is not really recommended if
you just want to be able to scroll backwards and forwards, because
adOpenStatic cursors are very expensive.
Instead, I would do this:
<%
' Return adOpenForwardOnly cursor
Set objRS = objCommand.Execute
If not objRS.EOF then
arrResults = objRS.GetRows
End If
' Now clean up objRS/objCommand
%>
the .GetRows methods puts all your data into a 2-D VBScript array (one
dimension for colums and one for rows - imagine an excel spreadsheet for
example).
Since this is not connected to the database in any way, you can "scroll"
backwards and forwards to your heart's content without burdening the
database.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Jonathan Charlton" <jcharlton@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, July 22, 2002 8:01 PM
Subject: [asp_databases] Re: Cursor Issue
: Cheers Ken,
:
: I did have Option Explicit defined and I could set the cursor type using
the
: adOpenStatic variable with embedded SQL. Neither of the two options below
: worked alone however if I force an adOpenStatic cursor using
: objRS.CursorLocation = adUseClient and then execute the recordset using
: objRS.Open objCommand,,adOpenStatic then it seems to do the trick.
:
: Thanks for the advice I have been going round in circles on this one for
: ages.
:
: Jon
:
: -----Original Message-----
: From: Ken Schaefer [mailto:ken@a...]
: Sent: 22 July 2002 02:56
: To: ASP Databases
: Subject: [asp_databases] Re: Cursor Issue
:
:
: You be able to set the cursor type like so:
:
: objRS.Open objCommand,,adOpenStatic
:
: -or-
:
: you can force an adOpenStatic cursor by changing the cursor location to
: adUseClient:
:
: <%
: objRS.CursorLocation = adUseClient
: %>
:
: Do you have Option Explicit in your code? Perhaps adOpenStatic is not
: defined, hence you are getting the default cursor type?
:
: Cheers
: Ken
:
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: "Jonathan Charlton" <jcharlton@e...>
: Subject: [asp_databases] Re: Cursor Issue
:
:
: : I am calling a stored procedure and then putting its contents into a ADO
: : recordset within the ASP. You are completely right that Stored
Procedures
: : cannot pass back recordsets. My problem is that I dont seem to be able
to
: : set the cursor direction of the recordset. It is always set to forwards
: : only.
: :
: : Thanks for trying anyway!
: :
: : -----Original Message-----
: : From: Vaishnavi [mailto:mail2vaish@y...]
: : Sent: 19 July 2002 15:11
: : To: ASP Databases
: : Subject: [asp_databases] Re: Cursor Issue
: :
: :
: : Hello,
: : Your problem is not very clear but for sanity's sake ......let me try to
: : answer it :-)
: : Are you trying to return a record set from within a stored procedure?
: : A stored procedure can only have multiple return values and I quite
doubt
: : it will return a record set. Thats as far as my knowledge goes, limited
as
: : it may be...I would love to know if thats really possible...
: :
: : However if my asumption of what u r doing is not right, do post in a
: : little more detail
: :
: : Regards,
: :
: : > Hi all,
: :
: : I wondered if you could help me with a problem that is driving me to the
: : brink of insanity!!!
: :
: : I have an ASP page with some embedded SQL. I have set the cursor to move
: : back and forth and perform a find and filter on the record set and all
is
: : well. see code below:-
: :
: : -------------------------------------------------------------
: :
: : set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
: : SecurityMappingsRS.CursorType = adOpenStatic
: : SecurityMappingsRS.Open "SELECT * FROM TB_SEC_ACE WHERE RESOURCENODE_URN
: ="
: : & Request.Form("LowLevel"), Conn
: :
: : SecurityMappingsRS.Filter = "RESOURCENODE_URN = " & Request.Form
: : ("LowLevel")
: : While Not SecurityGroupRS.EOF
: : SecurityMappingsRS.Find ("GROUPNODE_URN = " &
: : SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
: :
: : -------------------------------------------------------------
: :
: : My problem is occurring when I try to switch over to using a stored
: : procedure (embedded SQL being evil and all). I have created a Stored
: : Procedure that returns the same data and tried running it in multiple
: : different ways but it just doesn't seem to get the message that I want a
: : cursor that goes backwards and forwards. see code below:-
: :
: : -------------------------------------------------------------
: :
: : set objCommand = Server.CreateObject("ADODB.Command")
: : objCommand.ActiveConnection = Conn
: : objCommand.CommandText = "ap_sec_get_ace"
: : objCommand.CommandType = adCmdStoredProc
: :
: : set objParam = objCommand.CreateParameter("@I_ResourceNode", adInteger,
: : adParamInput)
: : objCommand.Parameters.Append objParam
: : objCommand.Parameters("@I_ResourceNode") = Request.Form("LowLevel")
: :
: : set objParam = objCommand.CreateParameter("@I_GroupNode", adInteger,
: : adParamInput)
: : objCommand.Parameters.Append objParam
: : objCommand.Parameters("@I_GroupNode") = NULL
: :
: : ' Recordset to provide security mapping details for resources
: : set SecurityMappingsRS = Server.CreateObject("ADODB.recordset")
: : SecurityMappingsRS.Open objCommand, , adOpenStatic
: :
: : SecurityMappingsRS.Filter = "RESOURCENODE_URN = " &
: : Request.Form("LowLevel")
: : While Not SecurityGroupRS.EOF
: : SecurityMappingsRS.Find ("GROUPNODE_URN = " &
: : SecurityGroupRS.Fields.Item("GROUPNODE_URN").value)
: :
: : ---------------------------------------------------------------
: :
: : I get a nasty error message when I remove the filter saying "Rowset
: : position cannot be restarted".
: :
: : I have tried doing..
: : SecurityMappingsRS.Open objCommand, , adOpenStatic
: :
: : SecurityMappingsRS.CursorType = adOpenStatic
: : SecurityMappingsRS.Open objCommand.Execute
: :
: : ..and I get the same message.
: :
: : Any help/suggestions would be gratefully received!
: :
: : Regards
: :
: : Jon
:
:
:
:
:
:
|
|
|
View Cart
