Hi,
I have many programs in which I have had dreamweaver create a
recordset as below. You'll notice that I comment out the line that
begins RsTrans.Souurce and use it for a model for my own sql
statement to use as a replacement.
Does anyone know what will happen if I install 8.02 and try
to work on such a file?
<%
Dim RsTrans
Dim RsTrans_numRows
Set RsTrans = Server.CreateObject("ADODB.Recordset")
RsTrans.ActiveConnection = MM_locbookdata_STRING
'RsTrans.Source = "SELECT * FROM dbo.Transactions WHERE
Adsize <> 'Credit' AND Book = '" +
Replace(RsTrans__MMColParam, "'", "''") + "' ORDER BY Price DESC,
SaleType ASC" THIS LINE COMMENTED OUT AND REPLACE WITH LINE BELOW
RsTrans.Source = "SELECT * FROM dbo.Transactions WHERE Adsize
<> 'Credit' AND " & Filter1 & Filter2 & Filter3
& " ORDER BY" & Sor1 & Sor2 & Sor3
RsTrans.CursorType = 0
RsTrans.CursorLocation = 2
RsTrans.LockType = 1
RsTrans.Open()
RsTrans_numRows = 0
%>
Here's an example of "Filterx" that comes earlier in the
program
If (Request.Form("Book") <> "") Then
Filter1= " Book = " & chr(39) & Request.Form("Book")
& chr(39)
End If
I'm afraid I'll get all confused if 8.02 starts rewriting the
recordset, but I know at some point I'll need to upgrade to 9.0
Thanks for any suggestions as to what will happen.
Shelly
1
Reply
AdChoices