Re: remotely creating and populating a stock inventory db -almost there!

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24595
interpreted = N
texte = adding &asSKUsort=1 to search will output assending order of SKU.John Butler wrote:> Thank you Brian & Charles! > > Well the writing to db was not the problem Brian (the fields, records, and values all came > out just the way I wanted them), it was more in the reading that I was having trouble > with. > And probably you guys are right that I should be using just one options.db as you show > below Charles. > I never thought of doing it the way you suggest... But it makes sense now that you show > me. > > Just for reference, do you know a way to force webcat to return [founditems] in the EXACT > order they appear in a db? (as opposed to seemingly random, or else by sorting on field > values?) If you say no, and if I HAD to continue the way I was going, then I would have > tried adding a RecordNum field to all those dynamic product options db's (to sort on > that). > > maybe someone could try the code I posted just for fun and say, neato! before I dump all > that work... > ...or nevermind. :-) > > Thanks for your time > > -John > > Charles Kline wrote: > > > I think there are much easier ways to do this than it appears you are > > trying to do. > > > > This is done with just two databases. > > > > one contains the products. > > > > another contains the options. > > > > so you would have something like: > > > > == catalog.db == > > > > skunamedesc > > 100a shirtthis is a cool shirt > > > > == options.db == > > > > oiduidtypevalue > > 1001colortan > > 1002colorblue > > 1003sizesmall > > 1004sizelarge > > > > The options database is related to the catalog.db and the items are bound > > together 'cause they share the same 'sku/oid'. > > > > Only two dbs to deal with. > > > > - ck > > - > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 -- _/_/_/CyberLive, Inc.\_\_\_ _/_/_/_/_/ Jym Duane \_\_\_\_\_\_ Marketing / Custom Design \ E-Commerce Phone: (949) 443-1323 Fax: (949)443-1360 Email: sales@cyberlive.com Web: http://www.cyberlive.com _/_/_/_/_/_/_/_/_/_/_/_/_/_/ \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/_/_/_/_/ The Internet Services Professionals \_\_\_\_\_\_\_ 31781 Camino Capistrano, Suite 302, San Juan Capistrano, CA 92675------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: remotely creating and populating a stock inventory db -almost there! (John Butler 1999)
  2. Re: remotely creating and populating a stock inventory db -almost there! (John Butler 1999)
  3. Re: remotely creating and populating a stock inventory db -almost there! (John Butler 1999)
  4. Re: remotely creating and populating a stock inventory db -almost there! (Jym Duane 1999)
  5. Re: remotely creating and populating a stock inventory db -almost there! (Charles Kline 1999)
adding &asSKUsort=1 to search will output assending order of SKU.John Butler wrote:> Thank you Brian & Charles! > > Well the writing to db was not the problem Brian (the fields, records, and values all came > out just the way I wanted them), it was more in the reading that I was having trouble > with. > And probably you guys are right that I should be using just one options.db as you show > below Charles. > I never thought of doing it the way you suggest... But it makes sense now that you show > me. > > Just for reference, do you know a way to force webcat to return [founditems] in the EXACT > order they appear in a db? (as opposed to seemingly random, or else by sorting on field > values?) If you say no, and if I HAD to continue the way I was going, then I would have > tried adding a RecordNum field to all those dynamic product options db's (to sort on > that). > > maybe someone could try the code I posted just for fun and say, neato! before I dump all > that work... > ...or nevermind. :-) > > Thanks for your time > > -John > > Charles Kline wrote: > > > I think there are much easier ways to do this than it appears you are > > trying to do. > > > > This is done with just two databases. > > > > one contains the products. > > > > another contains the options. > > > > so you would have something like: > > > > == catalog.db == > > > > skunamedesc > > 100a shirtthis is a cool shirt > > > > == options.db == > > > > oiduidtypevalue > > 1001colortan > > 1002colorblue > > 1003sizesmall > > 1004sizelarge > > > > The options database is related to the catalog.db and the items are bound > > together 'cause they share the same 'sku/oid'. > > > > Only two dbs to deal with. > > > > - ck > > - > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 -- _/_/_/CyberLive, Inc.\_\_\_ _/_/_/_/_/ Jym Duane \_\_\_\_\_\_ Marketing / Custom Design \ E-Commerce Phone: (949) 443-1323 Fax: (949)443-1360 Email: sales@cyberlive.com Web: http://www.cyberlive.com _/_/_/_/_/_/_/_/_/_/_/_/_/_/ \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/_/_/_/_/ The Internet Services Professionals \_\_\_\_\_\_\_ 31781 Camino Capistrano, Suite 302, San Juan Capistrano, CA 92675------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Jym Duane

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:

[WebDNA] prevent database duplicates (2019) Requiring that certain fields be completed (1997) Help HTML reader (1999) [WebDNA] File Include HTM (2008) Formulas.db + Users.db (1997) Sort Issue? (2000) SSL question (2005) searchable list archive (1997) won't serve .tpl (2000) For Grant: Webcatalog 4.0 - When will we be able to beta testit? (2000) Is there a 'does not contain' comparison? (1999) Dual Processors (2008) Separate SSL Server (1997) WCS Newbie question (1997) Forcing a NEWCART (1997) Expected behavior? (1998) Search for specific characters in a string (2005) Is the list server working? (1998) 2.1b3 --> way slow (1997) shipping costs (2000)