I want to insert new records into a table which has MyUUID as its primary
key as well as a column, VersionId, which needs to be updated. Each new
record should be identical to the old record, except for a new MyUUID and an
incremented VersionID. For example, this old record:
MyUUID: BT784-PI89
MyName: Smith
VersionID: 1
should have its corresponding new record:
MyUUID: A622T-U8FF
MyName: Smith
VersionID: 2
I can't use the query syntax:
INSERT into tbl (MyUUID, name, VersionID)
SELECT MyUUID, name, VersionID
FROM tbl
WHERE MYUUID = '#form.MyUUID#'
because that would be overwriting (making non-unique) the UUID, not to
mention the version number.
Is there a way to do the insert with the Select as well as a dynamically
generated uuid? In other words, to simultaneously use the select for given
columns (MyName) and passed-in values for other columns(MyUUID, VersionID).
I need this to work with CF4.5; any ideas?
Thanks ahead of time,
Andrew Kopelman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
