Re: Easy access question

2001-05-23 Thread Art Broussard
> 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

RE: Easy access question

2001-05-23 Thread Scott Wolf
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

RE: [Easy access question]

2001-05-23 Thread SMatthews
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

Re: Easy access question

2001-05-23 Thread Paul E. Cross
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

Re: Easy access question

2001-05-23 Thread Seamus Campbell
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

RE: Easy access question

2001-05-23 Thread Bryan Love
use percent (%) instead of star(*) as the wildcard Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]]

Re: Easy access question

2001-05-23 Thread jperlmutter
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:

RE: Easy access question

2001-05-23 Thread James Mathieson
> -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

RE: Easy access question

2001-05-23 Thread Semrau, Steven L Mr SRA
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:

RE: Easy access question

2001-05-23 Thread Adkins, Randy
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

Re: Easy access question

2001-05-23 Thread Dimitar Michailov
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

Re: [Easy access question]

2001-05-23 Thread Alex
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