asp syntax

[lyealain]

[PHP]

pro = Request.Querystring("pro")
email = Request.Querystring("email")
rt = Request.Querystring("rt")


qryGetEmail = "SELECT DISTINCT supplier_feedback1.SupplierName, maintainance.Supp_Email FROM supplier_feedback1, maintainance WHERE (supplier_feedback1.SupplierName = maintainance.SupplierName) and (supplier_feedback1.ProjectName='" &pro& "' AND supplier_feedback1.Email='" &email& "' AND supplier_feedback1.RequestTime='" &rt& "')"

[/PHP]

is my code right??

[Atli]

Yea, it looks like it. Given that all the variables have been created and the query string acctually contains the values.

You might want to put a try block arround this, as I expect that trying to access a query field that does not exists will throw a NullReferenceEx ception.