I chose the Active Record

--- In flexcoders@yahoogroups.com, "Bill Sahlas" <[EMAIL PROTECTED]> wrote:
>
> Which wizard "option" did you use to create this?  The Active Record,
> the Bean and DAO, or the Flex Data Service Assembler?
>
> ________________________________
>
> From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of g8torjoe
> Sent: Friday, May 26, 2006 1:47 PM
> To: flexcoders@yahoogroups.com
> Subject: [flexcoders] Re: Question on CF components created by the Flex
> Wizard
>

>
> 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 flexcoders@yahoogroups.com, "Bill Sahlas" <bsahlas@> 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
> <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




Reply via email to