[thelist] ASP & SQL
Anthony Baratta
Anthony at Baratta.com
Thu Sep 12 14:16:11 CDT 2002
Oops....
Minor error in code.
> if CheckNull(strSearch) then
> strSearch = & " " & Fld & "like '%" & Trim(Request.Form(Fld)) & "%'"
> else
> strSearch = strSearch & "AND FieldOne like '%" & FieldOne & "%'"
> end if
Should be:
if CheckNull(strSearch) then
strSearch = & " " & Fld & "like '%" & Trim(Request.Form(Fld)) & "%'"
else
strSearch = strSearch & "AND " & Fld & " like '%" &
Trim(Request.Form(Fld)) & "%'"
end if
Sorry.
--
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list