
December 16th, 2004, 05:50 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 12
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
input images into database
Hello, I am new at SQL and have run into a problem. I want to put images into SQL allowing users to add to it over the web to create a dynamic PDF. So far I am able to create the PDF “on the fly” with all the data the text data they want but they now want checkboxes, lines and other images added. I have managed to get it to work as long as I use the BCP utility however it is not fun to use and doesn’t allow users to add their own images if necessary. I tried to just UPDATE the tables inserting the images into the image column but it doent work. So my question is… could someone please point me in the direction of an article or give an easy example of how to input an image into a table that already exists.
I tried: (as well as many other variations)
UPDATE checklist_item_type_codes
SET shape = "c:\two.jpg"
WHERE checklist_item_type_id = 2
Thanks in advance
|