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 and is 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.com Jym 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]

> > > > > > Product# [SKU] should have how many size options? > >

> Product# [SKU] should have how many color options? > > > > > > > > -----------------------[/FGA-ProductNIS-0.tmpl]----------------------- > > ***************************************************************************** > > -----------------------[FGA-ProductNIS-1.tmpl]----------------------- > > > > > > > >

Choose size options and color options for the upcoming NIS-[SKU].db for > Product# [SKU]

> > > > > >

Give the Sizes Please:

> [loop start=1&end=[NumSizeOpts]&advance=1] > [SKU] ---NIS Size Option#[index]=
> [/loop] >

>

Give the Colors Please:

> [loop start=1&end=[NumColorOpts]&advance=1] > [SKU] ---NIS Color Option#[index]=
> [/loop] > > > > > > -----------------------[/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

> > > > > > > [loop start=1&end=[NumSizeOpts]&advance=1] > NISSize[index]=[interpret][NISSize[index]][/interpret] NAME=NISSize[index] value=[interpret][NISSize[index]][/interpret]>
> [/loop] >

> [loop start=1&end=[NumColorOpts]&advance=1] > NISColor[index]=[interpret][NISColor[index]][/interpret] NAME=NISColor[index] value=[interpret][NISColor[index]][/interpret]>
> [/loop] > >

> > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][FoundItems][text > show=T]Findex=[index][/text] > [loop > start=1&end=[NumSizeOpts]&advance=1][text show=T]Lindex=[index][/text][/loop] > > [/FoundItems][/Search] >
[ListFields NIS-[SKU].db][FieldName][/ListFields]
[NumSizes][NumColors][color] > Stock= >
> >
> > > > > -----------------------[/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

> >
> >
> > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][FoundItems][text > show=T]Findex=[index][/text] > [loop > start=1&end=[NumSizeOpts]&advance=1][text show=T]Lindex=[index][/text] > [/loop] > [/FoundItems][/Search] >
[ListFields NIS-[SKU].db][FieldName][/ListFields]
[NumSizes][NumColors][color]Stock= db=NIS-[SKU].db&lookInField=color&value=[interpret][NISColor[Findex]][/interpret]&returnField=[interpret][NISSize[Lindex]][/interpret]¬Found=rats][/interpret] > SIZE=5>
> >
> > > > -----------------------[/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:

    
  1. Re: remotely creating and populating a stock inventory db - almost there! (Derrick Puckett 1999)
  2. INVENTORY:Re: remotely creating and populating a stock inventory db - almost there! (Jym Duane 1999)
  3. Re: remotely creating and populating a stock inventory db - almost there! (Jym Duane 1999)
  4. Re: remotely creating and populating a stock inventory db - almost there! (Brian Boegershausen 1999)
  5. Re: remotely creating and populating a stock inventory db - almost there! (John Butler 1999)
  6. remotely creating and populating a stock inventory db - almost there! (John Butler 1999)
JohnThis is great. God bless you . this is an essential feature to offer customers to keep ahead of the comppetion to this product and is 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.com Jym 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]

> > > > > > Product# [SKU] should have how many size options? > >

> Product# [SKU] should have how many color options? > > > > > > > > -----------------------[/FGA-ProductNIS-0.tmpl]----------------------- > > ***************************************************************************** > > -----------------------[FGA-ProductNIS-1.tmpl]----------------------- > > > > > > > >

Choose size options and color options for the upcoming NIS-[SKU].db for > Product# [SKU]

> > > > > >

Give the Sizes Please:

> [loop start=1&end=[NumSizeOpts]&advance=1] > [SKU] ---NIS Size Option#[index]=
> [/loop] >

>

Give the Colors Please:

> [loop start=1&end=[NumColorOpts]&advance=1] > [SKU] ---NIS Color Option#[index]=
> [/loop] > > > > > > -----------------------[/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

> > > > > > > [loop start=1&end=[NumSizeOpts]&advance=1] > NISSize[index]=[interpret][NISSize[index]][/interpret] NAME=NISSize[index] value=[interpret][NISSize[index]][/interpret]>
> [/loop] >

> [loop start=1&end=[NumColorOpts]&advance=1] > NISColor[index]=[interpret][NISColor[index]][/interpret] NAME=NISColor[index] value=[interpret][NISColor[index]][/interpret]>
> [/loop] > >

> > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][founditems][text > show=T]Findex=[index][/text] > [loop > start=1&end=[NumSizeOpts]&advance=1][text show=T]Lindex=[index][/text][/loop] > > [/FoundItems][/Search] >
[ListFields NIS-[SKU].db][FieldName][/ListFields]
[NumSizes][NumColors][color] > Stock= >
> >
> > > > > -----------------------[/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

> >
> >
> > [Search db=NIS-[SKU].db&necolordatarq=nadaamigo][founditems][text > show=T]Findex=[index][/text] > [loop > start=1&end=[NumSizeOpts]&advance=1][text show=T]Lindex=[index][/text] > [/loop] > [/FoundItems][/Search] >
[ListFields NIS-[SKU].db][FieldName][/ListFields]
[NumSizes][NumColors][color]Stock=[interpret][lookup > db=NIS-[SKU].db&lookInField=color&value=[interpret][NISColor[Findex]][/interpret]&returnField=[interpret][NISSize[Lindex]][/interpret]¬Found=rats][/interpret] > SIZE=5>
> >
> > > > -----------------------[/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)