Short version: On a hosted server, when I run a query the GUIDs are returned in as binary when it should be a string. This does not happen on my local test box or at the office.
How is this possible? Where do I go from here? Example: This should be a GUID! -61879846-93-127-1078-106-23-5869-88-92-1272400000000000000000000 Long version: I have written an app (free, project for a friend) with CFMX 6 / MSSQL 2000, uploaded it to my friends hosting company. They have CFMX and SQL but they don't provide any type of database upload. All I get to work with is a web interface, some asp MSSQL Web manager. I’m not about to sit here and recreate the entire db. So, I created a SQL Script and placed it in a <cfquery> block to create the table structure and that worked. Next I wrote a quick page to dump all the local data that I have to the screen in the form of an insert statement, one for every record in my local db. Copied that output and put it in a <cfquery> block, upload, run. It seemed to work just fine. I login to the hosting account, view the data via the MSSQL SQL Web management screen, the tables are there, the data is there, sweet, should be good to go. This is where it gets wonkie. I launch the site on the host. Error. It appears to be a GUID issue. That’s weird, the data was there. So, I do a <cfdump> on the query. Normally every record in the query is represented as a string, right? Yeah, normally. This time the GUID is returned as binary data inside the cfquery dump. How is this possible? Where do I go from here? Example: This should be a GUID! -61879846-93-127-1078-106-23-5869-88-92-1272400000000000000000000 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
