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 = 24596
interpreted = N
texte = Thank you Brian & Charles!Well the writing to db was not the problem Brian (the fields, records, and values all cameout just the way I wanted them), it was more in the reading that I was having troublewith.And probably you guys are right that I should be using just one options.db as you showbelow Charles.I never thought of doing it the way you suggest... But it makes sense now that you showme.Just for reference, do you know a way to force webcat to return [founditems] in the EXACTorder they appear in a db? (as opposed to seemingly random, or else by sorting on fieldvalues?) If you say no, and if I HAD to continue the way I was going, then I would havetried adding a RecordNum field to all those dynamic product options db's (to sort onthat).maybe someone could try the code I posted just for fun and say, neato! before I dump allthat work......or nevermind. :-)Thanks for your time-JohnCharles 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
Associated Messages, from the most recent to the oldest:
Thank you Brian & Charles!Well the writing to db was not the problem Brian (the fields, records, and values all cameout just the way I wanted them), it was more in the reading that I was having troublewith.And probably you guys are right that I should be using just one options.db as you showbelow Charles.I never thought of doing it the way you suggest... But it makes sense now that you showme.Just for reference, do you know a way to force webcat to return [founditems] in the EXACTorder they appear in a db? (as opposed to seemingly random, or else by sorting on fieldvalues?) If you say no, and if I HAD to continue the way I was going, then I would havetried adding a RecordNum field to all those dynamic product options db's (to sort onthat).maybe someone could try the code I posted just for fun and say, neato! before I dump allthat work......or nevermind. :-)Thanks for your time-JohnCharles 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
John Butler
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:
Determining Method (2000)
I'm tired of all this! (2000)
WebDNA Book? (2003)
Extended [ConvertChars] (1997)
WebCatalog2 Feature Feedback (1996)
oops private message leaked into talk list (1997)
More on the email templates (I like it) (1997)
Upgrading old WebCat Database Files (1997)
Shownext! (1998)
Migrating to NT (1997)
MATH TIME (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Getting the protocol FINAL (2004)
form data submission get (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Wow .. (2003)
WebCat2b12 - New features for 1.6 users ... (1997)
[WebDNA] Detect the server's ip address? (2015)
WebCat2 beta 11 - new prefs ... (1997)
How can I Add several Items into the cart at once? (1997)