Re: [flexcoders] is there a sample to update/delete records in a database server through webservice?
Steven, I know you had first posted on this 10 days ago, but it just came to my attention that Flex with .NET and Web Services is covered in the following online training: Flex 2 Beyond the Basics with: David Gassner http://movielibrary.lynda.com/html/modPage.asp?ID=290 11. Working with .NET If you do not already have an account with Lynda.com, you can get a 1 day free pass here: http://www.lynda.com/freepass/24 It looks like the training at the link above only cover retrieving data, but once you have that all working extending it to do insert, update and delete should be fairly straight forward. Please post back and let us know if you have your Flex/.NET/database configuration working. hth, g On 12/6/06, greg h [EMAIL PROTECTED] wrote: Steven, As Tracy has posted, Flex w/ .NET w/ SQL Server works. You asked for a sample app. I do not know of one where the back end logic is a web service in .NET, but I will check around. I will post back if I find one. On the other hand, if you can point us to a sample .NET webservice that includes update/delete, maybe we can throw together in Flex the MXML and AS to reference it. hth, g On 12/5/06, Steven Xu [EMAIL PROTECTED] wrote: Hi Greg, Thanks for the quick reply. I think webservice should be cross-platform. My back end at this time is .NET SQL 2005 server. Any sample for update database in MS SQL 2005 server? Thank you again, Steve
Re: [flexcoders] is there a sample to update/delete records in a database server through webservice?
Steven, As Tracy has posted, Flex w/ .NET w/ SQL Server works. You asked for a sample app. I do not know of one where the back end logic is a web service in .NET, but I will check around. I will post back if I find one. On the other hand, if you can point us to a sample .NET webservice that includes update/delete, maybe we can throw together in Flex the MXML and AS to reference it. hth, g On 12/5/06, Steven Xu [EMAIL PROTECTED] wrote: Hi Greg, Thanks for the quick reply. I think webservice should be cross-platform. My back end at this time is .NET SQL 2005 server. Any sample for update database in MS SQL 2005 server? Thank you again, Steve
[flexcoders] is there a sample to update/delete records in a database server through webservice?
Hi Folks, There are many samples showing how to get/download the records/XML from a webservice , however none of them talking about how to change the server data while user modify the Datagrid / List in the flash application through webservice. Is the webservice way to update server data is too slow, more complex, hardly implement? I am new to flex. Flex application does so exciting interface, but how can I get my data saved in server database through webservice. Thanks for guiding me to the right direction, any sample will be appreciated. Steve Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.
RE: [flexcoders] is there a sample to update/delete records in a database server through webservice?
The way to get data into the server is the same as the way to get it out: Call a web service operation/method and pass the data to it. How that is handled on the server depends on the implementation of the web service. It is easy to sample get data from a server, but to have an example of saving data on a server, you would need to own the server. Tracy From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steven Xu Sent: Tuesday, December 05, 2006 4:51 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] is there a sample to update/delete records in a database server through webservice? Hi Folks, There are many samples showing how to get/download the records/XML from a webservice , however none of them talking about how to change the server data while user modify the Datagrid / List in the flash application through webservice. Is the webservice way to update server data is too slow, more complex, hardly implement? I am new to flex. Flex application does so exciting interface, but how can I get my data saved in server database through webservice. Thanks for guiding me to the right direction, any sample will be appreciated. Steve Have a burning question? Go to Yahoo! Answers http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMz OTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx and get answers from real people who know.
Re: [flexcoders] is there a sample to update/delete records in a database server through webservice?
Steven, Could you let us know what you use on your back end? e.g. Java, ColdFusion, PHP, .NET, etc? And also what database you use? If we know what you use for backend logic we can better suggest samples that include update/delete logic. btw ... for ColdFusion, Flex Builder 2 includes wizards that can read your SQL database's schema and automatically generate the necessary Flex and ColdFusion code to the SQL DML (Data Modification Language, i.e. INSERT, UPDATE and DELETE). btw #2 ... as Tracy suggested, there is no problem doing update or delete through a webservice. Personally, I prefer mx:RemoteObject, but mx:WebService should work just as good. Best regards, g On 12/5/06, Steven Xu [EMAIL PROTECTED] wrote: Hi Folks, There are many samples showing how to get/download the records/XML from a webservice , however none of them talking about how to change the server data while user modify the Datagrid / List in the flash application through webservice. Is the webservice way to update server data is too slow, more complex, hardly implement? I am new to flex. Flex application does so exciting interface, but how can I get my data saved in server database through webservice. Thanks for guiding me to the right direction, any sample will be appreciated. Steve --
RE: [flexcoders] is there a sample to update/delete records in a database server through webservice?
And, if you are using the term web service in the generic way, consider HTTPService instead of SOAP-based WebService. Tracy From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of greg h Sent: Tuesday, December 05, 2006 6:32 PM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] is there a sample to update/delete records in a database server through webservice? Steven, Could you let us know what you use on your back end? e.g. Java, ColdFusion, PHP, .NET, etc? And also what database you use? If we know what you use for backend logic we can better suggest samples that include update/delete logic. btw ... for ColdFusion, Flex Builder 2 includes wizards that can read your SQL database's schema and automatically generate the necessary Flex and ColdFusion code to the SQL DML (Data Modification Language, i.e. INSERT, UPDATE and DELETE). btw #2 ... as Tracy suggested, there is no problem doing update or delete through a webservice. Personally, I prefer mx:RemoteObject, but mx:WebService should work just as good. Best regards, g On 12/5/06, Steven Xu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Folks, There are many samples showing how to get/download the records/XML from a webservice , however none of them talking about how to change the server data while user modify the Datagrid / List in the flash application through webservice. Is the webservice way to update server data is too slow, more complex, hardly implement? I am new to flex. Flex application does so exciting interface, but how can I get my data saved in server database through webservice. Thanks for guiding me to the right direction, any sample will be appreciated. Steve
Re: [flexcoders] is there a sample to update/delete records in a database server through webservice?
Hi Greg, Thanks for the quick reply. I think webservice should be cross-platform. My back end at this time is .NET SQL 2005 server. Any sample for update database in MS SQL 2005 server? Thank you again, Steve - Original Message From: greg h [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Tuesday, December 5, 2006 3:31:34 PM Subject: Re: [flexcoders] is there a sample to update/delete records in a database server through webservice? Steven, Could you let us know what you use on your back end? e.g. Java, ColdFusion, PHP, .NET, etc? And also what database you use? If we know what you use for backend logic we can better suggest samples that include update/delete logic. btw ... for ColdFusion, Flex Builder 2 includes wizards that can read your SQL database's schema and automatically generate the necessary Flex and ColdFusion code to the SQL DML (Data Modification Language, i.e. INSERT, UPDATE and DELETE). btw #2 ... as Tracy suggested, there is no problem doing update or delete through a webservice. Personally, I prefer mx:RemoteObject, but mx:WebService should work just as good. Best regards, g On 12/5/06, Steven Xu [EMAIL PROTECTED] com wrote: Hi Folks, There are many samples showing how to get/download the records/XML from a webservice , however none of them talking about how to change the server data while user modify the Datagrid / List in the flash application through webservice. Is the webservice way to update server data is too slow, more complex, hardly implement? I am new to flex. Flex application does so exciting interface, but how can I get my data saved in server database through webservice. Thanks for guiding me to the right direction, any sample will be appreciated. Steve !-- #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family:Arial; clear:both; } #ygrp-vitnav{ padding-top:10px; font-family:Verdana; font-size:77%; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space:nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana; font-size:77%; padding:15px 0; } #ygrp-ft{ font-family:verdana; font-size:77%; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px; } #ygrp-vital{ background-color:#e0ecee; margin-bottom:20px; padding:2px 0 8px 8px; } #ygrp-vital #vithd{ font-size:77%; font-family:Verdana; font-weight:bold; color:#333; text-transform:uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type:none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right:.5em; } #ygrp-vital ul li .cat{ font-weight:bold; } #ygrp-vital a { text-decoration:none; } #ygrp-vital a:hover{ text-decoration:underline; } #ygrp-sponsor #hd{ color:#999; font-size:77%; } #ygrp-sponsor #ov{ padding:6px 13px; background-color:#e0ecee; margin-bottom:20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type:square; padding:6px 0; font-size:77%; } #ygrp-sponsor #ov li a{ text-decoration:none; font-size:130%; } #ygrp-sponsor #nc { background-color:#eee; margin-bottom:20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family:Arial; font-weight:bold; color:#628c2a; font-size:100%; line-height:122%; } #ygrp-sponsor .ad a{ text-decoration:none; } #ygrp-sponsor .ad a:hover{ text-decoration:underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0;} .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120%; } blockquote{margin:0 0 0 4px;} .replbq {margin:4;} -- Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.
RE: [flexcoders] is there a sample to update/delete records in a database server through webservice?
HTTPService is cross platform as well and is easier to work with than SOAP-based WebService. And theoretically faster, since SOAP adds to the payload. I am using Flex to update SQL Server 2003 via HTTPService and ASP.NET 1.1 and ADO.NET very successfully. If you do not plan to publish your service to third party consumers, you really do not need the overhead of SOAP. I have used all three methods of creating the update query I mentioned in my previous post. Building dynamic sql on the client and a passthrough on the server is easiest, but keep in mind the security issue. Tracy From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steven Xu Sent: Tuesday, December 05, 2006 7:05 PM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] is there a sample to update/delete records in a database server through webservice? Hi Greg, Thanks for the quick reply. I think webservice should be cross-platform. My back end at this time is .NET SQL 2005 server. Any sample for update database in MS SQL 2005 server? Thank you again, Steve - Original Message From: greg h [EMAIL PROTECTED] To: flexcoders@yahoogroups.com Sent: Tuesday, December 5, 2006 3:31:34 PM Subject: Re: [flexcoders] is there a sample to update/delete records in a database server through webservice? Steven, Could you let us know what you use on your back end? e.g. Java, ColdFusion, PHP, .NET, etc? And also what database you use? If we know what you use for backend logic we can better suggest samples that include update/delete logic. btw ... for ColdFusion, Flex Builder 2 includes wizards that can read your SQL database's schema and automatically generate the necessary Flex and ColdFusion code to the SQL DML (Data Modification Language, i.e. INSERT, UPDATE and DELETE). btw #2 ... as Tracy suggested, there is no problem doing update or delete through a webservice. Personally, I prefer mx:RemoteObject, but mx:WebService should work just as good. Best regards, g On 12/5/06, Steven Xu [EMAIL PROTECTED] com mailto:[EMAIL PROTECTED] wrote: Hi Folks, There are many samples showing how to get/download the records/XML from a webservice , however none of them talking about how to change the server data while user modify the Datagrid / List in the flash application through webservice. Is the webservice way to update server data is too slow, more complex, hardly implement? I am new to flex. Flex application does so exciting interface, but how can I get my data saved in server database through webservice. Thanks for guiding me to the right direction, any sample will be appreciated. Steve Everyone is raving about the all-new Yahoo! Mail beta. http://us.rd.yahoo.com/evt=42297/*http:/advision.webevents.yahoo.com/ma ilbeta