I created a simple (I thought) admin panel to update specific text on a
page. But to my surprise when I update the text it adds it at the end
instead of replacing the existing text. Not sure what I need to do so it
adds and deletes existing text.
This is the panel code:
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ
"frmAddAlert">
<cfquery datasource="text">
INSERT INTO alert (alert)
VALUES (
<cfif IsDefined("FORM.alert") AND #FORM.alert# NEQ "">
'#FORM.alert#'
<cfelse>
NULL
</cfif>
)
</cfquery>
<cflocation url="../../status1.cfm?msg=Alert+Title+added+successfully.">
</cfif>
<form action="<cfoutput>#CurrentPage#</cfoutput>" method="post"
name="frmalert" id="frmAddAlert">
<textarea name="alert" cols="70" rows="10" id="alert"
class="formveld"></textarea>
<input name="Reset" type="reset" id="Reset" value=" Reset "
class="formveld"> <input name="Submit" type="submit" id="Submit"
value=" Submit " class="formveld">
<input type="hidden" name="MM_InsertRecord" value="frmAddAlert">
</form>
This is the insertion page code:
<cfquery name="GetAlert" datasource="text">
SELECT *
FROM alert
</cfquery>
<cfoutput query="GetAlert">#GetAlert.alert#</cfoutput>
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
http://www.esu.edu
[email protected]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316915
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
