On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu <[email protected]> wrote:
> >Comments = '#trim(Form.Comments)#')
>
> Should be Comments = Comments = '#trim(Form.Comments)#'
>
>
Remove the opening bracket as well
<CFquery NAME="qUpdate" DATASOURCE="learncfe"> <!--- error --->
UPDATE GuestBook
SET
GuestName = '#Form.GuestName#',
Email = '#Form.Email#',
FirstVisit = #Form.FirstVisit#,
GotHere = '#Form.GotHere#',
Rating = '#Form.Rating#',
Comments = '#trim(Form.Comments)#'
WHERE GuestBook_ID = #Form.GuestBook_ID#
</CFquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:317176
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
