Re: real beginner stumped
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33359
interpreted = N
texte = I think your sql command is not rightshould'nt it beselect distinct(category) from etableIf it still fails to deliver results, then try this approachselect distinct(category) as category_distinct from etableand use [category_distinct] in your [founditmes] loop,hope this worksanup----- Original Message -----From: chris h ssd
To: WebCatalog Talk Sent: Monday, June 19, 2000 12:48 PMSubject: real beginner stumped> Hello,> I've got a question....> does anyone see anything wrong with this?>> >> [browsername]> [date]> [SQL dsn=ingram&statement=SELECT DISTINCT etable.Category FROM etable]> Found [NumFound] items
> [FoundItems]> [Category]
> [/FoundItems]> [/SQL]>> for some reason it will not display anything... if i run the same code> in cold fusion 4, and asp it works fine.>> Also is there a setting to display any sort of debuging code?>>> chris>>>> -------------------------------------------------------------> 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/-------------------------------------------------------------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:
I think your sql command is not rightshould'nt it beselect distinct(category) from etableIf it still fails to deliver results, then try this approachselect distinct(category) as category_distinct from etableand use [category_distinct] in your [founditmes] loop,hope this worksanup----- Original Message -----From: chris h ssd To: WebCatalog Talk Sent: Monday, June 19, 2000 12:48 PMSubject: real beginner stumped> Hello,> I've got a question....> does anyone see anything wrong with this?>> >> [browsername]> [date]> [SQL dsn=ingram&statement=SELECT DISTINCT etable.Category FROM etable]> Found [NumFound] items
> [founditems]> [Category]
> [/FoundItems]> [/SQL]>> for some reason it will not display anything... if i run the same code> in cold fusion 4, and asp it works fine.>> Also is there a setting to display any sort of debuging code?>>> chris>>>> -------------------------------------------------------------> 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/-------------------------------------------------------------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/
Anup Setty
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:
WebMerchant and Mac Auth Hub Help Please (1999)
my price won't move (1997)
Word wrapping (1997)
Three new problems, maybe a fourth (1997)
Error: Error: expected [/APPLICATION] ??? (1998)
WC2.0 Memory Requirements (1997)
Help! WebCat2 bug (1997)
.html to .tpl (1998)
Multiple fields on 1 input (1997)
Re:Remote stockroom ? (1998)
Search results templates (1996)
WebDNA Challenge - Was: Why WebDNA is not popular (2002)
Heads up, cookies *may* be outlawed in Europe (2001)
tcpconnect/tcpsend frustrations (2002)
Help! Strange happenings... (1997)
[Sum] function? (1997)
AppleScript: Tell application:app location? (1998)
b12 cannot limit records returned and more. (1997)
Director 7 (1999)
Dealer locator (1998)