Urgent Help Please - format field in slq

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

Urgent Help Please - format field in slq

Author

Topic

MichelleB
Starting Member

8 Posts

Posted - 2014-03-14 : 01:03:07

hi i need to be able to show the links from the field 'Facebook' as a link, it is showing as text?
the display is working, it loops each act name and lists the facebook link but i want the link to by a button with the ahref


Set objRs = Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT `Name`, `FaceBook` FROM `Contacts` WHERE Contact='"&strContact&"' "
objRS.Open strSQL, objconn
strA = objRS("ActName")
%>
<table border="0">						
<%do until objrs.EOF%>							<tr>
<%for each x in objrs.Fields%><td align="left">								<%Response.Write(x.value)%>
</td>
<%next%>
</tr>
<%
objrs.MoveNext
loop
%>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources