> still not working. hmm...
>
> <cfif qry_emailToPK.recordcount>
> <cfset variables.newguid = CreateUUID()>
> <cfquery
> name="qry_CREATETOKEN"
> datasource="#variables.datasource#">
> insert into #request.sqlobjectprefix#TblEmailRecovery
> (
> guid,
> emailaddress
> )
> VALUES
> (
> <cfqueryparam cfsqltype="cf_sql_varchar" value="#variables.newguid#">,
> <cfqueryparam cfsqltype="cf_sql_varchar"
> value="#qry_emailToPK.emailaddress#">
> );
>
>
> SELECT IDENT_CURRENT('#request.sqlobjectprefix#
> TblEmailRecovery') as mynewidentity;
>
> go
> </cfquery>
Are you sure this table even has an identity column? If so, why do you
also need a GUID? Normally, you'd have one or the other, but not both.
Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358689
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
