|
|
 |
|
<%
strProductID = stripInvalidChars(Request.QueryString("productID"))
strPropertyID = stripInvalidChars(Request.QueryString("propertyID"))
strServiceID = stripInvalidChars(Request.QueryString("serviceID"))
strJobID = stripInvalidChars(Request.QueryString("jobID"))
if not(isEmpty(strServiceID)) then
strSQL = "SELECT [serviceName] FROM [" & STR_SRVC_SRVC_TABLE & "]"
strSQL = strSQL & " WHERE [serviceID] = " & strServiceID
set rst = server.createObject("ADODB.recordset")
rst.open strSQL,conn,1,3
strEnquiryDesc = STR_SERVICE_DESC1 & STR_SERVICE_DESC2
strCarry1Value = rst.fields("serviceName")
strCarry1Tag = STR_SERVICE1_TAG
rst.Close
set rst = nothing
elseif not(isEmpty(strProductID)) then
strSQL = "SELECT [productName] FROM [" & STR_PROD_TABLE & "]"
strSQL = strSQL & " WHERE [productID] = " & strProductID
set rst = server.createObject("ADODB.recordset")
rst.open strSQL,conn,1,3
strEnquiryDesc = STR_PRODUCT_DESC1 & STR_PRODUCT_DESC2
strCarry1Value = rst.fields("productName")
strCarry1Tag = STR_PRODUCT1_TAG
rst.close
set rst = nothing
elseif not(isEmpty(strPropertyID)) then
strSQL = "SELECT [propertyName] FROM [" & STR_PROP_TABLE & "]"
strSQL = strSQL & " WHERE [propertyID] = " & strPropertyID
set rst = server.createObject("ADODB.recordset")
rst.open strSQL,conn,1,3
strEnquiryDesc = STR_PROPERTY_DESC1 & STR_PROPERTY_DESC2
strCarry1Value = rst.fields("propertyName")
strCarry1Tag = STR_PROPERTY1_TAG
rst.close
set rst = nothing
elseif not(isEmpty(strJobID)) then
strSQL = "SELECT [Name] FROM [" & STR_JOBS_TABLE & "]"
strSQL = strSQL & " WHERE [ID] = " & strJobID
set rst = server.createObject("ADODB.recordset")
rst.open strSQL,conn,1,3
strEnquiryDesc = STR_JOB_DESC1 & STR_JOB_DESC2
strCarry1Value = rst.fields("Name")
strCarry1Tag = STR_JOB1_TAG
rst.close
set rst = nothing
else
strEnquiryDesc = STR_STANDARD_DESC1 & STR_STANDARD_DESC2
end if
%>
|
|
|
|
|
