Hi All, I have an issue and I am out of my mind...... to solve it.
FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. I thought of using arrays but I dont know how to add database date to the array and compare. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Can anyone help me with this? Thanks in Advance... Priya ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

