RE: Looking for jQuery Form Help...
Thanks again Tony. Your help is much appreciated...
-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Tuesday, October 13, 2009 5:33 PM
To: cf-talk
Subject: Re: Looking for jQuery Form Help...
You just need to point to each form element that you want to disable. For
instance, if you setup a parent container then you can command each matching
element to disable:
function disableForm(bool){
$("#DivWithInputs input,#DivWithInputs textarea").each(function(){
$(this).attr("disabled",bool);
});
}
Then just setup a true/false on your two radios
~|
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:327174
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for jQuery Form Help...
Since the original question was cross-posted to the jquery list, I might as well cross-post my answer: Are you using the "disabled" attribute on the inputs that you want to "turn off"? If so, you can add/remove it. http://www.it.dev.duke.edu/public/disabled.html http://www.it.dev.duke.edu/public/disabled.txt (src) Rick ~| 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:327156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for jQuery Form Help...
You just need to point to each form element that you want to disable. For
instance, if you setup a parent container then you can command each matching
element to disable:
function disableForm(bool){
$("#DivWithInputs input,#DivWithInputs textarea").each(function(){
$(this).attr("disabled",bool);
});
}
Then just setup a true/false on your two radios
~|
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:327154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for jQuery Form Help...
Hello again Tony. How would I take your below example and use it to
"disable" select boxes, textareas, radio buttons and checkboxes? Thanks, Che
-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Tuesday, October 13, 2009 11:32 AM
To: cf-talk
Subject: Re: Looking for jQuery Form Help...
Disable
Enable
function showHide(bool){
if(bool)
{
$("input[name=shippingaddress]").attr("disabled",true);
}
else{
$("input[name=shippingaddress]").attr("disabled",false);
}
}
~|
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:327151
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for jQuery Form Help...
Tested:
Disable
Enable
function showHide(bool){
if(bool)
{
$("input[name=shippingaddress]").attr("disabled",true);
}
else{
$("input[name=shippingaddress]").attr("disabled",false);
}
}
~|
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:327132
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for jQuery Form Help...
Tony, thanks so much! Tested EQ What I needed!
-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Tuesday, October 13, 2009 11:32 AM
To: cf-talk
Subject: Re: Looking for jQuery Form Help...
Tested:
Disable
Enable
function showHide(bool){
if(bool)
{
$("input[name=shippingaddress]").attr("disabled",true);
}
else{
$("input[name=shippingaddress]").attr("disabled",false);
}
}
~|
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:327133
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for jQuery Form Help...
In your function if the radio is checked (or unchecked depending on the ready
state), enable the collection of form elements by using
$("input[name=formelement]").attr("disabled",true);
~|
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:327130
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for jQuery Form Help...
this is using disabled to keep them visible:
function showHide(){
if($(this).is(":checked")){
$("input, select, textarea",
"#DifferentShippingAddress").attr("disabled","disabled");
}
else{
$("input, select, textarea",
"#DifferentShippingAddress").removeAttr("disabled");
}
}
~Mahcsig
On Tue, Oct 13, 2009 at 8:16 AM, Tony Bentley wrote:
>
> Sure:
>
> name="UseDifferentShippingAddress">
>
>
>
>
>
> function showHide(){
> if($(this).is(":checked")){
> $("#DifferentShippingAddress").show();
> }
> else{
> $("#DifferentShippingAddress").hide();
> }
> }
>
> This is untested but basically the div uses a showhide function that
> toggles the form to be visible using the radio controller. You'll need to
> handle to blank fields in your CF logic no matter if it shows or not. You
> can use a case statement against form.UseDifferentShippingAddress to decide
> if you want to include the other form fields.
>
>
~|
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:327129
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for jQuery Form Help...
Sure:
function showHide(){
if($(this).is(":checked")){
$("#DifferentShippingAddress").show();
}
else{
$("#DifferentShippingAddress").hide();
}
}
This is untested but basically the div uses a showhide function that toggles
the form to be visible using the radio controller. You'll need to handle to
blank fields in your CF logic no matter if it shows or not. You can use a case
statement against form.UseDifferentShippingAddress to decide if you want to
include the other form fields.
~|
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:327127
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Looking for jQuery Form Help...
I should add that by default, the bottom form fields in my example screen shot are "off". That is, they are visible, but you can't enter any data. When turned "on", only then can data be entered. Thanks in advance to anyone that can help. -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Tuesday, October 13, 2009 10:26 AM To: cf-talk Subject: Looking for jQuery Form Help... Take a look at the link below. It's a screen shot of a form where the "Shipping" form fields can be toggled on/off. I haven't been able to find (or search properly) for jQuery code that does something similar. Can anyone point me in the right direction? Thanks, Che http://www.asitv.com/images/jquery_form.jpg ~| 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:327122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looking for jQuery Form Help...
Take a look at the link below. It's a screen shot of a form where the "Shipping" form fields can be toggled on/off. I haven't been able to find (or search properly) for jQuery code that does something similar. Can anyone point me in the right direction? Thanks, Che http://www.asitv.com/images/jquery_form.jpg ~| 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:327115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfdocument to pdf fillinallow. cannot generate fillin pdf form. help?
I have a template that generates a detailed information for my clients that want the information emailed to them. not a big problem until we got into them wanting to modify the document sent to them and return it for processing. i am not locked into using cfdocument or even pdf format. in fact i was looking at excel format first, but since i have more pdf format experience i thought it would be quicker - so far not the case. any guidance? ~| 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:304105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form->database->form help needed
Ah, this looks great. I'll suggest the steps. I'm pretty sure I get it all. Thanks a bunch (again) Deanna. I owe you at least a beer. >Been there, had that client. You do still need to keep in mind things like >whether or not a record is "complete" if they haven't filled everything in, >when you're storing data like this. And, you might want to consider adding >something like "Step 2 of 546." to your screens, so people can see how far >along they are. Though, I still go back to saying that I'm not sure what the >benefit is to having each on a separate page. You're doing a logic model >program planning process, right? (Twas pioneered here in Wisconsin.) There >aren't _that_ many steps to that. I'd at least group all the questions from >each phase together. > > >Situation Analysis >vision >mission >etc > >Inputs >investment by >Outputs >what we do >who we reach >Outcomes >short term results >medium term results >long term results > > >As to putting stuff in session vars - yah, it's pretty easy. You're on 6.1, >right? So, locking isn't the major conundrum it used to be. You can save >your whole query results to the session, and then you'd just reference them >as #session.queryname.columnname.# But, I'm not sure you then update that >directly. I think you'd have to make it a structure instead, but since each >query should only have one row of data returned, that's not such a big deal. >You can just do this sort of thing: > > > > > > > > > > >Then, when you update a record, you can just do: > > > > > > > > > > >- Original Message - >From: "daniel kessler" <[EMAIL PROTECTED]> >To: "CF-Talk" >Sent: Thursday, May 19, 2005 12:41 PM >Subject: Re: form->database->form help needed > > >> ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form->database->form help needed
Been there, had that client. You do still need to keep in mind things like whether or not a record is "complete" if they haven't filled everything in, when you're storing data like this. And, you might want to consider adding something like "Step 2 of 546." to your screens, so people can see how far along they are. Though, I still go back to saying that I'm not sure what the benefit is to having each on a separate page. You're doing a logic model program planning process, right? (Twas pioneered here in Wisconsin.) There aren't _that_ many steps to that. I'd at least group all the questions from each phase together. Situation Analysis vision mission etc Inputs investment by Outputs what we do who we reach Outcomes short term results medium term results long term results As to putting stuff in session vars - yah, it's pretty easy. You're on 6.1, right? So, locking isn't the major conundrum it used to be. You can save your whole query results to the session, and then you'd just reference them as #session.queryname.columnname.# But, I'm not sure you then update that directly. I think you'd have to make it a structure instead, but since each query should only have one row of data returned, that's not such a big deal. You can just do this sort of thing: Then, when you update a record, you can just do: - Original Message - From: "daniel kessler" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, May 19, 2005 12:41 PM Subject: Re: form->database->form help needed > >I think he's just talking about a simple multi-page form, but instead of >>storing the info in the session scope and inserting upon completion, he's >>inserting between each page. > > well it's a distinct form on each page, but yes, I go to the db between > each page for an UPDATE > >>So, Daniel, yes - you can retrieve the record set you're working with and >>store it. I'd probably go with storing it in the session scope. But, be >>aware that every time your user updates a page, you'll need to also update >>that session scope var. I'd maybe think twice about your design - that's a >>lot of round trips to the database. > > It's this way because I was told "what if they just close the page" or a > whole bunch of other what-ifs and was told that not only would it need to > store it between each page, but that it also had to have a Save button on > each page just in case they wanted to save partially typed information. > Some of the entries can be thousands of characters. > >>You could, instead, be storing stuff in >>the session scope as they go, and then have a "save" button (repeated on >>each page), that saves their current work-state. It depends on the >>sophistication level of your users, and what you're really trying to >>collect. > > So at the beginning, I should do a db query and store it to the session > scope and while I don't know how to address the session scope, it seems it > would be pretty easy to look up. Then each one of the form fields just > needs to reference that to fill-in. And as you said, I'd also have to > fill it in whenever I go to the database, not as a seperate database call > but just (or however it's done). > > Does that all sound right? > > btw, here's an example of one of the pages, not that it will help I think: > http://hhp.umd.edu/empower/situation_analysis/s_vision_01_test.cfm > > thanks! > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form->database->form help needed
thank you for your fine comments. I agree and argued that point this morning so I'm in the process of removing them now. :-) >This isn't an answer to any of your questions, but just real briefly >if you're going to prepopulate the field with something like "What's >your vision." you should use some javascript to remove that value when >the field receives focus... > > > >Although in general I would recommend not placing anything in the >field in advance unless it's an actual default value. Partly this is >because of accessibility, and partly just because it's annoying to >users. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form->database->form help needed
> btw, here's an example of one of the pages, not that it > will help I think: > http://hhp.umd.edu/empower/situation_analysis/s_vision_01_ > test.cfm This isn't an answer to any of your questions, but just real briefly if you're going to prepopulate the field with something like "What's your vision." you should use some javascript to remove that value when the field receives focus... Although in general I would recommend not placing anything in the field in advance unless it's an actual default value. Partly this is because of accessibility, and partly just because it's annoying to users. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form->database->form help needed
>I think he's just talking about a simple multi-page form, but instead of >storing the info in the session scope and inserting upon completion, he's >inserting between each page. well it's a distinct form on each page, but yes, I go to the db between each page for an UPDATE >So, Daniel, yes - you can retrieve the record set you're working with and >store it. I'd probably go with storing it in the session scope. But, be >aware that every time your user updates a page, you'll need to also update >that session scope var. I'd maybe think twice about your design - that's a >lot of round trips to the database. It's this way because I was told "what if they just close the page" or a whole bunch of other what-ifs and was told that not only would it need to store it between each page, but that it also had to have a Save button on each page just in case they wanted to save partially typed information. Some of the entries can be thousands of characters. >You could, instead, be storing stuff in >the session scope as they go, and then have a "save" button (repeated on >each page), that saves their current work-state. It depends on the >sophistication level of your users, and what you're really trying to >collect. So at the beginning, I should do a db query and store it to the session scope and while I don't know how to address the session scope, it seems it would be pretty easy to look up. Then each one of the form fields just needs to reference that to fill-in. And as you said, I'd also have to fill it in whenever I go to the database, not as a seperate database call but just (or however it's done). Does that all sound right? btw, here's an example of one of the pages, not that it will help I think: http://hhp.umd.edu/empower/situation_analysis/s_vision_01_test.cfm thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207184 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: form->database->form help needed
>twice about your design - that's a lot of round trips to the database. You could, In addition, you will need to have a lot of NULLable fields in your database. That, in turn, can lose some of your design intent. Once the entire form has been submitted, as far as the user is concerned, have they left out any information that your business logic requires? And that kind of rot. M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207169 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form->database->form help needed
I think he's just talking about a simple multi-page form, but instead of storing the info in the session scope and inserting upon completion, he's inserting between each page. So, Daniel, yes - you can retrieve the record set you're working with and store it. I'd probably go with storing it in the session scope. But, be aware that every time your user updates a page, you'll need to also update that session scope var. I'd maybe think twice about your design - that's a lot of round trips to the database. You could, instead, be storing stuff in the session scope as they go, and then have a "save" button (repeated on each page), that saves their current work-state. It depends on the sophistication level of your users, and what you're really trying to collect. - Original Message - From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, May 19, 2005 10:10 AM Subject: Re: form->database->form help needed >I have to admit, I'm thoroughly lost... maybe an ascii-art picture of > what you're trying to describe might help? > >> I have an application where each page is a single field >> and between >> each page, that field information is sent to the database. >> There's a >> template page that gets copied by the content people and >> their own >> form element is added to the form template. >> I've set it up so that the page in between will find out >> if the field >> exists and if so, add it to the database. >> But if the person has already partially gone through the >> screens >> which adds the elements to the db and then leaves and >> comes back to >> their "project" to continue, I need it to fill in the >> pages that >> they're already completed, as they come to those pages. > >> I'm not sure how to approach this. Can I do a db call and >> cookie the >> recordset for each page to read or somehow add the >> recordset to the >> application variables? I'm really out of my element here >> so any >> advice or requests for clarity are greatly appreciated. > > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.fusiontap.com > http://coldfusion.sys-con.com/author/4806Dealey.htm > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207166 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: form->database->form help needed
I have to admit, I'm thoroughly lost... maybe an ascii-art picture of what you're trying to describe might help? > I have an application where each page is a single field > and between > each page, that field information is sent to the database. > There's a > template page that gets copied by the content people and > their own > form element is added to the form template. > I've set it up so that the page in between will find out > if the field > exists and if so, add it to the database. > But if the person has already partially gone through the > screens > which adds the elements to the db and then leaves and > comes back to > their "project" to continue, I need it to fill in the > pages that > they're already completed, as they come to those pages. > I'm not sure how to approach this. Can I do a db call and > cookie the > recordset for each page to read or somehow add the > recordset to the > application variables? I'm really out of my element here > so any > advice or requests for clarity are greatly appreciated. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
form->database->form help needed
I have an application where each page is a single field and between each page, that field information is sent to the database. There's a template page that gets copied by the content people and their own form element is added to the form template. I've set it up so that the page in between will find out if the field exists and if so, add it to the database. But if the person has already partially gone through the screens which adds the elements to the db and then leaves and comes back to their "project" to continue, I need it to fill in the pages that they're already completed, as they come to those pages. I'm not sure how to approach this. Can I do a db call and cookie the recordset for each page to read or somehow add the recordset to the application variables? I'm really out of my element here so any advice or requests for clarity are greatly appreciated. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Form Help
- Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> > Can anybody please help me with this page? I've been fooling around > with it forever and I'm just not having any luck. > > There are two things that I need help with: > > 1.Why aren't my dropdowns working properly? They should be pulling > the data from the database and displaying it when possible. As it > stands, they just look like regular drop-downs, no matter what value is > in the db. This code has worked for me on other forms, but for some > reason I must have done something different here. What's happening with the drop-downs? Not sure I understand from this. Is there no data returned by the queries that populate them? If there is data returned, is it not being output correctly in the drop-down? In what way is are the drop-downs not working? As you say you've been fooling around with them a lot, I assume you've done the usual routine of paring your code down in a test page to the bare minimum that's needed to causes the error, and carry on paring until the error doesn't appear... Not sure about multiple INSERTs, though I'm certain this is a topic that you'll find some coverage of in the list archives. I think as far as SQL syntax goes, it's one INSERT at a time. HTH, Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Form Help
Can anybody please help me with this page? I've been fooling around with it forever and I'm just not having any luck. There are two things that I need help with: 1.Why aren't my dropdowns working properly? They should be pulling the data from the database and displaying it when possible. As it stands, they just look like regular drop-downs, no matter what value is in the db. This code has worked for me on other forms, but for some reason I must have done something different here. 2.How can I insert multiple records? This is something I haven't done before and I can't find good documentation on... I'm not even sure where to start. I've added in the code for doing a single insert... which should be okay... but I'm not sure where to go from here. Thank you for any help you are able to offer. My code: *** *** *** SELECT id, centraladmin, provadmin, trainer FROM users WHERE id = #client.id# SELECT * from courses WHERE id = #url.id# SELECT attendee.*, users.id AS users_id, users.lname, users.fname FROMattendee, users WHERE attendee.assigneddate = #url.id# and users.id = attendee.users_id ORDER BYusers.lname, users.fname ASC SELECT * FROM salutation ORDER by salutation ASC SELECT * FROM prov ORDER by abbreviation ASC SELECT * FROM country ORDER by name ASC SELECT * FROM profession SELECT * FROM designation SELECT * FROM years SELECT * FROM empstatus SELECT * FROM empplace SELECT * FROM empresp SELECT * FROM dpccat SELECT * FROM dpcclass select * FROM caeyear ORDER BY year DESC SELECT * FROM payment SELECT * FROM postassign UPDATE attendee SET assigneddate = '#form.assigneddate#', attended = '#form.attended#', withdrawn = '#form.withdrawn#', paymentmethod = '#form.paymentmethod#', paymentcleared = '#form.paymentcleared#', authnum = '#form.authnum#', assignrec1 = '#form.assignrec1#', assignrec2 = '#form.assignrec2#', assignrec3 = '#form.assignrec3#', pretest = '#form.pretest#', writtentest1 = '#form.writtentest1#', writtentest2 = '#form.writtentest2#', writtentest3 = '#form.writtentest3#', skilltest1 = '#form.skilltest1#', skilltest2 = '#form.skilltest2#', skilltest3 = '#form.skilltest3#', postassign = '#form.postassign#', adminnote = '#form.adminnote#' WHERE users_id = #form.id# SELECT * FROM users WHERE id = #form.id# SELECT users_id, attended, writtentest1, writtentest2, writtentest3, skilltest1, skilltest2, skilltest3, postassign FROM attendee WHERE users_id = #form.id# UPDATE attendee SET gradnum = '#gradnum#' WHERE users_id = #form.id# UPDATE attendee SE
RE: FORM help
> You can use Javascript.. but using a template and passing variables back
> to
> the template for correct is a much more cleaner approach..
>
> Cfif isDefined("form.CheckboxName") in CF
>
> If document.formname.CheckboxName.value == "" in JavaScript
erm... close, but not quite...
document.formname.CheckboxName.checked == true;
using Checkbox.value == "" will tell you whether or not you typed when you were constructing the form.
Isaac Dealey
www.turnkey.to
954-776-0046
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FORM help
You can use Javascript.. but using a template and passing variables back to
the template for correct is a much more cleaner approach..
Cfif isDefined("form.CheckboxName") in CF
If document.formname.CheckboxName.value == "" in JavaScript
Joe
Certified Advanced ColdFusion Developer
[EMAIL PROTECTED]
-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 3:02 AM
To: CF-Talk
Subject: FORM help
I have a form where some of the fields are mandatory.
However at the bottom is a check box to say the the form details are not
required by the application.
How can I test for the mandatory fields but ignore them if they select that
the service is not required and submit the form?
Thanks! :)
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FORM help
Well it depends on if you want JS alerts, or if you prefer to send them to another page listing the errors with a "back link". Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "Tilbrook, Peter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 12:02 AM Subject: FORM help > I have a form where some of the fields are mandatory. > > However at the bottom is a check box to say the the form details are not > required by the application. > > How can I test for the mandatory fields but ignore them if they select that > the service is not required and submit the form? > > Thanks! :) > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FORM help
In javascript (client side):
if(!document.myform.mycheck.checked){
//write your validation for the mandatory fields here
}
In CF (server side):
Pascal
-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: woensdag 17 juli 2002 9:02
To: CF-Talk
Subject: FORM help
I have a form where some of the fields are mandatory.
However at the bottom is a check box to say the the form details are not
required by the application.
How can I test for the mandatory fields but ignore them if they select
that the service is not required and submit the form?
Thanks! :)
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FORM help
I have a form where some of the fields are mandatory. However at the bottom is a check box to say the the form details are not required by the application. How can I test for the mandatory fields but ignore them if they select that the service is not required and submit the form? Thanks! :) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript form help
first, name all the checkboxes the same (say "cbox"), then use the below
function with the onclick action
function checkBoxes(theForm){
var counter = 0;
for( i=0; i
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Rayna Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 1:01 PM
To: CF-Talk
Subject: javascript form help
does anyone know where i can find a script that will limit the user from
chosing more than a certain amount of choices in a checkbox form? the user
can only chose up to 5 choices, but there are many choices that they can
chose from.
any help would be greatly appreciated.
Rayna
Rayna Evans
AAMC
2501 M Street, 2nd Fl
Washington, DC 20037
202-862-6243 (direct)
Extension 4243 (internal)
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript form help
Rayna,
Check out qForms:
http://www.pengoworks.com/qForms/
It's a JavaScript framework for working w/forms. There isn't a built in
validation method for this, but here's one that'll work with qForms:
function _f_isCheckboxLenLT(len){
_param(arguments[0], 5, "number");
if( this.value.split(",").length >= len )
this.error = "The " + this.description + " field must
have less than " + len + " values selected.";
}
_addValidator("isCheckboxLenLT", _f_isCheckboxLenLT);
Now all you'll need to do is attach the method to your form field:
o.fieldName.isCheckboxLenLT(5);
(Where "o" is the qForm object and "fieldName" is the name of the
checkbox field.)
-Dan
> -Original Message-
> From: Rayna Evans [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 30, 2001 4:01 PM
> To: CF-Talk
> Subject: javascript form help
>
> does anyone know where i can find a script that will limit the user
from
> chosing more than a certain amount of choices in a checkbox form? the
> user can only chose up to 5 choices, but there are many choices that
they
> can chose from.
>
> any help would be greatly appreciated.
>
> Rayna
>
> Rayna Evans
> AAMC
> 2501 M Street, 2nd Fl
> Washington, DC 20037
> 202-862-6243 (direct)
> Extension 4243 (internal)
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript form help
Rayna,
Assuming that all of your checkboxes have the same name, but different
values, this script will work.
function countChecked(TheForm)
{
var cChecked = 0;
for( var i=0;i 5 )
{
alert('You must choose 5 or less items.');
return false;
}
return true;
}
... end form
If however you have checkboxes of different names then you would want to
change the function to this (assuming that each item checkbox name had the
same name fragment for instance "Choice1,Choice2,Choice3,...").
function countChecked(TheForm)
{
var cChecked = 0;
for( var i=0;i 5 )
{
alert('You must choose 5 or less items.');
return false;
}
return true;
}
HTH as I'm writing without a page to test the code. It should work
though
-Nate
-Original Message-
From: Rayna Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 4:01 PM
To: CF-Talk
Subject: javascript form help
does anyone know where i can find a script that will limit the user from
chosing more than a certain amount of choices in a checkbox form? the user
can only chose up to 5 choices, but there are many choices that they can
chose from.
any help would be greatly appreciated.
Rayna
Rayna Evans
AAMC
2501 M Street, 2nd Fl
Washington, DC 20037
202-862-6243 (direct)
Extension 4243 (internal)
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
javascript form help
does anyone know where i can find a script that will limit the user from chosing more than a certain amount of choices in a checkbox form? the user can only chose up to 5 choices, but there are many choices that they can chose from. any help would be greatly appreciated. Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form Help
> > How about just (the "IS" test isn't > a > > case-sensitive test). > > :-) > > I read a while back that compareNoCase is a faster way of comparing strings > than using IS... Correct. Since CompareNoCase() is a boolean expression, it supposedly executes faster than a string expression like IS. From what I understand, this is true for all boolean vs. string comparisons. I do use CompareNoCase() over IS myself, but I have found that it's not the most "user-friendly" code and tends to confuse the heck out of the newer codings because you have to use a NOT modifier in order to test for a true boolean condition. So... ...may be faster, but... ...is the more intuative approach and doesn't confuse the heck out of people (also takes less time to type). It all depends on how your application needs to work I guess. If you have a lot of load, or you're looping over thousands of lines (see below) and need to cram every last millisecond of performance out of CF, the CompareNoCase() may be better, but if you need the app done yesterday, and there's the possibility of a newer coder working on it in the future, it may be worth the slight performance drop to use the IS comparison. Just as a reference, I tested the two methods on my Compaq 1850r server, which has a single PII-400 processor. The first code sample.. ..took an average of 1265 milliseconds to complete according to the debugging info. The second sample.. ..averaged 453 milliseconds. So, it would appear that using the boolean operator really IS faster, and that whatever it is that the previous poster mentioned was correct. -Justin Scott, Staff Developer http://www.annex.com PS: Sorry about the crosspost on CF-Talk. It was a good thread on the fusebox list and I thought it would benefit the "rookie" developers on the list since they probably never thought about this kind of stuff. I know I never did until about 8 months ago . ~~ 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: Some Form help please
Thanks, it works now :) The thing that was causing my errors was the fact I was calling my formfields by numbers ie 1,2,3,4 etc It was throwing an error when trying to evaluate it, didn't realise calling then numbers would cause a problem. Thanks again Brian - Original Message - From: "Duane Boudreau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 30, 2000 5:06 AM Subject: RE: Some Form help please > Brian, > > Try > > > Duane Boudreau > CFExperts.Com > > > -Original Message- > From: Brian Mitter [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 30, 2000 12:00 AM > To: [EMAIL PROTECTED] > Subject: Some Form help please > > > I'm having a little trouble with this bit of code. What Im trying to do is > retrieve the value of the formfields that have been passed on from the > previous page. I know the formfields are called "form.1", "form.2" etc upto > "form.10". That part is working ok. > It is complainging about this part: & row)#> > > > > > > > > > > > > > > > It's got to be something stooopid I'm doing but can't see it, Anyone help? >Thanks > Brian > > > -- -- > -- > 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. > > -- > 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. > -- 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: Some Form help please
Brian, Try Duane Boudreau CFExperts.Com -Original Message- From: Brian Mitter [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 30, 2000 12:00 AM To: [EMAIL PROTECTED] Subject: Some Form help please I'm having a little trouble with this bit of code. What Im trying to do is retrieve the value of the formfields that have been passed on from the previous page. I know the formfields are called "form.1", "form.2" etc upto "form.10". That part is working ok. It is complainging about this part: It's got to be something stooopid I'm doing but can't see it, Anyone help? Thanks Brian -- 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. -- 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.
Some Form help please
I'm having a little trouble with this bit of code. What Im trying to do is retrieve the value of the formfields that have been passed on from the previous page. I know the formfields are called "form.1", "form.2" etc upto "form.10". That part is working ok. It is complainging about this part: It's got to be something stooopid I'm doing but can't see it, Anyone help? Thanks Brian -- 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.
