RE: How would I write this query...
Thanks, Baz & Josh, too! Rick > -Original Message- > From: Baz [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 19, 2006 9:55 PM > To: CF-Talk > Subject: RE: How would I write this query... > > > SELECT * > FROM XYZ > WHERE ColumnName like 'A%' > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How would I write this query...
Thanks, James! Rick > -Original Message- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 19, 2006 9:54 PM > To: CF-Talk > Subject: Re: How would I write this query... > > > WHERE companynamecolumn > LIKE > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How would I write this query...
Perfect...thanks, Charlie... Rick > -Original Message- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 19, 2006 9:52 PM > To: CF-Talk > Subject: Re: How would I write this query... > > > WHERE > companyName LIKE '#form.companyName#%' > > the LIKE is similar to 'contains'. the % is a wildcard character, so > putting it at the end of the string means any string that starts with > #form.companyName#. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232889 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How would I write this query...
Would that be ... WHERE CompanyName LIKE '#form.CompanyName#%' -- Josh - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Sunday, February 19, 2006 6:43 PM Subject: How would I write this query... > What I'm after would be a list > of the company names that > match the letters in the form field > that start with the first letter of > the company name...not with the > form field letters just anywhere in the > name... > > E.g > > Search for the letter "A" would bring up > > Allstate > AIM > > Not: > > Hartford > Allstate > AIM > > or > > if the search was for "All"... > > Allstate > > would match... > > ??? > > Rick > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232887 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How would I write this query...
SELECT * FROM XYZ WHERE ColumnName like 'A%' -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, February 19, 2006 9:43 PM To: CF-Talk Subject: How would I write this query... What I'm after would be a list of the company names that match the letters in the form field that start with the first letter of the company name...not with the form field letters just anywhere in the name... E.g Search for the letter "A" would bring up Allstate AIM Not: Hartford Allstate AIM or if the search was for "All"... Allstate would match... ??? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232886 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How would I write this query...
WHERE companynamecolumn LIKE On 2/20/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > What I'm after would be a list > of the company names that > match the letters in the form field > that start with the first letter of > the company name...not with the > form field letters just anywhere in the > name... > > E.g > > Search for the letter "A" would bring up > > Allstate > AIM > > Not: > > Hartford > Allstate > AIM > > or > > if the search was for "All"... > > Allstate > > would match... -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232885 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How would I write this query...
WHERE companyName LIKE '#form.companyName#%' the LIKE is similar to 'contains'. the % is a wildcard character, so putting it at the end of the string means any string that starts with #form.companyName#. On 2/19/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > What I'm after would be a list > of the company names that > match the letters in the form field > that start with the first letter of > the company name...not with the > form field letters just anywhere in the > name... > > E.g > > Search for the letter "A" would bring up > > Allstate > AIM > > Not: > > Hartford > Allstate > AIM > > or > > if the search was for "All"... > > Allstate > > would match... > > ??? > > Rick > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232883 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54