Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-28 : 08:21:53
|
| Alex writes "I'm trying to perform a search on an access database.i have one table. with different columns.i.e. columns: author, titel,the search should first look for an exact match with author. order by ASCthen exact match with titel order by ASCthen similar match with author order by ASCthen similar match with titel order by ASCthen sould display:exact author if found more order ASCexact titel if found more order ASCsimilar author if found more order ASCsimilar titel if found more order ASCi've done it by loop the recordset with 4 different sql queries and it works.(open the recordset, get data, close, loop with new sql query)!!!main problem!!!but now i want to page through my search results.i've tried it with getrows or the ADO object.but when i loop my recordset with a new sql query my paging data for the first query is lost or it only shows the first query or something else happens...questionis there a way to perform a search with multiple querys and multiple ordering?thanks in advance" |
|
|
|
|
|
Searching Access Database