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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Xu Sent: Tuesday, December 05, 2006 7:05 PM To: [email protected] 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: [email protected] 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>
