Re: How to best sort in a pre-defined item-by-item order ...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49724
interpreted = N
texte = Kenneth Grome wrote: > It's easy enough to store a bunch of comma-separated skus in the > favorites field in a database record. This is another instance of not using the tool to it's full potential. I have never seen a single instance of someone wanting to store multiple values in a single field that wasn't more efficiently done using multiple rows in a database instead.Create a new database favorites.db with the following columns:userid
hitsSKUwhere [userid] is whatever you have as the unique identifier for the user in your visitors.db.However you want to add the items to the favorites.db initiall, set the [hits] field to 1. As they chose that same link more than once, increment the [hits] column each time. You may want to ensure that they don't have more than X number of favorites (I would suggest 10 or so as the max); you will need to create logic to replace the last record with the new item if they already have the maximum number of favorites listed.Then, when you want to display their favorites list, do a search with reverse sorting on the [hits] column and within the [founditems] loop, do a [lookup] or [search] of the products database for that item's info. This scheme will autosort their favorites in decreasing order of how favored the items it.QEDJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Kenneth Grome wrote: > It's easy enough to store a bunch of comma-separated skus in the > favorites field in a database record. This is another instance of not using the tool to it's full potential. I have never seen a single instance of someone wanting to store multiple values in a single field that wasn't more efficiently done using multiple rows in a database instead.Create a new database favorites.db with the following columns:useridhitsSKUwhere [userid] is whatever you have as the unique identifier for the user in your visitors.db.However you want to add the items to the favorites.db initiall, set the [hits] field to 1. As they chose that same link more than once, increment the [hits] column each time. You may want to ensure that they don't have more than X number of favorites (I would suggest 10 or so as the max); you will need to create logic to replace the last record with the new item if they already have the maximum number of favorites listed.Then, when you want to display their favorites list, do a search with reverse sorting on the [hits] column and within the [founditems] loop, do a [lookup] or [search] of the products database for that item's info. This scheme will autosort their favorites in decreasing order of how favored the items it.QEDJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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://webdna.smithmicro.com/
John Peacock
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:
Trouble with Showif and Search (1998)
Tron? (2008)
[OT] BBedit Blank Line removal (2003)
Unix DB Permission Error (2002)
case=T and [showif] (2002)
Search returns all, not 20 (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Can't save email prefs (2003)
[WAY OFF TOPIC] anybody live in Kansas? (2003)
Security Issues and WebCommerce Solution (1997)
Dark Horse Comics success story (1997)
Help! WebCat2 bug (1997)
Problems getting parameters passed into email. (1997)
encryption (2003)
[WebDNA] Image resizing on the fly (2012)
WebCatalog/Mac 2.1b2 - PIXO (1997)
My first ship table (1998)
Practice runs ? (1997)
WebCat2b15MacPlugin - [protect] (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)