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 right should'nt it be select distinct(category) from etable If 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 PM Subject: 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 right should'nt it be select distinct(category) from etable If 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 PM Subject: 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:
Needed, Freelance Web Developer (2007)
RE:DatabaseHelper (1997)
A quickie question (1997)
Search design (1997)
Re:Help name our technology! (1997)
Cookie setting (2003)
Sorting... stumped. (2006)
how is this possible (2000)
Trouble with formula.db + more explanation (1997)
WebCat2: Formulas.db question (1997)
The word TYPE in search contexts and fields (1998)
SET-payment (2000)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Max Include levels (2000)
PSC recommends what date format yr 2000??? (1997)
Word wrapping (1997)
wierd [cart] action! (1997)
Search and sort (2001)
read and write you own cookies with webcat (1997)
sendmail formatting (2001)