>>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:5545
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
