RE: Auto-populating form item

2003-03-12 Thread Dan G. Switzer, II
Check out qForms. It'll greatly simplify the syntax of dealing w/JS forms,
as well as it'll cut your work down tremendously. 

http://www.pengoworks.com/qforms/

There's a number of examples online that will give you an idea of where to
get start. Essentially all you need to do this is to set an event to run
during the onblur event for each of the first three fields. This should call
a function which checks the value of each of the first three fields and if a
value exists in each field, it'll update the initials field using something
like:

oForm.initials.setValue(
oForm.firstName.getValue().charAt(0) +
oForm.middleName.getValue().charAt(0) +
oForm.lastName.getValue().charAt(0)
);

-Dan

 -Original Message-
 From: Owens, Howard [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, March 11, 2003 8:08 PM
 To: CF-Talk
 Subject: RE: Auto-populating form item
 
 Another suggestion ...
 
 Store your queries in WDDX packages ... deserialize to JavaScript.
 
 There's an example on how to do this on my advanced Forta book ... which
 is
 two editions old ... not sure if it's carried forward ... but if you know
 JS
 at all, it's not really difficult to figure out once you have the
 examples.
 
 H.
 
 
  -Original Message-
  From:   Lincoln Milner [SMTP:[EMAIL PROTECTED]
  Sent:   Friday, March 07, 2003 7:31 AM
  To: CF-Talk
  Subject:Auto-populating form item
 
  Folks,
 
  We've got this data entry form that allows entry, query, record
 deletion,
  and a host of other functionality.  One thing it needs to do is after
 the
  first three form items are completed (it's a subject id.t number), the
  fourth auto-populates with the subject initials.
 
  This should be seamless to the user, i.e., no refresh of the page or
  submitting of data, so my question is how can we take form items 1, 2,
 and
  3 and use them to dynamically call a query to retrieve the initials from
 a
  database?  Or is this beyond the scope of CF?
 
  Cheers!
 
  Lincoln T. Milner
  Senior Application Programmer/Analyst
  Department of Health Evaluation Sciences
  Pennsylvania State University
  600 Centerview Drive
  Suite 2200, A210
  Hershey, PA 17033-0855
  Ph:  717.531.7178
  Fax: 717.531.5779
  [EMAIL PROTECTED]
 
 
  *E-Mail Confidentiality Notice*
  This message (including any attachments) contains information intended
 for
  a specific individual(s) and purpose that may be privileged,
 confidential
  or otherwise protected from disclosure pursuant to applicable law.  Any
  inappropriate use, distribution or copying of the message is strictly
  prohibited and may subject you to criminal or civil penalty.  If you
 have
  received this transmission in error, please reply to the sender
 indicating
  this error and delete the transmission from your system immediately.
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



RE: Auto-populating form item

2003-03-11 Thread Owens, Howard
Another suggestion ...

Store your queries in WDDX packages ... deserialize to JavaScript.

There's an example on how to do this on my advanced Forta book ... which is
two editions old ... not sure if it's carried forward ... but if you know JS
at all, it's not really difficult to figure out once you have the examples.

H.


 -Original Message-
 From: Lincoln Milner [SMTP:[EMAIL PROTECTED]
 Sent: Friday, March 07, 2003 7:31 AM
 To:   CF-Talk
 Subject:  Auto-populating form item
 
 Folks,
  
 We've got this data entry form that allows entry, query, record deletion,
 and a host of other functionality.  One thing it needs to do is after the
 first three form items are completed (it's a subject id.t number), the
 fourth auto-populates with the subject initials.
  
 This should be seamless to the user, i.e., no refresh of the page or
 submitting of data, so my question is how can we take form items 1, 2, and
 3 and use them to dynamically call a query to retrieve the initials from a
 database?  Or is this beyond the scope of CF?
  
 Cheers!
 
 Lincoln T. Milner
 Senior Application Programmer/Analyst
 Department of Health Evaluation Sciences
 Pennsylvania State University
 600 Centerview Drive
 Suite 2200, A210
 Hershey, PA 17033-0855
 Ph:  717.531.7178
 Fax: 717.531.5779
 [EMAIL PROTECTED]
 
 
 *E-Mail Confidentiality Notice*
 This message (including any attachments) contains information intended for
 a specific individual(s) and purpose that may be privileged, confidential
 or otherwise protected from disclosure pursuant to applicable law.  Any
 inappropriate use, distribution or copying of the message is strictly
 prohibited and may subject you to criminal or civil penalty.  If you have
 received this transmission in error, please reply to the sender indicating
 this error and delete the transmission from your system immediately.
 
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Auto-populating form item

2003-03-07 Thread Lincoln Milner
Folks,
 
We've got this data entry form that allows entry, query, record deletion, and a host 
of other functionality.  One thing it needs to do is after the first three form items 
are completed (it's a subject id.t number), the fourth auto-populates with the subject 
initials.
 
This should be seamless to the user, i.e., no refresh of the page or submitting of 
data, so my question is how can we take form items 1, 2, and 3 and use them to 
dynamically call a query to retrieve the initials from a database?  Or is this beyond 
the scope of CF?
 
Cheers!

Lincoln T. Milner
Senior Application Programmer/Analyst
Department of Health Evaluation Sciences
Pennsylvania State University
600 Centerview Drive
Suite 2200, A210
Hershey, PA 17033-0855
Ph:  717.531.7178
Fax: 717.531.5779
[EMAIL PROTECTED]


*E-Mail Confidentiality Notice*
This message (including any attachments) contains information intended for a specific 
individual(s) and purpose that may be privileged, confidential or otherwise protected 
from disclosure pursuant to applicable law.  Any inappropriate use, distribution or 
copying of the message is strictly prohibited and may subject you to criminal or civil 
penalty.  If you have received this transmission in error, please reply to the sender 
indicating this error and delete the transmission from your system immediately.

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Auto-populating form item

2003-03-07 Thread Raymond Camden
You would need client side code for this. This would be relatively easy
with Flash Remoting. You could also do it with JavaScript and hidden
frames as well.

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

My ally is the Force, and a powerful ally it is. - Yoda 

 -Original Message-
 From: Lincoln Milner [mailto:[EMAIL PROTECTED] 
 Sent: Friday, March 07, 2003 9:31 AM
 To: CF-Talk
 Subject: Auto-populating form item
 
 
 Folks,
  
 We've got this data entry form that allows entry, query, 
 record deletion, and a host of other functionality.  One 
 thing it needs to do is after the first three form items are 
 completed (it's a subject id.t number), the fourth 
 auto-populates with the subject initials.
  
 This should be seamless to the user, i.e., no refresh of the 
 page or submitting of data, so my question is how can we take 
 form items 1, 2, and 3 and use them to dynamically call a 
 query to retrieve the initials from a database?  Or is this 
 beyond the scope of CF?
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



RE: Auto-populating form item

2003-03-07 Thread Tangorre, Michael
you need to use Javascript for this too work with no refresh.
depending upon the amount of data you potentially could retrieve, this might not be a 
good idea.

At anyrate, check out www.pengoworks.com for how to relate form elements and create 
structures allowing for what you desire to do.

hth,

mike

-Original Message-
From: Lincoln Milner [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 10:31 AM
To: CF-Talk
Subject: Auto-populating form item


Folks,
 
We've got this data entry form that allows entry, query, record deletion, and a host 
of other functionality.  One thing it needs to do is after the first three form items 
are completed (it's a subject id.t number), the fourth auto-populates with the subject 
initials.
 
This should be seamless to the user, i.e., no refresh of the page or submitting of 
data, so my question is how can we take form items 1, 2, and 3 and use them to 
dynamically call a query to retrieve the initials from a database?  Or is this beyond 
the scope of CF?
 
Cheers!

Lincoln T. Milner
Senior Application Programmer/Analyst
Department of Health Evaluation Sciences
Pennsylvania State University
600 Centerview Drive
Suite 2200, A210
Hershey, PA 17033-0855
Ph:  717.531.7178
Fax: 717.531.5779
[EMAIL PROTECTED]


*E-Mail Confidentiality Notice*
This message (including any attachments) contains information intended for a specific 
individual(s) and purpose that may be privileged, confidential or otherwise protected 
from disclosure pursuant to applicable law.  Any inappropriate use, distribution or 
copying of the message is strictly prohibited and may subject you to criminal or civil 
penalty.  If you have received this transmission in error, please reply to the sender 
indicating this error and delete the transmission from your system immediately.

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Auto-populating form item

2003-03-07 Thread Cantrell, Adam
Prepopulate a javascript structure with all of the possible initials you'll
need from the database. Use that javascript structure as a pseudo database -
call to it when your criteria is fulfilled from the other form fields.

You could also build a flash widget (Rich Internet Application) to give the
user the impression that there was no communication with the server.
Although depending on how many initials you have in your database, you'd
still probably want to store them in a local structure to give a snappy
response. You don't want the user clicking on things, and not know why
nothing is happening, or guessing around at what they have to do to continue
on.

Adam.




 -Original Message-
 From: Lincoln Milner [mailto:[EMAIL PROTECTED]
 Sent: Friday, March 07, 2003 9:31 AM
 To: CF-Talk
 Subject: Auto-populating form item
 
 
 Folks,
  
 We've got this data entry form that allows entry, query, 
 record deletion, and a host of other functionality.  One 
 thing it needs to do is after the first three form items are 
 completed (it's a subject id.t number), the fourth 
 auto-populates with the subject initials.
  
 This should be seamless to the user, i.e., no refresh of the 
 page or submitting of data, so my question is how can we take 
 form items 1, 2, and 3 and use them to dynamically call a 
 query to retrieve the initials from a database?  Or is this 
 beyond the scope of CF?
  
 Cheers!
 
 Lincoln T. Milner
 Senior Application Programmer/Analyst
 Department of Health Evaluation Sciences
 Pennsylvania State University
 600 Centerview Drive
 Suite 2200, A210
 Hershey, PA 17033-0855
 Ph:  717.531.7178
 Fax: 717.531.5779
 [EMAIL PROTECTED]
 
 
 *E-Mail Confidentiality Notice*
 This message (including any attachments) contains information 
 intended for a specific individual(s) and purpose that may be 
 privileged, confidential or otherwise protected from 
 disclosure pursuant to applicable law.  Any inappropriate 
 use, distribution or copying of the message is strictly 
 prohibited and may subject you to criminal or civil penalty.  
 If you have received this transmission in error, please reply 
 to the sender indicating this error and delete the 
 transmission from your system immediately.
 
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4