Coding Thread, Image Update Query in Coding and Web Development; Hi all,
I've ran into an annoying issue, we have two databases of concern. One with the last years images ...
27th October 2008, 01:22 PM #1
Image Update Query
I've ran into an annoying issue, we have two databases of concern. One with the last years images of pupils; and the other database holding the current images of pupils. I've created an SQL query which runs and 'updates' the images. However, these images are now showing as 0x in the fields. Where as doing a select statement instead of a update statement, with the same query displays a different result e.g. 0xFFD8FEE... etc.
I've tried manually putting one of the results into the field which needs updating which works wonderfully. It's just when trying to use the SQL query it somehow changes to 0x.
Please help meeeee!!!
Any help be most appreciated!
(Hehe I like the troll animation)
IDG Tech News
27th October 2008, 01:42 PM #2
What DBMS? What's the table Schema? Are these BLOBs? Giz code snippets
27th October 2008, 01:50 PM #3
Currently using MSSQL and the query looks something similar to:
update myTable set imgdata = photo from myTable
left outer join [ExternalDatabase].[CurrentDatabase].[dbo].[tablePhotos] on
myTable.ID = tablePhotos.ID
Both fields are Image type
27th October 2008, 02:14 PM #4
Ack.. sorry... not too hot on th'ol MSSQL - anyone else?
28th October 2008, 09:32 AM #5
Well I never did find the solution or reason for the issue. However, I took a deep breath, closed my eyes and then deleted and reinserted the rows of data. Seemed to work fine when inserting, just not updating.
Last Post: 27th October 2008, 09:20 PM
By EduTech in forum Gaming
Last Post: 24th May 2008, 07:35 AM
Last Post: 14th January 2008, 12:39 AM
By mattx in forum General Chat
Last Post: 1st November 2007, 05:07 PM
By markwilliamson2001 in forum Web Development
Last Post: 5th October 2007, 09:43 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)