I really dont want the user to see an "Either BOF or
EOF" error message, or infact to know that there has been an error, instead
i want to redirect them to the homepage,.. which brings about my question,...
Is the Error number for either BOF or EOF errors always 800a0bcd???
my plan is to do a responce.redirect if it exists
Is there a better way of handling errors than err.number, err.description and err.source. What i want is to be able to get the line, file etc that you get in the error message when you dont trap for errors so that i can email it back to myself whenever an error occurs.
View Replies View RelatedWhat is the best way to control is a transaction? I've done a little test and both of the examples below seem to do the job, but I was wondering which is the better method, this:
If err.number <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Or this:
If conn.Errors.Count <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
I have a client that has asked if I can provide his users with a downloadable rss reader that is hard-coded to his XML feed only.I'm thinking the download should be a java applet.
View Replies View Relatedthis is probably off-topic but, I was wondering what the best approach to coding recordsets.
I started working for new a webhoster, and i've been learning asp for the last 6 months.
My boss keeps pushing me to use Dreamweaver's built-in recordset handeling.
I feel that dreamweaver produces less-maintainable spagetti-code.
Comming from php i use a class for database stuff, i've ported my class over to asp witch works like a charm.
I am having problem with a search page cutting across multiple result pages.The form has two form fields,a listbox and a textfield.The method of the form is set to GET and the action was set to "no page" since it is supposed to take user to a result page based on the option selected on the listbox and the value of the textfield is used in searching the database. Code:
View Replies View RelatedI have this code and when the sql returns no results i get this error message:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I tried using this code to by pass it but than the table doesn't display:
if (Rs3.BOF and Rs3.EOF) then
response.write "No Comments found"
response.end
I have three sql statements each on populates a table but when the recordset is empty i get that message here is the code:
I am getting the following error when I try to access a table:
ADODB.Fielderror '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /~D30040860/secure/shop/transferorder.asp, line 98
It appears Macromedia/Dreamweaver was used in the development process. When I modify and save the ASP code the new code does not execute, it is as if some compiler is used to create the final executable code. Can some one explain this or direct me to where I can find out how MAcromedia/Dreamweaver works.
When I execute my asp written page i encountered an error known as:
<ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. >
But I've checked that my recordset did contain records and my session did not times out.
Enclosed are my coding which i suspect the errors might be raised from. Code:
Can someone tell me what code I need to write in order to prevent an empty recordset returning the error below?
I think the error is something to do with the page count.
Error:
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/newspublisher/edit/viewOlder.asp, line 17
Line 17 = objdata.AbsolutePage = lngPageNo
Code:
I'm getting this error :
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code:
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 Relatedhere 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.
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?
I am trying to configure apache::asp on apache2 and when i try to serve an asp page I get an internal server error. I get this in the error logs
66.249.65.228 - - [10/Jan/2008:12:57:57 -0500] "GET /asp/includes/functions.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:58:38 -0500] "GET /asp/includes/feed.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:06 -0500] "GET /asp/includes/contactField.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:19 -0500] "GET /asp/includes/encryption.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:33 -0500] "GET /asp/includes/LogonEdit.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:47 -0500] "GET /asp/includes/header.asp HTTP/1.1" 500 603
We've been expriencing periodic database connection errors with ASP code
talking to an MS Access database. Every once in a while, the code can't
connect to the database.
Usually there are no log entries that might point
to difficulties, but early this morning the Application Log was filled with
the 2 errors below. Once we did an IISRESET, the problem cleared. Does IIS
need to be re-installed, or??
Since upgrading to Windows 2003 Server from Windows 2000
Enterprise Server we have had alot of ASP problems. The
problems are centered around asp pages which are one level
or more below the main folder within a web site. We have
many web sites which have used the database interface
wizard in FrontPage which puts these pages up to three
levels deep inside the folder hierarchy of the main site.
The pages will not work with IIS 6. I have had to re-
engineer many of these sites without the database
interface wizard. My solution at this point is to put all
ASP pages at the root level which seems to work but
negates all version of Frontpage management including
FrontPage 2003 Beta. This is a serious problem!
Especially for us who teach FrontPage and ASP!
first, in NS (version 3, don't ask), get a
Code:
HTTP Error 400
400 Bad Request
Due to malformed syntax, the request could not be understood
what's that?
second, how do you turn the pop-up error alert window in IE for Mac off so that we can see the error in the browser window?
just for the record, the app works in windows fine, seems to have troubles on the Mac side.
I have a classic ASP application that runs fine on IIS on win 2000 or IIS on XP. But recently a client installed it on Win 2003 and now consistently gets an Internet Explorer-side error:' syntax error line. char 1' when he browses to it with IE 6.0.
When client moved the whole app as-is to an XP machine and then browsed to
it, he had no problem. I suspect the error involves client-side javascript. Iam looking into it; in the meantime:Are there a known issues of this kind involving IE 6.0 and windows 2003?
I recently finished a project for someone and they are getting 500 errors. What's driving me nuts is the application works fine from my location. All I can think is it could be a firewall issue but I've messed with my firewall and I can't reproduce the error.
What's ever more annoying is they are getting this error from more than one location. I don't see anything that would cause this. This is an admin application that uses Session and adds/updates an access DB. Works fine here.
Before we upgraded our intranet server to Windows 2000, when I had an ASP error the page used to load up to the point where it was crashing out and then I would get an error message. This allowed me to response.write values to find out where the error was happening.
Since we upgraded, all I get now is a 'page cannot be displayed' with the error message on it. This means that I can't response.write values anymore and makes debugging a lot more difficult.
Is there a setting somewhere that controls how the message is displayed? Is this in IIS or is it a browser issue?
I'm afraid I have a technical problem here. Basically what happens is that I'm getting some random errors(like Type mismatch... etc) that shouldn't under normal circumstances occur. Then I connect to my server via remote desktop and Recycle the application pool on which my asp pages run. Errors then disappear
View Replies View RelatedAll across my site i am getting 0x80020009 errors every so often.
they point to lines of code like
where FolderNAMEIN is a string such as "Botswana" and the
VarFolderNameLength is 150
if len(FolderNAMEIN) > VarFolderNameLength then
and
RS("Company") where Company is a valid field in the database.
I've get a problem in browsing .aspx pages locally.
I'm using Windows 2000 Advanced Server with IIS enabled
and .NET framework SDK installed, as well as Visual
Studio.NET.
But when I browse .aspx pages locally, I.E. shows "Server
Application Unavailable" message. In the Event log, I find
error event of ASP.NET 1.0.3705.0 with the description :
aspnet_wp.exe could not be launched because the username
and/or password supplied in the processModel section of
the config file are invalid.
I have written a script on an include page which pretty much will write all the required ServerVariables and session variables into a string and email off to me incase a page happens to error out.
I have the code working as I want it to using the folllowing:
If Err.Number = <> 0 Then
'RUN INCLUDE
End If
My issue is, where do I include this on the pages? If I put it at the top will it only run if there is an error at the start of the page or will it be assigned no matter how far down the page the error exists.
Or do I need to put in On Error Resume Next at the top then put the include at the bottom?
example,
I have 3 drop down boxes n a page.
1st box contains all countries,
2nd box contains all locations in that country selected from the 1st box
3rd box contains all items at that particular location selected from the 2nd box
Despite trying the codes given, I am still not getting it right!
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf14 Thread 0x4a4 DBC 0x10bbfcc Jet'.
/sanbookshop/searchtest.asp, line 22
I am trying to write a search script in my spare time at work. We have a knowledge base consisting of 200+ .mht files. My script was working ok when I was testing it on just a few files but I am getting out of memory errors trying to search through the whole KB. Here is the search code:
View Replies View Related3 workstations previously installed and able to access server.
4th workstation am able to map to server access files but when
attempting to log in receive the following error.
EXTERNAL DATABASE OPEN FAILURE
Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL
Server does not exist.
The workstation that is unable to connect is running XP SP2, MDAC 2.7..
the difference btwn this and the others is that it is running wireless.
Ruled out wirelss as being the problem because hooked LAN cable and
receive the same error. Code:
i am having troubles including a file
<!--#include file ="../Config/Connection.asp"--->
its brigning up an error message like this
Active Server Pages error 'ASP 0131'
Disallowed Parent Path
/account/ADMINCenter/Confirm.ASP, line 5
The Include file '../Config/Connection.asp' cannot contain '..' to indicate the parent directory.
ive tried placing the full path to the file in the include but i still get errors saying it doesnt not exist, but it does.
I have a form page that people fill out and push submit. When they push
submit, the information is stored in a database in two different tables.
You are then directed to a page that lists everything you have submitted so
you can print it. I am having problems with this second page. Information
from one of the tables is listed, but the information from the other table
isn't listed. They are related by the "casenumber" that is given when
submitted.
I have looked at the tables, and the information is there, and they have the
same casenumber, but the information doesn't get put on the 2nd page. We
just moved our site to IIS 6. Everything was working perfectly in IIS 5,
but is now "broken" in IIS 6. I always get the following error when it hits
the coding that should put in the information from the second table:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record. Code:
I haven't found this explicitly stated in any documentation, but i just
wanted to confirm this with people here. When there's an asp error on a
page, the request has appended to log something of the format
|-|ASP_0xxx|description. It also seems that this is inserted at point of
error, whether or not there has already been append to log data.
so, my questions:
1) is the |-|ASP_... always a consistent format?
2) does the |-|ASP... error message displace any other AppendToLog output?
I know the -query column only takes so many characters and anything busting
the limit simply gets chopped. I was wondering if that includes asp error
messages, or whether they appropriate some of the space
3) Why didn't they use something like &|-| as the seperator? using the &
would definitively close off any dangling query string variables, making it
easier for log file analyzers to separate the wheat from the chaff...
I am trying to create a search script but I am running into an out of memory error. Here is the search subroutine which loops multiple times:
Code: .....