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 = 24589
interpreted = N
texte = Just a few questions:Why are you creating a database for every sku? Dont you think you may accumulate to many databases to keep track of? Why not just uses 1 database? I thought [writefile] did not understand databases? could this be causing some of your problems, I looked over the code real quick and didn't analyze the entire thing. That was just one of my thoughts which could be causing you problems in the long run, but if I am wrong, I congratulate you on getting it to work. As we all know, everything written or not written in the manual isn't always true.Brian Boegershausen WebCatalog Programmer www.collegefever.com ----- Original Message ----- From: John Butler
To: WebCatalog Talk Sent: Thursday, November 18, 1999 12:02 PM Subject: remotely creating and populating a stock inventory db - almost there! > 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=[inter pret][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]=[inter pret][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 ------------------------------------------------------------- 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:
Just a few questions:Why are you creating a database for every sku? Dont you think you may accumulate to many databases to keep track of? Why not just uses 1 database? I thought [writefile] did not understand databases? could this be causing some of your problems, I looked over the code real quick and didn't analyze the entire thing. That was just one of my thoughts which could be causing you problems in the long run, but if I am wrong, I congratulate you on getting it to work. As we all know, everything written or not written in the manual isn't always true.Brian Boegershausen WebCatalog Programmer www.collegefever.com ----- Original Message ----- From: John Butler To: WebCatalog Talk Sent: Thursday, November 18, 1999 12:02 PM Subject: remotely creating and populating a stock inventory db - almost there! > 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=[inter pret][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]=[inter pret][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 ------------------------------------------------------------- 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
Brian Boegershausen
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:
Robert Minor duplicate mail (1997)
using showpage and showcart commands (1996)
a new bug? (1999)
encryption madness (2003)
show all problem (1997)
Help! Missing [showif] or [hideif] (2000)
[WebDNA] TCPconnect and Bitcoin rate (2017)
Mail Server Needed. (1998)
Price override (2004)
Finding max value for a field (1997)
WebCatalog for Postcards ? (1997)
text size limitation (1997)
[WebDNA] New problem with [ShowNext] (2010)
WCS Newbie question (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
World Address Info (2003)
[WebDNA] thisAutonumber? (2011)
WebCat2 - [format thousands] (1997)
Replacing a Word (1999)
quitting (1997)