My 2 cents would be to do the insert and return the ID from the cfc.
This code I borrowed from http://mkruger.cfwebtools.com/ sweet site
with lots of info.
<cfquery name="putUser" datasource="#dsn#">
SET NOCOUNT ON
INSERT INTO USERS (username, email)
VALUES
(<cfqueryparam cfsqltype="CF_SQL_CHAR" value="#usersname#">,
<cfqueryparam cfsqltype="CF_SQL_CHAR" value="#email#"> )
SELECT @@Identity AS newId
SET NOCOUNT OFF
</cfquery>
--- In [email protected], "Ken Bromberger" <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
>
>
> I have a webservice that returns the new ID for the database as
> a result of a record insert. Is there a way to capture this when the
> webservice inserts the record? I have been looking at the Handling
> result and fault events on live docs but don't quite see how I bind the
> result. Any tips??
>
>
>
> Thanks! - Ken
>
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
