I've got a page that users of my website are sent to when they log in, and one part of it shows their friends (think myspace). The page works fine if the user has one friend, but it seems that if they have more than one then i get the "Operation not allowed" error.
I won't post the whole page because there's about 750 lines of it, but here's the code that gets the friends images from a mysql db and then shrinks them (if necessary) and puts each image into a table (for a tidy layout):
NOTE: "sql" is in case there is more than one users image to get, i've checked the query when there is more than one user image to get and it looks fine... Code:
I keep getting the following error at the line "Do while oRs.EOF = FALSE". I've already added some code in the SQL standard procedure to eliminate the recordsets that are returned from temp tables (i.e. not the final recordset), but it still returns the same error.
The reason I'm using the recordset object is because I need to output the result of each recordset, and am not sure how to do this otherwise.
The error message and ASP code is below.
Error Type: ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed. Code:
The following ASP code yields the following error, but actually the new record is stored in database. The same error happens when the application deletes a record, such as sqlStmt ="delete from test where username='2323'"
<% Dim objRS, sqlStmt Set objRS = Server.CreateObject ("ADODB.Recordset") sqlStmt = "insert into test VALUES ('2341', '2341');" objRS.Open sqlStmt, strConnect objRS.Close Set objRS = Nothing %>
ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed.
Mainly I am asking if someone can look at a small portion of code to see if there are any obvious problems for use with mysql??perhaps with the way dates are inserted?? Code:
I'm using Shadow's upload script. whenever i try to upload a file larger than a few hundred kilobytes, i get this error: "operation not allowed; /_uploader.asp, line 56" at the top of _uploader.asp, i have changed the maximum file size to 50 mb. this is line 56 on uploader.asp:
there is a site using an Access DB, and they want a sister site on the same server, i.e. within a folder of the original site www.site.com/sistersite/, but using the same database, the error I get is
ADODB.Connection error '800a0e79' Operation is not allowed when the object is open.
I'm getting the error "operation is not allowed when the object is closed" on the following line:
<% If Not rsAlloAmts.EOF Or Not rsAlloAmts.BOF Then %>
I haven't dealt we this particular type of situation and not sure how I can bind the necessary values to the page based on what is passed in to the procedure. I'm not sure how to handle this type of logic on the page?
I have a problem with my programm and get the error above. In the file I've commented the relevant lines with **** and normaly the SQL-statement are in one row but there is a better overview when it looks like this.
I have created a form using post which directs to a psmail.asp page. i keep getting the following when submitting the form. Can anyone suggest what i may have done wrong?
Error 405 Method Not Allowed The requested method POST is not allowed for URL /html/psmail.asp Powered by Zeus Technology
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /changeprofile.asp, line 44
after reinstalling Windows XP (incl. IIS) it is not possible to create new webs on the local IIS in the likeweise reinstalled Visual Interdev 6.0.
After typing in the name of the desired webserver (machine name or localhost) the following error comes up: "Method not allowed(Error code = 80070005)". It is however possible to create webs with Interdev on other webservers in our network.
I'm trying to build a search for my forums that i'm building and now i'm getting this error: Microsoft JET Database Engine error '80040e14' Syntax error in JOIN operation. Code:
I m getting the following error when executing the below given code:
==== Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. =====
I have come up against a very strange error, well one I havnt got before - and was wondering is there a way around this. In my mysql db i have a price field which is set as "decimal(10,2)" but when I try read from it through my asp page I get this error at the line where i do my recordset query:
Microsoft Cursor Engine (0x80040E21) Multiple-step operation generated errors. Check each status value.
If I change the field type to "Integer(10)" its fine, it just doesnt like the decimal for some reason . And the thing thats really throwing me off is when I write the sql string doing the query out to the page and copy it into my mysql browser and run it, it comes back fine with all the data and no error.
I need to create a asp page with fields like FirstName, LastName etc. But this 2 fields only allow the user to enter english characters, no chinese, no jap.. nothing else..
What is there that i must do to disable users from entering character other then English??
Method Not Allowed The requested method POST is not allowed for the URL /Database/processForm.asp.
Apache/1.3.33 Server at antonyx.freestarthost.com Port 80
i just got this error, however, i have managed to post data into my database on this server b4, why is this error comin up now, could there be a prob with my asp file??
I would like to create a list of characters, and what to replace them with before inserting them into a database. So far, I know of the sigle quote, and you just replace it with two single quotes (' to ''). Are there any other ones that you guys are aware of?
I have a script that has worked flawlessly for a while. It allows a user to select from a listbox - with highlighted lines already of their settings, multiple lines (CTRL-SHFT) and the page updates the database properly.
Now, for some reason, I have a user that when we load their settings, all is fine. If I submit the form, immediately, with no new additional selections, all works fine. But, if I add even one new selection on the list box by holding CTRL-SHFT, the submit button no longer works at all.
This user does have a long list of selections already, I am just wondering if I may have hit a max some how?
My Default.asp page has a listbox to redirect the users to other pages on the web site.
If I access the web site by giving it the full URL, the listbox works fine (for example: http://domain/Default.asp)
But if I access the web site by just using the domain (for example: http://domain), the Default.asp page is displayed fine, but if I select an item in the listbox, I get the error "HTTP 405 - Resource not allowed"
I want to allowed my user to upload file to site. how can I make this work. so can anybody help me with this issueI will be using this software to build this application.
going from Users to Organization (links) or vise versa and totally at random.The error message appears in a pop up window:
"Internet Explorer cannot open the Internet site "file://C:aaProject x.x.x.x 80.hta". Operation aborted. OK"
After clicking OK the system will continue to work. This problem is not consistent and is seeing on part of clients PC. I found that most of these computers are using proxy server for Internet connection.
Does anyone have some good advice for the following situation?
If a condition is true, an insert is restricted ( aborted ) otherwise the insert is allowed. I have been killing myself on this for a week with no success. I just need some advise at this point. Currently I am running a stored proc that returns yes or no based on the variables that a user is inputting. If the sp result is yes ( a record already exists ) the insert isnt allowed and the user is forced to update the existing record.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /project/reg.asp, line 34
I have moved an ASP application to Windows 2003 and I have problems as I am currently using an Access Database until I upgrade it. However, I am getting the error: Operation must use an updateable query.
I have had this before so this didn't bother me too much. I added my IUSR_WINSERVER2003 to the security tab of the folder containing the database and gave read/write permissions. However, I am still getting the updateable query errors! I even added the Everyone account temporarily to see if it made a difference - and I still get the error. Is there something new in Win 2003 ? Can anyone help me?