16 yr old needs ASP/SQL help

Article View: bit.listserv.sqlinfo

Article #352

Back to bit.listserv.sqlinfo Previous Next

#352

From: news.cpinternet.com
Date: Sat, 06 Nov 1999 00:00

16 lines
1097 bytes

Hello, I am designing a search engine and I can't get the results narrow
 enough unless I split the words up in a string.
  Like so:

  SQL_query = "SELECT * FROM BMV WHERE Description LIKE '%Janet%' AND
  Description LIKE '%Martin%'"

  But how can I do that with the method below from a form? I don't know how
  to seperate the words in a string for a search engine??? Any help would
be
  great! please e-mail me: info@netdynasty.com

  SQL_query = "SELECT * FROM China WHERE Name LIKE '" & Search & "%'"

  Best Regards,
  Brian Bierbaum

Technical Details

Message-ID: <86WU3.544$mf7.6830@newsfeed.slurp.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,9c6d0ac8d78f1a48,start
X-Google-Attributes: gid11355a,public
From: "news.cpinternet.com" <webmaster@netdynasty.com>
Subject: 16 yr old needs ASP/SQL help
Date: 1999/11/06
Message-ID: <86WU3.544$mf7.6830@newsfeed.slurp.net>
X-Deja-AN: 545189747
X-Trace: newsfeed.slurp.net 941895172 209.32.54.43 (Sat, 06 Nov 1999 07:32:52 CDT)
NNTP-Posting-Date: Sat, 06 Nov 1999 07:32:52 CDT
Newsgroups: bit.listserv.sqlinfo
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3