Skip to main content
Participant
November 17, 2006
Question

Afraid to upgrade to 8.02

  • November 17, 2006
  • 1 reply
  • 189 views
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
This topic has been closed for replies.

1 reply

Deaf_Web_Designer
Inspiring
November 17, 2006
Why are you afraid to upgrade to 8.02?

Be sure to have all sites backed up before proceed to upgrade.