Below are two different examples of how my DW is opeing/updating recordsets...whats the difference and what is making DW make these changes? Thanks in advance.


Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_con_on_on_STRING
Recordset1.Source = "SELECT * FROM anytable"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0

and

Set rs_cmd = Server.CreateObject ("ADODB.Command"
rs_cmd.ActiveConnection = MM_conn_cellnet_STRING
rs_cmd.CommandText = "SELECT * FROM anytable
rs_cmd.Prepared = true
Set rs = rs_cmd.Execute
rs_cnt = 0

The only thing I can possibly think of is that it is because of the way the connection string is written.

Any insight would be appreciated.

Thanks.

- Doc

Edited by - daveblohm on 10 May 2007 17:27:11

the first example is pre DW8.02 and is vulnerable to sql injection attacks, the second is post DW8.02 and is more secure.

DW8.02|ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk
www.dogworld-uk.com

Thanks a bunch.

- Doc

Progress is made by the discontent.