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-response-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:342925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm