Re: [flexcoders] Flex - Database
Ted, Did you ever post any of these class files? Rich On 9/15/06, Ted Patrick [EMAIL PROTECTED] wrote: Greg, I have been playing with a custom MYSQL Class for AS3 based on Socket. It uses flash.net.Socket to connect directly to a database natively and exchange data. flash.net.Socket is an intrinsic class within the Flash Player 9 and provides a true Binary TCP/IP Socket. TCP/IP Sockets are the basis for most DB connections including ORACLE, MYSQL, MSSQL. Flash.net.Socket is available today Flash Player 9 and is fully available within Flex. Socket also includes: read/write of AMF3 compress/uncompress using ZLIB Image data can be written to the Display List via Loader.writeBytes( ByteArray ) including native image support for SWF,GIF,PNG,JPG AS3 driver development is just a matter of time. I expect we will see the community step up and write some great drivers to allow native databaseaccess. Outside of databases I have personally seen flash.net.Socket implement the following protocols thus far: POP3, IMAP, SVN, VNC, XMPP, NNTP, AIM, TELNET, DNS, LDAP Fire up AS3, learn flash.net.Socket and flash.utils.ByteArray, and write some more protocols! Cheers, Ted Patrick Flex Evangelist Adobe Systems Incorporated -- Rich Tretola mx:EverythingFlex/ http://www.EverythingFlex.com
RE: [flexcoders] Flex - Database
Has anyone actually tried executing an SQL 2005 XML Webservice directly in Flex 2? I have setup an example but I always get the following error in flex when calling a webservice method: faultCode:DecodingError faultString:'Error #1009: Cannot access a property or method of a null object reference.' faultDetail:'null' I can test the Webservice with XMLSpy, send a SOAP request and read it without problems. So my guess is flex can't handle the sort of decoding it's using. Here's the envelope I'm sending (it's the same as calling the webservice operation GetProductById in Flex: SOAP-ENV:Envelope xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; SOAP-ENV:Body m:GetProductByID xmlns:m=http://Adventure-Works/Products; m:ProductID-0/m:ProductID /m:GetProductByID /SOAP-ENV:Body /SOAP-ENV:Envelope And this is the resulting xml http://212.100.188.156/formulaOne/wsResult.xml Apparently flex is having a problem decoding the resulting XML Anyone with a tip? Jonas -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paul Andrews Sent: vrijdag 15 september 2006 11:31 To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Flex - Database That's true, but there would be nothing to stop anyone building a data access layer using actionscript that was separate to the view logic. Currently the view logic will use FDS, or a web service/whatever to get the data for the view, there's no logical reason why the fuctionality that typically lives on the server couldn't reside in actionscript classes and still retain independence from the view. It's a separate argument whether you want that processing for performance reasons to take place on the client or the server, but in terms of logically separating layers there's no reason not to do that and have a very slim database/persistence layer sitting on the server rather the full access layer. In essence, it's good that the current Flex facilities (almost) enforce the separation, but even without that separation you can be a good developer and not compromise the architecture. Maybe I'll get flamed for this.. Paul - Original Message - From: Tom Chiverton [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Friday, September 15, 2006 10:15 AM Subject: Re: [flexcoders] Flex - Database On Thursday 14 September 2006 16:02, Tracy Spratt wrote: If this functionality is the same as the SQLXML functionality I played with a year or so ago, SQL Server provides an url against which you can make SQL queries. Handy, but you really shouldn't be using it. The temptation then will be to keep your data access layer mixed up with the view. Eww. -- Tom Chiverton Helping to vitalistically leverage bricks-and-clicks e-services This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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 -- 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 __ NOD32 1.1756 (20060914) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http
RE: [flexcoders] Flex - Database
Has anyone actually tried executing an SQL 2005 XML Webservice directly in Flex 2? I have setup an example but I always get the following error in flex when calling a webservice method: faultCode:DecodingError faultString:'Error #1009: Cannot access a property or method of a null object reference.' faultDetail:'null' I can test the Webservice with XMLSpy, send a SOAP request and read it without problems. So my guess is flex can't handle the sort of decoding it's using. Here's the envelope I'm sending (it's the same as calling the webservice operation GetProductById in Flex: SOAP-ENV:Envelope xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; SOAP-ENV:Body m:GetProductByID xmlns:m=http://Adventure-Works/Products; m:ProductID-0/m:ProductID /m:GetProductByID /SOAP-ENV:Body /SOAP-ENV:Envelope And this is the resulting xml http://212.100.188.156/formulaOne/wsResult.xml Apparently flex is having a problem decoding the resulting XML Anyone with a tip? Jonas -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paul Andrews Sent: vrijdag 15 september 2006 11:31 To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Flex - Database That's true, but there would be nothing to stop anyone building a data access layer using actionscript that was separate to the view logic. Currently the view logic will use FDS, or a web service/whatever to get the data for the view, there's no logical reason why the fuctionality that typically lives on the server couldn't reside in actionscript classes and still retain independence from the view. It's a separate argument whether you want that processing for performance reasons to take place on the client or the server, but in terms of logically separating layers there's no reason not to do that and have a very slim database/persistence layer sitting on the server rather the full access layer. In essence, it's good that the current Flex facilities (almost) enforce the separation, but even without that separation you can be a good developer and not compromise the architecture. Maybe I'll get flamed for this.. Paul - Original Message - From: Tom Chiverton [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Friday, September 15, 2006 10:15 AM Subject: Re: [flexcoders] Flex - Database On Thursday 14 September 2006 16:02, Tracy Spratt wrote: If this functionality is the same as the SQLXML functionality I played with a year or so ago, SQL Server provides an url against which you can make SQL queries. Handy, but you really shouldn't be using it. The temptation then will be to keep your data access layer mixed up with the view. Eww. -- Tom Chiverton Helping to vitalistically leverage bricks-and-clicks e-services This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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 -- 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 __ NOD32 1.1756 (20060914) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paul Andrews Sent: vrijdag 15 september 2006 13:50 To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Flex - Database Ah, OK now we're talking about the security of a Flex/Flash app, and I take your point. Is that always an issue on an intranet? perhaps not. I guess that security is always going
Re: [flexcoders] Flex - Database
On Thursday 14 September 2006 16:02, Tracy Spratt wrote: If this functionality is the same as the SQLXML functionality I played with a year or so ago, SQL Server provides an url against which you can make SQL queries. Handy, but you really shouldn't be using it. The temptation then will be to keep your data access layer mixed up with the view. Eww. -- Tom Chiverton Helping to vitalistically leverage bricks-and-clicks e-services This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
Re: [flexcoders] Flex - Database
That's true, but there would be nothing to stop anyone building a data access layer using actionscript that was separate to the view logic. Currently the view logic will use FDS, or a web service/whatever to get the data for the view, there's no logical reason why the fuctionality that typically lives on the server couldn't reside in actionscript classes and still retain independence from the view. It's a separate argument whether you want that processing for performance reasons to take place on the client or the server, but in terms of logically separating layers there's no reason not to do that and have a very slim database/persistence layer sitting on the server rather the full access layer. In essence, it's good that the current Flex facilities (almost) enforce the separation, but even without that separation you can be a good developer and not compromise the architecture. Maybe I'll get flamed for this.. Paul - Original Message - From: Tom Chiverton [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Friday, September 15, 2006 10:15 AM Subject: Re: [flexcoders] Flex - Database On Thursday 14 September 2006 16:02, Tracy Spratt wrote: If this functionality is the same as the SQLXML functionality I played with a year or so ago, SQL Server provides an url against which you can make SQL queries. Handy, but you really shouldn't be using it. The temptation then will be to keep your data access layer mixed up with the view. Eww. -- Tom Chiverton Helping to vitalistically leverage bricks-and-clicks e-services This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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 -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
Re: [flexcoders] Flex - Database
Ah, OK now we're talking about the security of a Flex/Flash app, and I take your point. Is that always an issue on an intranet? perhaps not. I guess that security is always going to force the layer split on the internet (so you might as well do it anyway for the intranet). I've spent too much time on intranet applications, forgetting about those devious sorts out there.. Paul - Original Message - From: Tom Chiverton [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Friday, September 15, 2006 11:55 AM Subject: Re: [flexcoders] Flex - Database On Friday 15 September 2006 10:30, Paul Andrews wrote: typically lives on the server couldn't reside in actionscript classes and still retain independence from the view. What happens if I decompile and alter the client, then recompile it ? Nothing the client does (or asks to be performed) should be trusted, which is why business layers live on servers. -- Tom Chiverton Helping to collaboratively harvest unique portals This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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 -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
Re: [flexcoders] Flex - Database
On Friday 15 September 2006 12:49, Paul Andrews wrote: I've spent too much time on intranet applications, forgetting about those devious sorts out there.. Heh, me too :-) Nice to pop back to the big bad world sometimes though - the majority of security breeches come from people inside the company, rather than external threats. -- Tom Chiverton Helping to synergistically transition user-centric initiatives This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
Re: [flexcoders] Flex - Database
Nothing the client does (or asks to be performed) should be trusted, which is why business layers live on servers. Oh, collery: Using FDS data-sync is a bad idea from this point of view, as it allows the app very fine grained access (i.e. at the level of tables) as opposed to a high level business process (create a user with these properties). I don't see a way to have FDS managed data-sync *and* proper control over what goes in the DB. -- Tom Chiverton, it's only paranoia if they aren't out to get you. This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
RE: [flexcoders] Flex - Database
I really agree, but you will notice that soon after getting some HelloWorld.mxml level applications working, many beginners want to start using dynamic data. And now that Flex pricing has opened up it to any size project or company, many beginners do not come from an enterprise background and are not already proficient in a server-tier platform, and do not have access to a team that is. For such a developer, the current hurdle to get data into Flex is very high. Some solutions that do not require learning another language would be very useful to a large group of developers. Maybe they are making their wife a recipe program. Maybe they are doing a proof of concept for their boss. There is a very long way between HelloWorld and enterprise application architecture best-practice. Making Flex data access easy is going to help more than hurt. Tracy -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom Chiverton Sent: Friday, September 15, 2006 5:16 AM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Flex - Database On Thursday 14 September 2006 16:02, Tracy Spratt wrote: If this functionality is the same as the SQLXML functionality I played with a year or so ago, SQL Server provides an url against which you can make SQL queries. Handy, but you really shouldn't be using it. The temptation then will be to keep your data access layer mixed up with the view. Eww. -- Tom Chiverton Helping to vitalistically leverage bricks-and-clicks e-services This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. -- 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 -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
RE: [flexcoders] Flex - Database
Greg, I have been playing with a custom MYSQL Class for AS3 based on Socket. It uses flash.net.Socket to connect directly to a database natively and exchange data. flash.net.Socket is an intrinsic class within the Flash Player 9 and provides a true Binary TCP/IP Socket. TCP/IP Sockets are the basis for most DB connections including ORACLE, MYSQL, MSSQL. Flash.net.Socket is available today Flash Player 9 and is fully available within Flex. Socket also includes: read/write of AMF3 compress/uncompress using ZLIB Image data can be written to the Display List via Loader.writeBytes( ByteArray ) including native image support for SWF,GIF,PNG,JPG AS3 driver development is just a matter of time. I expect we will see the community step up and write some great drivers to allow native database access. Outside of databases I have personally seen flash.net.Socket implement the following protocols thus far: POP3, IMAP, SVN, VNC, XMPP, NNTP, AIM, TELNET, DNS, LDAP Fire up AS3, learn flash.net.Socket and flash.utils.ByteArray, and write some more protocols! Cheers, Ted Patrick Flex Evangelist Adobe Systems Incorporated __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
[flexcoders] Flex - Database
Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance. -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
Re: [flexcoders] Flex - Database
- Original Message - From: Sudharshan Rao [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Thursday, September 14, 2006 8:46 AM Subject: [flexcoders] Flex - Database Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance. Flex doesn't connect directly to a database. You will need to use a server-side technology and communicate with it using: Http service, Web service, Flex Data Service, etc. - just check out the tutorials on the adobe site and all over the web. Paul www.ipauland.com -- 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/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/
Re: [flexcoders] Flex - Database
You can connect direct to database with webservices in SQL2005 (end points)RogerioOn 9/14/06, Paul Andrews [EMAIL PROTECTED] wrote: - Original Message - From: Sudharshan Rao [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Thursday, September 14, 2006 8:46 AM Subject: [flexcoders] Flex - Database Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance. Flex doesn't connect directly to a database. You will need to use a server-side technology and communicate with it using: Http service, Web service, Flex Data Service, etc. - just check out the tutorials on the adobe site and all over the web. Paul www.ipauland.com __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
Re: [flexcoders] Flex - Database
- Original Message - From: Rogerio Gonzalez To: flexcoders@yahoogroups.com Sent: Thursday, September 14, 2006 2:00 PM Subject: Re: [flexcoders] Flex - Database You can connect "direct" to database with webservices in SQL2005 (end points)Rogerio How does this differ from webservices in general? What make it "Direct"? I think the OP really wants to talk directly to a database and squirt SQL at it inside Flex. Paul On 9/14/06, Paul Andrews [EMAIL PROTECTED] wrote: - Original Message - From: "Sudharshan Rao" [EMAIL PROTECTED]To: flexcoders@yahoogroups.comSent: Thursday, September 14, 2006 8:46 AMSubject: [flexcoders] Flex - Database Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance. Flex doesn't connect directly to a database. You will need to use aserver-side technology and communicate with it using:Http service, Web service, Flex Data Service, etc. - just check out thetutorials on the adobe site and all over the web.Paulwww.ipauland.com __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
RE: [flexcoders] Flex - Database
If this functionality is the same as the SQLXML functionality I played with a year or so ago, SQL Server provides an url against which you can make SQL queries. No other server-side code is requiered. Obviously it is not direct, but it appears so. I had a lot of problems with it at the time and gave up, but if they got it working then it will be a very effective answer to how do I query a database with Flex? Tracy From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Paul Andrews Sent: Thursday, September 14, 2006 9:58 AM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Flex - Database - Original Message - From: Rogerio Gonzalez To: [EMAIL PROTECTED]ups.com Sent: Thursday, September 14, 2006 2:00 PM Subject: Re: [flexcoders] Flex - Database You can connect direct to database with webservices in SQL2005 (end points) Rogerio How does this differ from webservices in general? What make it Direct? I think the OP really wants to talk directly to a database and squirt SQL at it inside Flex. Paul On 9/14/06, Paul Andrews [EMAIL PROTECTED]com wrote: - Original Message - From: Sudharshan Rao [EMAIL PROTECTED]com To: [EMAIL PROTECTED]ups.com Sent: Thursday, September 14, 2006 8:46 AM Subject: [flexcoders] Flex - Database Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance. Flex doesn't connect directly to a database. You will need to use a server-side technology and communicate with it using: Http service, Web service, Flex Data Service, etc. - just check out the tutorials on the adobe site and all over the web. Paul www.ipauland.com __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
Re: [flexcoders] Flex - Database
Hi Tracy and others... I had a lot of problems with it at the time and gave up, but if they got it working then it will be a very effective answer to "how do I query a database with Flex?"I have troubles with that in past too (Flash + SQL + IIS) with security issues. This time, the MS seems to improve some things on SQL2005 for webservices and such (xml too).I am testing some things with that, when it´s done I post here. But seems nice :PLike you say, it´s not direct, but is pretty more likely then use PHP or ASP or what ever just to do an Query. Rogerio __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
Re: [flexcoders] Flex - Database
Sudharshan, I concur with Paul's intial post. Database driven Flex applications are generally at least a 3-tier architecture. 1) UI = Flex; 2) Database = ?; 3) Middle tier (aka application server) = ?. Generally the middle tier is an http server. However, in the case of mx:RemoteObjects it is an AMF server. The SQL2005 issues raised by Tracy and Roger are a case where the database now bundles in http services. For a very broad view of how to get data into Flex, following is a link for a Jeff Tapper article that does a good job comparing and contrasting the options (note: the article is from the Flash era but is still relevant to Flex 2): http://www.devx.com/webdev/Article/21803/0/page/1 Adobe has made the ColdFusion application server very Flex friendly. You can find videos demonstrating some Flex Builder 2 wizards for creating ColdFusion/Flex 2 applications using mx:RemoteObject here: http://www.adobe.com/devnet/coldfusion/articles/wizards.html Flex 2 certainly integrates well with other application servers too. Flex 2 is certainly very Java friendly, and there is an active PHP project AMFPHP for that application server. hth, gOn 9/14/06, Paul Andrews [EMAIL PROTECTED] wrote: - Original Message -From: Sudharshan Rao [EMAIL PROTECTED]To: flexcoders@yahoogroups.com Sent: Thursday, September 14, 2006 8:46 AMSubject: [flexcoders] Flex - Database Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance.Flex doesn't connect directly to a database. You will need to use aserver-side technology and communicate with it using:Http service, Web service, Flex Data Service, etc. - just check out the tutorials on the adobe site and all over the web.Paulwww.ipauland.com __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
Re: [flexcoders] Flex - Database
In relation to Apollo, it has been mentioned it will be possible to write database drivers in AS3... might it not be possible then to do it for Flex as well? Just curious... it may well be a part of the Apollo API that allows that, but perhaps worth considering. On 9/14/06, greg h [EMAIL PROTECTED] wrote: Sudharshan, I concur with Paul's intial post. Database driven Flex applications are generally at least a 3-tier architecture. 1) UI = Flex; 2) Database = ?; 3) Middle tier (aka application server) = ?. Generally the middle tier is an http server. However, in the case of mx:RemoteObjects it is an AMF server. The SQL2005 issues raised by Tracy and Roger are a case where the database now bundles in http services. For a very broad view of how to get data into Flex, following is a link for a Jeff Tapper article that does a good job comparing and contrasting the options (note: the article is from the Flash era but is still relevant to Flex 2): http://www.devx.com/webdev/Article/21803/0/page/1 Adobe has made the ColdFusion application server very Flex friendly. You can find videos demonstrating some Flex Builder 2 wizards for creating ColdFusion/Flex 2 applications using mx:RemoteObject here: http://www.adobe.com/devnet/coldfusion/articles/wizards.html Flex 2 certainly integrates well with other application servers too. Flex 2 is certainly very Java friendly, and there is an active PHP project AMFPHP for that application server. hth, gOn 9/14/06, Paul Andrews [EMAIL PROTECTED] wrote: - Original Message -From: Sudharshan Rao [EMAIL PROTECTED]To: flexcoders@yahoogroups.com Sent: Thursday, September 14, 2006 8:46 AMSubject: [flexcoders] Flex - Database Hi, I am new to flex, Can somebody please help me in how to connect to database through flex. Thanks in advance.Flex doesn't connect directly to a database. You will need to use aserver-side technology and communicate with it using:Http service, Web service, Flex Data Service, etc. - just check out the tutorials on the adobe site and all over the web.Paulwww.ipauland.com __._,_.___ -- 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 Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___
