• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

ASP - Insert using a dropdown box

C

Cintirich

Limp Gawd
Joined
Oct 9, 2006
Messages
244
Mods, please delete. This has been resolved.

Thank you.

Hello all,

I've searched and searched and even tried posting to the ASP forums with no success so I'm hoping I can get some help here. I've been working on this issue for two days and am getting no farther at this point.


I'm setting up a simple website using MS Visual Studio 2010 and I have a question having to do with dropdown boxes.
I need to be able to insert data into a table (MOVIE) of 6 columns using 5 text boxes and a dropdown box. The text boxes are no problem. I used formview and set them up accordingly. The sticky point is updating the last field using the dropdown.
The field I need to update for insertion is MOV_Genre (from the table MOVIE). MOV_Genre is tied to the GENRE table via the foreign key GEN_Code (from the table GENRE). The dropdown should show the entries from the other field in GENRE, GEN_name.
So far, I have been able to get GEN_name to display, but it won't update the MOV_Genre field and causes an error when I try to update.
Here is my code. (Sorry it's not in a code box, it kept getting truncated) Hopefully it helps.
Thanks!
Rich
 
Last edited:
Why not share your solution (along with the original issue) instead of editing out the problem and stating that it's fixed for you?
 
You must log in or register to reply here.
Back
Top