properties for open.recordset

[DougP]

<%
Set fp_conn = Server.CreateObject(&quot;ADODB.Connection&quot
Set fp_rs = Server.CreateObject(&quot;ADODB.Recordset&quot
fp_conn.Open Application(&quot;Mail-List_ConnectionString&quot
SQL_String = &quot;Select * From [Logins] Where Login = '&quot; & name & &quot;' And Password = '&quot; & pass & &quot;';&quot;
fp_rs.Open SQL_String, fp_conn, 1, 3, 1 ' Note 2 = Table

' What are the other options for the bottom line

fp_conn, 1,3,1

I can't find anything in Help or learnasp.com

TIA DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[ToddWW]

Doug,

Link9 wrote a very nice FAQ regarding recordset properties. Take a look here.

faq333-618

Thanks Link9

ToddWW

 

[Guest_imported]

You could try defining them seperately:

i.e.

fp_rs.activeconnection = fp_Conn

fp_rs.CursorType = 1 (or adOpenKeyset)' cursor type required
fp_rs.LockType = 3 (or adLockOptimistic) ' Select lock type

I have found before, instead of putting in the appropriate number i.e. 1, put in the text equivalent adOpenKeyset - this has worked for me before, not sure what the difference is.