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 -----Original Message----- From: Azadi Saryev [mailto:[email protected]] Sent: 02 March 2011 10:24 To: cf-talk Subject: Re: Database Lookup - Possible with CF? 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: > Hi > > I have created a web form, but what I would like it to do (and I'm not > sure if this is possible with Coldfusion?) is when a user enters their > employee number into a text field without a page refresh it runs a > database lookup and populates other fields in the form with that > employees information (name, address etc) > > Is this possible and is anybody willing to share any code snippets on > how to do this. > > I am getting pushed toward ASP.net for this but I am trying to fight 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:342667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
