> You are close, the percent sign (%) is your wildcard not (*) just replace
> the character and it should work fine.
>
Doh!!! I should have seen that. : ]
Thanks
Art
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
You should be using T% instead of T*
Even though * is a valid wildcard in Access, all of your queries
in CF have to be written in SQL, which uses % as it's wildcard
character. Damned Microsoftalways gotta be different.
Scott Wolf
Goodfriend Computer Training
-Original Message-
Fro
Art, try using a % instead of * in your Select statement.
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 12:42 PM
To: CF-Talk
Subject: Re: [Easy access question]
T%
"Art Broussard" <[EMAIL PROTECTED]> wrote:
I want to search a dic
Try % instead of *
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index
where name like 'T%'
At 01:31 am 24/05/01 , you wrote:
>I want to search a dictionary table in an access database. I want to find
>all records where the name starts with the letter T.
>
>
>select * from dic
>where name like 'T*'
>order by name
>
>
>This should give me any reco
use percent (%) instead of star(*) as the wildcard
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
The wildcard should be a '%', not a '*'.
select * from dic
where name like 'T%'
order by name
"Art Broussard" <[EMAIL PROTECTED]> on 05/23/2001 11:31:27 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Jan E Perlmutter/BISYS_BPS)
Subject:
> -Original Message-
> From: Art Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 11:31 AM
> To: CF-Talk
> Subject: Easy access question
>
>
> I want to search a dictionary table in an access database. I want
> to find all records where the name starts with the letter T
You are close, the percent sign (%) is your wildcard not (*) just replace
the character and it should work fine.
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-Original Message-
From:
That should work. What are you getting?
You can also do this:
select * from dic
where Left(name,1) = 'T'
order by name
-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 11:31 AM
To: CF-Talk
Subject: Easy access question
I want t
In SQL, these are the wildcard options:
% - match zero or more characters
_ - match a single character
[] - match one of a set of characters.
So your query would be:
select * from dic
where name like 'T%'
order by name
Hope that helps,
Dimo.
- Original Message -
Fro
T%
"Art Broussard" <[EMAIL PROTECTED]> wrote:
I want to search a dictionary table in an access database. I want to find all
records where the name starts with the letter T.
select * from dic
where name like 'T*'
order by name
This should give me any record that has the first lette
12 matches
Mail list logo