Re: Upload image to database

  •  12-17-2007, 6:00 AM

    Re: Upload image to database

    Thanks for the reply Adam.
     
    I'm no longer having the problem above, however, when trying to upload an image, I receive an IE dialog box stating; "Unable to upload file." If I run SQLProfiler whilst doing this, it appears that it's at least attempting to write the image to the database, the following is shown in SQLProfiler..
     
    exec sp_executesql N'insert into fsitems (path,isdir,parentpath,createdt,filename,filesize,filedata) values (@cdq_0,0,@cdq_1,CONVERT(DATETIME,@cdq_2),@cdq_3,@cdq_4,@cdq_5)',N'@cdq_0 nvarchar(19),@cdq_1 nvarchar(1),@cdq_2 nvarchar(50),@cdq_3 nvarchar(18),@cdq_4 int,@cdq_5 varbinary(5329)',@cdq_0=N'/lightning_logo.png',@cdq_1=N'/',@cdq_2=N'2007-12-17 11:54:29.671',@cdq_3=N'lightning_logo.png',@cdq_4=5329,@cdq_5=0x89504E470D0A1A0A0000000D49484452000000...
     
    But no rows are in the fsitems table.

    Is this likely to be some sort of permissions issue?
View Complete Thread