ASP Oracle connections

[outra9e]

Hi guys wonder if anyone can give some advice.

As you probably all know, the chances of Oracle supporting me on this issue are about miniscule to nowt!

I can connect to an oracle data source using an ASP and can retrieve, add, update, delete and search the records.

I have a problem, in that if I return a search that has multiple returns, I cannot make the page browsable, I can create a page that lets me browse the records, but if I try to duplicate this on a search results page it doesnt work.

Here is my connection code to return a search:

<%
Dim objConn, objRS, sOraUserId
'declare variables for holding submitted values
dim sPurchOrder, sPos
'get values from submitted form
sPurchOrder = Request.Form(&quot;Purch_Order&quot
sPos = Request.Form(&quot;Pos&quot

Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot
objConn.Open &quot;Provider=msdaora;User ID=****;Password=****;Data Source=****&quot;
Set objRS = Server.CreateObject(&quot;ADODB.Recordset&quot
objRS.CursorLocation = adUseServer
objRS.CursorType = adOpenForwardOnly
objRS.LockType = adLockOptimistic

objRS.Open &quot;SELECT * FROM ***** where ***** = '&quot; & ****** & &quot;' and **** = '&quot; & **** & &quot;'&quot;, objconn, , , adCmdText
%>

Now all I need is code to make the page browsable, eg nav buttons...

Can anyone help?

Cheers