Re: Easy access question
> 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://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easy access question
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- 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. select * from dic where name like 'T*' order by name This should give me any record that has the first letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists
RE: [Easy access question]
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 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 letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists
Re: Easy access question
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.cfm?sidebar=lists
Re: Easy access question
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 record that has the first letter in name start >with T right? Wrong. : ( > >What am I doing wrong??? > >Art > > > ~~ 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.cfm?sidebar=lists
RE: Easy access question
use percent (%) instead of star(*) as the wildcard Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 8: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. select * from dic where name like 'T*' order by name This should give me any record that has the first letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists
Re: Easy access question
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: 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. select * from dic where name like 'T*' order by name This should give me any record that has the first letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists
RE: Easy access question
> -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. > > >select * from dic >where name like 'T*' >order by name > > > This should give me any record that has the first letter in name > start with T right? Wrong. : ( > > What am I doing wrong??? > > Art > Try where name like 'T%' I just went through this myself, going half-mad (since * does work in an Access query) until I opened my CFWACK and noticed the % instead of * Unless I went totally mad and it was the other way around James Mathieson Information Systems Manager The Wildlife Society 5410 Grosvenor Lane Bethesda, MD 20814-2197 PH: 301-897-9770 Fax: 301-530-2471 [EMAIL PROTECTED] http://www.wildlife.org/ ~~ 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.cfm?sidebar=lists
RE: Easy access question
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: 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. select * from dic where name like 'T*' order by name This should give me any record that has the first letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists
RE: Easy access question
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 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 letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists
Re: Easy access question
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 - From: "Art Broussard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 23, 2001 11:31 AM 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. > > >select * from dic >where name like 'T*' >order by name > > > This should give me any record that has the first letter in name start with T right? Wrong. : ( > > What am I doing wrong??? > > Art > > > ~~ 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.cfm?sidebar=lists
Re: [Easy access question]
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 letter in name start with T right? Wrong. : ( What am I doing wrong??? Art ~~ 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.cfm?sidebar=lists