I am struggling with opening a database and reading data from it via SQL. Please tell me what is wrong with this code. I am trying to open up different tables and get information from them and put it on the one page. Code:
View RepliesADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
This is the error I recieve when trying to run my site. I know why. I am passing a non existed URL Parameter. However I would like to recieve a MsgBox that says that such record doesn't exist. Code:
It says I have 8 records but is not displaying them.
Error:
ADODB.Fielderror '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /deleteevent.asp, line 33 Code:
I have several pages I set up in my web site and I am having trouble with two of them - search and results. The stat_search uses a form which seems to work right and when I test the recordset on the stat_results page and enter a value it returns the right results.
When a value is entered from the stat_search page the results page displays the records with the right value and the Records _ of _ indicates the right number of records but when I use the Next or Last arrows to move to the next record I receive the ADODB.Field error. Code:
Howcome it doesn't work?
ADODB.Fielderror '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /gemetria/kjvresp3.asp, line 0
It was working before!!! Code:
This is the error I'm getting:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/ism5315/readtrends.asp, line 46
What I'm trying to do is select the records from my table that match the sensor and gauge the user selects. I have time fields that are optional, and I'm trying to get the page to work if the user selects no time frame first.
Of course, there can be mutliple records for the gauge and sensors, so I created a loop that should run thru and select them all. But I am getting the above error. But I know I am getting into the loop because I have included a response.write sql to verify I am selecting the correct objects. Code:
Exact error message:
ADODB.Fielderror '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/admindemo/profiles_browse.asp, line 0
Howcome it doesn't work?
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/gemetria/kjvresp3.asp, line 0
It was working before!
I've created a form whereby the user fills in there details into a datbase.Once there details have been entered into the database I want to show the Primary Key(there generated ID number).This is the code I have right now
<%
SQLQuery = "Select * from StudentReg"
Set GetDetails=MM_dbconnect_STRING.Execute(SQLQuery)
%>
<%=GetDetails("ID")%>
This however will only show the frist ID number in the database, not the one the user just entered. How do I get the current ID within the new record?
I have a cookie with a path of "/"
im trieng to delete it before the expired time has comed anyway i am trieng to delete it by setting the cookie to ""
like so: Response.Cookies("name") = "";
but its not working but...i found out that if i dont set the path it is being deleted but i have to set the path because from some reason without it i have issues where the cookie is not found in some pages.
I'm doing an e-inventory system using Dreamweaver MX, ASP. The problem is that I want the system deleted the item that user already choose to use, for example in the store they got 12 keyboard. then when user choose to take 2 keyboard, I want the system automatically state the item left in the store was 10.
View Replies View RelatedI have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.
So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.
I noticed that a database that was used and afterwards all its tables were manually deleted, is larger (in kb) then a new empty database.
Does the database store deleted records? How can I retrieve deleted records and tables from a database?
how i can build a script to list deleted domains ? then obviously i can add more features on from there, ive looked everywhere and all of them seem to be php so i cant see how they do it.
View Replies View RelatedI have a web application that simply has 2 text boxes with a start and end date. I have a submit button which triggers the delete from an access database. I use vb.net and asp.net with an access database.
I either don't display "record deleted" or always display "record deleted". I tried the textboxchanged, but that doesn't trigger until I hit the submit button. I tried response.redirect, response.write and even tried using a label with the message. Can anyone tell me how to stop the "recode deleted" upon clicking on the textbox or clicking anywhere on the form.
ASPNET profile/account was accidentally deleted on NT/2000 platform. Is there anyway to get it back without reinstalling the whole exchange/IIS services?
View Replies View RelatedI just recently moved from a shared account to a private server. On the shared account, everything worked fine, but after transferring every file as it was before, onto the new server, without any changes to code, the ldb files now won't disappear on their own, like they did on the shared hosting account.
I can manually delete them, but am wondering if there is a server setting that needs to be configured in order for it to delete the ldb files upon closing of the database?
Will these ldb files cause problems in performance if not deleted properly?
I'm pretty new at this so if someone could tell me what I need to do to the foloowing code I would really appreciate it!
strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc" ...
I am using the following to delete the contents of a cookie
Response.Cookies("maincookie").expires = DateAdd("d",-2,now)
Response.redirect "login.asp"
If i try to alert the value of the cookie in the same page, it shows
the old value. As well as when it is alerted from the login.asp it
shows the old value.
The problem is when i try to update the value of the cookie in the
login page, it does not update the new value.
Only if i close the browser and reopen, the new value gets updated and
even if the old value is originally present in the cookie.
I am specifying the domain and path when creating the cookie. the
expires property is set to date + 1 when creating.
What should be done to delete the contents of the cookie? Should i
specify the domain as well as path when changing the expires property?
I've been using text files for Tab-Delimited/ADO/ASP sites so that users can
update and display their products lists through my system with relative
ease.
Only problem is that for the last few months or so, this system has been
generating loads of timeouts. ISP has said that I should be looking to
upgrade my system, as it is the mechanics of it that are creaking under the
strain. My queries are:
a) Which REALLY performs better OLEDB DSN-less or ODBC DSN-less?
b) If I convert the system to use 1 Access DB rather than 50-odd
tab-delimited text files will this REALLY perform better in relation to
timeouts?
To give you some idea of the problems, the site can viewed by going to
www.bardwells.co.uk and clicking the Product List link.
I just can't understand it because the pages on the whole are very lean and
zippy (esp. ADSL), but its these exact same Broadband users who seem to have
more trouble with timeouts than dial-up ones.
in one of my sql queries on an asp page i am trying to select some data from an access table. The problem is the search criteria is based on a yes/no field. I need to find any record where the value is null or true. So far i have this:
if ISNULL(orseof("Returned")) OR orseof("Returned") = True then
the ISNULL section works it is just the = true bit that doesn't.
How can my ASP serverscript read a JPG file and create a small thumbnail
image? I don't mean simple resizing, but true resizing so that the image
actually gets smaller in size. Is this possible without the use of a 3rd
party component?Does anyone have a code example for me?
I'm getting this error:
Microsoft VBScript runtime error '800a0009'
Subscript out of range: 'True'
/Featured.asp, line 28
on this code:
If response.buffer is set to true, and no response.flush has been executed, is it accurate to expect that my browser should not be rendering the content which I (well Ok, someone else) is sending in response.write statements?
View Replies View Relatedi m trying to create a true and false quiz which accesses the questions from a access database processes the results and then writes back to the database
I dont know how to structure the code for the radio buttons,i also need to give the user immediate feedback, but i cant use pop up boxes
why does isnumeric return true?
a=""
if isnumeric(a) then
response.write("test")
end if
empty isnt numerical is it?
How do I evaluate a RegExp to true or false? Like I want to know if the value is correct or not using this snippet. Code:
View Replies View RelatedBeen having problems sending a true/false value to my database from a checkbox/radio group. Using checkboxes.... Code:
View Replies View RelatedHere's what I want to do (i'm kind of there in JavaScript, but want to move it to ASP).
I have 17 different html pages. quiz1.html > quiz17.html.
The user says take a quiz and it pops up a window holding quiz1.html.
Within each page is a true/false question. Upon answering the user is told:
1. what they answered.
2. if that is correct or not
3. a corresponding sentence about the question.
4. an image the corresponds to if they were corect or not.
(This is all done in javascript).
----
However, now I want to take these 17 questions and randomize them and choose 6 questions.
For example:
The window pops up and it's question 1 they do that then move to the next one. 1-6 (random out of 17.
I'd like to do this in ASP.
in my web page, i would like to user to see a ticked checkbox should the database = True however, i cannot seems to be getting it. Would anybody be able to help me out? Code:
View Replies View RelatedI have a big asp file that has an error under certain conditions -- totally
repeatable. However, it only fails when I set response.buffer = True at the
top. WHen I set it False in order to debug it, it works every time! I even
set it to True, but did a .Flush just before the error, and the error won't
happen.
It only happens when response.buffer is True and no .response.flush is issued.
The error is a string variable turns-up empty and crashes a function
requiring a date. I could test for this before the line where it crashes,
but where did my data go? Why is the buffer affecting it?
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
View Replies View Relatedwhat is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies View Related