Re: Check boxes
>>SET ColumnA = '#form.var1#' WHERE ColumnB IN (#form.var2#) How ever, make sure you check for form.var2 not being empty, because ColumnB IN () causes an error. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
lol On 3/4/2011 12:26 PM, Matt Quackenbush wrote: > Be sure to add to your query. If you want to know why, > post a link to your live site, and we can show you. :-) > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
Be sure to add to your query. If you want to know why, post a link to your live site, and we can show you. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
That is exactly what I was going to suggest. Good job. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
Never mind -- I figured it out. This works: UPDATE aTable SET ColumnA = '#form.var1#' WHERE ColumnB IN (#form.var2#) I had tried using IN in my update query except that I didn't include the parentheses. Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
Are you doing the update via a SQL statement or stored proc? On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams wrote: > > Hello all -- > > I have a form that contains checkboxes which sends multiple record numbers > to > an action form for processing. For example, it would send: > > formfield1="ABC" > formfield2=1,2,3,4,5,6,7 > > In the database I want to update the formfield1 column to ABC wherever the > formfield2 column value is either 1 or 2 or 3 or 4 or 5 or 6 or 7. > > I've tried a few different ways to do this, but only one record gets > updated. > > Any tips on how I can accomplish this? > > Scott > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
update tablename set formfield1 = where formfield2 in On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams wrote: > > Hello all -- > > I have a form that contains checkboxes which sends multiple record numbers > to > an action form for processing. For example, it would send: > > formfield1="ABC" > formfield2=1,2,3,4,5,6,7 > > In the database I want to update the formfield1 column to ABC wherever the > formfield2 column value is either 1 or 2 or 3 or 4 or 5 or 6 or 7. > > I've tried a few different ways to do this, but only one record gets > updated. > > Any tips on how I can accomplish this? > > Scott > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Check boxes
Hello all -- I have a form that contains checkboxes which sends multiple record numbers to an action form for processing. For example, it would send: formfield1="ABC" formfield2=1,2,3,4,5,6,7 In the database I want to update the formfield1 column to ABC wherever the formfield2 column value is either 1 or 2 or 3 or 4 or 5 or 6 or 7. I've tried a few different ways to do this, but only one record gets updated. Any tips on how I can accomplish this? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check Boxes
On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm wrote: > > The company table represents the seller, and the Customer table represents > the individual Buyers. > Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table > > If that is the case then the query should work COMPANY <-> INVOICE <-> CUSTOMER This is how the information is joined. ~| 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:328962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
The company table represents the seller, and the Customer table represents the individual Buyers. Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table ~| 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:328961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check Boxes
On Tue, Dec 8, 2009 at 10:35 AM, Damo Drumm wrote: > > This was what i meant to put in instead of qgetcustomer query > So am I still missing a join somewhere > > > >select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum >from INVOICE >where INVOICE_Key = #url.invoice# > > > > > > based on the code you sent me, yes I believe you are still missing a join in qgetinvoices select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name from INVOICE I, COMPANY C, CUSTOMER CU where I.COMPANY_Number = C.COMPANY_Number and CU.invoice_number = I.invoice_number This all depends if invoice_number is unique in the invoice table. if it isn't then you have more work to do. If so, this is the basic query. Then you can add in more conditions to the where clause get only the results you want. In this schema, what does the company represent? the seller, the buyer, both? Is the customer an individual or a company? if it is a company why are there to separate tables? Not saying any of your schema is incorrect. Just relevant information to try help you. Even if there was something wrong with the schema not sure you could even change it right now. ~| 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:328956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum from INVOICE where INVOICE_Key = #url.invoice# ~| 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:328955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
> > > > select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, > C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name > from INVOICE I, COMPANY C, CUSTOMER CU > where I.COMPANY_Number = C.COMPANY_Number > AND I.COMPANY_Number = '#form.COMPANY_Number#' > AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%' > AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%' > AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%' > AND I.INVOICE_PDFFile <> '' > > > This query looks like it gets the results for your search. You have 3 tables: invoice, company, and customer. You join the invoice table and the company table via the SQL, I.COMPANY_Number = C.COMPANY_Number. Unfortunately you do not join customer table to the other 2 tables. This is why you are always getting more results than you want. You need to join the invoice table to the customer table. the top half of your code looks like it was not a full cut and paste. If it was then it really doesn't make any sense. What is the query, qgetcustomer, being used for? ~| 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:328954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
Heres the code im using SELECT invoice.*, customer.CUSTOMER_Name FROM invoice left join customer on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum; Invoice Number : Customer Number : Customer Name : Your Search has returned 0 results select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name from INVOICE I, COMPANY C, CUSTOMER CU where I.COMPANY_Number = C.COMPANY_Number AND I.COMPANY_Number = '#form.COMPANY_Number#' AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%' AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%' AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%' AND I.INVOICE_PDFFile <> '' ~| 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:328953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm 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 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 checked 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
Re: Check Boxes
Showing code would be a good first step... On Tue, Dec 8, 2009 at 6:27 AM, Damo Drumm 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 > > ~| 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:328951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Check Boxes
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 ~| 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:328950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bind Problem cfinput to check boxes...
think i found my problem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Bind Problem cfinput to check boxes...
so i have this cfinput it is bout to a checkbox value.. you should be able to check & uncheck multiple boxes, or just type in the id's you want.. the check box is in a loop worked great when the where only 9 or so. now its up to 30... my proble is if some on selects checkbox 32 & submits the form. on update i see in the text field 2,3,32 not just 32 which is the real value that was inserted... i doubt this makes sense... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT : Check boxes in coldext grid
I have a coldext grid that I am using to update bit fields and I was wondering if anyone had been able to incorporate check boxes. I have the select box working but I know what the powers that be will want check boxes. I have contacted the author, Justin Carter, about this and he pointed me toward a work around that I have not been able to get to work. I email him about it but he hasn't gotten back to me. I was wondering if the collective wisdom here had encountered a way to to do this. We are on CF 7 here. TIA, G -- "The pursuit of truth and beauty is a sphere of activity in which we are permitted to remain children all our lives." - Albert Einstein ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes not checked
Sweet.glad it helped ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes not checked
Thanks to everyone who helped out on this one. I got it to work like this: I used Bryan's example and it worked fine. Checked> ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Check Boxes not checked
Output getMemberEmailGroupsRet.GroupID and you should see that it is the same value every time. What I would do is build a list of all the subscribed groups using ValueList(), and then you need to do cfif listfindnocase(list_of_subscribed_groups, EmailListArray[x][1] So basically you are checking each subscribed group against each available group. ~Brad -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 3:06 PM To: CF-Talk Subject: Re: Check Boxes not checked Checked> #EmailListArray[x][2]# #EmailListArray[x][2]# ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes not checked
getMemberEmailGroupsRet.GroupID will only return the first record. Is that your intention? If not try listFind() On 1/31/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > In case anyone is wondering, regarding the checkbox issue, I am querying two > tables. > > tblEmailGroups and tblEmailGroupNames > > tblEmailGroupNames has the names and ID of all of the email groups that a > user can check to subscribe to. > > tblEmailGroups contains the GroupID of the email group and the UserID of the > user. > > So what I am doing is, as I loop through the query I want to see if the ID > number from tblEmalGroups matches any in tblEmailGroupNames, and if there is > a match, check the checkbox. > > Bruce > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check Boxes not checked
In case anyone is wondering, regarding the checkbox issue, I am querying two tables. tblEmailGroups and tblEmailGroupNames tblEmailGroupNames has the names and ID of all of the email groups that a user can check to subscribe to. tblEmailGroups contains the GroupID of the email group and the UserID of the user. So what I am doing is, as I loop through the query I want to see if the ID number from tblEmalGroups matches any in tblEmailGroupNames, and if there is a match, check the checkbox. Bruce ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Check Boxes not checked
What is x? Are you incrementing it? Perhaps that needs to be currentrow? Are you looping over a query? Otherwise getMemberEmailGroupsRet.GroupID will always return the value for the first record in the result set? ~Brad -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 2:56 PM To: CF-Talk Subject: Check Boxes not checked I have this line of code3: Checked> As you can see it is supposed to do a comparison and if there is a match, the corresponding checkbox should be checked. But what it is doing is only checking the first box and no others. Can anyone tell me why this is happening? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes not checked
Checked> #EmailListArray[x][2]# #EmailListArray[x][2]# Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" On 1/31/07, Alan Rother <[EMAIL PROTECTED]> wrote: > > Can you send a larger chunk of the code? > > I cant tell if this code is in a loop or not. > > Also the value getMemberEmailGroupsRet.GroupID > > I am assuming this is from a query? In any case, something above this is > probably the cause of your problem. Best guess, the GroupID is not getting > incremented, if it needs to. Or the x value isn't getting incremented... > > It's hard to tell from this small sample. > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes not checked
I'm not quite sure what your code is doing, but when I do what you appear to be doing, I'm always comparing the current value is found in a list...then I chek the box (as multiple checkboxes with the same name have their values passed as a list). So something like (assuming outputting checkboxes in a loop): checked> Not sure if that was clear enough ;-) HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check Boxes not checked
Can you send a larger chunk of the code? I cant tell if this code is in a loop or not. Also the value getMemberEmailGroupsRet.GroupID I am assuming this is from a query? In any case, something above this is probably the cause of your problem. Best guess, the GroupID is not getting incremented, if it needs to. Or the x value isn't getting incremented... It's hard to tell from this small sample. On 1/31/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > > I have this line of code3: > > Checked> > As you can see it is supposed to do a comparison and if there is a match, > the corresponding checkbox should be checked. But what it is doing is only > checking the first box and no others. Can anyone tell me why this is > happening? > > -- > Bruce Sorge > > "I'm a mawg: half man, half dog. I'm my own best friend!" > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Check Boxes not checked
I have this line of code3: Checked> As you can see it is supposed to do a comparison and if there is a match, the corresponding checkbox should be checked. But what it is doing is only checking the first box and no others. Can anyone tell me why this is happening? -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Check Boxes - another NUG question
Worked! Thanks for the advice. What is a bit daunting about CF for newbies is the various valid approaches to accomplish the same task. Rick -Original Message- From: Kreig Zimmerman [mailto:kkz@;foureyes.com] Sent: Friday, 01 November, 2002 10:54 To: CF-Talk Subject: Re: Check Boxes - another NUG question Oh yeah, I may have slightly misunderstood the last question, so to add: The way to do this on the form page is this: .since it is a boolean we are using as a value, in the IIF, "1" evaluates to "true", and "0" to false. Thus only "1"s make the checkbox be checked. Randell B Adkins wrote: >In the database field you can set the value to anything you want, >however you will need to test for the value to properly >set the checkboxes on the form to be checked or unchecked. > >Example: >CheckBoxField: Value could be "AGREE" or DISAGREE" > >on the Form: >qMyQuery.CheckBoxField EQ 'AGREE'>checked> > > > > >>>>[EMAIL PROTECTED] 11/01/02 10:29AM >>> >>>> >>>> >When querying a db where some original input fields were check boxes >and >were inserted into the db as a binary (yes/no, 1/0, on/off), is the >only way >to display a check box on the query page, either checked or unchecked, >to >create a form and add an insert field? If so, I'm having trouble with >the >conditional logic. Is there an approach I'm overlooking. > >Rick > > > > ~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Check Boxes - another NUG question
Oh yeah, I may have slightly misunderstood the last question, so to add: The way to do this on the form page is this: ..since it is a boolean we are using as a value, in the IIF, "1" evaluates to "true", and "0" to false. Thus only "1"s make the checkbox be checked. Randell B Adkins wrote: >In the database field you can set the value to anything you want, >however you will need to test for the value to properly >set the checkboxes on the form to be checked or unchecked. > >Example: >CheckBoxField: Value could be "AGREE" or DISAGREE" > >on the Form: >qMyQuery.CheckBoxField EQ 'AGREE'>checked> > > > > >>>>[EMAIL PROTECTED] 11/01/02 10:29AM >>> >>>> >>>> >When querying a db where some original input fields were check boxes >and >were inserted into the db as a binary (yes/no, 1/0, on/off), is the >only way >to display a check box on the query page, either checked or unchecked, >to >create a form and add an insert field? If so, I'm having trouble with >the >conditional logic. Is there an approach I'm overlooking. > >Rick > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
Re: Check Boxes - another NUG question
The way I've always done this is this: On the form page: On the processing page: ..the benefit of this approach is that, should the checkbox be checked on the form page, form.ThisBox is passed to the processing page with a value of "1". When it is _not_ checked, it is not passed to the processing page at all; and the param tells CF that the default value for form.thisBox is "0". Takes care of any problems. The easiest way to do it, especially since I to tend to store checkbox values as BITs in the DB. Kennerly, Rick H CIV wrote: >When querying a db where some original input fields were check boxes and >were inserted into the db as a binary (yes/no, 1/0, on/off), is the only way >to display a check box on the query page, either checked or unchecked, to >create a form and add an insert field? If so, I'm having trouble with the >conditional logic. Is there an approach I'm overlooking. > >Rick > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Check Boxes - another NUG question
In the database field you can set the value to anything you want, however you will need to test for the value to properly set the checkboxes on the form to be checked or unchecked. Example: CheckBoxField: Value could be "AGREE" or DISAGREE" on the Form: checked> >>> [EMAIL PROTECTED] 11/01/02 10:29AM >>> When querying a db where some original input fields were check boxes and were inserted into the db as a binary (yes/no, 1/0, on/off), is the only way to display a check box on the query page, either checked or unchecked, to create a form and add an insert field? If so, I'm having trouble with the conditional logic. Is there an approach I'm overlooking. Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Check Boxes - another NUG question
When querying a db where some original input fields were check boxes and were inserted into the db as a binary (yes/no, 1/0, on/off), is the only way to display a check box on the query page, either checked or unchecked, to create a form and add an insert field? If so, I'm having trouble with the conditional logic. Is there an approach I'm overlooking. Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Count check boxes?
Thanks guys! One (or a combination) of your ideas worked. It's late.. maybe I dreamed it up myself. NOT Ann > -Original Message- > From: Ann Harrell [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 23, 2001 1:12 PM > To: CF-Talk > Subject: Count check boxes? > > > I have a list of 67 names each with a unique ID. I've given each > check box a > corresponding ID. I just want to count the number of boxes checked and > output that number for now. > > If you want to know what a wobber is, go to www.wob-l.org at your > own risk. > > Thanks! > > > > SELECT Met_ID, FirstName, LastName > FROM Wobbers > ORDER BY Wobbers.Met_ID > > > > > > Met > ID > Name > > > >NAME="MetCheck#Met_ID#" VALUE=""> > #Met_ID# > #FirstName# #LastName# > > > >VALUE="Count > Wobbers Met"> > > > > Ann Harrell > Mind like a steel trap.. > Rusty and illegal in 37 states. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Count check boxes?
Why not name each check box the same name and use a different value??? #Met_ID# #FirstName# #LastName# You'll then be presented with a comma separated list containing all your checked boxes... Do a ListLen(form.MetCheck, ",") for the number of items checked. Just a thought. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 11:12 AM To: CF-Talk Subject: Count check boxes? I have a list of 67 names each with a unique ID. I've given each check box a corresponding ID. I just want to count the number of boxes checked and output that number for now. If you want to know what a wobber is, go to www.wob-l.org at your own risk. Thanks! SELECT Met_ID, FirstName, LastName FROM Wobbers ORDER BY Wobbers.Met_ID Met ID Name #Met_ID# #FirstName# #LastName# Ann Harrell Mind like a steel trap.. Rusty and illegal in 37 states. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Count check boxes?
Hi Ann, I would do it like this: Name the checkbox fieldname the same for all 67 names. Then when posting the form just do a #ListLen(Form.IDList)# to get your count of checked boxes. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Count check boxes?
Have you thought about giving the checkboxes all the same name, and setting the value equal to the Met_ID? It's much easier to keep track of this way. On your action page, you can view #form.checkboxname# and see all the values that were checked. Then you can get a count with #ListLen(form.checkboxname)#. I have a quick demo at http://63.71.102.112/check.cfm tom www.basic-ultradev.com "Ann Harrell" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a list of 67 names each with a unique ID. I've given each check box a > corresponding ID. I just want to count the number of boxes checked and > output that number for now. > > If you want to know what a wobber is, go to www.wob-l.org at your own risk. > > Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Count check boxes?
Ann A better way... Define all checkboxes with the same name, but an unique value (the ID). That way you get a list containing the values of all the checked Items, The listLen() function will give you the number of checked boxes for example: #ListLen(MetCheck)# boxes were checked #theID# HTH Dick At 1:12 PM -0500 5/23/01, Ann Harrell wrote: >I have a list of 67 names each with a unique ID. I've given each check box a >corresponding ID. I just want to count the number of boxes checked and >output that number for now. > >If you want to know what a wobber is, go to www.wob-l.org at your own risk. > >Thanks! > > > >SELECT Met_ID, FirstName, LastName >FROM Wobbers >ORDER BY Wobbers.Met_ID > > > > > > Met > ID > Name > > > > NAME="MetCheck#Met_ID#" VALUE=""> > #Met_ID# > #FirstName# #LastName# > > > > > > > >Ann Harrell >Mind like a steel trap.. >Rusty and illegal in 37 states. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Count check boxes?
Change the form like so: #Met_ID# #FirstName# #LastName# Notice that I changed te name so that all the checkbox will have the same name. This will cause one form field to be posted called form.MetCheck which will contain a list of all the IDs that were checked. To get a count simply use listLen(form.MetCheck). Note that if none of the fields were checked, form.MetCheck will not exist. I handle this by using cfparam to initialize the variable with an empty string. Craig > -Original Message- > From: Ann Harrell [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 23, 2001 2:12 PM > To: CF-Talk > Subject: Count check boxes? > > I have a list of 67 names each with a unique ID. I've given each check box a > corresponding ID. I just want to count the number of boxes checked and > output that number for now. > > If you want to know what a wobber is, go to www.wob-l.org at your own risk. > > Thanks! > > > > SELECT Met_ID, FirstName, LastName > FROM Wobbers > ORDER BY Wobbers.Met_ID > > > > > > Met > ID > Name > > > > VALUE=""> > #Met_ID# > #FirstName# #LastName# > > > > > > > > Ann Harrell > Mind like a steel trap.. > Rusty and illegal in 37 states. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Count check boxes?
first of all, i suggest you name all of your checkboxes the same, unless you have a different reason, and you should assign the ID's to the values of the checkboxes. the reason for this is that all of the boxes checked will come out in one form variable in a comma delimited list of their values. so let's say I name all my check boxes Goober, and each of their values are the ID's. Let's say I click on 3 boxes. The value of Form.Goober would be 34,54,22. something like that. See, it comes out as a comma delimited list! ou also know how many boxes were checked by the number of values in the list, which is 3. So Listlen(Form.Goober) is equal to 3! >From: "Ann Harrell" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Count check boxes? >Date: Wed, 23 May 2001 13:12:22 -0500 > >I have a list of 67 names each with a unique ID. I've given each check box >a >corresponding ID. I just want to count the number of boxes checked and >output that number for now. > >If you want to know what a wobber is, go to www.wob-l.org at your own risk. > >Thanks! > > > >SELECT Met_ID, FirstName, LastName >FROM Wobbers >ORDER BY Wobbers.Met_ID > > > > > > Met > ID > Name > > > > VALUE=""> > #Met_ID# > #FirstName# #LastName# > > > > > > > >Ann Harrell >Mind like a steel trap.. >Rusty and illegal in 37 states. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Count check boxes?
I have a list of 67 names each with a unique ID. I've given each check box a corresponding ID. I just want to count the number of boxes checked and output that number for now. If you want to know what a wobber is, go to www.wob-l.org at your own risk. Thanks! SELECT Met_ID, FirstName, LastName FROM Wobbers ORDER BY Wobbers.Met_ID Met ID Name #Met_ID# #FirstName# #LastName# Ann Harrell Mind like a steel trap.. Rusty and illegal in 37 states. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query to Check Boxes --oops mistake [CF-Talk]
JETS JETS JETS!!! - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 20, 2000 11:00 PM Subject: Re: Query to Check Boxes --oops mistake [CF-Talk] > I dont even know what you speak of. If I ever got away from my computer or > work I might. I did however try to find a Jon Hall kicker in the NFL on > espn.com :-) The only one I could find was a guy who played for the Jets, > but it doesn't appear he has played this year...anyway, since the Jets are > going to loose to Tampa next week it doesn't matter :) > > jon > - Original Message - > From: "Howie Hamlin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 20, 2000 9:20 PM > Subject: Re: Query to Check Boxes --oops mistake [CF-Talk] > > > > He jon, how did you miss that easy punt last Sunday? > > > > > > > > > > - Original Message - > > From: "Jon Hall" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, September 20, 2000 9:13 PM > > Subject: Re: Query to Check Boxes --oops mistake [CF-Talk] > > > > > > > > 1)> > > > checked> > > > ... > > > > > > I am assuming you are storing the 'RoleID' value as a comma delimited > list > > > in the database here. > > > - Original Message - > > > From: "sebastian palmigiani" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Wednesday, September 20, 2000 1:47 PM > > > Subject: Query to Check Boxes --oops mistake [CF-Talk] > > > > > > > > > > > > > > OOPS...Made a mistake on the last post for the names of the default > > > > parameters. > > > > > > > > - > > > > > > > > I have 5 check boxes displayed in a form. I want to show a checked > > status > > > on > > > > the check boxes based on the query. The query output varies from 0 to > 5 > > > > records. > > > > > > > > Here is what I have now. There has to be a more efficient way. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Sebastian > > > > > > > > > > > -- > > > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > > To Unsubscribe visit > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or > > > send a message to [EMAIL PROTECTED] with 'unsubscribe' > in > > > the body. > > > > > > > -- > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Query to Check Boxes --oops mistake [CF-Talk]
I dont even know what you speak of. If I ever got away from my computer or work I might. I did however try to find a Jon Hall kicker in the NFL on espn.com :-) The only one I could find was a guy who played for the Jets, but it doesn't appear he has played this year...anyway, since the Jets are going to loose to Tampa next week it doesn't matter :) jon - Original Message - From: "Howie Hamlin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 20, 2000 9:20 PM Subject: Re: Query to Check Boxes --oops mistake [CF-Talk] > He jon, how did you miss that easy punt last Sunday? > > > > > - Original Message - > From: "Jon Hall" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 20, 2000 9:13 PM > Subject: Re: Query to Check Boxes --oops mistake [CF-Talk] > > > > 1)> > > checked> > > ... > > > > I am assuming you are storing the 'RoleID' value as a comma delimited list > > in the database here. > > - Original Message - > > From: "sebastian palmigiani" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, September 20, 2000 1:47 PM > > Subject: Query to Check Boxes --oops mistake [CF-Talk] > > > > > > > > > > OOPS...Made a mistake on the last post for the names of the default > > > parameters. > > > > > > - > > > > > > I have 5 check boxes displayed in a form. I want to show a checked > status > > on > > > the check boxes based on the query. The query output varies from 0 to 5 > > > records. > > > > > > Here is what I have now. There has to be a more efficient way. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Sebastian > > > > > > > -- > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Query to Check Boxes --oops mistake [CF-Talk]
He jon, how did you miss that easy punt last Sunday? - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 20, 2000 9:13 PM Subject: Re: Query to Check Boxes --oops mistake [CF-Talk] > > checked> > ... > > I am assuming you are storing the 'RoleID' value as a comma delimited list > in the database here. > - Original Message - > From: "sebastian palmigiani" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, September 20, 2000 1:47 PM > Subject: Query to Check Boxes --oops mistake [CF-Talk] > > > > > > OOPS...Made a mistake on the last post for the names of the default > > parameters. > > > > - > > > > I have 5 check boxes displayed in a form. I want to show a checked status > on > > the check boxes based on the query. The query output varies from 0 to 5 > > records. > > > > Here is what I have now. There has to be a more efficient way. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Sebastian > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Query to Check Boxes --oops mistake [CF-Talk]
checked> ... I am assuming you are storing the 'RoleID' value as a comma delimited list in the database here. - Original Message - From: "sebastian palmigiani" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 20, 2000 1:47 PM Subject: Query to Check Boxes --oops mistake [CF-Talk] > > OOPS...Made a mistake on the last post for the names of the default > parameters. > > - > > I have 5 check boxes displayed in a form. I want to show a checked status on > the check boxes based on the query. The query output varies from 0 to 5 > records. > > Here is what I have now. There has to be a more efficient way. > > > > > > > > > > > > > > > > > > > > > > > > > > Sebastian > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Query to Check Boxes [CF-Talk]
How about this? CHECKED> -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 12:42 PM To: [EMAIL PROTECTED] Subject: Query to Check Boxes [CF-Talk] I have 5 check boxes displayed in a form. I want to show a checked status on the check boxes based on the query. The query output varies from 0 to 5 records. Here is what I have now. There has to be a more efficient way. Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Query to Check Boxes --oops mistake [CF-Talk]
OOPS...Made a mistake on the last post for the names of the default parameters. - I have 5 check boxes displayed in a form. I want to show a checked status on the check boxes based on the query. The query output varies from 0 to 5 records. Here is what I have now. There has to be a more efficient way. Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Query to Check Boxes [CF-Talk]
I have 5 check boxes displayed in a form. I want to show a checked status on the check boxes based on the query. The query output varies from 0 to 5 records. Here is what I have now. There has to be a more efficient way. Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Re: Check boxes! dynamic fields??
Thanks On the first page the fields are static. ie Field1 Field2 I can query the database with "Select #Fields# from Table_name" but i cant display the fields cause "Fields" is a list and cant get it to break it with cfloop --- Original Message --- "Billy Cravens" <[EMAIL PROTECTED]> Wrote on Wed, 5 Apr 2000 16:21:08 -0500 -- A couple of ways (off the top of my head): 1. dynamically build a list using javascript, whenever a box is checked. When box is checked (document.formname.fieldname.checked == true), add a value to a list. When a box gets unchecked, remove its value from the list. Pass the list you've built through a hidden form field, then loop through this list on the same page. 2. give the checkbox a naming convention that you can parse over. IE, call it check#id#, or whatever. Then on the next page, do some processing on all fields that begin with check..like: --- Billy Cravens [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Check boxes! dynamic fields??
A couple of ways (off the top of my head): 1. dynamically build a list using javascript, whenever a box is checked. When box is checked (document.formname.fieldname.checked == true), add a value to a list. When a box gets unchecked, remove its value from the list. Pass the list you've built through a hidden form field, then loop through this list on the same page. 2. give the checkbox a naming convention that you can parse over. IE, call it check#id#, or whatever. Then on the next page, do some processing on all fields that begin with check..like: --- Billy Cravens [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Check boxes! dynamic fields??
Hello all, I am using static check boxes, which are field names is the database, and according to what the user checks , they will see only those fields on the next page with data. I am having problem with displaying the data as it is in a single #Variable# , i tried this #x# but didnt work How can i do this? Appretiate it! Thanks Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Populating/Checking Check Boxes
You are not selecting County_Code in the getcodes query. You should use County.ID as your checkbox value. -David On Mon, 27 Mar 2000 16:15:32 -0700 Chris Geanious <[EMAIL PROTECTED]> writes: > Greetings, > Am dynamically creating and checking a set of check boxes with the > code below: > > > > > SELECT County.ID, County.County, 1 as FLG > FROM Cities_Served,County > WHERE Provider_ID = #ID# > ANDCities_Served.County_Code = County.ID > > UNION > > > > SELECT County.ID, County.County, 0 as FLG > FROM County > WHERE County.ID NOT IN (SELECT Cities_Served.County_Code > FROM Cities_Served WHERE Provider_ID = #ID# ) > > > > > >value="#County_Code#" >#FLG#>checked> > #County# > > > > > > I am getting: "Error resolving parameter County_Code , error > occurred > while evaluating the expression #County_Code#" > > Have gotten this to work elsewhere, but can't see my error here. > Anybody > see the mistake in the code or know a better way to do this? > > Many thanx in advance, > > Chris > > > > - - > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Populating/Checking Check Boxes
Greetings, Am dynamically creating and checking a set of check boxes with the code below: SELECT County.ID, County.County, 1 as FLG FROM Cities_Served,County WHERE Provider_ID = #ID# ANDCities_Served.County_Code = County.ID UNION SELECT County.ID, County.County, 0 as FLG FROM County WHERE County.ID NOT IN (SELECT Cities_Served.County_Code FROM Cities_Served WHERE Provider_ID = #ID# ) #FLG#>checked> #County# I am getting: "Error resolving parameter County_Code , error occurred while evaluating the expression #County_Code#" Have gotten this to work elsewhere, but can't see my error here. Anybody see the mistake in the code or know a better way to do this? Many thanx in advance, Chris -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
