Sry. I didn't read the question fully. You already know what I proposed.

--- In [email protected], "dinger0007" <[EMAIL PROTECTED]> wrote:
>
> 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" <kenb@> 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/
 


Reply via email to