[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