[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:

WC2b15 File Corruption (1997) 2 easy questions re: [showif] and [sendmail] (1997) [SHOWIF]s and empty arguments (1997) Browser Reloads and AddlineItem (1997) no global [username] or [password] displayed ... (1997) Showif, Hideif reverse logic ? (1997) Webcat 2.0.1 date math bug -> Crash! (1997) [WebDNA] Successful, working WebDNA7/CentOS install? (2013) Upgrade to MacOS9 and W*4.1 (1999) Not really WebCat (1997) PCS Customer submissions ? (1997) Country & Ship-to address & other fields ? (1997) pc (1997) Emailer Error 472? (2004) Formatting date to number - more (2000) Part Html part WebDNA (1997) Line items in table cells (1997) OT: Poll Please (2002) weird user / authenticate happenings (2003) Where is f2? (1997)