Hi All,
I know this isn't CF but this is the only list I know of. Does anyone know any
good SQL lists or a quick answer.
Sorry and thanks.
I've got a form with multiple check boxes that we want to use to send out mass
e-mails to suscribed customers. The sender with slection only the items that
apply to the content of the blast. I'm having a hard time writing the
conditional SQL that will allow one checkbox and multiple checkbox selections.
The embl_sub_trigger = 1 is just the subscribe bit value. Any advice or help
would be appreciated.
<CFQUERY name="blast_going_out" datasource="#Data_Source_dev#">
SELECT *
FROM email_blast_out
WHERE
<CFIF ISDEFINED ("FORM.blast_catv_form")>embl_sub_trigger = 1 AND
embl_ms_brd_cable = 1 OR
<cfelseif ISDEFINED ("FORM.blast_wireless_form")>embl_sub_trigger = 1 AND
embl_ms_brd_fxwirls =1 OR
<cfelseif ISDEFINED ("FORM.blast_wireless_lan_form")>embl_sub_trigger = 1 AND
embl_ms_brd_wirlan = 1 OR
<cfelseif ISDEFINED ("FORM.blast_infra_form")>embl_sub_trigger = 1 AND
embl_ms_cell_infra = 1 OR
<cfelseif ISDEFINED ("FORM.blast_handset_form")>embl_sub_trigger = 1 AND
embl_ms_cell_hand = 1 OR
<cfelseif ISDEFINED ("FORM.blast_vsat_form")>embl_sub_trigger = 1 AND
embl_ms_mic_vsat = 1 OR
<cfelseif ISDEFINED ("FORM.blast_sensors_form")>embl_sub_trigger = 1 AND
embl_ms_mic_sens = 1 OR
<cfelseif ISDEFINED ("FORM.blast_testequip_form")>embl_sub_trigger = 1 AND
embl_ms_mic_testeq = 1 OR
<cfelseif ISDEFINED ("FORM.blast_fiberoptics_form")>embl_sub_trigger = 1 AND
embl_ms_mic_fiboptic = 1 OR
<cfelseif ISDEFINED ("FORM.blast_military_form")>embl_sub_trigger = 1 AND
embl_ms_mic_miltry = 1 OR
<cfelseif ISDEFINED ("FORM.blast_space_form")>embl_sub_trigger = 1 AND
embl_ms_mic_space = 1 OR
<cfelseif ISDEFINED ("FORM.blast_cd_designguid_form")>embl_sub_trigger = 1 AND
embl_lit_cd_designgd = 1 OR
<cfelseif ISDEFINED ("FORM.blast_seltgde_hrd_form")>embl_sub_trigger = 1 AND
embl_lit_seltgde_hrd = 1 OR
<cfelseif ISDEFINED ("FORM.blast_newsletter_form")>embl_sub_trigger = 1 AND
embl_lit_newsletter = 1 OR
<cfelseif ISDEFINED ("FORM.blast_selection_guid_form")>embl_sub_trigger = 1 AND
embl_lit_selectguide = 1 OR
<cfelseif ISDEFINED ("FORM.blast_new_prods_form")>embl_sub_trigger = 1 AND
embl_ann_prod_ann = 1 OR
<cfelseif ISDEFINED ("FORM.blast_new_press_form")>embl_sub_trigger = 1 AND
embl_ann_press_releases = 1 OR
<cfelseif ISDEFINED ("FORM.blast_web_feat_form")>embl_sub_trigger = 1 AND
embl_ann_web_feat = 1 OR
<cfelseif ISDEFINED ("FORM.blast_events_form")>embl_sub_trigger = 1 AND
embl_ann_events = 1 OR
<cfelse>
<!--- ??? USE COLUMN IS NOT NULL AS STUPID DEFAULT THAT WILL NOT EFFECT QUERY
TO COVER LAST RUN "OR" --->
</CFIF>
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
