syntax on algorithm

[lyealain]

pls help on this.. imagine i have i have 2 ways of searching data... 1 is by dropdown search and another is textbox search in page A ..either one can perform the search...

pageB

a="select from table
where partnumber= '"&textboxSearch&"' || partnumber ='"&dropDownSearch&"' "
set b = conn.execute(a)

if not b.eof
call main()

else
response.redirect("confirm.asp?res=cannotFind")
end if
can that be done?? but i cant get my main()
-------------------------------------------------------------------------------------

i have also tried

a="select from table
where partnumber= '"&textboxSearch&"' || partnumber ='"&dropDownSearch&"' "
set b = conn.execute(a)

if textboxSearch ="" then
response.write(" confirm.asp?res=blank ")

call main()

** this res=blank can work for the textbox search... but when i click on the dropdown.. it always link me to the "res=blank "

[jhardman]

what is "||" supposed to mean?

Jared

[lyealain]

what is "||" supposed to mean?

Jared

that is or statement

[jhardman]

that is or statement

when connecting to a db you have to write in SQL (structured query language. I'm not really an expert here either, but I can get around). You should use "OR" not "||"

try

a="SELECT * FROM table WHERE partnumber= '"&textboxSearch&"' OR partnumber ='"&dropDownSearch&"'"

I tried to emphasize sql keywords by capitalizing them, but sql is not case-sensitive.