> that wont work - db would look for a field with the generated UUID as a
> name... you need to have a subselect:
>
[snip]
> SELECT (select '#CreateUUID()#') as MyUUID, name, VersionID + 1
nope, you don't need a "subselect". in fact for some DBs (say sql server)
you don't even need to have the insert value pointing to a column name.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
