Thanks Mark.
> -----Original Message-----
> From: Mark Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 7:08 AM
> To: CF-Server
> Subject: RE: inserting blobs into SQL 7.0
>
>
> 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,
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
