worked
Swoosh`s Code stuff
SQL, C#, VB, .net, asp, JavaScript, you name it. Code samples, Error messages and stuff like that. Please add coments if you think I said something stupid :D or if you have a better idea ... or anything at all ...
Wednesday, January 25, 2023
Friday, April 2, 2021
Fastest C# compare string
Use
string.Equals(s1, s2, StringComparison.OrdinalIgnoreCase)
instead of toupper or tolower
Monday, February 8, 2021
Thursday, April 9, 2020
Parse URL in SQL
I searched a lot, and I did not like anything I found. Then I saw this on sql-server-helper.com
That site looks a little odd, I thought I would save this for myself, in case the site goes away, like some I used before stackoverflow.
And this is how you use it
CREATE FUNCTION [dbo].[ParseURLQueryString]
( @QueryString AS VARCHAR(MAX) )
RETURNS @QueryStringTable TABLE
( [Key] VARCHAR(100), [Value] VARCHAR(1000) )
AS
BEGIN
DECLARE @QueryStringPair VARCHAR(2000)
DECLARE @Key VARCHAR(100)
DECLARE @Value VARCHAR(1000)
WHILE LEN(@QueryString) > 0
BEGIN
SET @QueryStringPair = LEFT ( @QueryString, ISNULL(NULLIF(CHARINDEX('&', @QueryString) - 1, -1),
LEN(@QueryString)))
SET @QueryString = SUBSTRING( @QueryString, ISNULL(NULLIF(CHARINDEX('&', @QueryString), 0),
LEN(@QueryString)) + 1, LEN(@QueryString))
SET @Key = LEFT (@QueryStringPair, ISNULL(NULLIF(CHARINDEX('=', @QueryStringPair) - 1, -1),
LEN(@QueryStringPair)))
SET @Value = SUBSTRING( @QueryStringPair, ISNULL(NULLIF(CHARINDEX('=', @QueryStringPair), 0),
LEN(@QueryStringPair)) + 1, LEN(@QueryStringPair))
INSERT INTO @QueryStringTable ( [Key], [Value] )
VALUES ( @Key, @Value )
END
RETURN
END
( @QueryString AS VARCHAR(MAX) )
RETURNS @QueryStringTable TABLE
( [Key] VARCHAR(100), [Value] VARCHAR(1000) )
AS
BEGIN
DECLARE @QueryStringPair VARCHAR(2000)
DECLARE @Key VARCHAR(100)
DECLARE @Value VARCHAR(1000)
WHILE LEN(@QueryString) > 0
BEGIN
SET @QueryStringPair = LEFT ( @QueryString, ISNULL(NULLIF(CHARINDEX('&', @QueryString) - 1, -1),
LEN(@QueryString)))
SET @QueryString = SUBSTRING( @QueryString, ISNULL(NULLIF(CHARINDEX('&', @QueryString), 0),
LEN(@QueryString)) + 1, LEN(@QueryString))
SET @Key = LEFT (@QueryStringPair, ISNULL(NULLIF(CHARINDEX('=', @QueryStringPair) - 1, -1),
LEN(@QueryStringPair)))
SET @Value = SUBSTRING( @QueryStringPair, ISNULL(NULLIF(CHARINDEX('=', @QueryStringPair), 0),
LEN(@QueryStringPair)) + 1, LEN(@QueryStringPair))
INSERT INTO @QueryStringTable ( [Key], [Value] )
VALUES ( @Key, @Value )
END
RETURN
END
SELECT * FROM [dbo].[ParseURLQueryString] ( 'fname=Barack&lname=Obama&addr=1600 Pennsylvania Ave NW&city=Washington&st=DC&zip=20500' )
Wednesday, February 26, 2020
WiX undefined preprocessor variable
Not sure how many people will see my small blog, but here I go, maybe it helps someone.
I recently had this WiX undefined preprocessor variable issue.
The actual variable was the same old $(var.MyProject.TargetDir)
After looking through the whole internet and not finding anything, the fix was a simple one.
The "MyProject" HAS TO BE EXACTLY THE SAME NAME as the web project that I added as a reference to the Wix project.
So if your project is called WhatewerWebAll, then you have to have something like:
You can say what you want, but the "undefined preprocessor variable $(var.MyProject.TargetDir)" message is actually not really describing the real issue, but maybe that's just me.
I recently had this WiX undefined preprocessor variable issue.
The actual variable was the same old $(var.MyProject.TargetDir)
After looking through the whole internet and not finding anything, the fix was a simple one.
The "MyProject" HAS TO BE EXACTLY THE SAME NAME as the web project that I added as a reference to the Wix project.
So if your project is called WhatewerWebAll, then you have to have something like:
You can say what you want, but the "undefined preprocessor variable $(var.MyProject.TargetDir)" message is actually not really describing the real issue, but maybe that's just me.
Wednesday, January 15, 2020
Sony Android TV Bluetooth headset issue a2dp
From what I understand after investigating this issue, this happens with multiple TV types from Sony.
I got a new TV, Sony BRAVIA, 49XG8096, 4K Ultra HD.
The TV is cool, no issues with it at all.
My plan was to connect it with a Bluetooth headset too, so I can watch a movie without wires, even if my wife is sleeping next to me.
I first bought a JBL Tune 500 headset, just because that was on stock, and could not lose time searching for anything else. The headset was working fine, connecting with anything, but I couldn't get it to connect to the TV at all.
I looked up this issue and saw that there is a list of headphones that are on an Official list from Sony. I can't say I was happy, but I went back to the store, and changed the headphones to a Sony this time, model WH-CH500B.
According to the list, it should have worked.
Well, it didn't.
I investigated some more, and I found out that this is might be a software issue, with a very easy fix.
I went to the TV's Play Store, searched for Bluetooth, and installed the first 3rd party app that I found. The app connected the Sony Headset to the Sony TV in less then 5 seconds.
After this, I can just go to the TV settings, and the WH-CH500B is listed as paired, I can easily turn it on or off.
I am thinking that the JBL might have been working too if I used an app like this.
I am not sure why Sony cannot do this themselves, but I don't care anymore.
I got a new TV, Sony BRAVIA, 49XG8096, 4K Ultra HD.
The TV is cool, no issues with it at all.
My plan was to connect it with a Bluetooth headset too, so I can watch a movie without wires, even if my wife is sleeping next to me.
I first bought a JBL Tune 500 headset, just because that was on stock, and could not lose time searching for anything else. The headset was working fine, connecting with anything, but I couldn't get it to connect to the TV at all.
I looked up this issue and saw that there is a list of headphones that are on an Official list from Sony. I can't say I was happy, but I went back to the store, and changed the headphones to a Sony this time, model WH-CH500B.
According to the list, it should have worked.
Well, it didn't.
I investigated some more, and I found out that this is might be a software issue, with a very easy fix.
I went to the TV's Play Store, searched for Bluetooth, and installed the first 3rd party app that I found. The app connected the Sony Headset to the Sony TV in less then 5 seconds.
After this, I can just go to the TV settings, and the WH-CH500B is listed as paired, I can easily turn it on or off.
I am thinking that the JBL might have been working too if I used an app like this.
I am not sure why Sony cannot do this themselves, but I don't care anymore.
Friday, December 15, 2017
SQL - update column with sequence number starting from 1
DECLARE @id INT;
SET @id = 0
UPDATE x SET @id = [ItemNo] = @id + 1
Subscribe to:
Posts (Atom)