Welcome, Guest
Username: Password: Remember me

TOPIC: Uploading Images

Uploading Images #885

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

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
  • OFFLINE
  • 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.
www.gainfocus.biz
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