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:crosenb...@gmail.com] 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 That's a very basic cfc, must be saved as a cfc extension. The 1st key part is making the cfc file in a web-accessible url folder. Then you have to create ajax that will send the parameters it needs to do whatever functioning you need to do. I hope this get's you a good starting point.... >Hi > >We are on CF7, not sure if this restricts the amount of functionality >available to me? > >So how would it work - when a user types in their employee number in the >text field how would ajax call a SQL query to lookup the data in the db >table to populate the rest of the fields in the form. > >Do you have any code examples, as I am struggling to grasp how to >implement this at the moment? > >Many Thanks > >It is definitely possible and rather easy using CF (or just plain >javascript) - all you need to do is make an ajax request to a cfc/cfm on > >your server passing entered employee number as data/argument, which will > >return necessary data based on emp number. You then populate necessary >fields with returned data. >CF's built-in ajax functionality will come in handy here (i.e. cfinput >fields with bind attribute pointing to your cfc method), but not >required - same is easily achieved with a regular js ajax request; >jQuery will even make it fun. >If you are not very familiar with javascript, and you are running CF8+, >then use the built-in cf functionality. All you need is well described >in CF Developer's Guide (download pdf from adobe.com) and numerous >blogs. > >Azadi > >On 02/03/2011 17:37 , Ian Vaughan wrote: >the >> corner of Coldfusion - so if I can deliver this app in Coldfusion it >> would certainly help it's case so it would still be a viable >development >> option here. >> >> Many Thanks >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
