Skip to Content
Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started
book

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

by Ben Forta, Raymond Camden, Charlie Arehart
September 2007
Intermediate to advanced
600 pages
20h 21m
English
Adobe Press
Content preview from Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

Controlling <cfinsert> Form Fields

<cfinsert> instructs ColdFusion to build SQL INSERT statements dynamically. ColdFusion automatically uses all submitted form fields when building this statement.

Sometimes you might want ColdFusion to not include certain fields. For example, you might have hidden fields in your form that aren’t table columns, such as the hidden field shown in Listing 14.7.

That field might be there as part of a security system you have implemented; it isn’t a column in the table. If you try to pass this field to <cfinsert>, ColdFusion passes the hidden Login field as a column to the database. Obviously, this generates an database error, as seen in Figure 14.3, because no Login column exists in the Films table.

Figure 14.3. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development

Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development

Ben Forta, Charlie Arehart, Jeffrey Bouley, Jeff Tapper, Matt Tatam, Raymond Camden, Robi Sen, Sarge Sargent
macromedia® Coldfusion® MX 7 Web Application Construction Kit

macromedia® Coldfusion® MX 7 Web Application Construction Kit

Ben Forta, Raymond Camden, Leon Chalnick, Angela Buraglia

Publisher Resources

ISBN: 9780321515483Purchase book