[Request] - SQL Search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33538
interpreted = N
texte = I had to design a search page using the [SQL] command.In case of a free search, I would like to display the results in this order:1- exact search: ... WHERE FieldName = '[Keywords]' 2- exact substring: ... WHERE FieldName like '%[Keywords]%' 3- AND search: ... WHERE FieldName like '%[Keyword1]%' AND FieldName like '[KeyWord2]%' AND (etc...) 4-OR Search: ... WHERE FieldName like '%[Keyword1]%' OR FieldName like '[KeyWord2]%' OR (etc...)Method 3 and 4 use a [ListWords] contect to separate the words.Now, my problem is: how do I filter out of the results for method 2 and following, the results found by one or many of the previous methods?I would like to use an array, append all the results, unless already in the array, then display the records in the array one by one.Using a table would not work, as many users would use the same table. Unless I use the cart number to differenciate the results for one user, plus a search ID number to identify the results for this user, in case this user shares his cart number or has several windows open.Maybe SMS could come with a solution to this problem and provide a SQL search context that would do all that sorting for us.That would be extra super duper. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. [Request] - SQL Search (Nicolas Verhaeghe 2000)
I had to design a search page using the [SQL] command.In case of a free search, I would like to display the results in this order:1- exact search: ... WHERE FieldName = '[Keywords]' 2- exact substring: ... WHERE FieldName like '%[Keywords]%' 3- AND search: ... WHERE FieldName like '%[Keyword1]%' AND FieldName like '[KeyWord2]%' AND (etc...) 4-OR Search: ... WHERE FieldName like '%[Keyword1]%' OR FieldName like '[KeyWord2]%' OR (etc...)Method 3 and 4 use a [listwords] contect to separate the words.Now, my problem is: how do I filter out of the results for method 2 and following, the results found by one or many of the previous methods?I would like to use an array, append all the results, unless already in the array, then display the records in the array one by one.Using a table would not work, as many users would use the same table. Unless I use the cart number to differenciate the results for one user, plus a search ID number to identify the results for this user, in case this user shares his cart number or has several windows open.Maybe SMS could come with a solution to this problem and provide a SQL search context that would do all that sorting for us.That would be extra super duper. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Nicolas Verhaeghe

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Stinkin' [Referrer] (1998) Wierd thing in ViewOrder.tpl (1999) WC TableGrinder (1997) WebCat2: Items xx to xx shown, etc. (1997) OT: Poll Please (2002) AddLineItem Problem (1997) How do I pass [cart] when user clicks back (2000) Most Efficiant Way to do restricted Areas (1997) ASP and WebCatalog ?? (2000) Spawning Holdup? (2000) Download (1999) This list needs a digest: rant, rave... (1997) 2 Nt's (1998) [OT] photos and misc. (2004) WebCat2: multiple currency support (1997) Showif, Hideif reverse logic ? (1997) WebMerchant (2000) Nested tags count question (1997) passing search criteria (1997) append=T problem (1998)