I have a page that displays the contents of a record in a database that when displayed, if the contents are very long it stretches the table's length across the whole page and looks very ugly how do you set the table so that it only expands downward not across.<br />
<br />
I checked the html section and no one has an answer, can this be in asp using vbcrlf or something?<!--content-->hi,<br />
can you give an example?<!--content-->go to <!-- w --><a class="postlink" href="http://www.northshore-adventures.com">www.northshore-adventures.com</a><!-- w --><br />
<br />
click on view stories <br />
if the user doesn't press enter then it does one line across the whole web page, UGLY.<br />
here is my code<br />
<br />
<% @Language = VBScript %><br />
<% Option Explicit %><br />
<%<br />
<br />
Dim dbConn, dbQuery, recordsetDB, strStories, strQueryString1,strUser_Id<br />
Dim Hunt_Id, Hunt_Password, CurPage, NumPages<br />
<br />
Hunt_Id = request.form("OldHunt_Id")<br />
Hunt_Password = request.form("Hunt_Password")<br />
<br />
Set dbConn = Server.CreateObject("ADODB.Connection") <br />
dbConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\premfs7\sites\premium2\nsadvenventures\Database\Stories.mdb")<br />
<br />
strquerystring1 = "SELECT Stories.Stories, Stories.Hunt_Id FROM Stories "<br />
Set recordsetDB = server.createObject("ADODB.recordset")<br />
recordsetDB.CursorLocation =3<br />
recordsetDB.PageSize =10<br />
recordsetDB.Open strquerystring1, dbconn<br />
numpages = recordsetDb.PageCount<br />
CurPage = CInt(request.querystring("Page"))<br />
If curpage < 1 Then Curpage = 1<br />
If curpage > Numpages Then Curpage = Numpages<br />
recordsetDB.AbsolutePage = Curpage<br />
%><br />
<br />
<html><br />
<br />
<head><br />
<title>View Stories</title><br />
</head><br />
<body background="grback.jpg"><br />
<p align="center"><img border="0" src=http://www.webdeveloper.com/forum/archive/index.php/"THEGREATSTORIES.gif"><br />
<p><br />
Page <%=CurPage%> Of <%=NumPages%><br />
<% Do While recordsetDb.AbsolutePage = Curpage AND NOT recordsetDB.EOF%><br />
</p><br />
<table border="3" width="504" height="100" bordercolordark ="darkGreen" bordercolorlight="lightgreen" Wrap="Virtual"> <br />
<tr> <br />
<td> <br />
<%<br />
<br />
strStorieS = recordsetDB("Stories").VALUE <br />
strUser_Id = recordsetDB("Hunt_Id").Value %><br />
Submitted by <% response.write ""& strUser_Id & "" %><P><br />
<%response.write ""& strStories &"" %> <br />
<input type="hidden" name="Hunt_Password" size="24" Value="<%=Hunt_Password%>"><br />
<br />
<input type="hidden" name="OldHunt_Id" size="24" Value="<%=Hunt_Id%>"><br />
</td><br />
</tr><br />
</table><br />
<br />
<%<br />
recordsetDB.MoveNext <br />
<br />
Loop<br />
recordsetDB.close<br />
%><br />
<br />
<form Name ="Navigate" METHOD="POST" ACTION="View_Storie.asp" onSubmit="return false;"> <br />
<br />
<input type="HIDDEN" name="Hunt_Password" size="24" Value="<%=Hunt_Password%>"><br />
<input type="HIDDEN" name="OldHunt_Id" size="24" Value="<%=Hunt_Id%>"><br />
<input type="Submit" value="First Page" onClick=" <br />
self.location.href = 'http://www.webdeveloper.com/forum/archive/index.php/<%=Session("Page")%> ?Page=1'; <br />
return true;"><br />
<input type="Submit" value="Prev Page" onClick=" <br />
self.location.href = 'http://www.webdeveloper.com/forum/archive/index.php/<%=Session("Page")%>?Page=<%=(curPage-1)%>'; <br />
return true;"> <br />
<input type="Submit" value="Next Page" onClick="self.location.href = <!-- m --><a class="postlink" href="http://www.webdeveloper.com/forum/archive/index.php/">http://www.webdeveloper.com/forum/archive/index.php/</a><!-- m --><br />
'<%=Session("Page")%>?Page=<%=(curPage+1)%>'; <br />
return true;"> <br />
<input type="submit" value="Last Page" onClick="<br />
self.location.href = 'http://www.webdeveloper.com/forum/archive/index.php/<%=Session("Page")%>?Page=<%=numPages%>';return true;"> <br />
</form> <br />
<br />
<br />
<form NAME="Back_TO_Main" METHOD="POST" ACTION="LoggedMainPics.asp"><br />
<input type="hidden" name="Hunt_Password" size="24" Value="<%=Hunt_Password%>"><br />
<br />
<input type="hidden" name="OldHunt_Id" size="24" Value="<%=Hunt_Id%>">GO BACK<br />
TO THE MAIN MENU <input type="submit" value="GO" name="backview"><br />
</form><!--content-->heh, thanks, good idea, maybe somethings in life are easier than they seem.<br />
<br />
Alex<!--content-->ok putting a table inside the table didn't work it just grows with the other table, unless there is a way to make it a fixed length? I hate html, sort of.<!--content-->view stories<br />
<br />
can't see a link for that anywhere <!--content-->okay...<br />
<br />
first of all... <br />
you double-posted (htlm forum also)<br />
<br />
second...<br />
the link that you provide doesn't have a "view stories" link.<br />
I think that might be because you have some password accessed page that leads to that link (?). <br />
Just one suggestion on that: If you don't need a password protected area (and I mean really need), then don't use one just for the sake of having one.<br />
<br />
third...<br />
your site looks vastly different for cross-browser viewing (maybe you don't care... but I'm just telling you).<br />
<br />
Lastly...<br />
without an actual view of the data-generated table itself, it's tough to say... but you may need to "break-apart" some fields and place them below (or in a different link) in order to display all of the information.<br />
<br />
You really need to provide a link to the data if you want further help. <br />
So... the balls in your court.<br />
<br />
and... you may want to re-design the menu/frame thing. It is very inconsistent and sometimes redundant on some pages (and have you ever seen your site in a Netscape or Opera browser?).<br />
<br />
I'm not trying to be critical... but you asked for help on something... and there are other areas that need help as well. It's all do-able, so... we'll deal with each item as we go.<br />
<br />
First priority... we need the correct link to the data.<br />
<br />
k<!--content-->Originally posted by Calmaris <br />
I have a page that displays the contents of a record in a database that when displayed, if the contents are very long it stretches the table's length across the whole page and looks very ugly how do you set the table so that it only expands downward not across.<br />
<br />
I checked the html section and no one has an answer, can this be in asp using vbcrlf or something? <br />
Your editing, it seems needs to be done in the (I have a page that displays the contents of a record). Try doing the table thing in there, that was suggested.<!--content-->y'know... actually - after looking at your code - I see that you have not declared a column width (table width, yes... column width no).<br />
<br />
I'm curious...<br />
And I see that - aside form apparently speaking to... and answering yourself - you also say "I hate html, sort of".<br />
<br />
HTML?<br />
You hate HTML?<br />
Do you know HTML?<br />
(Hate? javascript, yeah. SQL, sure. ASP, ok. But HTML.... ????)<br />
Does anybody really hate HTML???!!!<br />
<br />
I'd be happy to help you Calmaris... but what are we dealing with here?<br />
<br />
Please provide a link to that data.<br />
I will try to create a table for you.<br />
<br />
(your freaking me out y'know. Hate html??? whew!!!)<br />
<br />
k<!--content-->You say:<br />
<br />
click on view stories if the user doesn't press enter then it does one line across the whole web page,<br />
<br />
That is not very clear. clicking on view stories I suppose opens another page. Where does pressing enter come to play? and if you didn't press enter, it is source that you see or the actual Data. I am thinking of something small concerning that link to the page.<!--content-->Maybe the answer was given in the other thread. But what kind of data with no spaces could it be to stretch the table besides code? Images weren't mentioned<!--content-->i figured it out i just used word wrap, your supposed to click on the events button on the top and click on view stories, the logon is for people to be able to add stories comments, etc. and because there is an admin section to maintain the databases. lol and no i don't hate Html it was the thought of the moment. it all works goog for now, thx for critism. lol not what i expected, thx.<br />
<br />
Alex<!--content-->
<br />
I checked the html section and no one has an answer, can this be in asp using vbcrlf or something?<!--content-->hi,<br />
can you give an example?<!--content-->go to <!-- w --><a class="postlink" href="http://www.northshore-adventures.com">www.northshore-adventures.com</a><!-- w --><br />
<br />
click on view stories <br />
if the user doesn't press enter then it does one line across the whole web page, UGLY.<br />
here is my code<br />
<br />
<% @Language = VBScript %><br />
<% Option Explicit %><br />
<%<br />
<br />
Dim dbConn, dbQuery, recordsetDB, strStories, strQueryString1,strUser_Id<br />
Dim Hunt_Id, Hunt_Password, CurPage, NumPages<br />
<br />
Hunt_Id = request.form("OldHunt_Id")<br />
Hunt_Password = request.form("Hunt_Password")<br />
<br />
Set dbConn = Server.CreateObject("ADODB.Connection") <br />
dbConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\premfs7\sites\premium2\nsadvenventures\Database\Stories.mdb")<br />
<br />
strquerystring1 = "SELECT Stories.Stories, Stories.Hunt_Id FROM Stories "<br />
Set recordsetDB = server.createObject("ADODB.recordset")<br />
recordsetDB.CursorLocation =3<br />
recordsetDB.PageSize =10<br />
recordsetDB.Open strquerystring1, dbconn<br />
numpages = recordsetDb.PageCount<br />
CurPage = CInt(request.querystring("Page"))<br />
If curpage < 1 Then Curpage = 1<br />
If curpage > Numpages Then Curpage = Numpages<br />
recordsetDB.AbsolutePage = Curpage<br />
%><br />
<br />
<html><br />
<br />
<head><br />
<title>View Stories</title><br />
</head><br />
<body background="grback.jpg"><br />
<p align="center"><img border="0" src=http://www.webdeveloper.com/forum/archive/index.php/"THEGREATSTORIES.gif"><br />
<p><br />
Page <%=CurPage%> Of <%=NumPages%><br />
<% Do While recordsetDb.AbsolutePage = Curpage AND NOT recordsetDB.EOF%><br />
</p><br />
<table border="3" width="504" height="100" bordercolordark ="darkGreen" bordercolorlight="lightgreen" Wrap="Virtual"> <br />
<tr> <br />
<td> <br />
<%<br />
<br />
strStorieS = recordsetDB("Stories").VALUE <br />
strUser_Id = recordsetDB("Hunt_Id").Value %><br />
Submitted by <% response.write ""& strUser_Id & "" %><P><br />
<%response.write ""& strStories &"" %> <br />
<input type="hidden" name="Hunt_Password" size="24" Value="<%=Hunt_Password%>"><br />
<br />
<input type="hidden" name="OldHunt_Id" size="24" Value="<%=Hunt_Id%>"><br />
</td><br />
</tr><br />
</table><br />
<br />
<%<br />
recordsetDB.MoveNext <br />
<br />
Loop<br />
recordsetDB.close<br />
%><br />
<br />
<form Name ="Navigate" METHOD="POST" ACTION="View_Storie.asp" onSubmit="return false;"> <br />
<br />
<input type="HIDDEN" name="Hunt_Password" size="24" Value="<%=Hunt_Password%>"><br />
<input type="HIDDEN" name="OldHunt_Id" size="24" Value="<%=Hunt_Id%>"><br />
<input type="Submit" value="First Page" onClick=" <br />
self.location.href = 'http://www.webdeveloper.com/forum/archive/index.php/<%=Session("Page")%> ?Page=1'; <br />
return true;"><br />
<input type="Submit" value="Prev Page" onClick=" <br />
self.location.href = 'http://www.webdeveloper.com/forum/archive/index.php/<%=Session("Page")%>?Page=<%=(curPage-1)%>'; <br />
return true;"> <br />
<input type="Submit" value="Next Page" onClick="self.location.href = <!-- m --><a class="postlink" href="http://www.webdeveloper.com/forum/archive/index.php/">http://www.webdeveloper.com/forum/archive/index.php/</a><!-- m --><br />
'<%=Session("Page")%>?Page=<%=(curPage+1)%>'; <br />
return true;"> <br />
<input type="submit" value="Last Page" onClick="<br />
self.location.href = 'http://www.webdeveloper.com/forum/archive/index.php/<%=Session("Page")%>?Page=<%=numPages%>';return true;"> <br />
</form> <br />
<br />
<br />
<form NAME="Back_TO_Main" METHOD="POST" ACTION="LoggedMainPics.asp"><br />
<input type="hidden" name="Hunt_Password" size="24" Value="<%=Hunt_Password%>"><br />
<br />
<input type="hidden" name="OldHunt_Id" size="24" Value="<%=Hunt_Id%>">GO BACK<br />
TO THE MAIN MENU <input type="submit" value="GO" name="backview"><br />
</form><!--content-->heh, thanks, good idea, maybe somethings in life are easier than they seem.<br />
<br />
Alex<!--content-->ok putting a table inside the table didn't work it just grows with the other table, unless there is a way to make it a fixed length? I hate html, sort of.<!--content-->view stories<br />
<br />
can't see a link for that anywhere <!--content-->okay...<br />
<br />
first of all... <br />
you double-posted (htlm forum also)<br />
<br />
second...<br />
the link that you provide doesn't have a "view stories" link.<br />
I think that might be because you have some password accessed page that leads to that link (?). <br />
Just one suggestion on that: If you don't need a password protected area (and I mean really need), then don't use one just for the sake of having one.<br />
<br />
third...<br />
your site looks vastly different for cross-browser viewing (maybe you don't care... but I'm just telling you).<br />
<br />
Lastly...<br />
without an actual view of the data-generated table itself, it's tough to say... but you may need to "break-apart" some fields and place them below (or in a different link) in order to display all of the information.<br />
<br />
You really need to provide a link to the data if you want further help. <br />
So... the balls in your court.<br />
<br />
and... you may want to re-design the menu/frame thing. It is very inconsistent and sometimes redundant on some pages (and have you ever seen your site in a Netscape or Opera browser?).<br />
<br />
I'm not trying to be critical... but you asked for help on something... and there are other areas that need help as well. It's all do-able, so... we'll deal with each item as we go.<br />
<br />
First priority... we need the correct link to the data.<br />
<br />
k<!--content-->Originally posted by Calmaris <br />
I have a page that displays the contents of a record in a database that when displayed, if the contents are very long it stretches the table's length across the whole page and looks very ugly how do you set the table so that it only expands downward not across.<br />
<br />
I checked the html section and no one has an answer, can this be in asp using vbcrlf or something? <br />
Your editing, it seems needs to be done in the (I have a page that displays the contents of a record). Try doing the table thing in there, that was suggested.<!--content-->y'know... actually - after looking at your code - I see that you have not declared a column width (table width, yes... column width no).<br />
<br />
I'm curious...<br />
And I see that - aside form apparently speaking to... and answering yourself - you also say "I hate html, sort of".<br />
<br />
HTML?<br />
You hate HTML?<br />
Do you know HTML?<br />
(Hate? javascript, yeah. SQL, sure. ASP, ok. But HTML.... ????)<br />
Does anybody really hate HTML???!!!<br />
<br />
I'd be happy to help you Calmaris... but what are we dealing with here?<br />
<br />
Please provide a link to that data.<br />
I will try to create a table for you.<br />
<br />
(your freaking me out y'know. Hate html??? whew!!!)<br />
<br />
k<!--content-->You say:<br />
<br />
click on view stories if the user doesn't press enter then it does one line across the whole web page,<br />
<br />
That is not very clear. clicking on view stories I suppose opens another page. Where does pressing enter come to play? and if you didn't press enter, it is source that you see or the actual Data. I am thinking of something small concerning that link to the page.<!--content-->Maybe the answer was given in the other thread. But what kind of data with no spaces could it be to stretch the table besides code? Images weren't mentioned<!--content-->i figured it out i just used word wrap, your supposed to click on the events button on the top and click on view stories, the logon is for people to be able to add stories comments, etc. and because there is an admin section to maintain the databases. lol and no i don't hate Html it was the thought of the moment. it all works goog for now, thx for critism. lol not what i expected, thx.<br />
<br />
Alex<!--content-->