IMAGES

[VENU]

I have a table structure like this
EmpID LastName FirstName Emp_Picture
100| x |T |<BINARY>
200| W |W |<BINARY>
..
..
ETC
This table has 935 rows in it with Emp_Picture Blank.

How to insert the jpeg files into the Emp_Picture Column??
Do we have run the update statement for each and every employee or is there a
way to get around this problem..

Thanks in Advance
VENU

[JoeA]

Are the jpegs named as employee name.jbg or EmpID.jpg. If not you should rename the jpeg names as the EmpID or the LastnameFirstName. Put them all in a single directory and creat a VB scrip that will read the file name from that directory and drop the .jpeg part and you have your name or EmpID number that you can pass to a sp or query to update the table with the correct images to the correct employee. This is based on if the jpegs are independent and not part of some third party emp software.


------------
VENU at 6/28/00 4:53:58 PM

I have a table structure like this
EmpID LastName FirstName Emp_Picture
100| x |T |<BINARY>
200| W |W |<BINARY>
..
..
ETC
This table has 935 rows in it with Emp_Picture Blank.

How to insert the jpeg files into the Emp_Picture Column??
Do we have run the update statement for each and every employee or is there a
way to get around this problem..

Thanks in Advance
VENU