Operation Called
I don't know the exact operators, but it's something like:
a?b:c
Which translates to:
If a = TRUE then
return b
else
return c
end If
I need this for an ASP script.
I don't know the exact operators, but it's something like:
a?b:c
Which translates to:
If a = TRUE then
return b
else
return c
end If
I need this for an ASP script.
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:
View Replies View RelatedMy global.asa is not being called.. any idea what may be the problem
View Replies View RelatedI am getting the below error when i am calling function of dll in my asp page.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'GenerateWelcomeLetter'
/cgi-bin/Anagram_Utils/welcome_letter/generatedoc.asp, line 72
dim a
a = false
a = welcome.GenerateWelcomeLetter (qry,template_filename, save_filename)
The function in dll is having boolean as the return type. Can someone plzzz tell me what can be the problem. I am using dll for the first time in asp.
My web site HTML comes from a database via querystring e.g. page.asp?pid=55. I have a separate asp search page, search.asp. Its output is retrieved by an ajax call from page.asp and its HTML is then neatly wrapped and styled by page.asp.
I want search.asp to recognise if it is not being called via ajax frompage.asp, but directly e.g. via the address bar (and if so, redirect to page.asp). Do I need to put something into the posted string, or (better) is there an asp method that can do this?
The ajax call is
function GetSearchPage(st) {
var poststr = "searchterm=" + encodeURI(st);
makePOSTRequest('/search/search.asp', poststr,'divFullSearchDisplay');
}
I have the a function which creates a table of search results from a paramater passed from the page Request as shown below..
<%
GetSearches(unescape(Request("serialNumber")))
%>
Is there a way to detect when this function has finished execution as i want to page a page loader on the page until all the HTML is build and ready for rendering? I have the page loader in a div so when the above function finishes i would like to disable or hide it via Javascript. That bit is fine it's just the how to send a call to the Javascript so the DIV can be hidden is the problem.
I have a logout button for my admin system. I really need on logout, to go back to the login page. This is fine but I also need the session set to false. I could do this via using a secondry page called logout.asp, and place inside that something like session.abandon and a response.redirect. But I do not wish to have a secondry page.
View Replies View Relatedmy web application has user name and password, whenever user logged in i set his status in database as 1 so that only one user can logged at one time with same login and i
write a code to set status to 0 on logout menu, but if session expired then status will remain 1.
i have written code to set staus to 0 in onSession_End sub but it not work all the time. Sometimes it works and sometimes not. So i m looking for an alternative way of doing it
I'm running my script locally and the cookie has been saved on the machine because the login page is by-passed (with the Redirect to "menu.asp" below.
OK - but where is my cookie stored? Or at least give me clue. What will the cookie be called and what text will it contain if:
iAuthorID = 1
iSecurityLvl = 3
uName = "barny" ?
The machine user is "flintstone" and machine name is "W2KPro". The CookieName will be "mABmyASPBlog" ....
I have an .asp file that generates a nav menu.
I have tried and tried to "include" this in the blogger template, so that I can update the menu dynamically, without fiddling with a cumbersome blogger template all of the time.
The question is, does anyone know how I can "call" this file in to the template successfully?
I have tried using <script> tags: something like:
<script type="text/javascript" src="http://url.com/menu.asp"></script>
But had no success.
Does anyone know how I can accomplish this?
When some of the SQL Server stored procedures I have written are called via
my Classic ASP page I have written I get the following error in the cell that
is supposed to be retrieving a single result:
"ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.
/Default.asp, line 130"
I have no idea why this could be occuring. Some of the other stored
procedures work just fine. Any one have any ideas?
I don't know if this is a truly esoteric question, or not, but I'm
wondering how (or even if) you handle a timeout on a transaction
within a stored procedure executed in a Stored Procedure?
A theoretical example of the stored procedure (sadly, I'm not allowed
to post the actual code):
Create proc sp_testproc @myval int, @outval int OUTPUT as
begin tran
select top 1 @outval= myname from mytable where recid = @myval
update mytable set myname='xxxx' where recid = @myval ...
This is a mix of technologies so I hope I've put this in the right place.
I have a system where people can sign up to a data feed. They place a single line of Javascript on their web page and a formatted banner of products is displayed based on the options they have chosen in their affiliate account.
<script language="Javascript" src="http://www.somewhere.com/feed.asp"></script>
The original system was built by our developer 3 or 4 years ago, and worked fine. However, he built the system using two ASP files - feed.asp which looks like this:
Code:
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.
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:
View Replies View RelatedPlease help me out. I am looking to filter records to a specific day. Here is my error:
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record./calmenu.asp, line 0
<code>
<%
objRS.Filter = "eventdate = 1"
If IsNull(eventcaption) Then
eventcaption = ""
Else
Response.Write(objRS("eventcaption"))
objRS.Movenext
objRS.Filter = adFilterNone
End If
%>
</code>
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:
Any ideas what this could be?? Error Type:
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?
I've been trying to make my db web applications to work in
my test server and I keep getting this everytime I try to
modidy the database:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
The curious thing is that in my web hosting provider's
space it works perfectly. I don't know what's wrong with
the configuration of my IIS. Any ideas?
I look at this document (nonsense):
http://support.microsoft.com/default.aspx?scid=kb;en-
us;q175168
what the message 'Operation must use an updateable query' means. I've been to the Microsoft site as well as numerous other sites and have tried all the remedies regarding permissions etc but nothing seems to work.
The application was working perfectly previously but since backing up the site and reformatting the computer it just won't let me access the DB (Access). Perhaps I'm setting the permissions incorrectly.
I am a newbie to all this, but it was all working fine for a while then i stope working. Ive got a Flash Form, and storing that data in a database. As i said it was working all fine and nice. Then this message started to show:
Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/processForm.asp, line 15
and the ASP code i use is: Code:
I want to do bitwise operation on some large integers.
For example,
Response.Write CBool(2 AND 2^30) ' returns False
Response.Write CBool(2 AND 2^31) ' CRASHED!
Looks like the AND operator can only deal with integers up to 2147483647? Is there a way to make the AND operator work with larger integers,such as the double datatype?
using Access, i'm trying to input form info into a database.
below is the part of the code that's giving me problems:
' Creating Connection Object and opening the database
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
con.Execute sql_insert
i get this error whenever i submit the form:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
I'm trying to run an UPDATE operation, using a command object. I'm getting the error back, Operation must use an updateable query. I'm not sure if I'm doing something wrong here.
Would it be the Command object settings you have to set before executing the command? Can someone tell me what those settings should be for an update query?? Is there a lock on the table from somewhere else???
I am trying to query an Access database using the like operation; however, when I test the query in the browser all records from the database are displayed. Here is my code:
View Replies View Relatedi keep getting this error:
ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/rces/insert-script.asp, line 108
here is the code with the highlighted problem line
Code:
im trying to add an insert record page page. I built the page...but when i fill in details and submit the form i get this error
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/longtonhighclc/Insert_news.asp, line 115
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. My code for this query is: Code:
Request object error 'ASP 0104 : 80004005'
Operation not Allowed
/ShadowUploader.asp, line 56
Any idea why this error is returned.
It worked fine a few times, with simple .html files I was uploading.
Then I tried a zip file. and got the error.
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/apply/reporting/report.asp, line 22
I am trying to return a recordset from a stored procedure into an ASP page with the following code.... 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: