OK I found the problem. First I am the author of this code. I am just the one trying to clean up after this guy. There are two databases nic-dev and nic-prod. They are identical. All the tables have the same names. There was also an alias created for both data sources. nic-dev = dataMain and nic-prod = dataMain2. The query was hitting the wrong database. In the DEV db the data is stale. I wrongly assumed the query was hitting the PROD db. I placed a cfabort after the query ran and there it was. I saw that the query was using the DEV db.
The guy who worked on this website spent the last four years working on this site. I have a lot of cleaning to do. Thanks for all the help I learned a lot in the last few days. > Hello all > Thanks in advance for the help. I have a query that returns nothing > when there is data in the database. Here is the query > > <CFQUERY datasource ="#dataMain#" name ="pnpocData"> > SELECT DISTINCT emp_Fname, emp_Lname, office_telephone, > standard_e_mail_addr > from vw_Employee_data > where emp_no = "#getLocInfo.pnpocempno#" > </CFQUERY> > > I have used CFDUMP to verify that the employee number is correct in > the where condition of the query. I even used CFABORT to stop and view > the query. I then copied the query after interpolation into TOAD and > ran the query as is. Worked fine > > When i use CFDUMP after the query runs pnpocData is empty. > > Any ideas? > > > Sam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-newbie/message.cfm/messageid:4370 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
