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 = 24599
interpreted = N
texte = Jym there is no SKU field in those dbs that get created with the templates I posted... it isin the name of the db itself.But maybe doing an ascending sort on that RecordNum field I was going to add would work...But Charles solved it with &rank=off. It works good now, as far as I took it.So anyone out there who wants to use the templates (but for a better reason than I had - areason which doesn't really require more than 1 extra db it seems), replace the table in thatlast template (FGA-ProductNIS-3.tmpl) with this-  [Search db=NIS-[SKU].db&necolordatarq=nadaamigo&rank=off][FoundItems][textshow=T]Findex=[index][/text] [loopstart=1&end=[NumSizeOpts]&advance=1][text show=T]Lindex=[index][/text] [/loop] [/FoundItems][/Search]

[ListFields NIS-[SKU].db][FieldName]	[/ListFields]
[NumSizes]	[NumColors]	[color]	Stock=

-JohnJym Duane wrote:> adding &asSKUsort=1 to search will output assending order of SKU.>> John Butler wrote:>-------------------------------------------------------------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:

Re: remotely creating and populating a stock inventory db -almost there! (John Butler 1999) Re: remotely creating and populating a stock inventory db -almost there! (John Butler 1999) Re: remotely creating and populating a stock inventory db -almost there! (John Butler 1999) Re: remotely creating and populating a stock inventory db -almost there! (Jym Duane 1999) Re: remotely creating and populating a stock inventory db -almost there! (Charles Kline 1999)

Jym there is no SKU field in those dbs that get created with the templates I posted... it isin the name of the db itself.But maybe doing an ascending sort on that RecordNum field I was going to add would work...But Charles solved it with &rank=off. It works good now, as far as I took it.So anyone out there who wants to use the templates (but for a better reason than I had - areason which doesn't really require more than 1 extra db it seems), replace the table in thatlast template (FGA-ProductNIS-3.tmpl) with this-  [Search db=NIS-[SKU].db&necolordatarq=nadaamigo&rank=off][founditems][textshow=T]Findex=[index][/text] [loopstart=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][lookupdb=NIS-[SKU].db&lookInField=color&value=[interpret][NISColor[Findex]][/interpret]&returnField=[interpret][NISSize[Lindex]][/interpret]¬Found=rats][/interpret]SIZE=5>

-JohnJym Duane wrote:> adding &asSKUsort=1 to search will output assending order of SKU.>> John Butler wrote:>-------------------------------------------------------------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  John Butler

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:

Country & Ship-to address & other fields ? (1997) TIP: using [middle] to peel off page.html from [referrer] (2004) More questions about serial number dishing (1997) Re:trouble (1997) Trunk-gator (1997) Another option (2005) [applescript] (2001) RE: ShowNext Command (1997) Multiple prices (1997) Sorting by date (1997) Flash Stores (2003) [WebDNA] Old Problem, the exclamation point (2014) Another site that 4.0.1 seems to have broken (2000) Mac webcatalog3_0_5b11 more dead lock throws (1999) webCatalog and Stocks (1998) Exclamation point (1997) Dynamic Exchange Rates (2002) One other big addition... (1997) NT considerations (1997) Use of Back and Reload Buttons on ShoppingCart page? (1997)