Re: CF8 MS SQL Server Query Problems
I'm with Mike on this one. The query is fine, as you know from running it on the DB server itself. CF does nothing more than pass through the query to the JDBC driver, but that query will present no difficulties. The only thing left that I can think of is that the datasource in CFAdmin isn't pointing to the right server and/or DB or something. Or maybe the user profile in the datasource config has no rights to see records in that table ... ~| 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:323925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 MS SQL Server Query Problems
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:323911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 MS SQL Server Query Problems
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:323912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 MS SQL Server Query Problems
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 Robersonaaronarober...@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
