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 toSQL. Our trusty sys admin, Nick, has figured out a way to do a summaryreport 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 PaulSent: Thursday, August 23, 2001 10:48 AMSubject: [SQL] and [index] mystery solved> Ok, the [SQL] context DOES support [index], and I figured out why itwasn'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] haslooped,> 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_searchWHERE 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? maybeother> 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:
For a variety of reasons (CORRUPTION!!) we're migrating many of our dbs toSQL. Our trusty sys admin, Nick, has figured out a way to do a summaryreport 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 PaulSent: Thursday, August 23, 2001 10:48 AMSubject: [SQL] and [index] mystery solved> Ok, the [SQL] context DOES support [index], and I figured out why itwasn'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] haslooped,> 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_searchWHERE 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? maybeother> 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:
Canadian Postal Codes (location-based searching) (2001)
sort problems....bug or brain fart? (1997)
[WebDNA] HTML forum (2008)
Multiple prices (1997)
Moment of Thanks (1997)
too many nested tags ... (1997)
WC2.0 Memory Requirements (1997)
&fieldsdir=ra truely random?? (2000)
OT: Unix Geek Needed (2005)
multi-paragraph fields (1997)
PCS Emailer's role ? (1997)
GuestBook example (1997)
Databases (2000)
Frames and WebCat (1997)
Hiding the URL(was Cart ID Duplication) (2001)
Locking up with WebCatalog... (1997)
RE: protect tag not working (1998)
One per customer (2000)
RE: Questions To Answer (1997)
japanese characters (1997)