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:

SQL Error 22003 (2001) [WebDNA] Different settings on old vs new admin pages (2010) Revisit: speed test (2002) [WebDNA] agree? --> [url] broken inside [redirect], on a square-bracket-style include, included from a XML-style page (2009) sort without the or a (1998) Nested tags count question (1997) protect tag on NT IIS (1997) [WebDNA] Invitation to connect on LinkedIn (2011) Authenticate (1997) [WebDNA] An actual attempt to get WebDNA and MAMP Pro to work - (2018) Stopping bad HTML propagation ? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) WebCat Mac OS X and Encrypt Help Need (2000) no global [username] or [password] displayed ... (1997) ListFields and [name] (1997) New Plug-in and Type 11 errors (1997) Partner Edition question ... (2003) [url] link (1998) Calculating multiple shipping... (1997) Non-Cart Files in Shopping Cart Folder (1997)