As far as inserting images into a database, there are two custom tags
that will insert images as blobs: cfx_putimage and cfx_getimage. You can
find them in the tag gallery.
Mark
-----Original Message-----
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 7:25 PM
To: CF-Server
Subject: OT: inserting blobs into SQL 7.0
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
