Thanks but where are the tutorials on how to do this in CF7, they all seem to be geared toward CF8 onwards.
I am willing to learn, however time is not on my side as there is a lot of pressure to migrate to .NET -----Original Message----- From: jqdur...@gmail.com [mailto:jqdur...@gmail.com] Sent: 11 March 2011 18:30 To: cf-talk Subject: Re: RE: Database Lookup - Possible with CF? It's very easy to do in CF7. However, it appears you don't have the knowledge or desire to learn. You have to possess one. On Mar 11, 2011 8:22am, Ian Vaughan <i.vaug...@neath-porttalbot.gov.uk> wrote: > Thanks all for your help, I was just investigating if it could be done > with CF7, but it is looking like a long winded process to get anywhere > with it. > If you had CF8+ it is easier because of the new tags but it's looking as > though I need to go down the OO route via /NET webforms or MVC2 which > will be a similar learning curve as trying to get it done in CF7 but > would give better long term prospects > -----Original Message----- > From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] > Sent: 11 March 2011 14:06 > To: cf-talk > Subject: RE: Database Lookup - Possible with CF? > Ian, > Now you are sort of asking for us to define your functional spec. Getting > your data from a web service is a completely new discussion. Yes it's > possible with CF 7 - but what sort of web server? What are the methods? > What > get's returned? There could be dozens of answers to this question. It is > simply too broad. Investigate web services using WSDL - or possibly your > web > service is a REST type interface, where the data is returned from a POST > request as XML and you parse through it. Either way there's a whole slew > of > possibilities, obstacles and challenges that come with this part of your > process. If you want help start experimenting and give us specific > examples > of errors or hurdles you are trying to overcome. > -Mark > -----Original Message----- > From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] > Sent: Friday, March 11, 2011 4:02 AM > To: cf-talk > Subject: RE: Database Lookup - Possible with CF? > Thanks all. > The data is going to coming from a web service not a database, what steps > in > CF7 do I need to follow to consume an external web service and populate > the > form fields accordingly based on employeeid - is it the same process as > below? > -----Original Message----- > From: Dean Lawrence [mailto:dean...@gmail.com] > Sent: 10 March 2011 15:04 > To: cf-talk > Subject: Re: Database Lookup - Possible with CF? > Ian, > I think your a little confused about a couple of things. First off, > AJAX really has no direct relationship with ColdFusion. AJAX runs on > the client side and ColdFusion runs on the server side. AJAX simply > allows your browser to make additional HTTP requests via JavaScript > instead of having to leave the initial page request. Those additional > HTTP requests could be to a ColdFusion page (.cfc or .cfm), to an > Asp.Net page, or to a .php page, it doesn't really matter. You can > read about how to make an AJAX call using jQuery at > http://api.jquery.com/category/ajax/ > When you make the AJAX call to a processing page (in this case your > CFC), you will want to return JSON data so that jQuery can then use it > to populate your form fields. Once the data has been returned to > jQuery, the server is out of the picture, you will be using jQuery to > then use the data to populate the fields, not ColdFusion (or any other > server side language for that matter). Here is a simple example of how > to step through the returned JSON data to populate a form > rm-fields-more-efficient-approach" > target="_blank">http://stackoverflow.com/questions/635565/walk-json-resp onse-and-populate-fo > rm-fields-more-efficient-approach. > You will notice that in this thread, they are using .php to return the > JSON data. > Back to your CFC. When you make the AJAX call to your CFC, you will > want to return JSON data to jQuery. CF 7 doesn't have any built-in > functions to do this. However, here are two different projects that > you can use to convert the query data. > http://www.epiphantastic.com/cfjson/index.php > http://jsonutil.riaforge.org/ > Both of these project will convert native ColdFusion objects into JSON > data, so you could pass them a query, structure, or array and they > will do the conversion. So in your CFC, you would then return the > converted string, not the original query object. > Hopefully, this clears things up for you and will get you on the right > path. > Dean > On Thu, Mar 10, 2011 at 4:51 AM, Ian Vaughan > i.vaug...@neath-porttalbot.gov.uk> wrote: > > > > Hi Steve > > > > So my CFC would be like this? > > > > > > getting Employee ID"> > > > > > > > > database" returntype="query"> > > > > select * from employees > > where > > form.empid = getEmp.empid > > > > > > > > > > > > How would I then use a AJAX/Json call to populate the remaining form > > fields from the query in the above CFC? And how does AJAX call the CFC > > on Coldfusion 7? > > > -- > ------------------------------------------------------------------------ --- > Dean M. Lawrence > INTERNET DATA TECHNOLOGY > p // 888.438.4381 ext. 701 > w // www.idatatech.com > f // www.facebook.com/idatatech > t // www.twitter.com/idatatech > Social Marketing | SEO | Design | Inter > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
