Hi,
I'd like to adapt the query below to select records only if the Title field
contains the string "Book" (as an example).
I'd also like to use a different variant of the query elsewhere to select
all records where the Title field does not contain the string "Book".
I know my question sounds dumb to many, but I haven't worked with .ASP in a
while, and don't know how to put "Contains" and "Doesn't contain" in a
query, and can't seem to find this info easily at aspin.com
Many thanks for assistance.
David
set rsData = MyConn.execute("select URL,Counter,Title from HitTable ORDER BY
Counter DESC")
arData = rsData.getrows