RE: FN-FORUM: urgent Acccess problem

date posted 27th January 2007 17:40

[EMAIL REMOVED] wrote:
> I am getting
>
> Type mismatch
>
> on this statement
>
> rs.Open "SELECT Id FROM Product_Images where Product_Id = " &
> Product_Id & "
> and Thumbnail = " & Jpegthumb.Binary & " and Image = " & Jpeg.Binary
> & " and Status = '" & Status & "'",cn,adopenkeyset,adLockReadOnly
>
>
> The bit taht is causing the problem is
>
> & " and Thumbnail = " & Jpegthumb.Binary & " and Image = " &
> Jpeg.Binary
>
From memory, I don't think you can in SQL. I think object fields and
comment fields are held in a separate area of the database and don't work
like normal fields.

Instead, you'd need to provide a unique identifier for each of your JPG's,
store the UI's in your main records, and compare those. That would be
better for file use and stability because you'd need to store each image
just once. It would also make it easier for you to store the images outside
the database if you get into stability problems later on - not sure about
the latest versions, but older ones got fragile once they contained a lot of
objects.

Alternatively, if you're doing some kind of scan to find common images, you
could consider extracting the objects from the records you want to compare
and do the matching in your code rather than SQL.

HTH

Andy