I guess my thought was that I didn't want to deal with a php array. I don't have so much php experience so I was hoping to just output (or echo) that one variable that would be returned all formatted into HTML for presentation on the page. This would allow me to do pretty much all the work with CF. Does that make any sense?
The main reason I am thinking this way is because I feel comfortable coding with CF but not so comfortable with PHP and it is something I don't want to spend very much time on. Dusty On Thu, Apr 16, 2009 at 6:01 PM, John Mason <ma...@fusionlink.com> wrote: > You're adding a lot more work to this than is necessary. Just call the cfc > method (which will return a standard query) like so.. > > url_to_cfc/yourcfc.cfc?methodname=yourmethod&returnFormat=json > > This should provide you with a proper json string. Then on the php side use > json_decode() to decode the string into a php array. You should be good too > go with that and it'll take a lot less work. > > John > ma...@fusionlink.com > > > Dusty Hale wrote: > >> Hi thank you Allen, John, and Brooks for the responses. I was actually >> planning on keeping the query result in the cfc and formatting the results >> in HTML table rows and pushing that into a <cfsavecontent >> variable="myresults"> and then sending that returning that variable to the >> web service. So in PHP I was hoping to just spit out that variable somehow >> to display the results in the HTML table rows. >> >> Does that sound like it would work? Can anyone see any problems with doing >> it this way. Security is not too much of an issue here it is just some >> categories of sponsor information. >> >> Muchos Gracias, >> >> Dusty >> >> On Thu, Apr 16, 2009 at 10:36 AM, <ma...@fusionlink.com <mailto: >> ma...@fusionlink.com>> wrote: >> >> You can simply specify the return type as either wddx or json. PHP >> has (or at least had) a wddx reader. And json is common now, so I >> suspect php has functions for that as well. If you do specify the >> return type, do it in the url not on the attribute of the >> cffunction. It keeps your web service agnostic so to speak. >> >> John >> ma...@fusionlink.com <mailto:ma...@fusionlink.com> >> >> >> ----- Original Message ----- >> From: brooks.wil...@atl.frb.org <mailto:brooks.wil...@atl.frb.org> >> [mailto:brooks.wil...@atl.frb.org <mailto:brooks.wil...@atl.frb.org>] >> To: discussion@acfug.org <mailto:discussion@acfug.org> >> Sent: Thu, 16 Apr 2009 08:01:21 -0400 >> Subject: Re: [ACFUG Discuss] creating a web service with cf >> >> sure - but you need to decide on a data format. does php support >> cf query >> type? i doubt it - you will likely need to change the query to an >> array. >> >> >> >> >> Dusty Hale <du...@dustyhale.com <mailto:du...@dustyhale.com>> >> Sent by: ad...@acfug.org <mailto:ad...@acfug.org> >> 04/16/2009 01:02 AM >> Please respond to >> discussion@acfug.org <mailto:discussion@acfug.org> >> >> >> To >> discussion@acfug.org <mailto:discussion@acfug.org> >> >> cc >> >> Subject >> [ACFUG Discuss] creating a web service with cf >> >> >> >> >> >> >> I have a need which I think would be a good fit to create a web >> service >> but since I have never developed a web service I thought to get >> some other >> opinions. >> >> I have a site which is hosted on a Linux box with php and no CF. I >> need >> for part of this site to use a database and make a little admin app to >> manage it. Well I am lazy and don't want to do this with PHP and MySQL >> mainly because I know CF and SQL so I just want to do this with >> what I am >> used to. So my thought was that I could create a CFC that would >> act as a >> web service that the PHP site could call remotely. All it needs to >> do is >> get some data from the SQL server and display it in HTML. So I >> though I >> could generate the result HTML in the CFC and the PHP site could >> call it >> remotely. Again the PHP site is not on the same server as the CFC >> so it >> would be a remote call. >> >> This is basically what a web service is for right? Would this approach >> work? >> >> Thanks so much in advance for any replies. >> >> Dusty >> >> >> >> ------------------------------------------------------------- >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists >> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> ------------------------------------------------------------- >> >> >> >> >> ------------------------------------------------------------- >> >> To unsubscribe from this list, manage your profile @ >> >> http://www.acfug.org?fa=login.edituserform >> >> >> >> For more info, see http://www.acfug.org/mailinglists >> >> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >> >> List hosted by http://www.fusionlink.com >> >> ------------------------------------------------------------- >> >> >> >> >> >> -- >> Dusty Hale >> Email: du...@dustyhale.com >> Phone (Atlanta): 404.474.3754 >> Phone (Toll Free USA): 877.841.3370 >> Website: www.DustyHale.com <http://www.DustyHale.com> >> > > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > > -- Dusty Hale Email: du...@dustyhale.com Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
