I found an answer ...
<CFQUERY name="blast_going_out" datasource="#Data_Source_dev#">
SELECT *
FROM email_blast
WHERE 1 = 0
<CFIF ISDEFINED ("FORM.blast_catv_form")>OR embl_sub_trigger = 1 AND embl_ms_brd_cable
= 1
<cfelseif ISDEFINED ("FORM.blast_wireless_form")>OR embl_sub_trigger = 1 AND
embl_ms_brd_fxwirls =1
<cfelseif ISDEFINED ("FORM.blast_wireless_lan_form")>OR embl_sub_trigger = 1 AND
embl_ms_brd_wirlan = 1
<cfelseif ISDEFINED ("FORM.blast_infra_form")>OR embl_sub_trigger = 1 AND
embl_ms_cell_infra = 1
<cfelseif ISDEFINED ("FORM.blast_handset_form")>OR embl_sub_trigger = 1 AND
embl_ms_cell_hand = 1
<cfelseif ISDEFINED ("FORM.blast_vsat_form")>OR embl_sub_trigger = 1 AND
embl_ms_mic_vsat = 1
<cfelseif ISDEFINED ("FORM.blast_sensors_form")>OR embl_sub_trigger = 1 AND
embl_ms_mic_sens = 1
<cfelseif ISDEFINED ("FORM.blast_testequip_form")>OR embl_sub_trigger = 1 AND
embl_ms_mic_testeq = 1
<cfelseif ISDEFINED ("FORM.blast_fiberoptics_form")>OR embl_sub_trigger = 1 AND
embl_ms_mic_fiboptic = 1
<cfelseif ISDEFINED ("FORM.blast_military_form")>OR embl_sub_trigger = 1 AND
embl_ms_mic_miltry = 1
<cfelseif ISDEFINED ("FORM.blast_space_form")>OR embl_sub_trigger = 1 AND
embl_ms_mic_space = 1
<cfelseif ISDEFINED ("FORM.blast_cd_designguid_form")>OR embl_sub_trigger = 1 AND
embl_lit_cd_designgd = 1
<cfelseif ISDEFINED ("FORM.blast_seltgde_hrd_form")>OR embl_sub_trigger = 1 AND
embl_lit_seltgde_hrd = 1
<cfelseif ISDEFINED ("FORM.blast_newsletter_form")>OR embl_sub_trigger = 1 AND
embl_lit_newsletter = 1
<cfelseif ISDEFINED ("FORM.blast_selection_guid_form")>OR embl_sub_trigger = 1 AND
embl_lit_selectguide = 1
<cfelseif ISDEFINED ("FORM.blast_new_prods_form")>OR embl_sub_trigger = 1 AND
embl_ann_prod_ann = 1
<cfelseif ISDEFINED ("FORM.blast_new_press_form")>OR embl_sub_trigger = 1 AND
embl_ann_press_releases = 1
<cfelseif ISDEFINED ("FORM.blast_web_feat_form")>OR embl_sub_trigger = 1 AND
embl_ann_web_feat = 1
<cfelseif ISDEFINED ("FORM.blast_events_form")>OR embl_sub_trigger = 1 AND
embl_ann_events = 1
</CFIF>
</CFQUERY>
>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
