We just went through this, that will not work on CFMX 7 :-)
On Thu, Sep 8, 2011 at 2:21 AM, Grandville Ricks <[email protected]>wrote: > > >>While I'm not sure I like how you are doing it, it does seem like it > > > >No Raymond, > >Nothing shows up ..wiered !! > > > Mo, try this: > > > > <cfif isDefined("form.processForm")> > > <cfquery name="qName" datasource="#DSN1#" result="qr"> > > INSERT INTO TBLCPR_PROGRAM (PROGRAM_NAME) > VALUES > ( > <cfif IsDefined("FORM.PROGRAM_NAME") AND #FORM.PROGRAM_NAME# NEQ ""> > <cfqueryparam value="#FORM.PROGRAM_NAME#" cfsqltype="cf_sql_clob" > maxlength="4000"> > <cfelse> > '' > </cfif> > ) > </cfquery> > > <cfset variables.myLastRecord = qr.ROWID> <!--- ROWID is for oracle ---> > > <cflocation url="Progra_ackn.cfm?variable=#variables.myLastRecord#"> > > > </cfif> > > <cfoutput> > > <form action="#cgi.script_name#?#cgi.query_string#" method="post" > name="form1" id="form1"> > <input type="hidden" name="processForm" value="1" /> > <input type="text" name="program_name" value="" /> > > <input type="submit" name="submit" value="my submission" /> > </form> > > </cfoutput> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5546 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
