473,378 Members | 1,330 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

RS Loop - Numeric value out of range (null)

Hi All,

I am getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range
(null)
/database/data_entry.asp, line 90

Line 90 is shown below...

// count the total records by iterating through the recordset
for (rsProducts_total=0; !rsProducts.EOF; rsProducts.MoveNext())
{ <---- Line 90
rsProducts_total++;
}

This is an access database, connected to via a DSN.

Any help will be muchly appreciated! I'm stuck on this one!

Thanks!
Simon.

Apr 2 '07 #1
3 5184
Adotek wrote:
Hi All,

I am getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range
Nothing to do with your problem, but:
http://www.aspfaq.com/show.asp?id=2126
(null)
/database/data_entry.asp, line 90

Line 90 is shown below...

// count the total records by iterating through the recordset
for (rsProducts_total=0; !rsProducts.EOF; rsProducts.MoveNext())
{ <---- Line 90
rsProducts_total++;
}
I see nothing here that would cause your odbc driver to return an "out
of range" error. At this point in your code, results have already been
retrieved into your recordset so there should be nothing here for the
database engine or the odbc driver to complain about/
I can only assume that you are mistaken as to which line is actually
line 90. Do some error-trapping so you can determine the actual source
of your error.

However, I will say: this is an insa... I mean ... this is not the
recommended way to get a record count. If all you are doing is counting
the records, then you need to let the database engine do it for you:

sql="select count(*) from table where ... ";
set rs = conn.execute(sql,0,1);
rsProducts_total=rs(0).value;
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Apr 2 '07 #2
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC MicrosoftAccessDriver]Numericvalueoutofrange

Nothing to do with your problem, but:http://www.aspfaq.com/show.asp?id=2126
Yup - Agree! I would do it that way. In this case I am fixing someone
elses code.

line 90. Do some error-trapping so you can determine the actual source
of your error.
How can I error trap in any more detail? Advice here would be
appreciated.
However, I will say: this is an insa... I mean ... this is not the
recommended way to get a record count. If all you are doing is counting
the records, then you need to let the database engine do it for you:

sql="select count(*) from table where ... ";
set rs = conn.execute(sql,0,1);
rsProducts_total=rs(0).value;
Again, I agree...no need to loop! (Not my code!)

Thank you for your reply.

Apr 2 '07 #3
Adotek wrote:
>>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC MicrosoftAccessDriver]Numericvalueoutofrange

Nothing to do with your problem,
but:http://www.aspfaq.com/show.asp?id=2126
Yup - Agree! I would do it that way. In this case I am fixing someone
elses code.

>line 90. Do some error-trapping so you can determine the actual
source
of your error.
How can I error trap in any more detail? Advice here would be
appreciated.
use try ... catch around each line of code that could be generating this
error. I strongly suspect it is earlier in the process, bpresumably when the
recordset is being opened. If you can confirm this, then you need to
concentrate on the sql statement being used to open the recordset. First
step would be to run that sql statement in Access using the Query Builder.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Apr 2 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: dbarchitech | last post by:
hi, i'm building a query to find narrow ranges of zip codes within broader ranges in a table (for tax purposes). for example: LOW_ZIP HI_ZIP 23400 23499 need to find 23401 ...
30
by: Dr John Stockton | last post by:
It has appeared that ancient sources give a method for Numeric Date Validation that involves numerous tests to determine month length; versions are often posted by incomers here. That sort of code...
0
by: minjie | last post by:
Hello, I have a C++ CLI app that uses stored procedures to get record sets from tables. It works fine except for accessing one of the tables, which means the general logic of the code is OK. I got...
2
by: MrNobody | last post by:
I just noticed that a numeric up/down will let you manually type in any number even if it is beyond the min/max range you specified. The control will not actually return this value if it is...
30
by: Chaos | last post by:
As my first attempt to loop through every pixel of an image, I used for thisY in range(0, thisHeight): for thisX in range(0, thisWidth): #Actions here for Pixel thisX, thisY But it takes...
29
by: garyusenet | last post by:
I'm trying to investigate the maximum size of different variable types. I'm using INT as my starting variable for exploration. I know that the maximum number that the int variable can take is:...
6
by: Kc-Mass | last post by:
In a standard Ascii table a dash or hyphen is decimal 45. A period or dot is decimal 46. If I sort a table or recordset of mixed character string ascending in Access, those strings beginning with...
4
by: Serman D. | last post by:
I would like to extract the first 6 digits of a numeric value (e.g. the string '123456' out of the numeric 1234567890123456789). I tried a combination of CAST and SUBSTR, but it seems I am not...
1
by: Navs | last post by:
Hi, I am trying to insert a TIME value in a SQL Server 2008 database using a simple ODBC C program. I follow the steps below: 1. Connect and Allocate Statement handle 2. Prepare a Statement...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.