well, in your values section of your insert, you have an closing
parentheses without an openning one...
-----Original Message-----
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 21, 1999 7:06 PM
To: [EMAIL PROTECTED]
Subject: Inserting and Updateing Date Variables
'#DateFormat(form.articledate, "dd/mm/yy")#'
Can someone possible explain to me wht the above code works find in the
table update function (code below) but generates and error message in the
table insert function when both sets of code are being applied to the same
table ????
<cfquery datasource="citicentre">
insert into articles (articledate, articletitle, publication, content)
values '#DateFormat(form.articledate, "dd/mm/yy")#', '#form.articletitle#',
'#form.publication#', '#content#')
</cfquery>
<cfquery name="updatethearticle" datasource="citicentre">
update articles
Set articledate='#DateFormat(form.articledate, "dd/mm/yy")#',
articletitle='#articletitle#', publication='#publication#',
content='#content#'
Where articleid = #form.articleid#
</cfquery>
Kind Regards
Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.