2. ASPRunnerPro General questions
  3. GetRequestForm()
This topic is locked

GetRequestForm()

 		7/1/2005 14:17:52
ASPRunnerPro General questions
Lowkeck authorDevClub member

Hi all,
I have 2 tables in a MS SQL Database:
Customer Info

Support Tickets
Customer info is the table containing the "master key" Currently I use the GetRequestForm("Masterkey") in a field in the support ticket table to link the support tickets to an individual customer. Is it possible to use this function to also display the customer name from the Customer info table.
I apologize if I am not being clear.
Thanks for any help.
Jay
Sergey Kornilov admin 7/4/2005

Jay,
GetRequestForm("Masterkey") variable holds master key value.
If you need to dsiplay other fields from Customer Info table try something like this:

set rsTmp = Server.CreateObject ("ADODB.Recordset")

rsTmp.open "select * from [Customer Info] where ID = " & GetRequestForm("Masterkey"), dbConnection
Response.Write rsTmp("SomeOtherField")
rsTmp.Close

set rsTmp=Nothing
Lowkeck authorDevClub member 7/5/2005

Great, Thanks!