[thelist] Wordsearch in ASP/Access
Kevin Stevens
kjs at ratking.co.uk
Mon Sep 30 15:05:01 CDT 2002
> dim sSql : sSql = "select * from table"
> dim sTerm : sTerm = Request.Querystring( "searchterm" )
> If Len( Trim( sTerm ) ) > 0 then
> sSql = sSql & " where fieldname like '%" & sTerm & "%'"
> End If
> '...execute sSql, get recordset, convert to xml, pipe through xsl...
OK, now you're scaring me. Surely I don't need to know XML to do this, do I?
Kevin Stevens
kjs at ratking.co.uk
More information about the thelist
mailing list