Which wizard “option” did you
use to create this? The Active Record, the Bean and DAO, or the Flex Data
Service Assembler?
Bill, thank you very much
for your time and response. I apologize
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 [email protected],
"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: [email protected]
[mailto:[email protected]]
On
> Behalf Of g8torjoe
> Sent: Thursday, May 25, 2006 3:17 PM
> To: [email protected]
> 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
YAHOO! GROUPS LINKS
|
- RE: [flexcoders] Re: Question on CF components created by t... Bill Sahlas
-
