Line 31:
Line 32: dt = GetData("SELECT *,(SELECT ',' + CM.Name FROM [dbo].[Theme] AS CM WHERE ':' + Package.themeid + ':' LIKE '%:' + CONVERT(varchar(10), themeid) + ':%' FOR xml path(''), type).value('substring(text()[1], 2)', 'varchar(max)') AS theme, Nights+1 as Days,Price+2000 as SPrice from Package where Package.Slug='" + slug + "'");
Line 33: title = dt.Rows[0]["Title"].ToString();
Line 34: desc = dt.Rows[0]["MetaDescription"].ToString();
Line 35: keyword = dt.Rows[0]["MetaKeyword"].ToString();
|