Single Record In Array Produces Error.
I get a "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/tourasp/town.asp, line 200 "
error when running following piece of code:
set RS = Conn.Execute(strSQL)
DS = RS.GetRows()' -- (this is line 200)
RS.close
Conn.close
set RS = nothing
set Conn = nothing
If the recordset has two or more records in it, it works fine, but if the recordset has only record in it, I get the error. Code:
View Replies
ADVERTISEMENT
We are currently facing a strange problem. We wrote an ASP application using some sessions and database-connectivity, nothing special.
On some machines (we are all using IE5.5 / IE6) those applications produce a 404 error.
The pages that are called do exist (I checked it thousands of times and it is only happens on some machines). Most of the machines have no problem with that pages and do not produce any errors which makes me belive that it is no real programmed problem.
The strange thing is that a reinstallation of IE mostly helped and if not we reinstalled the complete computer (as you can guess this is no real suitable way.
Maybe it has something to do with the sessions we use, but they are not so big.
I hope (not for the one who really has) that somebody has also experienced this kind of problem and can point me into the right direction.
I also tried different IE newsgroups but they had no idea, that's why I now try to ask ASP-programmers.
View Replies
View Related
I have a table with one header, everytime I use this code (below) it returns EOF and I know for sure there is at least a zero there:Code:
set rs = server.createobject("adodb.recordset")
rs.open "SELECT myonlyheader FROM mydatabase", "dsn=whatever"
response.write rs("myonlyheader")
rs.close
set rs = nothing
What am I doing wrong here?
View Replies
View Related
I have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
On a site I have written some of the page's sometimes fail. It's where I have a currency in a text field - when the user attempts to update the value, the page throws an error. I have traced it down to being sometimes the currency is written as £60,00 instead of £60.00. So for some reason they're getting a commar instead of a period.
This only happens occasionally - the rest of the time the page works fine. The system the person is using doesn't change, and none of the code is changing. I've used FormatNumber with the paramaters of 2,,,0. Anyone had any experience of formating of currency just changing?
View Replies
View Related
I have developed an ASP application that can send as much as say 150MB of XML data to the client, if all records (approx 6,000) in the database are returned. Normally, users would choose filtering options and at most about 500 records would be returned at any time. It is rare for this volume of data to be download, but it can happen
My application runs on a corporate intranet. A rival contactor's 'expert' believes that it is intolerable for my application to generate this much data under any circumstances as it would unduly load the network
Ofcourse it is a simple matter for me to elimate large volume transactions by limiting any client request to a lesser number of records. If they really wanted all records several transactions would be necessary. That is, a paging mechanism could be provided
Given that there are many very large documents, pictures, and other media held on this intranet server, which users can view at any time I don't perceive this as a problem. Its pretty much a double standard. Also, the server script timeout prevents the server from being overloaded.
View Replies
View Related
I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example: Code:
View Replies
View Related
Microsoft VBScript runtime error '800a000d'
Type mismatch
I'm using Query String and using arrays to select data for a flash file.The 'type mismatch' is where my array starts.I'm not sure i'm using it the right way or not?
View Replies
View Related
I am receiving the following error when attempting to insert a new record into my database
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
The code below works 1st time through, but on the 2nd invocation (with TOTALLY different data), I get the above error message.
My database is an Access 2003 database, and everything else works fine !
Also, if I'm really trying to write a duplicate record, why doesn't it fall into my duplicate trap? Code:
View Replies
View Related
A page I'm working on contains a registration form which is supposed to a) update an Access database using ASP and b) email the contents of the submitted form to the camp administrator.
This is my first experience with ASP, and with any kind of database interfacing language, for that matter. Currently I'm struggling with the record insertion. I'll worry about email afterwards.
I'm using Dreamweaver 8, which is generating all the code for me. I have a testing server set up on my local machine (in my working directory, in fact). I've told DW to connect to the databse (located in %siteroot%/database) through the testing server using a DSN (same DSN as on the web server). Code:
View Replies
View Related
I get this weird error when I try to delete a record...
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Cal_EventID ='.
/calendar.asp, line 1596
Here is this code on line 1596.
Code:
SQL = "SELECT * FROM Cal_Events WHERE Cal_EventID = " & SafeSQL(request.querystring("eventid"))
Set RS=dbc.execute(SQL)
View Replies
View Related
i have a access DB, and a asp page to add the records to the database, i work on visual interdev, i get error when i run the code as:
ADODB.Recordset (0x800A0CB3)
object.provider is not compatible of performing requested operation.
/project/addprocess.asp, line 37 'points to rs.addnew line
my entire code is Code:
View Replies
View Related
I have am getting this error:
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. Code:
View Replies
View Related
Working on a order sys for a client. I go to create an order, no problem IF There are no other records in a specific table. It is working like this:
create order #1...creates "order" in order table and adds 1st item in orderdetail table...add items to order in orderdetail table...no error.
create order #2...creates "order" and gives an "HTTP 500 - Internal server error".
this involves one ASP page, two tables and one SP. Here they are: Code:
View Replies
View Related
I have a very simple Access database with these fields:
ID | Team | Score
I want a user to enter the new score of the team into a form and then it's updated. All pretty straighforward - except I'm getting an error at the bottom of this page:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forensic/update.asp, line 171
And when I submit the page I get this error:
View Replies
View Related
Can someone point out why this is giving me the error "Variable is
undefined: 'arrProducts' "
<begin_code>
Dim m_arrProducts()
Sub SerializeCart()
ReDim m_arrProducts(m_intCartCount -1)
response.Write("ARRAY: " & IsArray(m_arrProducts) & " Cart Count: " &
m_intCartCount)
For intCounter = 0 to m_intCartCount - 1
response.Write("product 1" & "<br/>")
Next
End Sub
<end_code>
the Response.Write prints "True" for IsArray and "2" for m_intCartCount.
View Replies
View Related
I'm trying to create a piece of code that randomly selects a record from a database (providing the record has not already been chosen for any of the previous 4 sections).
Here is my code:
View Replies
View Related
I have a booking form, called classroomform. On this form the user requests a classroom number, location, date, start/end time and number of students.
As it stands, the data is submitted via a submit button and an insert query created using Dreamweaver.
I already have various validation on the form, such as javascript which error checks for invalid times etc and asp validation which checks for correct dates etc.
However, the final touch that I'm looking to do is to add some code to the form which checks for duplicate entries that are in the database. I basically want an error check which doesn't allow the user to enter a duplicate record that is based on classroom number, location, date, start/end time.
Here's my code: ...
View Replies
View Related
Code:
SELECT * From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9
Now if i change this query to either of the below it reults in an error as nothing is puled from the database. Now if i run this query directly in Access, these 2 execute fine:
Code:
SELECT Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9
Or to
Code:
SELECT Distinct Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9
Size is a number (long integer) field.
Err.Number is -2147467259
Err.Description is blank. no description
Err.HelpContext is 5003251
I have increased the script time out and command time out time and still the same thing.
View Replies
View Related
i got this error when trying to looping through an array
Quote: Microsoft VBScript runtime error '800a000a'
This array is fixed or temporarily locked
Here are my code:
View Replies
View Related
I am retrieving a set of values from some checkboxes in a form. When I put the values into a variable it prints fine:
Code: .....
View Replies
View Related
I have a method on a com+ object that is returning an array of objects.
I know the array is popluated as calls to check the ubound and lbound
show valid values. However, any calls to get the value of a cell in the
array results in a type mismatch error.
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/idmTest/userTest.asp, line 30
I have pasted below some of the samples that i have tried. Each results Code:
View Replies
View Related
I am using a Replace function to replace single quotes with double when
submitting a text field in the database i.e. Replace (q, "'", "' ' ")
which works fine. When I retrieve the field from the database which has
apostrophe I am getting 'Object expected' error message. Is there a
way to fix this?
View Replies
View Related
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
View Replies
View Related
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
View Replies
View Related
I have been using recordsets to access data from a database.I then loop thru each row in a dataset and assign the values to the objects on my web page.The particular sql stmt that I have right now, only returns a single value from a database. I need to assign this single value to a variable in my asp code. Can I do this without using a recordset?
If I have to use a recordset, do I just do var1 = recordset("columnname") (I ofcource create the connection object, the sql stmt and stuff first).
View Replies
View Related
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies
View Related
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
View Replies
View Related
I'm assuming this can be done, but I can't seem to get it to work... I'd
like to easily return a single value from a sql statement, something like:
"intNewItems = conn.execute "SELECT COUNT (ItemID) WHERE ItemDate = Date()",
where conn is the connection object, etc. What am I getting wrong?
View Replies
View Related
I have a simple form submission but the problem is my SQL insert (or update) is failing if in the text field there is any single quotes (')
I tried running the like replace(textfield,"'","") to just remove them but it will still error out on me.
is there any other way to format the variable, do I need to use an escape character?
View Replies
View Related
I am trying to send a 'single' data type to a sql server db cell that is formatted for 'decimal' from asp/ado code and it is converting it to an integer. Should I be using some other data type in sql server?
View Replies
View Related
can i delete related data from 2 tables using a single sql statement? is my code correct? correct me if i wrong. i want to delete data where user click the delete link.
Code:
sqlDelete = "DELETE FROM Reservation R, Quotation Q WHERE R.resID = " & request.querystring("id") & " And Q.resID = " & request.querystring("id")
View Replies
View Related