My contemplations and diurnal novelties are publicized here


Do you want to extact your file extension. Do it using SQL! As follow:-

 

SELECT Collection.Item_No,

‘~/ThumbNail/’ + substring(Imagefile,0,CHARINDEX(‘.’,Imagefile,0))  + ‘_thumb’ + substring(Imagefile,CHARINDEX(‘.’,Imagefile,0),len(Imagefile))  ThumbNail,

‘this.src=”’ +  ‘Gallery/’ + ImageFile + ”” MouseOver,

‘this.src=”’ +  ‘ThumbNail/’ + substring(Imagefile,0,CHARINDEX(‘.’,Imagefile,0))  + ‘_thumb’ +

substring(Imagefile,CHARINDEX(‘.’,Imagefile,0),len(Imagefile)) + ”” MouseOut,

Collection.Title, Artist.[Artist Name] AS Artist, Category.Name AS Category, Media.Media, Surface.Surface_name as Surface, styles.style_name as Style FROM Collection INNER JOIN Artist ON Collection.Artist = Artist.ID INNER JOIN Category ON Collection.cat_id = Category.ID INNER JOIN Media ON Collection.Media = Media.ID INNER JOIN Surface ON Collection.Surface = Surface.ID INNER JOIN styles ON Collection.style = styles.ID

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: