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:
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)