Subscript Out Of Range: '[number: 160]'

I have a very simple table that keeps "brand names"

Two cells in the table.
BrandID, INT 4
Brand

Brand ID auto numbers as you put entries in the database in order. 1, 2, 3, 4 etc... Whats happening right now is that when i enter a new brand, say it's number 160, it's not showing up at the end of the table. It goes something like 150, 151, 152, 160, 154, 155 etc... So when my page pulls a list of products, Im getting this subscript error only on the number that is not at the end.

On the web I read that the error is caused by the number being out of the ubound and lbound range, which i guess makes sense if the page think 155 is the end im looking for 160. Why are my new entries not going to the end? Even when i enter them into sql viq enterprise manager, when i re run the results, the new entries pop up in the middle.

View Replies

ADVERTISEMENT

Subscript Out Of Range

Can someone help me find out why i am getting this error message :

Microsoft VBScript runtime error '800a0009'

Subscript out of range: '[number: 47]' /Risk/Risk_Continued_test.asp, line 72

my code is :

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|")
MM_columns = Split(MM_columnsStr, "|")

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

View Replies View Related

Subscript Out Of Range:?

Can anyone tell me what this error means?

Microsoft VBScript runtime error '800a0009'
Subscript out of range: 'Request.QueryString(...)'

View Replies View Related

What Is This Error Subscript Out Of Range: '1'

?? anyone it's in the title

Code:

<%displayscreen= Replace(Screen,"Contract Status - ","")
IF displayscreen= "New" THEN

Strsql="update toplinedata set reschedule=1 where cnum=" & JobsToUpdate(x)
SQLConnect.execute(StrSql)
end if

%>

View Replies View Related

Subscript Out Of Range: 'True'

I'm getting this error:

Microsoft VBScript runtime error '800a0009'

Subscript out of range: 'True'

/Featured.asp, line 28

on this code:

View Replies View Related

Subscript Out Of Range Error

I am currently having error with Subscript and whenver I use the upload form script, following error is printed.

Microsoft VBScript runtime error '800a0009'

Subscript out of range: '[number: 7]'

/admin_dates.asp, line 57

Following is my code where I think the problem lies -

Code:

View Replies View Related

Error :: Subscript Out Of Range

[vbs]
<%
tmpcats=Array()
t=0
SET prod_cat = Con.Execute("SELECT DISTINCT CATEGORY_ID FROM PROD_CAT")

WHILE NOT prod_cat.EOF
tmpcats(t)=prod_cat("category_id")
t=t+1
prod_cat.MOVENEXT
WEND

for i = 0 to UBound(tmpcats)
response.write i & " - " & tmpcats(i)
next

%>
[/vbs]

Is throwing up a "subscript out of range" error. I know this is simple, but my array stuff is a bit out of date.

View Replies View Related

Vbscript Runtime Error: Subscript Out Of Range

I'm getting a Microsoft vbscript runtime error (as usual) but this one has been bothering me for a few days now...

The thing is that the code I'm running is doing exactly what I want it to.. I'm using a text file as if it were a little mini database, the table within is setup as follows->

v0 v1 v2 v3
value,value,value,value|
value,value,value,value|
...

how I query this or whatever you want to call it is like this. Code:

View Replies View Related

Microsoft VBScript Runtime (0x800A0009) Subscript Out Of Range

Code:

<% response.write(p(4,1)) %>

'First number is the column. Second number is the row

I have a total of 15 columns. Columns 1 thru 14 are read perfectly.

However this same script for column 15,

Code:

<% response.write(p(15,1)) %>

Returns:

Microsoft VBScript runtime (0x800A0009)
Subscript out of range: '[number: 15]'

View Replies View Related

Microsoft VBScript Runtime (0x800A0009) ... Subscript Out Of Range

I am dumping a recordset into an array. And I would like to use the contents of the array to populate a text area. I get an error:

Error Type:

Microsoft VBScript runtime (0x800A0009)
Subscript out of range
/scripts/new_hires.asp, line 33

Where line 33 refers to: Code:

View Replies View Related

Subscript Out Of Range "ERROR"

I have a program that uploads a text file to the server using freeASPUpload.asp component. Then it updates a Access database that contains 3 fields.

After I select the text file then submit it, it uploads fine to the server and all the data is stored in the correct fields in the access database but this error prints out on the page. The page looks normal except for this error. Code:

View Replies View Related

Limiting Number Range

when a form is submitted which takes it to a process page, i have 2 seperate fields called hour and min to insert into a database field, basically what i want to do is run a check on the hour field to make sure it doesnt go higher then 23 if it does, return an error, also with the min field to not go above 59

View Replies View Related

Convert Real Number Into Text Number

I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?

View Replies View Related

IP Range

If an ip address falls in between 29.0.0.0 to 29.255.255.255 then i would like something to happen. I m not too good with the sql math part but i figured it would be something like this

Code:

<% if Request.ServerVariables("REMOTE_ADDR") >= "29.0.0.0" or <= "29.255.255.255" then Response.write("hello") end if

View Replies View Related

Sequential Number After Batch Number

here is the scenerio

in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003

Now each master batch can have multiple final mixed batch like

200701-0001-01
200701-0001-02
200701-0001-03

and this record is inserted in to fmix table.

so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,

how to achieve this

so in short each master batch will have more than one final mixed batch.

pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.

View Replies View Related

Retrieve The Error Number In VB With Err.Number

I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.

How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?

View Replies View Related

Out-of-range Datetime Value.

Once i inserted "date()" in date field
This worked fine for 3days
but on the 4th day I got this error

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Again I changed the format of date to oracle DB format
and Ive solved the prob

I just want to know why I got that error

View Replies View Related

Date Range

I have a database with a table that contains date fields "startdate" and "enddate". How do I build a code in asp to select the data contained between a date range entered
by the user?

View Replies View Related

IP Range Comparison

I need to compare an IP address to a database that contains ranges for each byte in a potentially "valid" IP.

Columns in the msSQL db are IP1, IP2, IP3 and IP4.

The problem is that one entry in the database may have a range. If I were to query all four columns and concatenate the data, I may get something like this:

12.35.124.12-89

So if a user sends me 4 variables (1 for each byte in IPv4) over a form, how I would I begin to compare this data?

View Replies View Related

Out Of Range Error

I'm trying to set up a random product feature on my site. Originally, I set up a hard-coded array of the ID numbers I wanted to randomize, but now I want to set it up so the random numbers are the ten most recent products. Code:

View Replies View Related

Date Range

My SQL statement is returning either 0 or all members not just the members that are beyond todays date.Code:

strCountPaidForumMembers = "SELECT COUNT (members.membersSubExpires) AS totalPaidMembers FROM members WHERE (((members.membersSubExpires)>=" & date() & "));"

View Replies View Related

Date Range

I have a db with dates. I have an sql select statement that is able to select records with a range of dates. The problem occurs when I choose a range of dates from 2 different months.

Code: .....

View Replies View Related

Inner Quartile Range

I'm querying to get an array of numbers. I need to find the "Middle %50" of that array of numbers. Is there a way to find the Inner Quartile Range using an ASP function? I cannot find any math functions that would do this.

Could I do it manually? Sort the values, split the array up, split it again to find the "Middle %50"?

View Replies View Related

Time() Range

I have this dropdown box and the options is TimeShift (6a-2pm, 2p-10p, 10p-6a ), im getting this data in a table (Acess DB) . My problem is how can i display (option selected) the actual shift based on the actual time. Code:

View Replies View Related

Date Range

I am looking to make a sql query with a date range of "last week". This would be 2 sundays ago to last saturday.

View Replies View Related

Specified Date Range

I have a requirement where I need to make a report for each auto dealer how many hits they got on specified date range, so for each car detail page I increment the counter and total it while doing that I store the last hit date, this gives the total hits for the dealer BUT does not facilitate date range

How do I give the user a date range so that he can check how many hits the dealer got lets say for last week OR last couple of days?

View Replies View Related

Date Range

I select from an Access table " where date >= '3/1/2004' and date <='3/31/2004' ", but no record. Can you tell me how to make this comparission?

View Replies View Related

Query By Date Range

I have to put Date Range Query using start and end date form. I have tried but when i run the query puting start and end date value in form, no result shows the records and when i only put start or end value the result shows the records. Code:

View Replies View Related

An Array Index Is Out Of Range.

I'm using "POST" vs "GET" because the string is so long, but I'm wondering if the string is to long even for "POST". Code:

View Replies View Related

Date Range Search

How to code for a date range search? For example I want to search for applicants who applied in between dates of Aug 1st - Aug 4th, how would I code it ? I am using ASP to code and SQL Server 2000 for DB.

View Replies View Related

Select A Range Of Dates

I want to select release dates from a large table and have it so my script only displays release dates PAST the current date.My script looks something like this but it's obviously wrong.Code:

sql = "SELECT * FROM searchtable WHERE console = '"& console &"' and release > "& date() &" ORDER BY release ASC"

The field "release" is set as a varchar with values such as 9/10/2005

View Replies View Related

Date Range Comparison

I am back with another question. I need to have the user input two dates for a date range--thats easy! But now I would like to pull all the files up in a directory that are within that date range. I don't know how to do a comparison on dates.

I already have a working script with a loop pulling up all the files in a directory based on one date entered and listing them ---now I want to make it pull up all the files within this date range---just need to know you can do a date comparison in asp.

View Replies View Related

Filtering Weekdays From A Range

I am trying (with Classic ASP) to pass from a form multiple selected check boxes. These are the days of the week. On the receiving page I need to check for the selected days between a date range (eg. 1/12/07 - 24/12/07) and write those dats to a database.

eg. all mondays and thursdays in the date range. I can wite the thing in vba no problem but into a web page and no satisfaction.

View Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved