Won Lee
Tue, 08 Dec 2009 06:48:35 -0800
On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm <damien.dr...@quinn-group.com>wrote:
> > Hi > can someone help me out here, Im trying to have a check box for each > invoice so when its ticked and you press submit all the ticked invoices will > be sent to the revelant email address, > I'm trying to have it so the check boxes will be defaulted to ticked if the > customer Number for the invoice, is in the Customer Table, The next problem > I have is for each Customer I add to the Customer Table its duplicating the > Data and showing everything twice if theres 2 Customers. or 3 times if > theres 3 Customers added and so on, I cant seem to figure out why its doing > this > > any tips would be great 1) only send email to customers who have a checkbox next to them one way would be to <input type="checkbox" name="sendEmail_customerID"> for each record the on the action page loop around the list of IDs and send the emails. 2) have the checkbox defaulted to checked use a <cfif condition>checked </cfif> 3) Looks like you have a Cartesian join. You need to edit your SQL query. Without any code these are my best guesses. W ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4