XSL pop up from SQl table - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

XSL pop up from SQl table

Is it possible to to show the image from the SQL Database table using XSL?? Like for example..I have an Excel table and put it in the SQL 2008 enterprise. All the data and the image are already in one table. I already done it using excel table to XSL and it's working perfectly.But everytime i am doing this from SQL,it shows the link or omitting the column for Photograph Field and Field Value.



We have created new table in sql server that will going to be used in ArcGis 9.3. We are having problem on data type blob for image. We cannot display the image in ArcView from Photograph field which is the data type that have shown in ArcCatalog is blob.

Here is the code for creating table and inserting image in SQL 2008:



Create table Sample1(
Id_no int identity (1,1) Not null,
OutletCde nvarchar(255) null,
Outletname nvarchar(255) null,
OutleType nvarchar(255) NULL,
Latitude float null,
longitude float null,
easting float null,
northing float null,
Photograph image null
)
Go

Insert into Sample1 (OutletCde,Outletname,OutleType,Latitude,longitude,easting,northing,Photograph)
Values ( '17400001254','Ramon Store','sar', '14.464367','120.980926','282363.878','1600042.096', 0xFFFFFFFF)
GO

DECLARE @Pointer_Value varbinary(16)
SELECT @Pointer_Value = TEXTPTR(Photograph)
FROM Sample1
WHERE Id_no = 1
WRITETEXT Sample1.Photograph @Pointer_Value 'C:17400001254.jpg'
GO

I am looking for how to gather picture from database and load it into pop up window that has data set from tables.I publish the picture in IIS so I can changed the directory location of picture within field Photo of SQL database.I attached a sample output that we want to get from our SQL server.Here i have done this output from excel table.


We hope you can help us asap!! Thanks

Gio
Sign In or Register to comment.