p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_howto thread: Re: proasp_howto digest: February 24, 2001


Message #1 by "Sarah Margolis" <sarahmargolis@l...> on Tue, 27 Feb 2001 13:43:20 -0800
Hello Everyone,

All I want to do is to add an extra search term to the following that in
addition to everything else would search the field MESSAGE for all entrys
that *contain variable MESSAGE.  Please help.

SQLStmt = "SELECT * FROM PRODUCT WHERE " _
  & "((DESCRIPTION LIKE '%" & DESCRIPTION & "%' OR LONG_DESCRIPTION LIKE '%"
& DESCRIPTION & "%') " _
  & "AND (PRODUCT_ID LIKE '%" & PRODUCT_ID & "%') " _
  & "AND ((" & Subcategory & ") " _
  & "AND (" & LANGUAGE & ") " _
  & "AND (" & MANUFACTURER & ") " _
  & "AND (" & LONG_DESCRIPTION & ") " _
  & "AND (" & ISBN & ") " _
  & "AND (" & CATEGORY & "))) " _
  & "ORDER BY PRODUCT_ID DESC "
   End If


  Return to Index