Thanks so it's just as easy/difficult to achieve this with a modern language such as ASP.net (web forms or MVC2) over Coldfusion which some are saying is reaching it's end of life, as there seems to be a steep learning curve for both.
So would I be better developing this application in a language that is more scaleable/future proof than CF Do you know of any weblinks for this " You would use the success handler of your ajax call to populate the form. This will take some further research on your part." -----Original Message----- From: Steve 'Cutter' Blades [mailto:[email protected]] Sent: 02 March 2011 16:01 To: cf-talk Subject: Re: Database Lookup - Possible with CF? Here is a brief tutorial on writing a CFC (Google is your friend) http://www.learn-coldfusion-tutorial.com/ColdFusion-Components.cfm You would put your query in a method in the CFC. You would use the success handler of your ajax call to populate the form. This will take some further research on your part. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer ____________ http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-deskto p-style-user-interfaces/book "The best way to predict the future is to help create it" On 3/2/2011 9:30 AM, Ian Vaughan wrote: > Hi Craig et al > > Thanks for this > > So download JQuery and link to the file on your server > > Does it have to be a CFC? Its just that I have never used them before - > where would your SQL go in the CFC and would it be the same as a cfm > page > > i.e. > <cfquery> select * from emptable where employeenumber = > #form.employeenumber#</cfquery> > > > Then after you have queried the database - how would you populate the > form fields on the fly with the data you extracted from the database > based on what employee number had been entered > > For example I take it that > <cfinput type="text" id="empname" name="empname" > value="#queryperson.empname#" ..... > > > Would not work? > > > -----Original Message----- > From: Craig Rosenblum [mailto:[email protected]] > Sent: 02 March 2011 14:50 > To: cf-talk > Subject: Re: Database Lookup - Possible with CF? > > > Basically the easiest way to do ajax, is the following... > > 1. download jquery libraries, or in your source code refer to different > hosting of the jquery libraries. jquery fyi, is javascript libraries, > that work cross-browser and make it easier to do things like ajax, and > millions of other things. > > 2. Read this and any other article, > http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-ca > lls-with-jquery/ to get a handle on how to use jquery. > > 3. create a cfc, that can send/receive data you want. > > Yes this is a lot to learn, if you've never played with ajax or jquery > before. So I will show you some example code. > > You can either download a copy of the jquery libraries, or refer to a > cdn hosted copy on google or jquery.com, or a few other sites hosting > jquery libraries for public use. > > Then you need to create a cfc, which is basically like a coldfusion > normal template, except it has functions, instead of normal page logic. > > A cfc will be like this structure > > cfcomponent > > cffunction name="somename" access="remote" output="true" > cfargument name=company_id type=integer required=true > > do some stuff > > /cffunction > > /cfcomponent ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
