How can I get the information on my

[robman22]

How can I get the information on my form(from my database) to change to the data relevant to my selection from my dynamic select box? For example: when I select Joe, I want to see Joe's info, and when I select Jane, I want to see Jane's. On the same form of course.

 

[KevinFSI]

I did this when I was in the Air Force. We had a list of employees. If you wanted to change any of the information for a particular employee you would select their name from the list and it would take you to a big form with all of their information in various form fields. You change what you want, keep the rest as-is and hit submit.

Just select a name (and associated ID,) pass it to the page with the form and run a query to retrieve that person's information:

SELECT *
FROM Employees
WHERE Employee_ID = 'YourEmployee'

Once you have that info, you can put it into your form fields like so;

<INPUT TYPE=&quot;text&quot; NAME=&quot;fname&quot; VALUE=&quot;#fname#&quot;>

Hope this is what you were after.

Kevin

 

[robman22]

Not really. I was wondering if I could select the item and have it populate the same form.

Thanks for your response.

 

[KevinFSI]

I don't see why not. Rather than select the item and pass it to another page like mine did, just select the item and use it later in the same page. Should work.

 

[Guest_imported]

I too am a big fan of the "rollover" form. In very rare cases I post forms to "other" pages, but for the most part, I like to stuff it all into one template.

The tricks you will need to master are:

Always name your variables the same as your "columns"

Use CFPARAM to provide a default for every variable

Use action="#GetFileFromPath(GetCurrentTemplatePath())#" in your forms so you cut/paste them or rename the file and they still work.