Re: FN-FORUM: urgent Acccess problem

date posted 27th January 2007 22:44

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 -----
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 = " &
>> 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
>
>
> --
> 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
>
>