Search results for query: *

I finally got this working. Thanks for everyones help/suggestions. Here is a link to the website I referenced: http://www.databasedev.co.uk/filter_combo_boxes.html

I am still having trouble with this. I tried and it didn't work. Here are the details: Each department has some committees. Whenever the user select department A, committtees from group A should appear. If department B is selected committees from B should appear, etc. The combo box for...

Awesome. Thanks for your feedback. I will try and post my results. :-)

I have a form with a combo box field. I want to create three other fields that are controlled by whatever the user selects. For example course has course name, and type. I want the to field the user selects to be the course number and then two other fields are automatically populated, course...

Thanks for everyone's feedback. I set it up as a continuous form and it works fine. :)

Thanks for your feedback I will try and post soon. Thanks again. Anna

I have a database that I would like to enhance to make data entry user friendly. The database collects information on faculty. The main form has a section of faculty education. Some faculty may have two or more degrees. I would like to have the user key in a value X which will equal the number...

LOL, csteinbillber. Thanks for all your replies. I will test soon. :-)

I have a loop that will insert user course selections. I also want to keep a running sum of the costs for these courses. The course fee is stored in tblCourse.course_fee which is then multiplied by number of people attending the course, which the users enters a value(no_attending). I keep...

Many thanks for your reply. I've decided to accomplish this by just having the select lists on different. It's not as efficient a choice as what I wanted but given my knowlege and time left to complete this I have no choice. :-)

I am trying to create an update menu based on a list of items (course numbers) that once the user selects a course the list of attendees will be populated on that same screen. Once the names appear the user then has the ability to delete edit and add to the selected course. I know how to do...

yes, it does help alot. :-)

It works! Awesome, can you give me a little information on why cfloop as opposed to cfoutput. Thanks again for your help. :-)

Here is the complete code for the cfmail: [code] <cfmail.....> <cfquery name="getReg" datasource="seligins"> SELECT b.firstname, b.lastname, a.course_date, a.course_name FROM tblCourse a, tblAttendee b, tblRegistration_details d WHERE a.course_id = d.course_id AND d.h_email =...

My form action page displays what a users has submitted and then sends that same information to their email address. Currently the <cfmail> information looks like: <table border="0" cellpadding="5" cellspacing="0"> <CFSET variables.bg_color = "E5DEEB"> <CFLOOP index="i"...

Thanks to all of you for your feedback, they're very helpful. Thanks, :-)

I figured it out myself, DUH!, I forgot the '' for #Form.h_email#. :-)

I am trying to finalize an online registration process. The form consists of checkboxes and text fields. Email is being used as the PK and a value of aap2@nyu.edu was entered into the form. The values are passed to an action form which contains the following queries: <!--- Initialize a...

My bad, YOU did help me! LOL You get me thinking about this in different ways. To show my appreciation I officially thanked you using the tek-tips "Thank..." link. :-)

I did some more searching on the internet and ended up with the following code that works perfectly: <cfset thisList = "#Form.course_id#"> <cfloop list = "#thisList#" index="nthisList"> <cfquery name="insertCourse" datasource="seligins"> INSERT INTO tblRegistration_details (h_email...