| Author |
 Topic  |
|
|
kamii47
Constraint Violating Yak Guru
352 Posts |
 Posted - 02/20/2013 : 06:21:21
|
Any simple way to get querystring value from a url without charindex and substring
I wanted to get the querystring value of entryid
http://www.mysite.com/Default.aspx?TabId=330&EntryId=1
Kamran Shahid
Principle Engineer Development
(MCSD.Net,MCPD.net)
|
|
|
James K
Flowing Fount of Yak Knowledge
3557 Posts |
Posted - 02/20/2013 : 07:48:29
|
Are you running into any issues when using charindex and substring? In any case, the following does not use either of those functions:DECLARE @x VARCHAR(256) = 'http://www.mysite.com/Default.aspx?TabId=330&EntryId=1';
SELECT STUFF(@x,1,PATINDEX('%&EntryId%',@x),'') |
 |
|
|
donjosdon
Starting Member
India
1 Posts |
Posted - 04/11/2014 : 06:22:06
|
I tried the below and it worked.
DECLARE @x VARCHAR(256) = 'http://www.mysite.com/Default.aspx?EntryId = 1&a=1&TabId=330';
--another query string combination
/*DECLARE @x VARCHAR(256) = 'http://www.mysite.comDefault.aspx?TabId=330&EntryId = 1&a=1';*/
SELECT STUFF(@x,1,PATINDEX('%EntryId%',@x)-1,'')
select LTRIM(RTRIM(Replace(REPLACE(SUBSTRING(STUFF(@x,1,PATINDEX('%EntryId%',@x)-1,''),0,
(case when CHARINDEX('&',STUFF(@x,1,PATINDEX('%EntryId%',@x)-1,''),1)=0 then 100 else CHARINDEX('&',STUFF(@x,1,PATINDEX('%EntryId%',@x)-1,''),1) end)
),'EntryId',''),'=','')))
Thanks
Joseph Don |
|
|
| |
Topic |
|
|
|
Any simple way to get querystring value from a url
