![]() |
#1 |
![]() Join Date: Jun 2008
Location: Buffalo
Posts: 198
|
![]() Hi there,
I am trying to define my page to get a value from the URL in asp. I have doen the following to connect and define my record set to get the table that all the information is in and display it in order. The following is the code Code:
<% Dim rsProdDetail__varProduct rsProdDetail__varProduct = "Request.QueryString("productID")" If (BVAL <> "") Then rsProdDetail__varProduct = BVAL End If %> <% Dim rsProdDetail Dim rsProdDetail_cmd Dim rsProdDetail_numRows Set rsProdDetail_cmd = Server.CreateObject ("ADODB.Command") rsProdDetail_cmd.ActiveConnection = MM_DMICSQL_STRING rsProdDetail_cmd.CommandText = "SELECT SER_ID_Name, SER_ID, Header, SubHeader, Disclaimer, Section, Pic_UNC, Paragraph, Bullets FROM dbo.F01_Products_Detail, dbo.F01_Products WHERE dbo.F01_Products_Detail.SER_ID=dbo.F01_Products.SER_ID_Name AND dbo.F01_Products_Detail.SER_ID=?" rsProdDetail_cmd.Prepared = true rsProdDetail_cmd.Parameters.Append rsProdDetail_cmd.CreateParameter("param1", 200, 1, 255, rsProdDetail__varProduct) ' adVarChar Set rsProdDetail = rsProdDetail_cmd.Execute rsProdDetail_numRows = 0 %> Code:
rsProdDetail__varProduct = "Request.QueryString("productID")" Thanks for your help! -Xavier |
![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|