Can't Update Table With Form Data in SQL Statement

SMS enable your application via Clickatell’s fast, simple and reliable API's, built to integrate with any system. Click here to learn more.

Flash Website Builder- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.

Check Out Custom Custom Logo Design by LogoBee. Website Design and Free Logo Templates available.

		CodingForums.com > :: Server side development > Other server side languages/ issues > ColdFusion
Can't Update Table With Form Data in SQL Statement

Before you post, read our: Rules & Posting Guidelines

Thread Tools

Rate Thread

Enjoy an ad free experience by logging in. Not a member yet? Register.

07-10-2009, 08:41 PM

PM User | #1

macwiz

Regular Coder

Join Date: Jul 2008

Posts: 195

Thanks: 3

Thanked 11 Times in 11 Posts

Can't Update Table With Form Data in SQL Statement

Hi. Attached is the zip file of the error and the 2 cfm pages.... selectstudents.cfm goes first.

THe issue I am having is that the database is not being updated when I run the editroster.cfm page, submitted from the selectstudents.cfm page. The students #FORM.Period#_Class column should be filled with the #URL.ClassID# if the checkbox is checked on the selectstudents.cfm page.

Thanks for the help! It's appreciated

Attached Files

UpdateRoster.zip (29.6 KB, 243 views)

__________________
-MacWiz1220
Science fiction does not remain fiction for long. And certainly not on the Internet.
-Vinton Cerf: Chief Internet Evangelist for Google and co-creator of the TCP/IP Internet Protocol Suite

Bookmarks

Jump To Top of Thread

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT +1. The time now is 07:07 AM.