Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - A dumb question
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

A dumb question

 Post Reply Post Reply
Author
ziwez0 View Drop Down
Groupie
Groupie


Joined: 15 July 2002
Location: United Kingdom
Status: Offline
Points: 144
Post Options Post Options   Thanks (0) Thanks(0)   Quote ziwez0 Quote  Post ReplyReply Direct Link To This Post Topic: A dumb question
    Posted: 24 September 2003 at 2:34am
Im having problems setting the size of my tables,
im using asp response.write method  to create the tables, but the width i can get to work but the height is just being a stubborn muel
have a look at the code and tell me where im goning wrong..please



<TABLE border=1 height="400" WIDTH="350"  CELLPADDING=0 CELLSPACING=0 bordercolor=red>
<td width="4"></td><td>

<%
Dim strLocation


function getLocation(olocation)
 Select Case olocation
 case "11"
 If Instr(strLocation," 11#")=0 Then
    strLocation=strLocation & " 11#"
    getLocation="Marsa Alam"
 End If
 case "33"
 If Instr(strLocation," 33#")=0 Then
    strLocation=strLocation & " 33#"
    getLocation="Sharm El Sheikh"
end if
 case "22"
 If Instr(strLocation," 22#")=0 Then
  strLocation=strLocation & " 22#"
  getLocation="Liveaboards"
  End If
 End Select
End function


Dim Conn, dbPath
dbPath = Server.MapPath("/demo/db/SpecialOffersDB.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE=" & dbPath

Set UserRecordset = Server.CreateObject("ADODB.Recordset")
sqlstring = "select * from Special02 order by location"


UserRecordset.Open sqlstring, conn

While NOT UserRecordset.EOF
objid = UserRecordset("IDKEY")
objLocation = UserRecordSet("Location")
objDate = UserRecordSet("Date-d")
objhotel = UserRecordSet("hotel")
objdesc = UserRecordSet("desc")
objcost = UserRecordSet("cost")
objuser = UserRecordSet("user")


 
   Response.Write "<table border='1' bordercolor='black' height='100' width='300'><tr><td height='10'><u>< ;b><h3>" & getLocation (objLocation) & "</h3></u></b></td><TD> &nbsp;</TD><TD>&nbsp;</TD></tr& gt;"
   Response.Write "<tr><td height='15'><u><b><h5&g t;" & objDATE & "</h5></u></b></td><TD> &nbsp;</TD><TD>&nbsp;</TD></tr& gt;"
  Response.Write "<tr><td class='spechoteldesc'>" & objhotel & "</td><td class='spechoteldesc'>" & objdesc & "</td><td class='specCost'><b>" & objcost & "</b></td></tr></table>"
 
    UserRecordset.MoveNext
wend
UserRecordset.Close : Set UserRecordset=nothing
conn.close : Set conn=nothing
%>

</td></tr>
</table>

(if you see "& gt;" just ignore, their is a problem uploading exactley what ive typed)



Edited by ziwez0
If anything takes long to do its worth doing.
Back to Top
ziwez0 View Drop Down
Groupie
Groupie


Joined: 15 July 2002
Location: United Kingdom
Status: Offline
Points: 144
Post Options Post Options   Thanks (0) Thanks(0)   Quote ziwez0 Quote  Post ReplyReply Direct Link To This Post Posted: 24 September 2003 at 3:21am
its ok ive sorted it, it hates <h1></h1> <h5></h5> etc

Edited by ziwez0
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.