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:

Re:no [search] with NT (1997) Protect (1997) Looking for someone to double check my code... (1999) Loss in form (1998) Where's Cart Created ? (1997) Search returns all, not 20 (1997) finding child records of child records of child records... with minimal code (2000) Users and groups for local directories (1999) WCS Newbie question (1997) Ignoring [OrderFile] context (2005) price on detail, but not shoppingcart (1997) Setting up WebCatalog with Retail Pro data (1996) Subject: Authenticating users without dialog box (1997) Math (1997) U&P IIS concept (1998) PCS Frames (1997) Security Levels... Possible? (2000) FYI: virus alert (1996) Text limits in NT version? (1997) Single Link browsing (1997)