Hi - I'm trying to insert an image into a SQL 7.0 database. I understand the general concensus is to insert a pointer (filename or otherwise) and keep the image on the file system. Unfortunately, the image isn't part of the web application, but is being forced by vendor designed software. It's an ID card system. With that said, it's not a ColdFusion question per se, but I'm hoping a database guru might be willing to help. The database already exists and is populated, but missing several records from an older system which for now are loose jpg files and text data. I'm trying to add new records with the correct image. SQL/ODBC is useless for manipulating blobs, correct? I understand that there is no support for blobs, but beyond that there is a 64k limit on query strings. What does that leave? bcp? t-sql? ado? The new image filename contains the id of the image. It needs to be parsed and inserted as a text field into the database. This seems to make ado the most viable option. I think I can wade through the details. I'm hoping someone can verify that this is the most direct way to get the new records inserted. Thanks, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
