INVENTORY: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 = 24592
interpreted = N
texte = LOUISE You may want to keep an eye on this thread it is dicussing the ways to do the inventory..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:
LOUISE You may want to keep an eye on this thread it is dicussing the ways to do the inventory..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:
PIXO (1997)
Quickie question on the email templates (1997)
Warning: 50 [MATH] Variable Limit per page (1998)
WCS Newbie question (1997)
Re:Problem displaying search result (1997)
Shownext from POST (2000)
form data submission gets truncated (1997)
Not really WebCat - need HTML Grider (1997)
WebCat b15 Mac plug-in (1997)
WebDNA deletes major DB data big time (2004)
I forgot (1998)
PIXO support (1997)
More on the email templates (1997)
OT-Load balance (2004)
Off-Topic: Automatic FTP scripts for OSX (2003)
So many lookers, hey smith micro (2003)
shipping with weigth (1998)
WCS Newbie question (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Shopping carts and reloading pages (1997)