| update blob column with images from a directory [message #539587] |
Tue, 17 January 2012 04:58  |
 |
kiran111
Messages: 49
Registered: October 2011
|
Member |
|
|
Hi frends,
need help
i have to update the blob column in a table with new image.
we have a table with 10 columns in which one column is 'image' as BLOB data type, and one more column with "image_name " and has more than 1000 rows.
I have a 300 images which I need to update in "image" column .
I need to match the given images name with "image_name" column, if row is present in the table than update the "image" column with the given image.
I search and found almost same code to insert the image in new table with a procedure, I mean code is to call the procedure, ( by passing image name and image directory)
Is there any way that we will check all the image given in the directory, if that image_name is present in the table then update the image
Can some one provide me a sample code for this
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
