Try This
UPDATE tablename
SET blah = '#form.blah#'
<cfif isDefined(attributes.String1)>
,string1 = attributes.String1
</cfif>
<cfif isDefined(attributes.String2)>
,string2 = attributes.String2
</cfif>
<cfif isDefined(attributes.String3)>
,string3 = attributes.String3
</cfif>
WHERE theid = #form.theid#
with regards to create the "set" you are going to have to set a flag
with what you want to update i.e. if the update button is clicked or a
hidden form value is equal to something if you explain the scenario I
will be able to advise you better but the above will give you the
ability to create a dynamic update statement without worrying about the
,,,,,.
Cheers
Jerry Staple
Web Application Developer
Certified Coldfusion (5.0) Developer
Head Office
133-137 Lisburn Road, Belfast
Northern Ireland BT9 7AG
T +44 (0) 28 9022 3224
F +44 (0) 28 9022 3223
E [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
W biznet-solutions.com <http://www.biznet-solutions.com/>
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2002 16:10
To: CF-Talk
Subject: Creating update statements on the fly
HI,
I wanted to create a Update statement on the fly. For creating a
Select
statement on the fly I have used
Select * from tablename
Where 0=0
<cfif isDefined(attributes.String1)>
and String1 = attributes.String1
</cfif>
How can I achieve this for update statement as I couldn't figure out
where to put Set statement and the last line with out coma(',') in my
statement.
Thanks in advance.
Sudheer Chakka.
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
