I have read post after post after post on how to fix this problem and nothing seems to work for me. I have also been on the phone with my hosting company and all permissions are set to writable and modifyable. Here is the code for my UpdateHandler.asp page. which returns the following error:
ADODB.Recordseterror '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /members/UpdateHandler.asp, line 51
rsPART calls a table in access and i think the rest is self explanatory. the data type in access is already set to currency. so how do i get "cost" to display in a currency format? is there another way to format currency?
I 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 just had my hosting provider to add write permissions to this database but I am still getting the following error Quote: ADODB.Recordseterror '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Code:
I can't seem to go through this recordset,method isn't supported on any of the commented out lines, anyone know what my problem is?
Code:
dim objConn set objConn = server.CreateObject("ADODB.CONNECTION") objConn.Open "Received", "t", "b" Dim RS Set RS = Server.CreateObject("ADODB.Recordset")
dim strSQL strSQL = "select TOP 15 (requestNumber) as rn from request_received" RS = objConn.Execute(strSQL)
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. I am moving my webserver from NT4 using SQL to win2003 using SQL 2003. I get the above error when my asp page does teh line:
Rs.absolutepage = intCurrentPage
I tested teh value of intCurrent page and teh value is 1. Any ideas? The .asp Page works perfectly fine on teh old machine.
I want to call a recordset based on whether the 'expiration_start' date and 'expiration_end' date are within the current date.
I've tried a few things but can't get it to work?
Here's my non-working SQL statement:
Code:
sSQL = "SELECT * FROM poll WHERE #" & date & "# BETWEEN expiration_start AND expiration_end"
I'm simply using 'date' to call the current date. I'm not sure if that's correct but it seems to work ok when I use it in an "if" statement like this example:
I started noticing some page errors in my web application. All of the erroring clients where using Windows XP - MSIE 6.0. It seems these clients were passing the bookmark (fragment identifier) portion of the URL to the server.
For example, with the following URL: http://testsite.com/page.aspx?myquery=test#bookmark
The browser *should* send a request for: http://testsite.com/page.aspx?myquery=test
However, these clients were sending the entire URL as the request. Thus, my querystring parameter "myquery" had the unexpected value of "test#bookmark".
Has anyone else noticed this behavior? Perhaps it is related to the download.ject patch (released July 2). I have yet to recieve a response to this message, which was posted one week ago in two other newsgroups.
Does anyone know when MS is going to phase out suppport for ASP (not asp.NET, but classical ASP) in their operating systems/web servers? For example, they have already stopped mainstream support for the main tool used to build ASP pages (Visual Interdev). It is very much possible that in the days to come , they come up with a version of IIS which does not support classical ASP. Does anyone know when that is supposed to happen?
I've been trying to write a an RSS feed program in ASP, but I cant find any decent or much reference to a good asp/dom/xml example. I want to be able to read AND write XML to a file system on a server. Does DOM support exists for ASP. I want to have full control over the XML like you can in PHP for example saying Node node = root.childNodes()
and then saying somthign like "for each node get child nodes" and attributes and what ever else I can get. The things I found so far are very limited. Does anyone know of anything like this. I've spent all yesterday and today looking and I still havent made much progress.
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page: GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
How do I enable my server to support ASP files?Am I even posting in the right thread? I am running windows server 2003. Could I enable this server to support ASP files?
Like IIS installed on it. Its not my server, so i dont know all about it or exactly what the company is, but i can upload whatever i want onto it. Im a complete beginner, so can anybody give me some sample code to test if it supports asp?
I have been using ALS for a while, and I want to be able to create my own version, But the only issue I have is being able to track users realtime, ie get what page they are on, how long they have been online, and being able to contact them by throwing a pop-up.
ALS does it but i've tried scoping the coding, but can't find anything.
Error Type: ADODB.Recordset (0x800A0CB3) Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Code: If checkAttemping = FALSE Then objRst("Ended")= FALSE 'reset old attempT
I would like to start using Outlook Web Access on my IIS 5.0 server. It has PHP and MySql on there along with their ISAPI filters. Everything works great. It has the ASP support taken off and I would like to re-add this support back to the server.Where is the ISAPI filter located at on the Server?
I am hoping that this would be the only reason that OWA will not work.
In my ASP page I set the charset to UTF-8 Response.charset="UTF-8"
But all the javascript functions included thourgh a .js file does not work. This happens only on IE6.0.28 and works fine on IE5 and IE6.0.26 also. If anyone of you guys have worked on mulitlingual support if u could mail me your ASP page,which uses a charset mail to me.
I have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
I need to support my web pages both in english and spanish. Is this possible in ASP. Can u please point to some places(websites)/articles which will show that. Or if you have any code Or any leads into it that would be great.
If application deals with browsers that do not support cookies, then what I will have to use other methods to pass information from one page to another in your application in the ASP.
Those pages does not output any thing if I use IE and If I access the pages from machines running Windows 2000 Server, XP or Windows NT Server. Opera outputs as per session variables name.
IIS server is running Windows 2000 server. I've checked the cookie settings which was set to accept cookies.
I'd like to bcc someone using Bamboo. I've tried setting smtp.BCC, but it doesn't work - gives an internal server error. Does Bamboo in fact support bcc?
IT also has almost all of the features I want. It uses a microsoft access 2000 database (I use the following code to connect to the database:
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " DSNtemp=dsntemp & "DBQ=" & server.mappath("SOMEPLACE") sqlstmt = "Select * From TABLENAME" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sqlstmt, DSNtemp, 3, 3 Do until rs.EOF or rs.EOF)
The code works fine, I would just like to add a thing and it would tell what page the user(s) are/is at and then I can request a chat with them and a box would pop up asking them if they would like to chat. My oly problem is how would I keep track of the visitors on my site, and how would I know when they left the site?
how ASP (not ASP.Net) to do the following things: 1) Get real-time information from other web site such as tracking via Fed-Ex; 2) Real-time credit card charging via a payment gateway such as WorldPay; 3) How to support multiple languages.
i want to build a ticket support system for my company, so when a client has a technical question, they can email a support address and get assigned a ticket number. then my colleague will get the email and respond when he can. my question/s is:
a) is there any existing system i can use (free if possible. i would rather use an existing system as i have limited time!)
b) how can i write some code that acts when an email address is sent. ie: user sends email, the server receives it and executes some code (sends an email back with assigned ticket number and adds record to db).