Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tinamiller1
Yak Posting Veteran
78 Posts |
 Posted - 2015-02-13 : 16:27:34
|
| I have researched how to put a URL column in my SQl Server 2008 database and table. I have tried varchar(max) and varchar(1000) and then done what I found online by inserting into the url with ' ' around it and then I ODBC into Access and it does not look like a link. Cannot link on it and have it go where it needs to. I have also tried this in the front-end application and it does not look like a link. It does not respond either. Does anyone know how to properly put this in the table?tina m miller |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-02-13 : 17:21:32
|
Can you explain what you meant when you said "it does not look like a link"?Usually, a link that you see on web pages (or in html e-mails and other places) has two parts to it. One is the text that you see. The other is a hidden href attribute that tells it what the link should do when clicked on. For example, the code fragment below should display Microsoft which appears as a link, which when clicked should take you to Microsoft.com <a href="http://www.microsoft.com">Microsoft</a> Unless you have something like that in the place where you are using the data that you retrieve from SQL Server, it wouldn't navigate to any link. To SQL Server, whatever you put in the varchar(max) or varchar(1000) column is just a string. It does not do any html linking or anything similar. |
 |
|
|
tinamiller1
Yak Posting Veteran
78 Posts |
Posted - 2015-02-13 : 17:53:12
|
| It does not when ODBCing or using Tableau as our front-end show up as a link. It does infact show up as a string but we want it to be a link just as in Access. Are you saying I need to in SQL Server my ProgramURL table put <a href=" in that area as you have done above? The issue is we cannot do a URL in Tableau on a specific program name. We have 135 distinct program names in the program table. You can only do a URL on in Tableau on the Program Name column itself in worksheet or dashboard. We want the end-user to say hey that is healthy checklist program, wonder what that is all about. Then hey, there is the link. Tableau does not do separate link per the data you have in the table. So the only thing I can think of is including the link in SQL Server so we can put that in Tableau but it has to be like a URL. Does SQL Server not have this capability? Is so that blows my mind Access a tool that is just pumped up Excel would and sophisticated SQL Server does not. I talked my team into migrating because we could not support an Access back-end and front-end Tableau. Any help would be greatly appreciated.tina m miller |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-13 : 18:04:49
|
| SQL Server just stores the data. It's up to the application to present the data in the way that you want. You could try changing the data to include the a href stuff, but it's up to Tableau to create the clickable link.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-02-16 : 01:46:29
|
| Focus on storing the data in the database. Use a Select statement to extract the information . Format the details in the application.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
URL SQL Server