bj,
I've taken a different direction. As a matter of fact I'm getting ready to
place the code for a search project I built out on my web site. Instead of
going to the database with a search I'm getting back a datatable of all
records and searching those. The method's I've built return a dataview.
So far it functions pretty quickly. I've tested it on up to 10,000 records
in the database of the on of the websites where I work,
www.collect.com. (I
know 10,000 records isn't a lot) But in this case it's more than it seems
because this is our content database. And each article can be up to four or
five pages of text long.
It's pretty speedy so far.
I'll put the project out on my site by tomorrow.
If you want to test it I'm using it for my code library at
www.aboutfortunate.com.
Sincerely,
--
S. Justin Gengo, MCP
Web Developer
Free code library at:
www.aboutfortunate.com
"Out of chaos comes order."
Nietzche
"bj daniels" <da******@gunnery.org> wrote in message
news:uV**************@TK2MSFTNGP09.phx.gbl...
I have a sql server (2000) and I want to add a search capability to my
asp.net page. It will search an Articles table - in particular the
'Article' field (ntext).
I started with the following statement:
sql = "Select * from [articles] where article like '%" & tbquery.text &
"%' " order by dateposted desc, title"
and the results are fine if I only enter one word into the textbox - how
can I make it more functional (using and, or and such)
bj daniels
da******@gunnery.org