Find Columns Name in the MSSQL DataBase

Hello Fellas,

Today I'm sharing the learning to how to find the column whose table name is unknown to us.

here is the query,


select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%TurnAroundTime%' order by TABLE_NAME

Thank You :)

Image Display from BLOB (database) in ADF.

Hello Fellas, today I'm sharing my ADF learning, as display of images from Database column BLOB, from Corousel
1. Create a table containing at-least two columns one containing id and another the blob.
2. Make EO & VO of the table.
3. Drag it to the jspx in form of corousel 

4. Drag image component from common components to the img.jspx structure,

leave the dialouge box containing Source & Short Desc,

5. Create a servlet by right click on view controller and selecting new

code of the servlet is available here 

ImgServlet 

6. now edit the source and shortdesc of image. by writing the code in.

source                        /imgservlet?id=#{item.Id}

shortdesc                    #{item.id}

where

imgservlet is the name of the servlet which we created as ImgServlet

and item is a variable created by the carousel item

FINAL OUTPUT

thank you :)

thanks to Adeel