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:

RE: [taxRate] [TaxTotal] ? (1997) system crashes, event log (1997) [WebDNA] [OT]Firewall advise (2010) EIMS Problems (1997) b12 cannot limit records returned and more. (1997) WebCatalog/Mac 2.1b2 - PIXO (1997) Re:listfiles-looking for slick solution (1997) [WebDNA] Can't write to a db when working on on a iMac (2019) Templates on Unix & CGI on Mac? (1997) Getting total number of items ordered (1997) Large databases in WebCat (1997) japanese characters (1997) ConverChars (1999) Search/sort in URL Was: GuestBook example (1997) [protect] on NT? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) The Form authentication trick (2000) RE: Nesting [ListFiles] (1998) Memory Leak (2000) Separate SSL Server (1997)