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
Re: How would I write this query...
WHERE companynamecolumn LIKE cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.letter#% 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...
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...
Would that be ... WHERE CompanyName LIKE '#form.CompanyName#%' -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com 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...
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...
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 cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.letter#% ~| 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...
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