• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

CSS/ASP

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
akbiro
Asked:
akbiro
  • 9
  • 8
1 Solution
 
strickddCommented:
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
 
Chris StanyonCommented:
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
 
akbiroAuthor Commented:
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Chris StanyonCommented:
@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
 
akbiroAuthor Commented:
Very cool...it helped, but it still doesn't work in IE.  It works perfectly in my Dreamweaver editor, but not IE.
0
 
Chris StanyonCommented:

//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
 
Chris StanyonCommented:
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
 
akbiroAuthor Commented:
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
 
Chris StanyonCommented:
In your code above, delete line 3.


0
 
akbiroAuthor Commented:
Ok...but no joy
0
 
akbiroAuthor Commented:
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
 
Chris StanyonCommented:
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
 
akbiroAuthor Commented:
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
 
akbiroAuthor Commented:
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
 
Chris StanyonCommented:
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
 
akbiroAuthor Commented:
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
 
Chris StanyonCommented:
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
 
akbiroAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now