Thanks Jacob...this worked great!
-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 10:56 AM
To: CF-Talk
Subject:RE: book title listing
What data base are you using? In MS SQL you can use LEFT like so:
where left(booktitle
Assuming you've got dates in one of your fields, you can use
year(date_field) to get just the 4 digit year. For a two digit year,
you could use right(year(date_field),2).
> -Original Message-
> From: Orlini, Robert [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 10, 2006 9:41 AM
>
>
October 10, 2006 11:01 AM
To: CF-Talk
Subject: Re: book title listing
In Oracle you would use SubStr() Something like SubStr(booktitle, 1, 1,)
On 10/10/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
> What data base are you using? In MS SQL you can use LEFT like so:
> wher
OK Chris. Thanks for the coding advice. I'll specify the column instead.
-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:16 AM
To: CF-Talk
Subject: RE: book title listing
And just because nobody else said it
:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:06 AM
To: CF-Talk
Subject: RE: book title listing
Hi Aaron,
where left(booktitle, 1) = 'A'
worked great!
Thanks.
Robert O.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 200
Hi Aaron,
where left(booktitle, 1) = 'A'
worked great!
Thanks.
Robert O.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:01 AM
To: CF-Talk
Subject: Re: book title listing
In Oracle you would use SubStr()
In Oracle you would use SubStr() Something like SubStr(booktitle, 1, 1,)
On 10/10/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>
> What data base are you using? In MS SQL you can use LEFT like so:
> where left(booktitle, 1) = 'A'
>
> This might be the same in the other Databases, not sure.
>
> >
What data base are you using? In MS SQL you can use LEFT like so:
where left(booktitle, 1) = 'A'
This might be the same in the other Databases, not sure.
> -Original Message-
> From: Orlini, Robert [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 10, 2006 8:50 AM
>
> I have a menu li
SELECT *, LEFT(booktitle,1) AS letter
FROM bookinfo
order by booktitle
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 9:50 AM
To: CF-Talk
Subject: book title listing
I have a menu list of books and would like to have it list each
I have a menu list of books and would like to have it list each title
alphabetically BUT only display the listing for one letter.
For instance, the menu page would have A-Z listed and when a user clicks on A
all the titles with A would list. I realize I have to add a where to the
statement, but
10 matches
Mail list logo
