Thanks Dave. We are using the JDBC drivers. Turns out the issue was the data type of the TransactionDate field. I had used a smalldatetime and changed it to datetime. Now the page displays fine. Thanks for the help! nicki
>> 2, H,mH,mþââ¬Å þââ¬Å, ââ¬ÃËââ¬ÅPÃËââ¬Å, >> xmÃ?à ¾m >> [01000][ODBC Socket][Microsoft][ODBC SQL Server >> Driver][SQL Server]Changed language setting to us_english. >> Ã?ÃËÃ?ñE [01000][ODBC Socket][Microsoft][ODBC SQL >> Server Driver][SQL Server]Changed database context to >> 'ITLogger'., ôÃȉâ¬ÅøÃȉâ¬ÅüÃȉâ¬Åüââ¬Å, >> xmÃ?à ¾m >> , itcrew > >You might try using the JDBC drivers instead. In almost all cases, you >should use JDBC if it's available. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! > >This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4