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 = 24591
interpreted = N
texte = JohnThis is great. God bless you .this is an essential feature to offer customers to keep ahead of the comppetion to this product andis something we had just embarked on ourselves. We appreciate your willingness to share and will reciprocate if we find and make any additions/changes/improvements.Please keep me on your list for testing. We will be trying it out asap.jym@cyberlive.comJym Duane.John Butler wrote:> Good day :-)>> ***** I need help from you serious webcat programmers out there.. ******>> This is a bit long but some may find some useful code they want :-)>> My site sells items that come in different sizes and colors and I want to offer all> those different sizes and colors using only one SKU per item. I am nearly successful>> in creating an additional feature of my site's admin area which will allow the admin> person to create (via browser) and view a db (which is relational to the main> products.db)> that stores a SKU's number in stock (NIS) for each size/color variation of that> SKU. (Note that there is no limit to the number of fields one can create as with the> recent omnibase app.)>> I just need help with that last section below (FGA-ProductNIS-3.tmpl), but I'll> post the code for the preceding pages as well so you see where I am going and so people> can> have the code if they want. These pages work great to create the db properly, and in>> populating it (the [replace] in FGA-ProductNIS-3.tmpl), but in viewing the> final db (the
in FGA-ProductNIS-3.tmpl), the rows of values shown in the> table do not match with the records in the db. Sooo close... I just need this last> 'viewing of> the db' working because I want the user to be able to resubmit to repopulate all the> fields in all the> records if needed.>> Any help would be GREATLY appreciated.>> try it out!!>> (In all pages, only the relevant code is included.)>> -----------------------[FGA-ProductCatalog.tmpl]----------------------->> > > > > > >> [Search db=FG-products.db&neSKUdata=NadaAmingo&max=100]> [foundItems]> setup> [/foundItems]> [/Search]> > >> -----------------------[/FGA-ProductCatalog.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-0.tmpl]----------------------->> > > > > > > Choose how many fields and records for NumInStock database for Product#> [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-0.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-1.tmpl]----------------------->> > > > > > > Choose size options and color options for the upcoming NIS-[SKU].db for> Product# [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-1.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-2.tmpl]----------------------->> > > > > > >> [WriteFile NIS-[SKU].db]NumSizes NumColors color[loop start=1&end=[NumSizeOpts]&advance=1]> [interpret][NISSize[index]][/interpret][/loop]> [/WriteFile]> [loop start=1&end=[interpret][NumColorOpts][/interpret]&advance=1][Append> db=NIS-[SKU].db]NumSizes=[NumSizeOpts]&NumColors=[NumColorOpts]&color=[interpret][NISColor[index]][/interpret][/Append][/loop]>> [interpret][closedatabase NIS-[SKU].db][/interpret]>> Please enter values for NIS (Number In Stock) for each size/color variation> for db- NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-2.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-3.tmpl]----------------------->> > > > > > > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][FoundItems][text> show=f]Findex=[index][/text]> [Replace db=NIS-[SKU].db&eqcolordatarq=[color]]color=[color][loop> start=1&end=[NumSizeOpts]&advance=1][text> show=f]Lindex=[index][/text]&[interpret][NISSize[Lindex]][/interpret]=[interpret][x[Lindex]y[Findex]][/interpret][/loop][/Replace]>> [/FoundItems][/Search]> [interpret][COMMITDATABASE NIS-[SKU].db][/interpret]>> See your newly populated COLOR=#AA1177>NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-3.tmpl]----------------------->> *****************************************************************************>> -------------------------------------------------------------> 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:
JohnThis is great. God bless you .this is an essential feature to offer customers to keep ahead of the comppetion to this product andis something we had just embarked on ourselves. We appreciate your willingness to share and will reciprocate if we find and make any additions/changes/improvements.Please keep me on your list for testing. We will be trying it out asap.jym@cyberlive.comJym Duane.John Butler wrote:> Good day :-)>> ***** I need help from you serious webcat programmers out there.. ******>> This is a bit long but some may find some useful code they want :-)>> My site sells items that come in different sizes and colors and I want to offer all> those different sizes and colors using only one SKU per item. I am nearly successful>> in creating an additional feature of my site's admin area which will allow the admin> person to create (via browser) and view a db (which is relational to the main> products.db)> that stores a SKU's number in stock (NIS) for each size/color variation of that> SKU. (Note that there is no limit to the number of fields one can create as with the> recent omnibase app.)>> I just need help with that last section below (FGA-ProductNIS-3.tmpl), but I'll> post the code for the preceding pages as well so you see where I am going and so people> can> have the code if they want. These pages work great to create the db properly, and in>> populating it (the [replace] in FGA-ProductNIS-3.tmpl), but in viewing the> final db (the in FGA-ProductNIS-3.tmpl), the rows of values shown in the> table do not match with the records in the db. Sooo close... I just need this last> 'viewing of> the db' working because I want the user to be able to resubmit to repopulate all the> fields in all the> records if needed.>> Any help would be GREATLY appreciated.>> try it out!!>> (In all pages, only the relevant code is included.)>> -----------------------[FGA-ProductCatalog.tmpl]----------------------->> > > > > > >> [Search db=FG-products.db&neSKUdata=NadaAmingo&max=100]> [founditems]> setup> [/foundItems]> [/Search]> > >> -----------------------[/FGA-ProductCatalog.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-0.tmpl]----------------------->> > > > > > > Choose how many fields and records for NumInStock database for Product#> [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-0.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-1.tmpl]----------------------->> > > > > > > Choose size options and color options for the upcoming NIS-[SKU].db for> Product# [SKU]
>> > > >> -----------------------[/FGA-ProductNIS-1.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-2.tmpl]----------------------->> > > > > > >> [WriteFile NIS-[SKU].db]NumSizes NumColors color[loop start=1&end=[NumSizeOpts]&advance=1]> [interpret][NISSize[index]][/interpret][/loop]> [/WriteFile]> [loop start=1&end=[interpret][NumColorOpts][/interpret]&advance=1][Append> db=NIS-[SKU].db]NumSizes=[NumSizeOpts]&NumColors=[NumColorOpts]&color=[interpret][NISColor[index]][/interpret][/Append][/loop]>> [interpret][closedatabase NIS-[SKU].db][/interpret]>> Please enter values for NIS (Number In Stock) for each size/color variation> for db- NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-2.tmpl]----------------------->> *****************************************************************************>> -----------------------[FGA-ProductNIS-3.tmpl]----------------------->> > > > > > > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][founditems][text> show=f]Findex=[index][/text]> [Replace db=NIS-[SKU].db&eqcolordatarq=[color]]color=[color][loop> start=1&end=[NumSizeOpts]&advance=1][text> show=f]Lindex=[index][/text]&[interpret][NISSize[Lindex]][/interpret]=[interpret][x[Lindex]y[Findex]][/interpret][/loop][/Replace]>> [/FoundItems][/Search]> [interpret][COMMITDATABASE NIS-[SKU].db][/interpret]>> See your newly populated COLOR=#AA1177>NIS-[SKU].db
>> > > >> -----------------------[/FGA-ProductNIS-3.tmpl]----------------------->> *****************************************************************************>> -------------------------------------------------------------> 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:
Multiple Merchant Accounts? (1997)
Progress !! WAS: Trouble with formula.db (1997)
[isfile] ? (1997)
question: back button prevention (1997)
Our Webcat site launched (1997)
need e-commerce recommendation (2004)
Post Test - Set Cookie Problem (2008)
[WebDNA] webdna email breaking (2011)
WebCatalog can't find database (1997)
WebCat2 - many [carts] on one template page? (1997)
This is a Test, sorry (1999)
anyone interested in doing an open-source WebCat basedforum? (2002)
Multiple prices (1997)
[OT] - CSS Based Layout and Design (2004)
Emailer help....! (1997)
WebCatalog and WebTen (1997)
Support ?? (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Formating Tables w/[founditems] (1998)
User Authentication (2003)