|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
how to joint these codes? |
|
From: |
Brandon |
|
Date: |
9/24/2001 9:37:19 PM |
|
IP: |
128.250.6.244 |
Code 1 provided below works fine without running Code2, and vise versa. However, I failed to link them using OR. Can anyone tell me why?
Code1:
SQLtext ="SELECT * from Researcher where ResearchInterest1 = '" & Request.Form("search_interest") & "' OR ResearchInterest2 = '" & Request.Form("search_interest") & "' order by Surname"
Code2:
SQLtext = "SELECT * from Researcher where ResearchInterestDescription like '%" & Trim(Request.Form("search_interest")) & "%'"
thanks |
Follow Up - Re: how to joint these codes? - Elija 9/25/2001 4:00:39 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
