Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: newportri
Greetings
I have a situation where a user fills out a form with 1 to 10 code numbers (Commercial Commodity Codes), which triggers a CFMAIL to all Vendors with those codes.
Would a CFQUERY that had:
SELECT cccategory_ID, ccc_cat_num
FROM cccodes_categories
WHERE ccc_cat_num LIKE '%#form.code_01#%'
OR ..... etc. etc.
be the approach here?
I would need to:
<cfmail to = "vendor@whatever.com"
all the vendors with either 1 or several of the form field codes....</cfmail>
Thanks in advance
rinorman
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied