Hi i assume that price is returned by a stored
procedure so put it ina variable called price.

' Dim price
' price=storedproceduere(productcode)

Recordset returns the record details(product name) put
it in the variable called det.

' Dim det
' pname=recordset("prodname")

Now i dont know how u want to pass these values as
querystring. So i take 2 cases,

1)If yr requirement is like 
 "members.asp?pname=price" this then
 ' "members.asp?" & pname & "=" & price ( this is the
code to substitute both variables)

2) If u want to send these 2 values as 2 different
parameters then,
'    "members.asp?productname=" & pname & "&price=" &
price

Hope this may help

Regards,
Bala (bala_isme@y...)




--- info@e... wrote:
> Database Type: SQL Server 2000
> 
> I am building a large e-commerce application and
> need to know how to join 
> these two on a variable like
> "mypage.asp?sku=002562". I am using the 
> stored procedure to give me a marked up price and
> the recordset to give me 
> my record details. Does anyone have any
> suggestions?? or another way to do 
> this with code examples?? Thanks!