You are running the insert query each time you load the page. Remove your
<cfparam>s on the form fields, and wrap the query in an <cfif>.
<cfif !structIsEmpty( form )>
<!--- insert query here --->
</cfif>
HTH
On Tue, Jan 15, 2013 at 2:34 PM, B Griffith <[email protected]> wrote:
>
> Hello All,
>
> I appreciate everyone's help on my other posts and think I'm coming to
> understand CF a lot better than I did before I started posting here a few
> days ago, so kudos to you, friends!
>
> My latest issue w/ my burgeoning new website is the input.cfm page, where
> an end-user may (in theory) enter a donor's information into a webform,
> click submit, and the data will subsequently be inserted into the SQL
> Server (2005) table dbo.DONOR, which while it's under development, has only
> six fields: kcid (auto-incrementing PK/UID for the database) and the other
> five which you see in the code below and are probably pretty
> self-explanatory. I have tried creating an empty structure called 'form'
> before applying the code and finally settled on a block of <cfparam>
> statements to set the vars to a default. I can't see a way around this
> because NOT doing so causes the form to indeed show at the top of the
> webpage, but it is followed by a CF error page. INCLUDING the <cfparam>
> tags or <cfset var = ""> or form = structNew(); causes the error output to
> go away but results in TWO recordsets being sent to the DB, one blank
> (except for the PK which is set up to auto-increment in SQL) and one with
> the correct info, and taking the next PK number. I also tried setting the
> fields to NOTNULL = TRUE in SQL but to no avail, apparently "" translates
> into something besides null on the server-side. Here is the code, I would
> greatly appreciate your thoughts on what I'm doing wrong and how to rectify
> it:
>
> <html>
> <head>
> <title>Input form for new donor</title>
> </head>
>
> <cfparam name="form.first" default="">
> <cfparam name="form.last" default="">
> <cfparam name="form.flag" default="">
> <cfparam name="form.supe" default="">
> <cfparam name="form.phone" default="">
>
> <body>
> <div> <hr /> </div>
> <form action="input.cfm" method="post">
> <table>
> <tr>
> <td>Donor First Name:</td>
> <td><input type="text" name="first" id="first" value="" /></td>
> </tr>
> <tr>
> <td>Donor Last Name:</td>
> <td><input type="text" name="last" id="last" value="" /></td>
> </tr>
> <tr>
> <td>Donor's Immediate Supervisor:</td>
> <td><input type="text" name="supe" id="supe" value="" /></td>
> </tr>
> <tr>
> <td>Supervisor's Phone Number:</td>
> <td><input type="text" name="phone" id="phone" value="" /></td>
> </tr>
> <tr>
> <td>Has this employee provided a sample in the past 30 days?
> (Y/N):</td>
> <td><input type="text" name="flag" id="flag" value="" /></td>
> </tr>
> </table>
> <input type="submit" value="Enter New Donor">
>
> <br /><a href="index.cfm">Back to homepage</a>
> <br /><a href="random.cfm">Random Donor Generator</a>
> </body>
>
> <cfquery name="addDonor" datasource="test">
> INSERT INTO DONOR (first,last,flag,supe,phone)
> VALUES
> ('#form.first#','#form.last#','#form.flag#','#form.supe#','#form.phone#')
> </cfquery>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353895
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
