Solved

CSS/ASP

Posted on 2010-09-15
18
238 Views
Last Modified: 2012-05-10
I am sure I have just overlooked something very simple...but I can't get the CSS fixed so the left column is at the top.  I need not only to fix it, but to know what I missed...if possible...


www.shipfish2u.com/productCatalogeditor/dashboard_worksheet.asp  The CSS file is below
@charset "utf-8";

body  {

	font: 100% Verdana, Arial, Helvetica, sans-serif;

	background: #666666;

	margin: 0; 

	padding-top: 20px;

	text-align: center; 

	color: #000000;

}





.twoCol #container { 

	width: 80em; 

	min-height: 70em;

	background: #FFFFFF;

	padding-top: 30px;

	margin: 0 auto;

	border: 1px solid #000000;

	text-align: left; 

} 





.twoCol #sidebar1 {

	float: right; 

	width: 30em;

	height: 50em;

	overflow: auto;

	background: #0FF;

	margin: 35px 10px 0 0;

	padding: 25px 0; 

}



.twoCol #sidebar1 h3, .twoCol #sidebar1 p {

	margin-left: 10px; 

	margin-right: 10px;

}





.twoCol #mainContent {

	margin: 0 1.5em 0 1.5em; 

}  



.view-img img { display: none; }

.view-img:hover img { position: absolute; display: block; 

}



.fltrt { 

	float: right;

	margin-left: 8px;

}

.fltlft { 

	float: left;

	margin-right: 8px;

}

.clearfloat { 

	clear:both;

    height:0;

    font-size: 1px;

    line-height: 0px;

}



a:link  {

	color:#000;

	font-size:12px;

	text-decoration: none;

}

a:hover {

	color:#000;

	font-weight: bold;

	font-size:12px;

	text-decoration: none;

}

a:active  {

	color:#0200ff;

	text-decoration: none;

}

a:visited  {

	color:#ff0000;	

	text-decoration:none;

}

Open in new window

0
Comment
Question by:akbiro
  • 9
  • 8
18 Comments
 
LVL 28

Expert Comment

by:strickdd
ID: 33684124
It looks to me like what you want is to put the <div id="sidebar1">...</div> AFTER the <div id="mainContent">...</div> and then remove the "float:right;" from #sidebar1
0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33684501
Your CSS rule for BODY has a padding-top of 20px and your #container has a padding-top of 30px so the left column is going to be at least 50px away from the top edge of the window.

Your site looks OK in Firefox, but the left column is being forced down by the right column in IE. You are rendering your site in Quirks mode because you have a meta tag before your DOCTYPE. Get this one fixed, and try and standardise your site across browsers.

The reason the column is being pushed down is because of your widths. You have set the container to a width of 80em and the right column to a width of 30em, leaving 50em (less margins, padding, border) for the left column, but in the left column you are specifying a fixed width for the tables - this fixed width is too wide to fit in the space, and so it forces down, below the right column.






0
 

Author Comment

by:akbiro
ID: 33686332
Ok...I got everything you said and made the changes and it is looking better.  What I do not understand it the information in the header.  Not sure what I need to remove and from where.  Thanks

Your site looks OK in Firefox, but the left column is being forced down by the right column in IE. You are rendering your site in Quirks mode because you have a meta tag before your DOCTYPE. Get this one fixed, and try and standardise your site across browsers.
0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33687022
@akbiro,

If you look at the source code of your page, you will see a <meta> tag BEFORE the DOCTYPE. Meta tags should go in the <head> section of your page.

You are already including that particular meta tag in your head so you just need to delete the line before DOCTYPE.



//This meta tag line needs deleting...

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>ShipFish2U-Product List)</title>

<link href="dashboard.css" rel="stylesheet" type="text/css" />

Open in new window

0
 

Author Comment

by:akbiro
ID: 33690316
Very cool...it helped, but it still doesn't work in IE.  It works perfectly in my Dreamweaver editor, but not IE.
0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33690449

//Your code looks like this

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />



"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>





//It should look like this

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

Open in new window

0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33690455
Hmm, for some reason my comments weren't posted.

The head of your document is still wrong. If you open you site in a brower and then view the source, you should see what I mean.

Your site is rendering in Quirks mode in IE, so until that is fixed there's no point in trying to debug anything else.

Get that sorted and then come back if you still have a problem.

0
 

Author Comment

by:akbiro
ID: 33690481
I hope you will keep patience with me...but I am still missing something.
<!--#include file="cons.asp"-->



<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<%' The above file is our Connection to our datebase.

' Below is all the code that is needed in order to retrieve our data from our Database.

Set getAllSQL = CreateObject("ADODB.Command")

getAllSQL.ActiveConnection=objConn

getAllSQL.Prepared = true

getAllSQL.Commandtext = "select * from products order by id DESC"



set objRs = getAllSQL.execute



if request.QueryString("Update") then ' Looks at the QueryString, if present, then continue

Set getSQL = CreateObject("ADODB.Command") ' Creates our Command Object

getSQL.ActiveConnection=objConn ' Gets our Connection

getSQL.Prepared = true ' Stores the CommandText for future use (To retrieve the records faster)

getS = int(Request.QueryString("Update")) ' Looks at the QueryString, if present, then we will use it against our database

getSQL.Commandtext = "SELECT ID, pdate, pname, pSubname, hide, lPrice1, lPrice2, lPrice3, lPriceText, mprice1, mprice2, mprice3, mPriceText, sPrice1, sPrice2, sPrice3, sPriceText, lthumb, limg, lzoomimg, mthumb, mimg, mzoomImg, sthumb, simg, szoomimg, tag, tagColor, category, description  FROM products where ID=?" ' Always list these in order as they appear.



'********************************************************************* - experts-exchange - samic400

'modified this section - you have no reference to adovbs.inc so that wouldn't find those parms

'********************************************************************* - experts-exchange - samic400

getSQL.Parameters.Append getSQL.CreateParameter("@ID", 3, 1, , getS)



getSQL.Parameters.Append getSQL.CreateParameter("@ID", adInteger, adParamInput, , getS)' Parameters will help with the prevention of SQL INJECTION, Get use to using this, it will save your site and maybe even your job one day.

set UpdateRs = getSQL.execute ' We set our RecordSet here, so there i no need to use the CreateObject.

if not UpdateRs.eof then ' If there are any records we will continue on to the next line, if the db is empty then we stop.

ID = int(UpdateRs("ID")) ' Gets the ID

pdate = trim(UpdateRs("pdate")) '

pName = trim(UpdateRs("pname")) ' 

pSubName = trim(UpdateRs("pSubName")) ' 

Hide = trim(UpdateRs("hide")) '

lPrice1 = trim(UpdateRs("lPrice1")) ' 

lPrice2 = trim(UpdateRs("lPrice2")) ' 

lPrice3 = trim(UpdateRs("lPrice3")) '

lPriceText = trim(UpdateRs("lPriceText")) ' 

mprice1 = trim(UpdateRs("mprice1")) ' 

mprice2 = trim(UpdateRs("mprice2")) ' 

mprice3 = trim(UpdateRs("mprice3")) '

mPriceText = trim(UpdateRs("mpriceText")) ' 

sPrice1 = trim(UpdateRs("sPrice1")) ' 

sPrice2 = trim(UpdateRs("sPrice2")) ' 

sPrice3 = trim(UpdateRs("sPrice3")) '

sPriceText = trim(UpdateRs("sPriceText")) ' 

lThumb = trim(UpdateRs("lthumb")) ' 

limg = trim(UpdateRs("limg")) ' 

lZoomImg = trim(UpdateRs("lzoomImg")) '

mThumb = trim(UpdateRs("mthumb")) ' 

mimg = trim(UpdateRs("mimg")) ' 

mZoomImg = trim(UpdateRs("mzoomImg")) ' 

sThumb = trim(UpdateRs("sthumb")) ' 

simg = trim(UpdateRs("simg")) ' 

sZoomImg = trim(UpdateRs("szoomImg")) '

Tag = trim(UpdateRs("tag")) ' 

tagColor = trim(UpdateRs("tagColor")) ' 

Category = trim(UpdateRs("category")) ' 

getdescription = trim(UpdateRs("description"))

' To read the information back into the Memofield (Textarea) we have to format it and strip the tags from it.

MyInfo = replace(MyInfo,"''","'")' Replace the Quote with the Single Quote

MyInfo = replace(MyInfo,"<br />",vblf)' Replace the <br /> with the orignal vblf

end if ' end it here

end if ' end it here

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<title>ShipFish2U-Product List)</title>

<link href="dashboard.css" rel="stylesheet" type="text/css" />

<!-- TinyMCE -->

<script type="text/javascript" src="/productCatalogeditor/jscripts/tiny_mce/tiny_mce.js"></script>

<script type="text/javascript">

	tinyMCE.init({

		// General options

		mode : "textareas",

		theme : "advanced",

		plugins : "pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave",



		// Theme options

		theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",

		theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",

		theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",

		theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft",

		theme_advanced_toolbar_location : "top",

		theme_advanced_toolbar_align : "left",

		theme_advanced_statusbar_location : "bottom",

		theme_advanced_resizing : true,



		// Example content CSS (should be your site CSS)

		content_css : "css/content.css",



		// Drop lists for link/image/media/template dialogs

		template_external_list_url : "lists/template_list.js",

		external_link_list_url : "lists/link_list.js",

		external_image_list_url : "lists/image_list.js",

		media_external_list_url : "lists/media_list.js",



		// Style formats

		style_formats : [

			{title : 'Bold text', inline : 'b'},

			{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},

			{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},

			{title : 'Example 1', inline : 'span', classes : 'example1'},

			{title : 'Example 2', inline : 'span', classes : 'example2'},

			{title : 'Table styles'},

			{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}

		],



		// Replace values for the template plugin

		template_replace_values : {

			username : "Some User",

			staffid : "991234"

		}

	});

</script>

<!-- /TinyMCE -->

</head>



<body class="twoCol">



<div id="container">



      <div id="sidebar1">

    

<table style="width:400px;">

<caption>List of all the records to update</caption>

  <tr>

    <td class="MyTdTop">ID</td>

    <td class="MyTdTop">pName</td>

    <td class="MyTdTop">hide</td>

  </tr>

   <%While Not objRs.EOF%>

  <tr>

 

    <td class="MyTd"><%=objRS("ID")%></td>

    <td class="MyTd"><a href="dashboard_worksheet.asp?update=<%=objRS("ID")%>"><%=objRS("PName")%></a></td>

    <td class="MyTd"><a href="dashboard_worksheet.asp?update=<%=objRS("ID")%>"><%=objRS("hide")%></a></td>

  </tr>

  

  <%' Always close out of your RecordSets and your DB Connection after you are finished with them, and no longer ar in need of them.

    objRs.MoveNext

    Wend

   

%>

</table>

    

    

    </div>





  <div id="mainContent">                  

    <%if request.QueryString("Update") then%>

<form action="setRecords.asp" method="post">

<table width="500">

<tr><td colspan="2"  class="MyTdTop">Update an existing Record in a Database</td></tr>

<input name="ID" type="hidden" value="<%=getS%>" />



<tr><td class="MyTd" width="300">Date Entered</td><td width="200"><input name="pdate" type="text" value="<%=pDate%>" size="24" /></td></tr>



<tr><td class="MyTd" width="300">Scientific Name</td><td width="200"><input name="pname" type="text" value="<%=pName%>" size="40" /></td></tr>



<tr><td class="MyTd">Common Name</td><td width="200"><input name="pSubName" type="text" value="<%=pSubName%>" size="40" /></td></tr>



<tr><td class="MyTd">Hide</td><td><input name="hide" type="form" value="<%=hide%>" /></td></tr>

<tr><td class="MyTd">Lg Price1</td><td><input name="lPrice1" type="text" value="<%=lPrice1%>" /></td></tr>

<tr><td class="MyTd">Lg Price2</td><td><input name="lPrice2" type="text" value="<%=lPrice2%>" /></td></tr>

<tr>

  <td class="MyTd">Lg Price3</td><td><input name="lPrice3" type="text" value="<%=lPrice3%>" /></td></tr>

<tr>

  <td class="MyTd">Lg Price Text</td><td><input name="lPriceText" type="text" value="<%=lPriceText%>" /></td></tr>



<tr>

  <td class="MyTd">Med Price1</td><td><input name="mprice1" type="text" value="<%=mprice1%>" /></td></tr>

<tr>

  <td class="MyTd">Med Price2</td><td><input name="mPrice2" type="text" value="<%=mPrice2%>" /></td></tr>

<tr>

  <td class="MyTd">Med Price3</td><td><input name="mPrice3" type="text" value="<%=mPrice3%>" /></td></tr>

<tr>

  <td class="MyTd">Med Price Text</td><td><input name="mpriceText" type="text" value="<%=mpriceText%>" /></td></tr>



<tr>

  <td class="MyTd">Sm Price1</td><td><input name="sPrice1" type="text" value="<%=sPrice1%>" /></td></tr>

<tr>

  <td class="MyTd">Sm Price2</td><td><input name="sPrice2" type="text" value="<%=sPrice2%>" /></td></tr>

<tr>

  <td class="MyTd">Sm Price3</td><td><input name="sPrice3" type="text" value="<%=sPrice3%>" /></td></tr>

<tr>

  <td class="MyTd">Sm Price Text</td><td><input name="sPriceText" type="text" value="<%=sPriceText%>" /></td></tr>





<tr><td class="MyTd">Large</td>

<td><a href="#" class="view-img">View Lg Thumb<img src="/img/<%=lthumb%>" "100" height="67" /></a></td></tr>

<tr><td></td><td><input name="lthumb" type="text" value="<%=lthumb%>" width="100" height="67"/></td>

</tr>

<tr><td class="MyTd">Large</td>

<td><a href="#" class="view-img">View Lg Image<img src="/img/<%=limg%>" "265" height="176" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="limg" type="text" value="<%=limg%>" width="260" height="173" /></td>

</tr>

<tr>

<td class="MyTd">Large</td>

<td><a href="#" class="view-img">View Lg 500<img src="/img/<%=lzoomImg%>" "500" height="365" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="lzoomImg" type="text" value="<%=lzoomImg%>" width="500" height="365"/></td>

</tr>



<tr><td class="MyTd">Medium</td>

<td><a href="#" class="view-img">View Med Thumb<img src="/img/<%=mthumb%>" "100" height="67" /></a> </td></tr>

<tr><td></td><td><input name="mthumb" type="text" value="<%=mthumb%>" width="100" height="67"/></td>

</tr>

<tr><td class="MyTd">Medium </td>

<td><a href="#" class="view-img">View Med Image<img src="/img/<%=mimg%>" "260" height="173" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="mimg" type="text" value="<%=mimg%>" width="260" height="173" /></td>

</tr>

<tr>

<td class="MyTd">Medium </td>

<td><a href="#" class="view-img">View Med 500<img src="/img/<%=mzoomImg%>" "500" height="365" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="mzoomImg" type="text" value="<%=mzoomImg%>" width="500" height="365"/></td>

</tr>



<tr><td class="MyTd">Small</td>

<td><a href="#" class="view-img">View Sm Thumb<img src="/img/<%=sthumb%>" "100" height="67" /></a> </td></tr>

<tr><td></td><td><input name="sthumb" type="text" value="<%=sthumb%>" width="100" height="67"/></td>

</tr>

<tr><td class="MyTd">Small</td>

<td><a href="#" class="view-img">View Sm Image<img src="/img/<%=simg%>" "260" height="173" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="simg" type="text" value="<%=simg%>" width="260" height="173" /></td>

</tr>

<tr>

<td class="MyTd">Small </td>

<td><a href="#" class="view-img">View Sm 500 Image<img src="/img/<%=szoomImg%>" "500" height="365" /></a></td>

</tr></tr>

<tr><td></td><td><input name="szoomImg" type="text" value="<%=szoomImg%>" width="500" height="365"/></td>

</tr>



<tr><td class="MyTd">Tag</td><td><input name="tag" type="text" value="<%=tag%>" /></td></tr>

<tr><td class="MyTd">Tag Color</td><td><input name="tagColor" type="text" value="<%=tagColor%>" /></td></tr>

<tr><td class="MyTd">Category</td><td><input name="category" type="text" value="<%=category%>" /></td></tr>

<tr><td class="MyTd">Description Text</td><td><textarea name="description" cols="50" rows="10"><%=getdescription%></textarea></td></tr>

<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Update" /></td></tr>

</table></form>

<a href="dashboard_worksheet.asp">Go back to Insert (or) Delete Records</a>

<%else%>



<form action="setRecords.asp" method="post">

<table width="492">

<tr><td colspan="2"  class="MyTdTop">Insert a New Record into the Database</td></tr>

<input type="hidden" name="MyRecord" value="Insert" />

<tr><td width="110" class="MyTd"><p>Date Entered</p>

  <p>YYYY-MM-DD</p></td><td width="344"><input name="pdate" type="text" size="40" /></td></tr>

<tr>

  <td width="110" class="MyTd">Scientific Name</td><td width="344"><input name="pname" type="text" size="40" /></td></tr>

<tr><td width="110" class="MyTd">Common Name</td><td width="344"><input name="pSubName" type="text" size="40" /></td></tr>

<tr><td height="33" class="MyTd">Hide</td><td><input name="hide" type="checkbox" value="true"  />

  (check to hide)</td></tr>

<tr><td></td>

<td><hr />



</td></tr>  

<tr>

  <td class="MyTd">Lg Price 1</td><td><input name="lPrice1" type="text" /></td></tr>

<tr>

  <td class="MyTd">Lg Price 2</td><td><input name="lPrice2" type="text" /></td></tr>

<tr>

  <td class="MyTd">Lg Price 3</td><td><input name="lPrice3" type="text" /></td></tr>

<tr>

  <td class="MyTd">Lg Price Text</td><td><input name="lPriceText" type="text" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Med Price 1</td><td><input name="mprice1" type="text" /></td></tr>

<tr>

  <td class="MyTd">Med Price 2</td><td><input name="mPrice2" type="text" /></td></tr>

<tr>

  <td class="MyTd">Med Price 3</td><td><input name="mPrice3" type="text" /></td></tr>

<tr>

  <td class="MyTd">Med Price Text</td><td><input name="mpriceText" type="text" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Sm Price 1</td><td><input name="sPrice1" type="text" /></td></tr>

<tr>

  <td class="MyTd">Sm Price 2</td><td><input name="sPrice2" type="text" /></td></tr>

<tr>

  <td class="MyTd">Sm  Price 3</td><td><input name="sPrice3" type="text" /></td></tr>

<tr>

  <td class="MyTd">Sm Price Text</td><td><input name="sPriceText" type="text" /></td></tr>



<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Lg Thumb Image</td><td><input name="lthumb" type="file" /></td></tr>

<tr>

  <td class="MyTd">Lg Image</td><td><input name="limg" type="file" /></td></tr>

<tr>

  <td class="MyTd">Lg Image 500</td><td><input name="lzoomImg" type="file" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Med Thumb Image</td><td><input name="mthumb" type="file" /></td></tr>

<tr>

  <td class="MyTd">Med Image</td><td><input name="mimg" type="file" /></td></tr>

<tr>

  <td class="MyTd">Med Image 500</td><td><input name="mzoomImg" type="file" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Sm Thumb Image</td><td><input name="sthumb" type="file" /></td></tr>

<tr>

  <td class="MyTd">Sm Image</td><td><input name="simg" type="file" /></td></tr>

<tr>

  <td class="MyTd">Sm Image 500</td><td><input name="szoomImg" type="file" /></td></tr>





<tr><td></td>

<td><hr />



</td></tr>



<tr><td class="MyTd">Tags</td><td><p>

  <label>

    <input type="radio" name="Tags" value="farm" id="RadioGroup1_0" />

    Farm</label>

  <br />

  <label>

    <input type="radio" name="Tags" value="wild" id="RadioGroup1_1" />

    Wild</label>

  <br />

  <label>

    <input type="radio" name="Tags" value="f1" id="RadioGroup1_2" />

    F1</label>

     <label>

   <br />

    <input type="radio" name="Tags" value="tank" id="RadioGroup1_2" />

    Tank</label>

   <br />

     <label>

    <input type="radio" name="Tags" value="potted" id="RadioGroup1_2" />

    Potted</label>

  <br />

   <label>

    <input type="radio" name="Tags" value="show" id="RadioGroup1_2" />

    Show</label>

  <br />

<tr><td></td>

<td><hr />

<tr><td class="MyTd">Tag Color</td><td>

  <label>

    <input type="radio" name="tagColor" value="#00FF00" id="RadioGroup2_0" />

    Green-Farm</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#000000" id="RadioGroup2_1" />

    Black-Wild</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#FF0000" id="RadioGroup2_2" />

    Red-F1</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#0200ff" id="RadioGroup2_3" />

    Blue-Tank</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#ff00fd" id="RadioGroup2_4" />

    Pink-Potted</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#FDC504" id="RadioGroup2_5" />

    Gold-Show</label>

  <br />

</td></tr>

<tr><td></td>

<td><hr />

<tr><td class="MyTd">Category</td><td>

  <label>

    <input type="radio" name="Category" value="malawi" id="Category_0" />

    Malawi (malawi)</label>

  <br />

  <label>

    <input type="radio" name="Category" value="tang" id="Category_1" />

    Tanganyikan (tang)</label>

  <br />

  <label>

    <input type="radio" name="Category" value="africa_other" id="Category_2" />

    African & other (africa_other)</label>  

  <br />

  <label>

    <input type="radio" name="Category" value="s_c_american" id="Category_3" />

    So & Cen American (s_c_american)</label><br />

  <label>

    <input type="radio" name="Category" value="pleco_other" id="Category_4" />

    Plecos & other (pleco_other)</label>

  <br />

  <label>

    <input type="radio" name="Category" value="plants" id="Category_5" />

    Plants (plants)</label><br />

    <label>

    <input type="radio" name="Category" value="koiGold" id="Category_6" />

    Koi & Goldfish (koiGold)</label><br />

     <label>

    <input type="radio" name="Category" value="new" id="Category_7" />

    New (new)</label>

  <br />

 

</td></tr>



<tr><td></td>



<td><hr />

<tr><td class="MyTd">Information</td><td><textarea id="elm1" name="description2" rows="15" cols="80" style="width: 100%"></textarea></td></tr>

<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Insert" /></td></tr>

</table></form>





	

<form action="setRecords.asp" method="post">

<table>

<tr><td colspan="2"  class="MyTdTop">Delete a Record in a Database</td></tr>

<input type="hidden" name="MyRecord" value="Delete" />

<tr><td class="MyTd">Choose Record</td><td>

<%'We are going to get the Values from the database and put them in a Dropdown (ListMenu) and so we can choose the item that we want to Delete%>

<select name="DelCom" style="font: 8pt verdana;">

<option value="">Choose a Record</option>

<%

objRs.MoveFirst                                                        

While (NOT objRs.EOF)

%>

<option value="<%=objRs("ID")%>"><%=objRs("id")&" "&objRs("pname")%></option>

<%

  objRs.MoveNext

Wend

%>

</select></td></tr>

<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Delete" /></td></tr>

</table></form>

<%End if%>

<br />



  

  <%' Always close out of your RecordSets and your DB Connection after you are finished with them, and no longer ar in need of them.

    

    objRs.Close

    Set objRs=Nothing

      objConn.close

      set objConn = nothing

%>

</table>



  </div>





      

</div>





</body>

</html>

Open in new window

0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33690549
In your code above, delete line 3.


0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:akbiro
ID: 33690575
Ok...but no joy
0
 

Author Comment

by:akbiro
ID: 33690695
Is there a simple way to take the textarea at the bottom and make it a footer <div> and then reduce the width of the left sidebar?  Would that clean up the page?
0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33690748
Right, now we can fix the issue.
 
 As I said earlier, the width of your columns are causing the problem.
 
 Your outer container is 60ems wide. Your right hand column is 25ems wide  - this leaves 35ems for the left column (table). You've set your table  width to 492px which would normally work fine, but the in your table you  have the TinyMCE editor, which is forcing the table to be wider than  the 492px. This won't fit in the 35em space you've got for the left  column, so it has to force it down below the right column. Does that  makes sense ?

I would recommend you take the tinyMCE out of the left column table. This will allow the left column to fit in the space.


0
 

Author Comment

by:akbiro
ID: 33690870
I think this is gonna work...I have to run out for a sec...I will return...finish and he back to you.  THANKS
0
 

Author Comment

by:akbiro
ID: 33692454
I can't figure it out...it is all screwed up now.  Fine in the add/create mode, falls completely apart in the change mode.  I have no clue what to do now.
0
 
LVL 42

Expert Comment

by:Chris Stanyon
ID: 33692645
All you need to do is close off one table before the TextArea, and put that in it's own table.

Not sure what you mean by add / create / change

// Currently your code look like this (lines 419-421 in your post)

<tr><td></td>



<td><hr />





//Change it so it looks like this.

</table>

<table>

<tr><td></td><td><hr /></td></tr>

Open in new window

0
 

Author Comment

by:akbiro
ID: 33695645
Can I post my code again and you can tell me where and how...I am lost

Can you look at it again.  I am sorry I am so dense...

http://www.shipfish2u.com/productCatalogeditor/dashboard_worksheet.asp
<!--#include file="cons.asp"-->



<%' The above file is our Connection to our datebase.

' Below is all the code that is needed in order to retrieve our data from our Database.

Set getAllSQL = CreateObject("ADODB.Command")

getAllSQL.ActiveConnection=objConn

getAllSQL.Prepared = true

getAllSQL.Commandtext = "select * from products order by id DESC"



set objRs = getAllSQL.execute



if request.QueryString("Update") then ' Looks at the QueryString, if present, then continue

Set getSQL = CreateObject("ADODB.Command") ' Creates our Command Object

getSQL.ActiveConnection=objConn ' Gets our Connection

getSQL.Prepared = true ' Stores the CommandText for future use (To retrieve the records faster)

getS = int(Request.QueryString("Update")) ' Looks at the QueryString, if present, then we will use it against our database

getSQL.Commandtext = "SELECT ID, pdate, pname, pSubname, hide, lPrice1, lPrice2, lPrice3, lPriceText, mprice1, mprice2, mprice3, mPriceText, sPrice1, sPrice2, sPrice3, sPriceText, lthumb, limg, lzoomimg, mthumb, mimg, mzoomImg, sthumb, simg, szoomimg, tag, tagColor, category, description  FROM products where ID=?" ' Always list these in order as they appear.



'********************************************************************* - experts-exchange - samic400

'modified this section - you have no reference to adovbs.inc so that wouldn't find those parms

'********************************************************************* - experts-exchange - samic400

getSQL.Parameters.Append getSQL.CreateParameter("@ID", 3, 1, , getS)



getSQL.Parameters.Append getSQL.CreateParameter("@ID", adInteger, adParamInput, , getS)' Parameters will help with the prevention of SQL INJECTION, Get use to using this, it will save your site and maybe even your job one day.

set UpdateRs = getSQL.execute ' We set our RecordSet here, so there i no need to use the CreateObject.

if not UpdateRs.eof then ' If there are any records we will continue on to the next line, if the db is empty then we stop.

ID = int(UpdateRs("ID")) ' Gets the ID

pdate = trim(UpdateRs("pdate")) '

pName = trim(UpdateRs("pname")) ' 

pSubName = trim(UpdateRs("pSubName")) ' 

Hide = trim(UpdateRs("hide")) '

lPrice1 = trim(UpdateRs("lPrice1")) ' 

lPrice2 = trim(UpdateRs("lPrice2")) ' 

lPrice3 = trim(UpdateRs("lPrice3")) '

lPriceText = trim(UpdateRs("lPriceText")) ' 

mprice1 = trim(UpdateRs("mprice1")) ' 

mprice2 = trim(UpdateRs("mprice2")) ' 

mprice3 = trim(UpdateRs("mprice3")) '

mPriceText = trim(UpdateRs("mpriceText")) ' 

sPrice1 = trim(UpdateRs("sPrice1")) ' 

sPrice2 = trim(UpdateRs("sPrice2")) ' 

sPrice3 = trim(UpdateRs("sPrice3")) '

sPriceText = trim(UpdateRs("sPriceText")) ' 

lThumb = trim(UpdateRs("lthumb")) ' 

limg = trim(UpdateRs("limg")) ' 

lZoomImg = trim(UpdateRs("lzoomImg")) '

mThumb = trim(UpdateRs("mthumb")) ' 

mimg = trim(UpdateRs("mimg")) ' 

mZoomImg = trim(UpdateRs("mzoomImg")) ' 

sThumb = trim(UpdateRs("sthumb")) ' 

simg = trim(UpdateRs("simg")) ' 

sZoomImg = trim(UpdateRs("szoomImg")) '

Tag = trim(UpdateRs("tag")) ' 

tagColor = trim(UpdateRs("tagColor")) ' 

Category = trim(UpdateRs("category")) ' 

getdescription = trim(UpdateRs("description"))

' To read the information back into the Memofield (Textarea) we have to format it and strip the tags from it.

MyInfo = replace(MyInfo,"''","'")' Replace the Quote with the Single Quote

MyInfo = replace(MyInfo,"<br />",vblf)' Replace the <br /> with the orignal vblf

end if ' end it here

end if ' end it here

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<title>ShipFish2U-Product List)</title>

<link href="dashboard.css" rel="stylesheet" type="text/css" />

<!-- TinyMCE -->

<script type="text/javascript" src="/productCatalogeditor/jscripts/tiny_mce/tiny_mce.js"></script>

<script type="text/javascript">

	tinyMCE.init({

		// General options

		mode : "textareas",

		theme : "advanced",

		plugins : "pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave",



		// Theme options

		theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",

		theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",

		theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",

		theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft",

		theme_advanced_toolbar_location : "top",

		theme_advanced_toolbar_align : "left",

		theme_advanced_statusbar_location : "bottom",

		theme_advanced_resizing : true,



		// Example content CSS (should be your site CSS)

		content_css : "css/content.css",



		// Drop lists for link/image/media/template dialogs

		template_external_list_url : "lists/template_list.js",

		external_link_list_url : "lists/link_list.js",

		external_image_list_url : "lists/image_list.js",

		media_external_list_url : "lists/media_list.js",



		// Style formats

		style_formats : [

			{title : 'Bold text', inline : 'b'},

			{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},

			{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},

			{title : 'Example 1', inline : 'span', classes : 'example1'},

			{title : 'Example 2', inline : 'span', classes : 'example2'},

			{title : 'Table styles'},

			{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}

		],



		// Replace values for the template plugin

		template_replace_values : {

			username : "Some User",

			staffid : "991234"

		}

	});

</script>

<!-- /TinyMCE -->

</head>



<body class="twoCol">



<div id="container">



      <div id="sidebar1">

    

<table style="width:400px;">

<caption>List of all the records to update</caption>

  <tr>

    <td class="MyTdTop">ID</td>

    <td class="MyTdTop">pName</td>

    <td class="MyTdTop">hide</td>

  </tr>

   <%While Not objRs.EOF%>

  <tr>

 

    <td class="MyTd"><%=objRS("ID")%></td>

    <td class="MyTd"><a href="dashboard_worksheet.asp?update=<%=objRS("ID")%>"><%=objRS("PName")%></a></td>

    <td class="MyTd"><a href="dashboard_worksheet.asp?update=<%=objRS("ID")%>"><%=objRS("hide")%></a></td>

  </tr>

  

  <%' Always close out of your RecordSets and your DB Connection after you are finished with them, and no longer ar in need of them.

    objRs.MoveNext

    Wend

   

%>

</table>

    

    

    </div>





  <div id="mainContent">                  

    <%if request.QueryString("Update") then%>

    <form action="setRecords.asp" method="post">

<table>

<tr><td colspan="2"  class="MyTdTop">Delete a Record in a Database</td></tr>

<input type="hidden" name="MyRecord" value="Delete" />

<tr><td class="MyTd">Choose Record</td><td>

<%'We are going to get the Values from the database and put them in a Dropdown (ListMenu) and so we can choose the item that we want to Delete%>

<select name="DelCom" style="font: 8pt verdana;">

<option value="">Choose a Record</option>

<%

objRs.MoveFirst                                                        

While (NOT objRs.EOF)

%>

<option value="<%=objRs("ID")%>"><%=objRs("id")&" "&objRs("pname")%></option>

<%

  objRs.MoveNext

Wend

%>

</select></td></tr>

<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Delete" /></td></tr>

</table></form>

<form action="setRecords.asp" method="post">

<table width="500">

<tr><td colspan="2"  class="MyTdTop">Update an existing Record in a Database</td></tr>

<input name="ID" type="hidden" value="<%=getS%>" />



<tr><td class="MyTd" width="300">ID</td><td width="200"><input name="id" type="text" value="<%=id%>" size="24" /></td></tr>

<tr><td class="MyTd" width="300">Date Entered</td><td width="200"><input name="pdate" type="text" value="<%=pDate%>" size="24" /></td></tr>



<tr><td class="MyTd" width="300">Scientific Name</td><td width="200"><input name="pname" type="text" value="<%=pName%>" size="40" /></td></tr>



<tr><td class="MyTd">Common Name</td><td width="200"><input name="pSubName" type="text" value="<%=pSubName%>" size="40" /></td></tr>



<tr><td class="MyTd">Hide</td><td><input name="hide" type="form" value="<%=hide%>" /></td></tr>

<tr><td class="MyTd">Lg Price1</td><td><input name="lPrice1" type="text" value="<%=lPrice1%>" /></td></tr>

<tr><td class="MyTd">Lg Price2</td><td><input name="lPrice2" type="text" value="<%=lPrice2%>" /></td></tr>

<tr>

  <td class="MyTd">Lg Price3</td><td><input name="lPrice3" type="text" value="<%=lPrice3%>" /></td></tr>

<tr>

  <td class="MyTd">Lg Price Text</td><td><input name="lPriceText" type="text" value="<%=lPriceText%>" /></td></tr>



<tr>

  <td class="MyTd">Med Price1</td><td><input name="mprice1" type="text" value="<%=mprice1%>" /></td></tr>

<tr>

  <td class="MyTd">Med Price2</td><td><input name="mPrice2" type="text" value="<%=mPrice2%>" /></td></tr>

<tr>

  <td class="MyTd">Med Price3</td><td><input name="mPrice3" type="text" value="<%=mPrice3%>" /></td></tr>

<tr>

  <td class="MyTd">Med Price Text</td><td><input name="mpriceText" type="text" value="<%=mpriceText%>" /></td></tr>



<tr>

  <td class="MyTd">Sm Price1</td><td><input name="sPrice1" type="text" value="<%=sPrice1%>" /></td></tr>

<tr>

  <td class="MyTd">Sm Price2</td><td><input name="sPrice2" type="text" value="<%=sPrice2%>" /></td></tr>

<tr>

  <td class="MyTd">Sm Price3</td><td><input name="sPrice3" type="text" value="<%=sPrice3%>" /></td></tr>

<tr>

  <td class="MyTd">Sm Price Text</td><td><input name="sPriceText" type="text" value="<%=sPriceText%>" /></td></tr>





<tr><td class="MyTd">Large</td>

<td><a href="#" class="view-img">View Lg Thumb<img src="/img/<%=lthumb%>" "100" height="67" /></a></td></tr>

<tr><td></td><td><input name="lthumb" type="text" value="<%=lthumb%>" width="100" height="67"/></td>

</tr>

<tr><td class="MyTd">Large</td>

<td><a href="#" class="view-img">View Lg Image<img src="/img/<%=limg%>" "265" height="176" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="limg" type="text" value="<%=limg%>" width="260" height="173" /></td>

</tr>

<tr>

<td class="MyTd">Large</td>

<td><a href="#" class="view-img">View Lg 500<img src="/img/<%=lzoomImg%>" "500" height="365" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="lzoomImg" type="text" value="<%=lzoomImg%>" width="500" height="365"/></td>

</tr>



<tr><td class="MyTd">Medium</td>

<td><a href="#" class="view-img">View Med Thumb<img src="/img/<%=mthumb%>" "100" height="67" /></a> </td></tr>

<tr><td></td><td><input name="mthumb" type="text" value="<%=mthumb%>" width="100" height="67"/></td>

</tr>

<tr><td class="MyTd">Medium </td>

<td><a href="#" class="view-img">View Med Image<img src="/img/<%=mimg%>" "260" height="173" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="mimg" type="text" value="<%=mimg%>" width="260" height="173" /></td>

</tr>

<tr>

<td class="MyTd">Medium </td>

<td><a href="#" class="view-img">View Med 500<img src="/img/<%=mzoomImg%>" "500" height="365" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="mzoomImg" type="text" value="<%=mzoomImg%>" width="500" height="365"/></td>

</tr>



<tr><td class="MyTd">Small</td>

<td><a href="#" class="view-img">View Sm Thumb<img src="/img/<%=sthumb%>" "100" height="67" /></a> </td></tr>

<tr><td></td><td><input name="sthumb" type="text" value="<%=sthumb%>" width="100" height="67"/></td>

</tr>

<tr><td class="MyTd">Small</td>

<td><a href="#" class="view-img">View Sm Image<img src="/img/<%=simg%>" "260" height="173" /></a> </td>

</tr></tr>

<tr><td></td><td><input name="simg" type="text" value="<%=simg%>" width="260" height="173" /></td>

</tr>

<tr>

<td class="MyTd">Small </td>

<td><a href="#" class="view-img">View Sm 500 Image<img src="/img/<%=szoomImg%>" "500" height="365" /></a></td>

</tr></tr>

<tr><td></td><td><input name="szoomImg" type="text" value="<%=szoomImg%>" width="500" height="365"/></td>

</tr>



<tr><td class="MyTd">Tag</td><td><input name="tag" type="text" value="<%=tag%>" /></td></tr>

<tr><td class="MyTd">Tag Color</td><td><input name="tagColor" type="text" value="<%=tagColor%>" /></td></tr>

<tr><td class="MyTd">Category</td><td><input name="category" type="text" value="<%=category%>" /></td></tr>

<tr><td class="MyTd">Description Text</td><td><textarea name="description" cols="50" rows="10"><%=getdescription%></textarea></td></tr>

<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Update" /></td></tr>

</table></form>

<a href="dashboard_worksheet.asp">Go back to Insert (or) Delete Records</a>

<%else%>



<form action="setRecords.asp" method="post">

<table width="492">

<tr><td colspan="2"  class="MyTdTop">Insert a New Record into the Database</td></tr>

<input type="hidden" name="MyRecord" value="Insert" />

<tr><td width="110" class="MyTd"><p>Date Entered</p>

  <p>YYYY-MM-DD</p></td><td width="344"><input name="pdate" type="text" size="40" /></td></tr>

<tr>

  <td width="110" class="MyTd">Scientific Name</td><td width="344"><input name="pname" type="text" size="40" /></td></tr>

<tr><td width="110" class="MyTd">Common Name</td><td width="344"><input name="pSubName" type="text" size="40" /></td></tr>

<tr><td height="33" class="MyTd">Hide</td><td><input name="hide" type="checkbox" value="true"  />

  (check to hide)</td></tr>

<tr><td></td>

<td><hr />



</td></tr>  

<tr>

  <td class="MyTd">Lg Price 1</td><td><input name="lPrice1" type="text" /></td></tr>

<tr>

  <td class="MyTd">Lg Price 2</td><td><input name="lPrice2" type="text" /></td></tr>

<tr>

  <td class="MyTd">Lg Price 3</td><td><input name="lPrice3" type="text" /></td></tr>

<tr>

  <td class="MyTd">Lg Price Text</td><td><input name="lPriceText" type="text" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Med Price 1</td><td><input name="mprice1" type="text" /></td></tr>

<tr>

  <td class="MyTd">Med Price 2</td><td><input name="mPrice2" type="text" /></td></tr>

<tr>

  <td class="MyTd">Med Price 3</td><td><input name="mPrice3" type="text" /></td></tr>

<tr>

  <td class="MyTd">Med Price Text</td><td><input name="mpriceText" type="text" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Sm Price 1</td><td><input name="sPrice1" type="text" /></td></tr>

<tr>

  <td class="MyTd">Sm Price 2</td><td><input name="sPrice2" type="text" /></td></tr>

<tr>

  <td class="MyTd">Sm  Price 3</td><td><input name="sPrice3" type="text" /></td></tr>

<tr>

  <td class="MyTd">Sm Price Text</td><td><input name="sPriceText" type="text" /></td></tr>



<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Lg Thumb Image</td><td><input name="lthumb" type="file" /></td></tr>

<tr>

  <td class="MyTd">Lg Image</td><td><input name="limg" type="file" /></td></tr>

<tr>

  <td class="MyTd">Lg Image 500</td><td><input name="lzoomImg" type="file" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Med Thumb Image</td><td><input name="mthumb" type="file" /></td></tr>

<tr>

  <td class="MyTd">Med Image</td><td><input name="mimg" type="file" /></td></tr>

<tr>

  <td class="MyTd">Med Image 500</td><td><input name="mzoomImg" type="file" /></td></tr>

<tr><td></td>

<td><hr />



</td></tr>

<tr>

  <td class="MyTd">Sm Thumb Image</td><td><input name="sthumb" type="file" /></td></tr>

<tr>

  <td class="MyTd">Sm Image</td><td><input name="simg" type="file" /></td></tr>

<tr>

  <td class="MyTd">Sm Image 500</td><td><input name="szoomImg" type="file" /></td></tr>





<tr><td></td>

<td><hr />



</td></tr>



<tr><td class="MyTd">Tags</td><td><p>

  <label>

    <input type="radio" name="Tags" value="farm" id="RadioGroup1_0" />

    Farm</label>

  <br />

  <label>

    <input type="radio" name="Tags" value="wild" id="RadioGroup1_1" />

    Wild</label>

  <br />

  <label>

    <input type="radio" name="Tags" value="f1" id="RadioGroup1_2" />

    F1</label>

     <label>

   <br />

    <input type="radio" name="Tags" value="tank" id="RadioGroup1_2" />

    Tank</label>

   <br />

     <label>

    <input type="radio" name="Tags" value="potted" id="RadioGroup1_2" />

    Potted</label>

  <br />

   <label>

    <input type="radio" name="Tags" value="show" id="RadioGroup1_2" />

    Show</label>

  <br />

<tr><td></td>

<td><hr />

<tr><td class="MyTd">Tag Color</td><td>

  <label>

    <input type="radio" name="tagColor" value="#00FF00" id="RadioGroup2_0" />

    Green-Farm</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#000000" id="RadioGroup2_1" />

    Black-Wild</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#FF0000" id="RadioGroup2_2" />

    Red-F1</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#0200ff" id="RadioGroup2_3" />

    Blue-Tank</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#ff00fd" id="RadioGroup2_4" />

    Pink-Potted</label>

  <br />

  <label>

    <input type="radio" name="tagColor" value="#FDC504" id="RadioGroup2_5" />

    Gold-Show</label>

  <br />

</td></tr>

<tr><td></td>

<td><hr />

<tr><td class="MyTd">Category</td><td>

  <label>

    <input type="radio" name="Category" value="malawi" id="Category_0" />

    Malawi (malawi)</label>

  <br />

  <label>

    <input type="radio" name="Category" value="tang" id="Category_1" />

    Tanganyikan (tang)</label>

  <br />

  <label>

    <input type="radio" name="Category" value="africa_other" id="Category_2" />

    African & other (africa_other)</label>  

  <br />

  <label>

    <input type="radio" name="Category" value="s_c_american" id="Category_3" />

    So & Cen American (s_c_american)</label><br />

  <label>

    <input type="radio" name="Category" value="pleco_other" id="Category_4" />

    Plecos & other (pleco_other)</label>

  <br />

  <label>

    <input type="radio" name="Category" value="plants" id="Category_5" />

    Plants (plants)</label><br />

    <label>

    <input type="radio" name="Category" value="koiGold" id="Category_6" />

    Koi & Goldfish (koiGold)</label><br />

     <label>

    <input type="radio" name="Category" value="new" id="Category_7" />

    New (new)</label>

  <br />

 

</td></tr>



<tr><td></td>



<td>



</table></form>





	



<%End if%>

<br />



  

  <%' Always close out of your RecordSets and your DB Connection after you are finished with them, and no longer ar in need of them.

    

    objRs.Close

    Set objRs=Nothing

      objConn.close

      set objConn = nothing

%>

</table>



  </div>

  <div id="footer"> 

  <table>

<tr><td class="MyTd">Information</td><td><textarea id="elm1" name="description2" rows="15" cols="80" style="width: 100%"></textarea></td></tr>

<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Insert" /></td></tr></table>

</div>

      

</div>





</body>

</html>

Open in new window

0
 
LVL 42

Accepted Solution

by:
Chris Stanyon earned 500 total points
ID: 33695963
Hi akbiro,

Give this a whirl. I didn't realise your tables were inside an IF statement, and you had two of them.

Make a backup of your own file and then try the code below.







<!--#include file="cons.asp"-->



<%' The above file is our Connection to our datebase.

' Below is all the code that is needed in order to retrieve our data from our Database.

Set getAllSQL = CreateObject("ADODB.Command")

getAllSQL.ActiveConnection=objConn

getAllSQL.Prepared = true

getAllSQL.Commandtext = "select * from products order by id DESC"



set objRs = getAllSQL.execute



if request.QueryString("Update") then ' Looks at the QueryString, if present, then continue

Set getSQL = CreateObject("ADODB.Command") ' Creates our Command Object

getSQL.ActiveConnection=objConn ' Gets our Connection

getSQL.Prepared = true ' Stores the CommandText for future use (To retrieve the records faster)

getS = int(Request.QueryString("Update")) ' Looks at the QueryString, if present, then we will use it against our database

getSQL.Commandtext = "SELECT ID, pdate, pname, pSubname, hide, lPrice1, lPrice2, lPrice3, lPriceText, mprice1, mprice2, mprice3, mPriceText, sPrice1, sPrice2, sPrice3, sPriceText, lthumb, limg, lzoomimg, mthumb, mimg, mzoomImg, sthumb, simg, szoomimg, tag, tagColor, category, description  FROM products where ID=?" ' Always list these in order as they appear.



'********************************************************************* - experts-exchange - samic400

'modified this section - you have no reference to adovbs.inc so that wouldn't find those parms

'********************************************************************* - experts-exchange - samic400

getSQL.Parameters.Append getSQL.CreateParameter("@ID", 3, 1, , getS)



getSQL.Parameters.Append getSQL.CreateParameter("@ID", adInteger, adParamInput, , getS)' Parameters will help with the prevention of SQL INJECTION, Get use to using this, it will save your site and maybe even your job one day.

set UpdateRs = getSQL.execute ' We set our RecordSet here, so there i no need to use the CreateObject.

if not UpdateRs.eof then ' If there are any records we will continue on to the next line, if the db is empty then we stop.

ID = int(UpdateRs("ID")) ' Gets the ID

pdate = trim(UpdateRs("pdate")) '

pName = trim(UpdateRs("pname")) ' 

pSubName = trim(UpdateRs("pSubName")) ' 

Hide = trim(UpdateRs("hide")) '

lPrice1 = trim(UpdateRs("lPrice1")) ' 

lPrice2 = trim(UpdateRs("lPrice2")) ' 

lPrice3 = trim(UpdateRs("lPrice3")) '

lPriceText = trim(UpdateRs("lPriceText")) ' 

mprice1 = trim(UpdateRs("mprice1")) ' 

mprice2 = trim(UpdateRs("mprice2")) ' 

mprice3 = trim(UpdateRs("mprice3")) '

mPriceText = trim(UpdateRs("mpriceText")) ' 

sPrice1 = trim(UpdateRs("sPrice1")) ' 

sPrice2 = trim(UpdateRs("sPrice2")) ' 

sPrice3 = trim(UpdateRs("sPrice3")) '

sPriceText = trim(UpdateRs("sPriceText")) ' 

lThumb = trim(UpdateRs("lthumb")) ' 

limg = trim(UpdateRs("limg")) ' 

lZoomImg = trim(UpdateRs("lzoomImg")) '

mThumb = trim(UpdateRs("mthumb")) ' 

mimg = trim(UpdateRs("mimg")) ' 

mZoomImg = trim(UpdateRs("mzoomImg")) ' 

sThumb = trim(UpdateRs("sthumb")) ' 

simg = trim(UpdateRs("simg")) ' 

sZoomImg = trim(UpdateRs("szoomImg")) '

Tag = trim(UpdateRs("tag")) ' 

tagColor = trim(UpdateRs("tagColor")) ' 

Category = trim(UpdateRs("category")) ' 

getdescription = trim(UpdateRs("description"))

' To read the information back into the Memofield (Textarea) we have to format it and strip the tags from it.

MyInfo = replace(MyInfo,"''","'")' Replace the Quote with the Single Quote

MyInfo = replace(MyInfo,"<br />",vblf)' Replace the <br /> with the orignal vblf

end if ' end it here

end if ' end it here

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<title>ShipFish2U-Product List)</title>

<link href="dashboard.css" rel="stylesheet" type="text/css" />

<!-- TinyMCE -->

<script type="text/javascript" src="/productCatalogeditor/jscripts/tiny_mce/tiny_mce.js"></script>

<script type="text/javascript">

	tinyMCE.init({

		// General options

		mode : "textareas",

		theme : "advanced",

		plugins : "pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave",



		// Theme options

		theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",

		theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",

		theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",

		theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft",

		theme_advanced_toolbar_location : "top",

		theme_advanced_toolbar_align : "left",

		theme_advanced_statusbar_location : "bottom",

		theme_advanced_resizing : true,



		// Example content CSS (should be your site CSS)

		content_css : "css/content.css",



		// Drop lists for link/image/media/template dialogs

		template_external_list_url : "lists/template_list.js",

		external_link_list_url : "lists/link_list.js",

		external_image_list_url : "lists/image_list.js",

		media_external_list_url : "lists/media_list.js",



		// Style formats

		style_formats : [

			{title : 'Bold text', inline : 'b'},

			{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},

			{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},

			{title : 'Example 1', inline : 'span', classes : 'example1'},

			{title : 'Example 2', inline : 'span', classes : 'example2'},

			{title : 'Table styles'},

			{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}

		],



		// Replace values for the template plugin

		template_replace_values : {

			username : "Some User",

			staffid : "991234"

		}

	});

</script>

<!-- /TinyMCE -->

</head>



<body class="twoCol">



<div id="container">



<div id="sidebar1">

	<table style="width:400px;">

		<caption>List of all the records to update</caption>

		<tr>

			<td class="MyTdTop">ID</td>

			<td class="MyTdTop">pName</td>

			<td class="MyTdTop">hide</td>

		</tr>

<%While Not objRs.EOF%>

		<tr>

			<td class="MyTd"><%=objRS("ID")%></td>

			<td class="MyTd"><a href="dashboard_worksheet.asp?update=<%=objRS("ID")%>"><%=objRS("PName")%></a></td>

			<td class="MyTd"><a href="dashboard_worksheet.asp?update=<%=objRS("ID")%>"><%=objRS("hide")%></a></td>

		</tr>



<%' Always close out of your RecordSets and your DB Connection after you are finished with them, and no longer ar in need of them.

objRs.MoveNext

Wend

%>

	</table>

</div>





<div id="mainContent">                  

<%if request.QueryString("Update") then%>

	<form action="setRecords.asp" method="post">

		<table>

			<tr><td colspan="2"  class="MyTdTop">Delete a Record in a Database</td></tr>

			<input type="hidden" name="MyRecord" value="Delete" />

			<tr><td class="MyTd">Choose Record</td><td>

			<%'We are going to get the Values from the database and put them in a Dropdown (ListMenu) and so we can choose the item that we want to Delete%>

			<select name="DelCom" style="font: 8pt verdana;">

			<option value="">Choose a Record</option>

			<%

			objRs.MoveFirst                                                        

			While (NOT objRs.EOF)

			%>

			<option value="<%=objRs("ID")%>"><%=objRs("id")&" "&objRs("pname")%></option>

			<%

			objRs.MoveNext

			Wend

			%>

			</select></td></tr>

			<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Delete" /></td></tr>

		</table>

	</form>



	<form action="setRecords.asp" method="post">

		<table width="500">

			<tr><td colspan="2"  class="MyTdTop">Update an existing Record in a Database</td></tr>

			<input name="ID" type="hidden" value="<%=getS%>" />



			<tr><td class="MyTd" width="300">ID</td><td width="200"><input name="id" type="text" value="<%=id%>" size="24" /></td></tr>

			<tr><td class="MyTd" width="300">Date Entered</td><td width="200"><input name="pdate" type="text" value="<%=pDate%>" size="24" /></td></tr>

			<tr><td class="MyTd" width="300">Scientific Name</td><td width="200"><input name="pname" type="text" value="<%=pName%>" size="40" /></td></tr>

			<tr><td class="MyTd">Common Name</td><td width="200"><input name="pSubName" type="text" value="<%=pSubName%>" size="40" /></td></tr>

			<tr><td class="MyTd">Hide</td><td><input name="hide" type="form" value="<%=hide%>" /></td></tr>

			<tr><td class="MyTd">Lg Price1</td><td><input name="lPrice1" type="text" value="<%=lPrice1%>" /></td></tr>

			<tr><td class="MyTd">Lg Price2</td><td><input name="lPrice2" type="text" value="<%=lPrice2%>" /></td></tr>

			<tr><td class="MyTd">Lg Price3</td><td><input name="lPrice3" type="text" value="<%=lPrice3%>" /></td></tr>

			<tr><td class="MyTd">Lg Price Text</td><td><input name="lPriceText" type="text" value="<%=lPriceText%>" /></td></tr>



			<tr><td class="MyTd">Med Price1</td><td><input name="mprice1" type="text" value="<%=mprice1%>" /></td></tr>

			<tr><td class="MyTd">Med Price2</td><td><input name="mPrice2" type="text" value="<%=mPrice2%>" /></td></tr>

			<tr><td class="MyTd">Med Price3</td><td><input name="mPrice3" type="text" value="<%=mPrice3%>" /></td></tr>

			<tr><td class="MyTd">Med Price Text</td><td><input name="mpriceText" type="text" value="<%=mpriceText%>" /></td></tr>



			<tr><td class="MyTd">Sm Price1</td><td><input name="sPrice1" type="text" value="<%=sPrice1%>" /></td></tr>

			<tr><td class="MyTd">Sm Price2</td><td><input name="sPrice2" type="text" value="<%=sPrice2%>" /></td></tr>

			<tr><td class="MyTd">Sm Price3</td><td><input name="sPrice3" type="text" value="<%=sPrice3%>" /></td></tr>

			<tr><td class="MyTd">Sm Price Text</td><td><input name="sPriceText" type="text" value="<%=sPriceText%>" /></td></tr>



			<tr><td class="MyTd">Large</td><td><a href="#" class="view-img">View Lg Thumb<img src="/img/<%=lthumb%>" "100" height="67" /></a></td></tr>

			<tr><td></td><td><input name="lthumb" type="text" value="<%=lthumb%>" width="100" height="67"/></td></tr>

			<tr><td class="MyTd">Large</td><td><a href="#" class="view-img">View Lg Image<img src="/img/<%=limg%>" "265" height="176" /></a> </td>

			</tr></tr>

			<tr><td></td><td><input name="limg" type="text" value="<%=limg%>" width="260" height="173" /></td></tr>

			<tr><td class="MyTd">Large</td><td><a href="#" class="view-img">View Lg 500<img src="/img/<%=lzoomImg%>" "500" height="365" /></a> </td>

			</tr></tr>

			<tr><td></td><td><input name="lzoomImg" type="text" value="<%=lzoomImg%>" width="500" height="365"/></td></tr>



			<tr><td class="MyTd">Medium</td>

			<td><a href="#" class="view-img">View Med Thumb<img src="/img/<%=mthumb%>" "100" height="67" /></a> </td></tr>

			<tr><td></td><td><input name="mthumb" type="text" value="<%=mthumb%>" width="100" height="67"/></td>

			</tr>

			<tr><td class="MyTd">Medium </td>

			<td><a href="#" class="view-img">View Med Image<img src="/img/<%=mimg%>" "260" height="173" /></a> </td>

			</tr></tr>

			<tr><td></td><td><input name="mimg" type="text" value="<%=mimg%>" width="260" height="173" /></td>

			</tr>

			<tr>

			<td class="MyTd">Medium </td>

			<td><a href="#" class="view-img">View Med 500<img src="/img/<%=mzoomImg%>" "500" height="365" /></a> </td>

			</tr></tr>

			<tr><td></td><td><input name="mzoomImg" type="text" value="<%=mzoomImg%>" width="500" height="365"/></td>

			</tr>



			<tr><td class="MyTd">Small</td>

			<td><a href="#" class="view-img">View Sm Thumb<img src="/img/<%=sthumb%>" "100" height="67" /></a> </td></tr>

			<tr><td></td><td><input name="sthumb" type="text" value="<%=sthumb%>" width="100" height="67"/></td>

			</tr>

			<tr><td class="MyTd">Small</td>

			<td><a href="#" class="view-img">View Sm Image<img src="/img/<%=simg%>" "260" height="173" /></a> </td>

			</tr></tr>

			<tr><td></td><td><input name="simg" type="text" value="<%=simg%>" width="260" height="173" /></td>

			</tr>

			<tr>

			<td class="MyTd">Small </td>

			<td><a href="#" class="view-img">View Sm 500 Image<img src="/img/<%=szoomImg%>" "500" height="365" /></a></td>

			</tr></tr>

			<tr><td></td><td><input name="szoomImg" type="text" value="<%=szoomImg%>" width="500" height="365"/></td>

			</tr>



			<tr><td class="MyTd">Tag</td><td><input name="tag" type="text" value="<%=tag%>" /></td></tr>

			<tr><td class="MyTd">Tag Color</td><td><input name="tagColor" type="text" value="<%=tagColor%>" /></td></tr>

			<tr><td class="MyTd">Category</td><td><input name="category" type="text" value="<%=category%>" /></td></tr>

		</table>

		

		<table>

			<tr><td class="MyTd">Description Text</td><td><textarea name="description" cols="50" rows="10"><%=getdescription%></textarea></td></tr>

			<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Update" /></td></tr>

		</table>



		</form>

	<a href="dashboard_worksheet.asp">Go back to Insert (or) Delete Records</a>



<%else%>



	<form action="setRecords.asp" method="post">

		<table width="492">

			<tr><td colspan="2"  class="MyTdTop">Insert a New Record into the Database</td></tr>

			<input type="hidden" name="MyRecord" value="Insert" />

			<tr><td width="110" class="MyTd"><p>Date Entered</p>

			<p>YYYY-MM-DD</p></td><td width="344"><input name="pdate" type="text" size="40" /></td></tr>

			<tr>

			<td width="110" class="MyTd">Scientific Name</td><td width="344"><input name="pname" type="text" size="40" /></td></tr>

			<tr><td width="110" class="MyTd">Common Name</td><td width="344"><input name="pSubName" type="text" size="40" /></td></tr>

			<tr><td height="33" class="MyTd">Hide</td><td><input name="hide" type="checkbox" value="true"  />

			(check to hide)</td></tr>

			<tr><td></td>

			<td><hr />



			</td></tr>  

			<tr>

			<td class="MyTd">Lg Price 1</td><td><input name="lPrice1" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Lg Price 2</td><td><input name="lPrice2" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Lg Price 3</td><td><input name="lPrice3" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Lg Price Text</td><td><input name="lPriceText" type="text" /></td></tr>

			<tr><td></td>

			<td><hr />



			</td></tr>

			<tr>

			<td class="MyTd">Med Price 1</td><td><input name="mprice1" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Med Price 2</td><td><input name="mPrice2" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Med Price 3</td><td><input name="mPrice3" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Med Price Text</td><td><input name="mpriceText" type="text" /></td></tr>

			<tr><td></td>

			<td><hr />



			</td></tr>

			<tr>

			<td class="MyTd">Sm Price 1</td><td><input name="sPrice1" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Sm Price 2</td><td><input name="sPrice2" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Sm  Price 3</td><td><input name="sPrice3" type="text" /></td></tr>

			<tr>

			<td class="MyTd">Sm Price Text</td><td><input name="sPriceText" type="text" /></td></tr>



			<tr><td></td>

			<td><hr />



			</td></tr>

			<tr>

			<td class="MyTd">Lg Thumb Image</td><td><input name="lthumb" type="file" /></td></tr>

			<tr>

			<td class="MyTd">Lg Image</td><td><input name="limg" type="file" /></td></tr>

			<tr>

			<td class="MyTd">Lg Image 500</td><td><input name="lzoomImg" type="file" /></td></tr>

			<tr><td></td>

			<td><hr />



			</td></tr>

			<tr>

			<td class="MyTd">Med Thumb Image</td><td><input name="mthumb" type="file" /></td></tr>

			<tr>

			<td class="MyTd">Med Image</td><td><input name="mimg" type="file" /></td></tr>

			<tr>

			<td class="MyTd">Med Image 500</td><td><input name="mzoomImg" type="file" /></td></tr>

			<tr><td></td>

			<td><hr />



			</td></tr>

			<tr>

			<td class="MyTd">Sm Thumb Image</td><td><input name="sthumb" type="file" /></td></tr>

			<tr>

			<td class="MyTd">Sm Image</td><td><input name="simg" type="file" /></td></tr>

			<tr>

			<td class="MyTd">Sm Image 500</td><td><input name="szoomImg" type="file" /></td></tr>





			<tr><td></td>

			<td><hr />



			</td></tr>



			<tr><td class="MyTd">Tags</td><td><p>

			<label>

			<input type="radio" name="Tags" value="farm" id="RadioGroup1_0" />

			Farm</label>

			<br />

			<label>

			<input type="radio" name="Tags" value="wild" id="RadioGroup1_1" />

			Wild</label>

			<br />

			<label>

			<input type="radio" name="Tags" value="f1" id="RadioGroup1_2" />

			F1</label>

			<label>

			<br />

			<input type="radio" name="Tags" value="tank" id="RadioGroup1_2" />

			Tank</label>

			<br />

			<label>

			<input type="radio" name="Tags" value="potted" id="RadioGroup1_2" />

			Potted</label>

			<br />

			<label>

			<input type="radio" name="Tags" value="show" id="RadioGroup1_2" />

			Show</label>

			<br />

			<tr><td></td>

			<td><hr />

			<tr><td class="MyTd">Tag Color</td><td>

			<label>

			<input type="radio" name="tagColor" value="#00FF00" id="RadioGroup2_0" />

			Green-Farm</label>

			<br />

			<label>

			<input type="radio" name="tagColor" value="#000000" id="RadioGroup2_1" />

			Black-Wild</label>

			<br />

			<label>

			<input type="radio" name="tagColor" value="#FF0000" id="RadioGroup2_2" />

			Red-F1</label>

			<br />

			<label>

			<input type="radio" name="tagColor" value="#0200ff" id="RadioGroup2_3" />

			Blue-Tank</label>

			<br />

			<label>

			<input type="radio" name="tagColor" value="#ff00fd" id="RadioGroup2_4" />

			Pink-Potted</label>

			<br />

			<label>

			<input type="radio" name="tagColor" value="#FDC504" id="RadioGroup2_5" />

			Gold-Show</label>

			<br />

			</td></tr>

			<tr><td></td>

			<td><hr />

			<tr><td class="MyTd">Category</td><td>

			<label>

			<input type="radio" name="Category" value="malawi" id="Category_0" />

			Malawi (malawi)</label>

			<br />

			<label>

			<input type="radio" name="Category" value="tang" id="Category_1" />

			Tanganyikan (tang)</label>

			<br />

			<label>

			<input type="radio" name="Category" value="africa_other" id="Category_2" />

			African & other (africa_other)</label>  

			<br />

			<label>

			<input type="radio" name="Category" value="s_c_american" id="Category_3" />

			So & Cen American (s_c_american)</label><br />

			<label>

			<input type="radio" name="Category" value="pleco_other" id="Category_4" />

			Plecos & other (pleco_other)</label>

			<br />

			<label>

			<input type="radio" name="Category" value="plants" id="Category_5" />

			Plants (plants)</label><br />

			<label>

			<input type="radio" name="Category" value="koiGold" id="Category_6" />

			Koi & Goldfish (koiGold)</label><br />

			<label>

			<input type="radio" name="Category" value="new" id="Category_7" />

			New (new)</label>

			<br />

			</td></tr>

		</table>



		<table>

			<tr><td class="MyTd">Information</td><td><textarea id="elm1" name="description2" rows="15" cols="80" style="width: 100%"></textarea></td></tr>

			<tr><td colspan="2" class="MyTd"><input type="submit" name="Submit" value="Insert" /></td></tr>

		</table>

	</form>



<%End if%>





<br />





<%' Always close out of your RecordSets and your DB Connection after you are finished with them, and no longer ar in need of them.



objRs.Close

Set objRs=Nothing

objConn.close

set objConn = nothing

%>

</div> <!--close main content -->



<div id="footer"> 

</div>



</div>





</body>

</html>

Open in new window

0
 

Author Closing Comment

by:akbiro
ID: 33696074
Ok...first, you are the best and I am sure busy and yet you spent a great deal of time on this.  I thank you VERY VERY much and I think I learned something as well.  I have a small .asp problem that makes it blow up when I update a record, but that is not a part of the question so I will either solve it or open a new page.  Really, thank you very much.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
In this Micro Tutorial users will learn how to embed custom fonts into websites using @font-face in CSS Select a font: Ensure the EULA allows you to use @font-face: Download the font: Get the browser-compatible files you need: Edit your CSS       - Name …
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now