MySQL Logic and Recordset Problem

[Guest]

Hi,

OK ---
- I am using the DW8 insert record "wizard"
- I have a table called 'blue' with 3 fields (id, text1, text2)
- I want the user to enter info into a form (1 field) -- the text1 field is a pulldown select
- I want the user entered data in the text1 form field to TRIGGER an auto insert of the text2 data, and then enter both text1 and text 2 field data into a table called ''red" on submit
- Assume that my form is setup correctly and that the form works and passes info from page1 to a results page, and that my tables (blue and red) are setup correctly

How do I do this ?.....LOL...I cannot figure it out ..Your help with putting EXACTLY what I need to in the recordset dialog
box (on the results page) would be GREATLY appreciated......

Regards,
Brain Fart

[Newsgroup_User · Accepted solution]

On 11 Jun 2007 in macromedia.dreamweaver.appdev, OleLena wrote:

> - I am using the DW8 insert record "wizard"
> - I have a table called 'blue' with 3 fields (id, text1, text2)
> - I want the user to enter info into a form (1 field) -- the text1
> field is a pulldown select
> - I want the user entered data in the text1 form field to TRIGGER an
> auto insert of the text2 data, and then enter both text1 and text 2
> field data into a table called ''red" on submit
> - Assume that my form is setup correctly and that the form works and
> passes info from page1 to a results page, and that my tables (blue
> and red) are setup correctly
>
> How do I do this ?

The better question is why do you want to do this? It sounds like
you're entering redundant data - in other words, for every time you
enter 'banana' in text1, you enter 'eaten at breakfast with cereal' in
text2? Either enter it all in text1, or extract it using a join on
output.

> .....LOL...I cannot figure it out ..Your help
> with putting EXACTLY what I need to in the recordset dialog
> box (on the results page) would be GREATLY appreciated......

What exactly are you trying to do?

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

[Guest]

Joe,
Good questions and right on! ....Trust me , I have thought about them .. the reason for the built-in "redundancy" has to do with a larger corporate (in this case, educational) issue with DB connections, and the maintenance of a reliable source of data ....

So---is there an answer to my questions?

JE