I am using 4Dv11SQL Server as my ODBC source and I am trying to get JDBC-ODBC bridge working. I have tried 3 different bridges: Sun, Sequelink and Easysoft. I seem to be the closest with Easysoft but I have one last hurdle.
Using the EasySoft JAVA test applet, I am able to retrieve data from my 4Dv11SQL database. I do notice that each field returned has an extra character at the end. When I perform a cfquery in ColdFusion... <cfquery name="test" datasource="v11"> Select MyField1 From MyTable1 </cfquery> and I try to cfoutput the column data,... <cfoutput query="test"> #MyField1# </cfoutput> I get a ColdFusion error "Element MyField1" is not recognized. Note: A cfdump is successful. When I cfoutput just the column name, the extra character is present. The extra character is chr(65533) which from what I can tell is a replacement character so I assume I do not know what the real character is. Any suggestions... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
