[thelist] Wordsearch in ASP/Access

[Kevin Stevens]

> 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