[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 andfollowing, 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 thearray, then display the records in the array one by one.Using a table would not work, as many users would use the same table. UnlessI use the cart number to differenciate the results for one user, plus asearch ID number to identify the results for this user, in case this usershares his cart number or has several windows open.Maybe SMS could come with a solution to this problem and provide a SQLsearch 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:

[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 andfollowing, 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 thearray, then display the records in the array one by one.Using a table would not work, as many users would use the same table. UnlessI use the cart number to differenciate the results for one user, plus asearch ID number to identify the results for this user, in case this usershares his cart number or has several windows open.Maybe SMS could come with a solution to this problem and provide a SQLsearch 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!

[Request] - SQL Search

2000

Top Articles:

Related Readings: