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 ==> >> > sku
namedesc> > 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:
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)