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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to get the hyperlinks in the cloumn of a table in sql

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-17 : 08:18:25
sri writes "Suppose I have a table to enter the name,number,address of employees in different coloumns.I want the names to be as hyperlink.how can i get that?
should we do that at the time of creating database?or do we need to write the code?
If we have to write code please let me know the code also."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-17 : 08:53:43
You should do this in your Front End application. Just store names in the table and format it to be hyperlink in Reports,etc

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-03-17 : 08:55:20
Hi Sri

Go to WWW.W3schools.com
Learn about
-- HTML
-- ASP or ASP.Net
-- SQL

For my knowledge, there is no magical way to create a hyperlink, that gives u data from a Database

U may need
-- Data contained in a table (May be SQL Server, or Access, or Oracle or any database in this case)
-- a front end application which runs on a browser like IE or Netscape Nav. ..
+ to have something like ADO, ... to deal with database
-- SQL code written in backend as stored procedures (the recommended way) or
query strings written in front end to be passed to the Backend (not the recommended way due to security ... concerns)
Go to Top of Page
   

- Advertisement -