RE: FN-FORUM: urgent Acccess problem

date posted 27th January 2007 23:25

What are you actually trying to do - why do you need to compare the
binary contents of the files ? If you did need to check to see if
they're the same, then you could generate a hashkey when the file is
first uploaded and store that and then compare hashes.=20

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
[EMAIL REMOVED]
Sent: 27 January 2007 23:36
To: Andy Macnaughton-Jones
Subject: Re: FN-FORUM: urgent Acccess problem


I had a horrible feeling it was impossible to do it like that. I think I
will check and see if they should have titles which would solve the
problem




Pam



----- Original Message -----=20
From: "Andy Henderson" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Saturday, January 27, 2007 6:32 PM
Subject: RE: FN-FORUM: urgent Acccess problem


>
> [EMAIL REMOVED] wrote:
>> I am getting
>>
>> Type mismatch
>>
>> on this statement
>>
>> rs.Open "SELECT Id FROM Product_Images where Product_Id =3D " &
>> Product_Id & "
>> and Thumbnail =3D " & Jpegthumb.Binary & " and Image =3D " & =
Jpeg.Binary
>> & " and Status =3D '" & Status & "'",cn,adopenkeyset,adLockReadOnly
>>
>>
>> The bit taht is causing the problem is
>>
>> & " and Thumbnail =3D " & Jpegthumb.Binary & " and Image =3D " &
>> 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=20
> 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=20
> of
> objects.
>
> Alternatively, if you're doing some kind of scan to find common
images,=20
> 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
>
>
> --=20
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>=20
--=20
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html