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
to change, but this can be done by +1
it seems, thank you)
From: Daniel Lancelot [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Problem with Insert Using Select
Date: Fri, 09 Feb 2001 14:50:00 -
that wont work - db would look for a field
to change, but this can be done by +1
it seems, thank you)
From: Daniel Lancelot [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Problem with Insert Using Select
Date: Fri, 09 Feb 2001 14:50:00 -
that wont work - db would look for a field
Message-
From: andrew kopelman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 11:00 PM
To: CF-Talk
Subject: Problem with Insert Using Select
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
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 09 February 2001 05:49
To: CF-Talk
Subject: RE: Problem with Insert Using Select
You answered your own question in your last paragraph - you _can_ put
constants and expressions in your select statement.
Try something like
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:
6 matches
Mail list logo