Dear NotNowJohn
Thanks for yore response.
Ok if my objective solves only one page, I will use coding in one page.
It is display the records if user selects three options.
If user selects one option or select two options from the select list it not displays the records from the table ?
I am using this query
ssql="SELECT * FROM ARC where contractno='" &contractno & "' AND category='" &category & "' AND recordno='" &recordno& "' "
Secondly if record not found in the table it should display the message that â Record not found â and redirect to firstpage.asp
I am developing intranet sit for the company.
Thanks for your cooperation.
Best regards.
Mateen Martin
[email protected]
Quote:
quote:Originally posted by NotNowJohn
Mateen,
You don't need 6 pages - you need only one page to process the select oprions from your select page. You pull out data from arc table on each page you want to create (for each users' selection or combination) - so you have to create appropriate select statement only.
So, you have to add this on your result page you sent in teh previous posts:
Code:
contractno=Request.Form("contractno")
recordno=Request.Form("recordno")
category=Request.Form("category")
ssql="SELECT * FROM archive2 where "
If contractno=="" then
ssql=ssql & "1=1"
Else
ssql=ssql & " contractno='" & contractno & "'"
End If
If recordno<>"" then
ssql=ssql & " AND recordno='" & recordno & "'"
End If
If category<>"" then
ssql=ssql & " AND category='" & category & "'"
End If
These statements include all user choosing combinations.
Why you insist on 6 pages?
...but the Soon is eclipsed by the Moon
|
