The query looks good to me. Run SQL Server Profiler to see what SQL Server is trying to execute, since the command sent to SQL Server isn't the same as what you see in the source code.
Is this the only query in the site with a problem? Maybe verify that the stockton datasource points to the correct database in CFAdmin, instead of possibly an empty test database. Maybe that hard-coded data source name isn't correct. Good luck, Mike Chabot On Wed, Jun 24, 2009 at 7:56 PM, Aaron Roberson<aaronarober...@gmail.com> wrote: > > Hey Jason. > > Here is the url to the page I am working with: > > http://www.fws.gov/stockton/afrp/alldocs.cfm > > The SQL in cfdump looks the same > > On Wed, Jun 24, 2009 at 4:42 PM, Jason Fisher <ja...@wanax.com> wrote: > >> >> What do you see if you dump? >> >> <cfdump var="#rs#" /> >> >> The metadata should at least confirm the SQL that's getting passed >> through. SQL Server certainly doesn't care about CF, it's just serving >> the request of the JDBC driver. >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
