that I am still a little confused. I am using beta 3 and the code
below was generated by the wizard automatically (at the end of the
create function):
<!--- If your server has a better way to get the ID that is more
reliable, use that instead --->
<cfquery name="qGetID" datasource="myDB_sql">
select ID
from dbo.partsShipAddr
where Name = <cfqueryparam value="#local1#"
cfsqltype="CF_SQL_VARCHAR" />
and Addr1 = <cfqueryparam value="#local2#"
cfsqltype="CF_SQL_VARCHAR" />
and Addr2 = <cfqueryparam value="#local3#"
cfsqltype="CF_SQL_VARCHAR" />
and City = <cfqueryparam value="#local4#"
cfsqltype="CF_SQL_VARCHAR" />
and State = <cfqueryparam value="#local5#"
cfsqltype="CF_SQL_VARCHAR" />
and Zip = <cfqueryparam value="#local6#"
cfsqltype="CF_SQL_VARCHAR" />
and Phone = <cfqueryparam value="#local7#"
cfsqltype="CF_SQL_VARCHAR" />
and Email = <cfqueryparam value="#local8#"
cfsqltype="CF_SQL_VARCHAR" />
and Comments = <cfqueryparam value="#local9#"
cfsqltype="CF_SQL_VARCHAR" />
and PurchaseLoc = <cfqueryparam value="#local10#"
cfsqltype="CF_SQL_VARCHAR" />
order by ID desc
</cfquery>
</cftransaction>
<cfset variables.ID = qGetID.ID>
This seems to be what you were referring to with creating a SELECT
statement with the exact conditions of my update. I guess my
confusion is that I don't see where variables.ID is getting passed
back to the automatically created gateway component and then back to
Flex. Does that make any sense?
Thanks again!!!
--- In flexcoders@yahoogroups.com, "Bill Sahlas" <[EMAIL PROTECTED]> wrote:
>
> We thought about exposing the returned ID (ID that gets created for
> AUTOINCREMENT keys) in the CFQUERY RESULT, a new attribute available as
> part of CFMX 7.x. But, the process to get this is not always supported
> by the backend DBs so we backed off this feature for now. You'll need
> to code this yourself in the release that you currently have by using a
> SELECT statement with a WHERE clause whose criteria is identical to the
> values that you used in the INSERT statement. For the final release
> this code is already gen'd by the wizard.
>
>
>
> ________________________________
>
> From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of g8torjoe
> Sent: Thursday, May 25, 2006 3:17 PM
> To: flexcoders@yahoogroups.com
> Subject: [flexcoders] Question on CF components created by the Flex
> Wizard
>
>
>
> I am having a little trouble following the flow of the CF components
> created by the wizard in Flex. I am using the save function of the
> gateway component and writing to the database successfully. When I
> create a new record I am wondering if the ID (or key - mine is ID)
> should be returned. I see in the component that is searches for the ID
> after I add it but when I debug my Flex app in the result event
> handler I am not finding that data. Am I making an assumption here?
> Thanks!
>
>
>
>
>
>
> --
> Flexcoders Mailing List
> FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
> Search Archives:
> http://www.mail-archive.com/flexcoders%40yahoogroups.com
>
>
>
>
> SPONSORED LINKS
>
> Web site design development
> <http://groups.yahoo.com/gads?t=ms&k=Web+site+design+development&w1=Web+
> site+design+development&w2=Computer+software+development&w3=Software+des
> ign+and+development&w4=Macromedia+flex&w5=Software+development+best+prac
> tice&c=5&s=166&.sig=L-4QTvxB_quFDtMyhrQaHQ>
>
> Computer software development
> <http://groups.yahoo.com/gads?t=ms&k=Computer+software+development&w1=We
> b+site+design+development&w2=Computer+software+development&w3=Software+d
> esign+and+development&w4=Macromedia+flex&w5=Software+development+best+pr
> actice&c=5&s=166&.sig=lvQjSRfQDfWudJSe1lLjHw>
>
> Software design and development
> <http://groups.yahoo.com/gads?t=ms&k=Software+design+and+development&w1=
> Web+site+design+development&w2=Computer+software+development&w3=Software
> +design+and+development&w4=Macromedia+flex&w5=Software+development+best+
> practice&c=5&s=166&.sig=1pMBCdo3DsJbuU9AEmO1oQ>
>
> Macromedia flex
> <http://groups.yahoo.com/gads?t=ms&k=Macromedia+flex&w1=Web+site+design+
> development&w2=Computer+software+development&w3=Software+design+and+deve
> lopment&w4=Macromedia+flex&w5=Software+development+best+practice&c=5&s=1
> 66&.sig=OO6nPIrz7_EpZI36cYzBjw>
>
> Software development best practice
> <http://groups.yahoo.com/gads?t=ms&k=Software+development+best+practice&
> w1=Web+site+design+development&w2=Computer+software+development&w3=Softw
> are+design+and+development&w4=Macromedia+flex&w5=Software+development+be
> st+practice&c=5&s=166&.sig=f89quyyulIDsnABLD6IXIw>
>
>
>
>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "flexcoders
> <http://groups.yahoo.com/group/flexcoders> " on the web.
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> ________________________________
>
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
SPONSORED LINKS
| Web site design development | Computer software development | Software design and development |
| Macromedia flex | Software development best practice |
YAHOO! GROUPS LINKS
- Visit your group "flexcoders" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
