ok I am getting the following error after I get my repeat region data on my page. I get all my data upto and including the repeated region stuff but I can't get any records after my repeat region. I get the following error. Any help would be great. Thanks.


ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/java/detail.asp, line 124

This is a common error. It means, given the command you placed on your recordset, no record sets were returned. And contrary to popular belief, that alone does not cause the error. However, when you attempt to write the data to your page from the recordset with no data, you get this error.

What you should do is that in your recordset building section, click the test button. If it returns no data, that's the reason.

To fix this, highlight the areas of the website where it's showing data from this recordset and apply the server behavior of SHOW REGION > IF RECORDSET IS NOT EMPTY.

This way, no data will be displayed (which causes your error) if no data exists.

For reference. .BOF is Beginning of File and .EOF is End of File.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Ok when I run my test I do get data. When I don't have the repeated region i don't get the error and with the repeated region i do get the error. What I am trying to do is show at the top of the page show account information. in the middle of the page this is where i need my repeated region to show all tax info for the past years. then at the bottom of the page i need to show the final total. With the repeated region in there i don't see my total stuff at the bottom of the page but i do get all of my past tax info. With out the repeated region i get my totals but i only see one year of tax info and i need the multiple years. Below is my code that is failing. Thanks for the help.




<pre id=code><font face=courier size=2 id=code>
&lt;%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%&gt;
&lt;!--#include file="Connections/tax.asp" --&gt;
&lt;%
var Recordset1__MMColParam = "1";
if (String(Request.QueryString("Account") != "undefined" &&
String(Request.QueryString("Account") != "" {
Recordset1__MMColParam = String(Request.QueryString("Account");
}
%&gt;
&lt;%
var Recordset1 = Server.CreateObject("ADODB.Recordset";
Recordset1.ActiveConnection = MM_tax_STRING;
Recordset1.Source = "SELECT * FROM Combined WHERE M_Account = '"+ Recordset1__MMColParam.replace(/'/g, "''" + "' ORDER BY M_Account ASC";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%&gt;
&lt;%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Recordset1_numRows += Repeat1__numRows;
%&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Untitled Document&lt;/title&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;p&gt;&lt;%=(Recordset1.Fields.Item("M_Account".Value)%&gt;&lt;/p&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;

&lt;table border="1"&gt;
&lt;tr&gt;
&lt;td&gt;M_Account&lt;/td&gt;
&lt;td&gt;Legal_Desc1&lt;/td&gt;
&lt;td&gt;Legal_Desc2&lt;/td&gt;
&lt;td&gt;Legal_Desc3&lt;/td&gt;
&lt;td&gt;Legal_Desc4&lt;/td&gt;
&lt;td&gt;Legal_Desc5&lt;/td&gt;
&lt;td&gt;Legal_Opt&lt;/td&gt;
&lt;td&gt;Street_Number&lt;/td&gt;
&lt;td&gt;Street_Name&lt;/td&gt;
&lt;td&gt;Owner&lt;/td&gt;
&lt;td&gt;Owner_2&lt;/td&gt;
&lt;td&gt;Owner_3&lt;/td&gt;
&lt;td&gt;Owner_4&lt;/td&gt;
&lt;td&gt;Owner_City&lt;/td&gt;
&lt;td&gt;Owner_State&lt;/td&gt;
&lt;td&gt;Owner_Zip&lt;/td&gt;
&lt;td&gt;Owner_Number&lt;/td&gt;
&lt;td&gt;Owner_Freeze_Year&lt;/td&gt;
&lt;td&gt;Owner_Exempts_Home&lt;/td&gt;
&lt;td&gt;Owner_Exempts_O65&lt;/td&gt;
&lt;td&gt;Owner_Exempts_Vet&lt;/td&gt;
&lt;td&gt;Owner_Exempts_DHS&lt;/td&gt;
&lt;td&gt;Owner_Exempts_Ceil&lt;/td&gt;
&lt;td&gt;Owner_Exempts_ABS&lt;/td&gt;
&lt;td&gt;Owner_Exempts_Excltype&lt;/td&gt;
&lt;td&gt;Owner_Exempts_Taxdef&lt;/td&gt;
&lt;td&gt;Owner_Frozen_Levy&lt;/td&gt;
&lt;td&gt;Land_Value&lt;/td&gt;
&lt;td&gt;AG_Exlusion&lt;/td&gt;
&lt;td&gt;Impr_Value&lt;/td&gt;
&lt;td&gt;Pers_Prop&lt;/td&gt;
&lt;td&gt;Homesite_Value&lt;/td&gt;
&lt;td&gt;Appraised_Value&lt;/td&gt;
&lt;td&gt;Account&lt;/td&gt;
&lt;td&gt;Year&lt;/td&gt;
&lt;td&gt;Jurisdiction&lt;/td&gt;
&lt;td&gt;Gross_Value&lt;/td&gt;
&lt;td&gt;AG_Exclusion&lt;/td&gt;
&lt;td&gt;Total_Homesite&lt;/td&gt;
&lt;td&gt;Taxable_Value&lt;/td&gt;
&lt;td&gt;Levy&lt;/td&gt;
&lt;td&gt;Account_Paid&lt;/td&gt;
&lt;td&gt;Total_Paid&lt;/td&gt;
&lt;td&gt;Date_Paid&lt;/td&gt;
&lt;td&gt;Homestead&lt;/td&gt;
&lt;td&gt;Over65&lt;/td&gt;
&lt;td&gt;Veteran&lt;/td&gt;
&lt;td&gt;Disabled&lt;/td&gt;
&lt;td&gt;Exempt5&lt;/td&gt;
&lt;td&gt;ABS_Exempt&lt;/td&gt;
&lt;td&gt;Exclusion_Type&lt;/td&gt;
&lt;td&gt;Deferral&lt;/td&gt;
&lt;td&gt;Due_Date&lt;/td&gt;
&lt;td&gt;Omit_Flag&lt;/td&gt;
&lt;td&gt;Split_Pay&lt;/td&gt;
&lt;td&gt;Levy_Paid&lt;/td&gt;
&lt;td&gt;Levy_Due&lt;/td&gt;
&lt;td&gt;M1&lt;/td&gt;
&lt;td&gt;Y1&lt;/td&gt;
&lt;td&gt;PNI1&lt;/td&gt;
&lt;td&gt;Total_ Due1&lt;/td&gt;
&lt;td&gt;M2&lt;/td&gt;
&lt;td&gt;Y2&lt;/td&gt;
&lt;td&gt;PNI2&lt;/td&gt;
&lt;td&gt;Total_Due2&lt;/td&gt;
&lt;td&gt;M3&lt;/td&gt;
&lt;td&gt;Y3&lt;/td&gt;
&lt;td&gt;PNI3&lt;/td&gt;
&lt;td&gt;Total_Due3&lt;/td&gt;
&lt;td&gt;Exempt_Amt&lt;/td&gt;
&lt;td&gt;Tax_Rate&lt;/td&gt;
&lt;td&gt;T_Account&lt;/td&gt;
&lt;td&gt;T_Levy_Paid&lt;/td&gt;
&lt;td&gt;T_Levy_Due&lt;/td&gt;
&lt;td&gt;T_Total_ Due1&lt;/td&gt;
&lt;td&gt;T_Total_Due2&lt;/td&gt;
&lt;td&gt;T_Total_Due3&lt;/td&gt;
&lt;/tr&gt;
&lt;% while ((Repeat1__numRows-- != 0) && (!Recordset1.EOF)) { %&gt;
&lt;tr&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("M_Account".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Legal_Desc1".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Legal_Desc2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Legal_Desc3".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Legal_Desc4".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Legal_Desc5".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Legal_Opt".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Street_Number".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Street_Name".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_3".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_4".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_City".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_State".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Zip".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Number".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Freeze_Year".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_Home".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_O65".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_Vet".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_DHS".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_Ceil".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_ABS".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_Excltype".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Exempts_Taxdef".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Owner_Frozen_Levy".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Land_Value".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("AG_Exlusion".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Impr_Value".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Pers_Prop".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Homesite_Value".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Appraised_Value".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Account".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Year".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Jurisdiction".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Gross_Value".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("AG_Exclusion".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Total_Homesite".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Taxable_Value".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Levy".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Account_Paid".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Total_Paid".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Date_Paid".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Homestead".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Over65".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Veteran".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Disabled".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Exempt5".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("ABS_Exempt".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Exclusion_Type".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Deferral".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Due_Date".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Omit_Flag".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Split_Pay".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Levy_Paid".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Levy_Due".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("M1".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Y1".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("PNI1".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Total_ Due1".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("M2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Y2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("PNI2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Total_Due2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("M3".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Y3".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("PNI3".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Total_Due3".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Exempt_Amt".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("Tax_Rate".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("T_Account".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("T_Levy_Paid".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("T_Levy_Due".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("T_Total_ Due1".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("T_Total_Due2".Value)%&gt;&lt;/td&gt;
&lt;td&gt;&lt;%=(Recordset1.Fields.Item("T_Total_Due3".Value)%&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;%
Repeat1__index++;
Recordset1.MoveNext();
}
%&gt;
&lt;/table&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;
&lt;p&gt;&lt;%=(Recordset1.Fields.Item("M_Account".Value)%&gt; &lt;/p&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;%
Recordset1.Close();
%&gt;

</font id=code></pre id=code>

Well, line 124 of detail.asp doesn't seem to hold any problems. Can you list the code for Connections/tax.asp ?

Usually if the page line with the error and the code line of the page don't match up in some kind of syntax or spelling error, the problem can lie in the includes.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

here is the code below. i am running IIS 5.1 on winxp and dwmx. Can I call you or setup a chat window. I am stumped.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Well, line 124 of detail.asp doesn't seem to hold any problems. Can you list the code for Connections/tax.asp ?

Usually if the page line with the error and the code line of the page don't match up in some kind of syntax or spelling error, the problem can lie in the includes.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> <pre id=code><font face=courier size=2 id=code>

&lt;%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_tax_STRING = "dsn=1;"
%&gt;

</font id=code></pre id=code>

How many recordsets do you have on the page? Is it possible when you went to select the bottom dynamic row of that table that you accidentally highlighted another recordset's data?

Check this out. Macromedia's page on your error code. Basically says what I'm saying: That a recordset is empty.

www.macromedia.com/support/ultradev/ts/documents/ud_bof_eof.htm

Can you tell me what your Recordset Builder looks like? ie, Name:, Connection: SQL Code, Select Tables, Orderby, or are you using ADVANCED VIEW?

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

I have one recordset. Name Recodset1 connection tax table combined all columns Filter M_Account = URL Parameter Account sort M_Account Asc. I am using the simple view.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
How many recordsets do you have on the page? Is it possible when you went to select the bottom dynamic row of that table that you accidentally highlighted another recordset's data?

Check this out. Macromedia's page on your error code. Basically says what I'm saying: That a recordset is empty.

www.macromedia.com/support/ultradev/ts/documents/ud_bof_eof.htm

Can you tell me what your Recordset Builder looks like? ie, Name:, Connection: SQL Code, Select Tables, Orderby, or are you using ADVANCED VIEW?

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Well if you want, send me your .ASP page, and database, and db setup info (DSN, Connection String?) and I can test it out locally. (if your db has personal data, make a copy of the db, and remove all tables that have nothing to do with the display of data on this page.)

Make sure the total file size is not over 4.092 MB, or my mail server will reject it.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Once I do a repeated region can't i show individual records after that. or after a repeated region it goes to the eof so i can't show anymore data. I know the record is there because I can see M_account when i call it before my repeated region but then i try to show it again after the repeated region and i get the error.

Wait a minute. If you're using the data that's IN the repeat region after the repeat region, that may cause the error too. You should make 2 recordsets. One for the repeat and one just to call the data the first time.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

My data is like 27mb. IN my recordset i have the following data account year tax and total tax. it would look like this

1 2000 20.00 80.00
1 1999 20.00 80.00
1 1998 20.00 80.00
1 1997 20.00 80.00

So I want to show the account number once at the tob then do a repeated region to show the year and the tax for that year and then I want to show once at the bottom thier total tax. If I do a repeated region i get this

1

2000 20.00
1999 20.00
1998 20.00
1997 20.00

eof bof error

If i don't do a repeated region i get this

1

2000 20.00

80.00

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Wait a minute. If you're using the data that's IN the repeat region after the repeat region, that may cause the error too. You should make 2 recordsets. One for the repeat and one just to call the data the first time.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I think the problem resides in M_Account.

Try removing the line :

&lt;p&gt;&lt;%=(Recordset1.Fields.Item("M_Account".Value)%&gt;&lt;/p&gt;

at the top and bottom of the page (leave it in the repeat region area)

Then run the page. What happens?



Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

When i take thos out i have just the repeated region which works fine. I think it might have to do with something with my filtering on the recordset. If i don't filter the recordset it works fine but if i do filter the recordset it doesn't. but if I don't filter my record set then i don't get the right data.

I think I got it fixed am now using three different recodsets that go to three diffferent tables one for my account one for my year and tax and the other one for my total. Thanks for your help. I am not sure what was wrong with it. I am going to mess around with it some more. thanks again for your help.