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

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24594
interpreted = N
texte = return=raw goes in the search I believe- ck >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 >-- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 856-273-3255 Fax# 856-273-3721Better a day as a lion, than a lifetime as a lamb.------------------------------------------------------------- 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 -almostthere! (Charles Kline 1999)
return=raw goes in the search I believe- ck >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 >-- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 856-273-3255 Fax# 856-273-3721Better a day as a lion, than a lifetime as a lamb.------------------------------------------------------------- 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 Charles Kline

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:

showif comparison begins w/ and contains (1997) WebMerchant and Mac Auth Hub Help Please (1999) This [search] worked before update to 4.5.1 (2003) [date format] w/in sendmail (1997) different show next (1997) WebCatalog vs. Cold Fusion (1998) Newbie Tax Question (1997) my price won't move (1997) WebDNA 4.5 not starting on boot? (2002) Problem displaying search result (1997) Reversed words (1997) [WebDNA] Convertchars Weirdness (2014) WebMerch/Emailer Error (1998) problem with NT beta (1997) Protect (1997) WebCat2 - [format thousands] (1997) Sorting by date (1997) WebCatalog2 Feature Feedback (1996) Odd request (2003) TXT (2003)