Re: FN-FORUM: urgent Acccess problem

date posted 27th January 2007 22:58

Hello,

It might be an idea to just store the file paths in a
database and the actual images in directories. I have
some code that gets the id of new record inserted
into an access database. Have to dig it out from other
pc if you need it.

Regards
Ahmed
--- [EMAIL REMOVED]
[EMAIL REMOVED] wrote:

>
> 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
> >
> >
> --
> 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
>
> Unsubscribe:
> http://www.freelancers.net/rm/108966207412039537
>
> To Post a New Message: [EMAIL REMOVED]
> Forum Homepage: http://www.freelancers.net/forum.php
>
> http://www.freelancers.net - freelancers and
> freelance jobs
>
>


Freelance Software Developer



___________________________________________________________
The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. http://uk.docs.yahoo.com/nowyoucan.html