It seems that your destination field is expecting an INT. But, if you are using Excel as the destination, it shouldn't matter.
Then, maybe it has to do with your concatenation. You may need to CAST/CONVERT your productID to a char value before you concatenate it to the URL. Something like: SELECT 'http://www.domain.com/page.cfm?id=' + CAST(productID AS char(10)) AS myURL FROM TableName This will get the productID to work as a character value. It is possible that SQL Server was trying to "add" the URL to your product ID rather than just append the product ID to the URL. M!ke -----Original Message----- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 1:45 PM To: CF-Talk Subject: Re: CF5 / SQL 2000 Export to Excel Yes, the productid should be part of a standard URL. I'm using SQL 2000 and getting an error message saying it can't convert the var of the URL to an int. Any pointers? Thank you! ~ Donna >Do you mean the productid should be part of a standard URL? If so: > >SELECT 'http://www.domain.com/page.cfm?id=' + id AS myURL FROM >TableName > >Depending on your database, you may need a different operator, other >than the plus (+) sign. Some DBs use pipes (|), some use functions >(Concat()). > >M!ke > >-----Original Message----- >From: Donna French [mailto:[EMAIL PROTECTED] >Sent: Friday, November 25, 2005 2:22 PM >To: CF-Talk >Subject: CF5 / SQL 2000 Export to Excel > >I have exported the data that I need using the SQL export tool but what >I am trying to accomplish is an Excel file for Froogle & I need one >field as a URL. Is there a way to have SQL or CF version 5 - or >combination of both - export my productid field as a URL instead of >just the productid alone? Any help or suggestions would be appreciated. > >TIA, > >-- >Donna French >[EMAIL PROTECTED] >http://dgfrench.blogspot.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:225271 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
