Fw: [SQL] and [index] mystery solved

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38123
interpreted = N
texte = For a variety of reasons (CORRUPTION!!) we're migrating many of our dbs to SQL. Our trusty sys admin, Nick, has figured out a way to do a summary report in the sql context founditems.Any general feedback on migrating to sql would be greatly appreciated.----- Original Message ----- From: Nick To: Bob McPeak Cc: Marla Ferrency ; Celeste Paul Sent: Thursday, August 23, 2001 10:48 AM Subject: [SQL] and [index] mystery solved > Ok, the [SQL] context DOES support [index], and I figured out why it wasn't > working in my particular case. Yet another thing we need to take note of, > is that SQL doesn't do summaries on searches like webcatalog does. to make > up for this, I had to simulate it with some [showif]s. This makes [index] > unusable, since [index] will count how many times the [founditems] has looped, > and not how many times our summarized variable was unique. > > Here's our example: > > [text show=F]minskusumm=[/text] > [SQL dsn=gmp&username=root&password=&statement=SELECT * FROM price_search WHERE sku=[something] ORDER BY minsku] > [founditems] > [showif [minskusumm]![minsku]] > > Code goes here. Because we're faking summary support with the [showif] up > above, SQL will return results that we don't use. Each time that happens, > [index] will get a new value. So where the original webcat search would > return index values like 1, 2, 3, 4, etc, our code inside the [showif] here > might see index values like 1, 5, 8, 15, 24, etc. > > [/showif] > [text show=F]minskusumm=[minsku][/text] > [/founditems] > > Hope that explains it. Bob, could you forward this to the talklist? maybe other > people have had this problem too. on summarized variables and SQL>. ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Fw: [SQL] and [index] mystery solved (Bob McPeak 2001)
  2. Re: Fw: [SQL] and [index] mystery solved (John Peacock 2001)
  3. Fw: [SQL] and [index] mystery solved (Bob McPeak 2001)
For a variety of reasons (CORRUPTION!!) we're migrating many of our dbs to SQL. Our trusty sys admin, Nick, has figured out a way to do a summary report in the sql context founditems.Any general feedback on migrating to sql would be greatly appreciated.----- Original Message ----- From: Nick To: Bob McPeak Cc: Marla Ferrency ; Celeste Paul Sent: Thursday, August 23, 2001 10:48 AM Subject: [SQL] and [index] mystery solved > Ok, the [SQL] context DOES support [index], and I figured out why it wasn't > working in my particular case. Yet another thing we need to take note of, > is that SQL doesn't do summaries on searches like webcatalog does. to make > up for this, I had to simulate it with some [showif]s. This makes [index] > unusable, since [index] will count how many times the [founditems] has looped, > and not how many times our summarized variable was unique. > > Here's our example: > > [text show=F]minskusumm=[/text] > [SQL dsn=gmp&username=root&password=&statement=SELECT * FROM price_search WHERE sku=[something] ORDER BY minsku] > [founditems] > [showif [minskusumm]![minsku]] > > Code goes here. Because we're faking summary support with the [showif] up > above, SQL will return results that we don't use. Each time that happens, > [index] will get a new value. So where the original webcat search would > return index values like 1, 2, 3, 4, etc, our code inside the [showif] here > might see index values like 1, 5, 8, 15, 24, etc. > > [/showif] > [text show=F]minskusumm=[minsku][/text] > [/founditems] > > Hope that explains it. Bob, could you forward this to the talklist? maybe other > people have had this problem too. on summarized variables and SQL>. ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Bob McPeak

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:

Mime Headers for Mail (1998) RE: strip .0 off off IPaddress (1999) Problem with [Search] inside of [Loop]? (1997) New cart in ShoppingCarts (2003) lookup command (1997) Any Newsletters out there (1998) Nesting format tags (1997) [WebDNA] Traverse the hierarchy (2008) Sorting Numbers (1997) What happened to my erbcatalogengine folder? (2001) Wireless WebDNA available today! (2000) Case statement (2003) Using files in an Email broadcast (1999) Date or time comparisons have bugs ... (1998) lookup problem (2000) $Quit, $CloseDatabase corrections (1997) WebDNA 4.5.1 for MacOS 9 (2003) Using tags to create a file name (2000) Almost a there but..bye bye NetCloak (1997) Stumpted Again (1997)