Search results for query: *

Basically in the SQL code I put in: update #ktemp set TOUPDATE = 'Y' where TOUPDATE = 'N' if @@rowcount = 0 raiserror 31000 'no rows' I create a temp table and add a column to update. If there is no data and therefore no update made the code errors out and stops the report from running. Hope...

I use some SQL code so that the report fails if there is no data to send. Kevin.

Thanks Gary, That was close enough, I had to make some minor adjustments based on different data...end result: IF Count(Split({MyField},';')) <= 2 then 'UNKNOWN TYPE' else If Count(Split({MyField},'+')) >= 3 Then If Split({MyField},'+')[3] Like '*MS*' Then 'Microsoft Internet...

There is consistency - I think. If after the first ';+' there is 'MS*" then 'Microsoft Internet Explorer', if after the first ';+' there is 'U' then return everything from the last '+' to the last '/'. And in any other case 'Unknown' That's in English...now all I need is it converted into...

Those will work great BUT the issue is there are more options available than just 'If U* then FireFox' I have found some more examples: Mozilla/5.0+(X11;+U;+Linux+i686;+en-US;+rv:1.8.1.12)+Gecko/20080312+SeaMonkey/1.1.8...

Sorry made the common assumption that because I was familiar with it that everyone must be. Raw Data (5 examples): Mozilla/4.0+(compatible;+MSIE+4.01;+Windows+NT;+MS+Search+5.0+Robot) Mozilla/4.0+ (compatible;MSIE+5.5;+Windows+2000+Server)...

I have searched the better part of the day looking for an answer - can't believe it doesn't exist, either that or I just couldn't find it. I am looking to get the browser type from the useragent field of an IIS Log. I have it working in SQL using the following: MainBrowser = case...