September 17, 2015 at 2:39 pm
Post if it still doesn't work and explain what you did step by step... because try as I might, I can't reproduce the issue. Can you open the links in IE?
September 17, 2015 at 3:48 pm
Ok it works your way, but why? Is it because of the stored procedure to return the results?
I'm going to try a few things on an trial and error to see if i can figure out what I did wrong.
September 17, 2015 at 3:53 pm
I don't think so. I did the first one as an embedded dataset and created a union query, just because I wanted the report to be as simple as possible and have the fewest possible points of failure. It worked fine. Then I built another based on the stored procedure, which also worked. Given that, the only thing I can come up with is that you were somehow setting the Go to URL setting wrong. I tried to break it every way I could, and that's about the only thing that would do it.
September 17, 2015 at 4:56 pm
I turned on the output to see if I would get any errors when I preview the report and I think I found out what the issue is. Here is the error
[rsInvalidURLProtocol] The value ‘Tweet text, Tweet http://t.co/shortenurl #text #text #text’ of the Hyperlink property of the text box ‘TweetResult’ has an invalid schema. URLs in reports may only use http://, https://, ftp://, mailto: or news:
Preview complete -- 0 errors, 1 warnings
I'm guessing that URLs must have one of those protocols, is that right? But the tweets do have http:// in front of the addresses
September 17, 2015 at 5:34 pm
pietlinden (9/17/2015)
Post if it still doesn't work and explain what you did step by step... because try as I might, I can't reproduce the issue. Can you open the links in IE?
The links look like the following if clicked on
TweetText:%20TweetText%20TweetText%203-TweetText%20(#TweetText,%20UT)%20http://t.co/shortenurl%20%23df%20%23fob%20%23me%20%23Heroes%20%23TweetText
September 17, 2015 at 5:47 pm
I would write a query against the underlying datasource (table(s)) to see what's going on.
Something like:
SELECT *
FROM TweetsList
WHERE TweetURL NOT LIKE 'http://%'
AND TweetURL NOT LIKE 'https://%'
AND TweetURL NOT LIKE 'ftp://%'
AND TweetURL NOT LIKE 'mailto:%'
AND TweetURL NOT LIKE 'news:%';
This stuff is just the sample data I used...
-- these should work fine.
INSERT INTO TweetsList(TweetDate,TweetURL)
VALUES (GETDATE(),'ftp://grabthis.com'),
(GETDATE(),'mailto:bartsimpson@simpsons.com'),
(GETDATE(),'https://www.securesite.com'),
(GETDATE(),'news:whatever.com');
-- this should fail.
INSERT INTO TweetsList(TweetDate,TweetURL) VALUES (GETDATE(),'www.xyz.com');
If you get any records returned, those are the ones that would cause problems.
September 17, 2015 at 6:19 pm
I used the query below against my production data, I got back a pretty much all data that is being feed in. Is it possible that the issue is the insert query being used for the production data?
SELECT *
FROM Table
WHERE column NOT LIKE 'http://%'
AND column NOT LIKE 'https://%'
AND column NOT LIKE 'ftp://%'
AND column NOT LIKE 'mailto:%'
AND column NOT LIKE 'news:%';
September 17, 2015 at 6:31 pm
I just reviewed the VALUES area of the insert statement and nothing jumps out. But I think this will be the area of focus
September 17, 2015 at 6:31 pm
I used the query below against my production data, I got back a pretty much all data that is being feed in.
SELECT *
FROM Table
WHERE column NOT LIKE 'http://%'
AND column NOT LIKE 'https://%'
AND column NOT LIKE 'ftp://%'
AND column NOT LIKE 'mailto:%'
AND column NOT LIKE 'news:%';
September 17, 2015 at 6:33 pm
What happened when you ran the query to see if there were any "illegal" hyperlinks?
The INSERT statement should have nothing to do with it, but it's your database, so you would know better than I.
September 17, 2015 at 6:59 pm
pietlinden (9/17/2015)
What happened when you ran the query to see if there were any "illegal" hyperlinks?The INSERT statement should have nothing to do with it, but it's your database, so you would know better than I.
Ok I'll rule out the INSERT statement, you know more than I overall and I appreciate the help. All the queries worked, is that bad? Should I gotten any bad results?
When I run the below it works
INSERT INTO TweetsList(TweetDate,TweetURL)
VALUES (GETDATE(),'ftp://grabthis.com'),
(GETDATE(),'mailto:bartsimpson@simpsons.com'),
(GETDATE(),'https://www.securesite.com'),
(GETDATE(),'news:whatever.com');
When I run this one it works
INSERT INTO TweetsList(TweetDate,TweetURL) VALUES (GETDATE(),'www.xyz.com');
When I run this one it works
SELECT *
FROM TweetsList
WHERE TweetURL NOT LIKE 'http://%'
AND TweetURL NOT LIKE 'https://%'
AND TweetURL NOT LIKE 'ftp://%'
AND TweetURL NOT LIKE 'mailto:%'
AND TweetURL NOT LIKE 'news:%';
September 17, 2015 at 7:02 pm
Ok I'll rule out the INSERT statement, you know more than I overall and I appreciate the help. All the queries worked, is that bad? Should I gotten any bad results?
When I run the below it works
INSERT INTO TweetsList(TweetDate,TweetURL)
VALUES (GETDATE(),'ftp://grabthis.com'),
(GETDATE(),'mailto:bartsimpson@simpsons.com'),
(GETDATE(),'https://www.securesite.com'),
(GETDATE(),'news:whatever.com');
When I run this one it works
INSERT INTO TweetsList(TweetDate,TweetURL) VALUES (GETDATE(),'www.xyz.com');
When I run this one it works
SELECT *
FROM TweetsList
WHERE TweetURL NOT LIKE 'http://%'
AND TweetURL NOT LIKE 'https://%'
AND TweetURL NOT LIKE 'ftp://%'
AND TweetURL NOT LIKE 'mailto:%'
AND TweetURL NOT LIKE 'news:%';
September 17, 2015 at 7:10 pm
If I run the query below, it returns results
SELECT *
FROM TweetsList
WHERE TweetURL NOT LIKE 'http://%'
AND TweetURL NOT LIKE 'https://%'
AND TweetURL NOT LIKE 'ftp://%'
AND TweetURL NOT LIKE 'mailto:%'
AND TweetURL NOT LIKE 'news:%';
The other 2 queries are INSERT statements so I can't run those against the prod DB
September 17, 2015 at 7:25 pm
Test reply because I can't see the others
September 17, 2015 at 7:33 pm
Ok I'll rule out the INSERT statement, you know more than I overall and I appreciate the help. All the queries worked, is that bad? Should I gotten any bad results?
When I run the below it works
INSERT INTO TweetsList(TweetDate,TweetURL)
VALUES (GETDATE(),'ftp://grabthis.com'),
(GETDATE(),'mailto:bartsimpson@simpsons.com'),
(GETDATE(),'https://www.securesite.com'),
(GETDATE(),'news:whatever.com');
When I run this one it works
INSERT INTO TweetsList(TweetDate,TweetURL) VALUES (GETDATE(),'www.xyz.com');
When I run this one it works
SELECT *
FROM TweetsList
WHERE TweetURL NOT LIKE 'http://%'
AND TweetURL NOT LIKE 'https://%'
AND TweetURL NOT LIKE 'ftp://%'
AND TweetURL NOT LIKE 'mailto:%'
AND TweetURL NOT LIKE 'news:%';
If I run the query below against the prod data, it returns results
SELECT *
FROM TweetsList
WHERE TweetURL NOT LIKE 'http://%'
AND TweetURL NOT LIKE 'https://%'
AND TweetURL NOT LIKE 'ftp://%'
AND TweetURL NOT LIKE 'mailto:%'
AND TweetURL NOT LIKE 'news:%';
The other 2 queries are INSERT statements so I can't run those against the prod DB
Viewing 15 posts - 16 through 30 (of 40 total)
You must be logged in to reply to this topic. Login to reply