Database Discussion - GUI building a table

Print Page | Close Window

GUI building a table

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3967
Printed Date: 29 March 2026 at 7:36pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: GUI building a table

Posted By: garv
Subject: GUI building a table
Date Posted: 30 June 2003 at 11:53pm

im curious... im using a database editor where you can view a database via the internet and then update delete and add to that database via the web. it all works fine but im trying to place my delete and update info into a similar table but every time i add the table cell tags the links no longer work, i mean they not even there anymore. here is a sample:

THIS WORKS
Response.Write("<tr bgcolor='" & sColor & "'>")
Response.Write ("<a href=""delete_entry.asp?ID=" & rsDatabase("ID_no") & """>")
Response.Write(rsDatabase("EvtMsnSqn").Value)
Response.Write("</a>")
Response.Write(rsDatabase("CSBuno").Value)
Response.Write(rsDatabase("TO").Value)

THIS DOESN'T
Response.Write("<tr bgcolor='" & sColor & "'>")
Response.Write ("<a href=""delete_entry.asp?ID=" & rsDatabase("ID_no") & """>")
Response.Write("<td>" & rsDatabase("EvtMsnSqn").Value & "</td>")
Response.Write("</a>")
Response.Write("<td>" & rsDatabase("CSBuno").Value & "</td>")
Response.Write("<td>" & rsDatabase("TO").Value & "</td>")

Replies:

Posted By: garv
Date Posted: 30 June 2003 at 11:56pm

can someone please help me with what it is im doing wrong?

Posted By: Bunce
Date Posted: 01 July 2003 at 12:57am

Garv, I think you're going to need to explain your problem a little better.

What database editor are you using?
What error message are you getting, if any?
What code are you using to connect to the database?
What other code do you have that could affect the output?

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: ljamal
Date Posted: 01 July 2003 at 1:06am

The problem you have is that when you add the table cells you are adding them around the value which leaves the link floating in between the row and the cell in HTML no man's land.

Try this
Response.Write("<tr bgcolor='" & sColor & "'>")
Response.Write ("<td><a href=""delete_entry.asp?ID=" & rsDatabase("ID_no") & """>")
Response.Write(rsDatabase("EvtMsnSqn").Value)
Response.Write("</a></td>")
Response.Write("<td>" & rsDatabase("CSBuno").Value & "</td>")
Response.Write("<td>" & rsDatabase("TO").Value & "</td>")

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: garv
Date Posted: 01 July 2003 at 5:16am

THAT WORKED!!
thanks ljamal it always ends up being something so simple.