Welcome, Guest
Username: Password: Remember me

TOPIC: Uploading Images

Uploading Images #885

  • be05x5
  • be05x5's Avatar
  • Expert Boarder
  • Posts: 123
  • Thank you received: 2
  • Karma: 0

I would like to upload a batch of images into the database. For some reason this does not work. A simple:

update items
set picture = '\\45borojevicg\Network Shared folder\FR34250BAT.jpg'
where itemcode = '1260HE'

does not work. Does anyone know why? How can I do this. We have over 300 new items and doing it by hand is too much work plus errors easily occur.
The administrator has disabled public write access.

Uploading Images #889

  • dgillz
  • dgillz's Avatar
  • Platinum Boarder
  • Posts: 395
  • Thank you received: 14
  • Karma: 6
I am pretty sure you will have to use a CAST command to convert the picture to digital data, the update the field. However I do not know how to do this.
Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports.
The administrator has disabled public write access.
Time to create page: 0.029 seconds
Powered by Kunena Forum  Protected by R Antispam