Steve,
Before you can update the database you need a match. What I mean by
a match is that you need to pass an ID to your query that matches that
of the record you wish to update.
Example:
<cfif isDefined("alertId") and len(form.alert)>
<cfquery name="qryUpdate" datasource="text">
update alert set
alert = '#FORM.alert#'
where alertId = '#FORM.alertId#'
</cfquery>
</cfif>
<form name="updateForm" method="post" action="thisFile.cfm">
AlertId: <input type="text" name="alertId" value="" /><br /><br />
Alert: <input type="text" name="alert" value="" /><br /><br />
<input type="submit" value="submit" />
</form>
On the alertId text field, you will pass the Id that corresponds that of
the primary key of the row you wish to update on the database. So look
at your database and try to find the row you need to update. Let's say
that the row number is number 4. So you type number 4 on the form for
AlertId field. Then type some text for the Alert field and hit submit.
This should work without a problem.
Ravi.
Steve LaBadie wrote:
> Sorry Ravi no dice. This should be a simple thing to do. There are no
> errors when the page loads and no update to the DB.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:316936
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
