Re: real beginner stumped

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33363
interpreted = N
texte = Hello,thank you for responding, but even if i use 'select * from etable' nothing comes up other than the top 2 values, which i stuck in there just see if its working at all. I know the ingram dns is working. /its an access database/ any clue? chris[browsername] [date] [SQL dsn=ingram&statement=select * from etable] Found [NumFound] items
[FoundItems] [u]
[/FoundItems] [/SQL]----- Original Message ----- From: Anup Setty To: WebCatalog Talk Sent: Monday, June 19, 2000 2:29 PM Subject: Re: real beginner stumped > 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 approach > > select distinct(category) as category_distinct from etable > > and use [category_distinct] in your [founditmes] loop, > hope this works > > anup > > ----- 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/ ------------------------------------------------------------- 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: real beginner stumped (Scott Anderson 2000)
  2. Re: real beginner stumped (chris h ssd 2000)
  3. Re: real beginner stumped (Anup Setty 2000)
  4. Re: real beginner stumped (Matt 2000)
  5. Re: real beginner stumped (Kim Ingram 2000)
  6. Re: real beginner stumped (chris h ssd 2000)
  7. real beginner stumped (chris h ssd 2000)
Hello,thank you for responding, but even if i use 'select * from etable' nothing comes up other than the top 2 values, which i stuck in there just see if its working at all. I know the ingram dns is working. /its an access database/ any clue? chris[browsername] [date] [SQL dsn=ingram&statement=select * from etable] Found [NumFound] items
[founditems] [u]
[/FoundItems] [/SQL]----- Original Message ----- From: Anup Setty To: WebCatalog Talk Sent: Monday, June 19, 2000 2:29 PM Subject: Re: real beginner stumped > 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 approach > > select distinct(category) as category_distinct from etable > > and use [category_distinct] in your [founditmes] loop, > hope this works > > anup > > ----- 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/ ------------------------------------------------------------- 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/ chris h ssd

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:

New Mac Emailer... (1997) Some Questions (1997) WC2.0 Memory Requirements (1997) Calculating multiple shipping... (1997) Now you see it now you donīt (1997) Include a big block of text (1997) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) A quickie question (1997) send mail problem? (1997) restart needed???? (1997) Problem with formatting dates stored in db (2003) [WebDNA] Why doesn't middle work as expected? (2009) Error Lob.db records error message not name (1997) WebCatalog 2.0 b 15 mac (1997) Have no fear of WebCatalog Builder..... (2000) [WebDNA] 301 redirect on linux (2010) Navigator 4.01 (1997) [WebDNA] Mass email using WebDNA (2008) WebCatalog 2.1b3 - Plugin or cgi ? (1997) Help! WebCat2 bug (1997)