Cursor Location Issue
I have a recordset connection in asp that I am using to search records.If I use the client side cursorlocation (rs.cursorlocation=3) then it takes really long to return back the records due to which a timeout occurs.If I change the cursorlocation to adUseNone(1) or adUseServer(2) then the search is faster and without any problems. But the sort on records cannot be done if I use adUseClient(3).
I need to have sort on these records. I am using dynamic server side cursor.Also my result set is not huge ..just 80 records.One more thing that is wierd is that the result set comes back instantly for the first search,but takes forever when searched again for the same criteria. Eveytime I logout and login and do the search for the 1st time the search is quick and takes forever for consequnt searches.
View Replies
ADVERTISEMENT
I have an error with Cursortype this is the error again
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/titans/Private/Edit_update.asp, line 20
Now after researching this error it says that access does not support cursortype = 3 is this statment true and if so, how do I go around this.
View Replies
View Related
I have just uploaded my site and now when i connect i get this error:
"ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. "
any ideas as to how i can fix this - surely i thought that my hosting company wouldn't habe a problem with the cursor i am using - i emailed them yesterday and they are - "working on it"
View Replies
View Related
I have a logon field. When data is entered, the user is taken to a protected page.
The problem/question is: Whe you click the back button and return to the logon page,the user data is still in the field. I want it cleared when the user returns to the logon page.How should I approach this problem. Java?
View Replies
View Related
How would i have the first text area on a form have the text cursor alreay set in it, so that if a user is unable to see where the first box is or is only using their keyboard they are still able to fill the form in. I have the tabindex already set up, and i know you can set the cursor in a box when the page loads as i have seen it on loads of form pages and find it useful my self.
View Replies
View Related
When a page is opened is there a way to set focus of the cursor to a named input. I want the cursor to be in the input box when the page is opened.
View Replies
View Related
I want to set the focus to an special Textbox when the website is selected.how can I do this.I am useing C# - ASP.NET
View Replies
View Related
the cursor types and lock types while opening the recordset.
View Replies
View Related
I have an ASP page that acts as a log-in page. THe user is instructed to input a password. I was wondering if anyone knows how to default the cursor to that input box. This way the user does not have to move the mouse and place the cursor in the input box, they can just start typing a password.
View Replies
View Related
how to put a cursor into the necessary text box. I mean when you open a login page a cursor should be in the Login Name entering box.
View Replies
View Related
Two further problems:
1. How do I set initial focus on a specific textbox? I dont want to tab to it.
2. How do I make a sepcific button the default that is submitted when I press enter? I dont want to click or tab to the button.
View Replies
View Related
I have one of the most perplexing problems that I've ever seen! I have an application that simply wants to add a record to a recordset. My setup for this is as follows: (using MDAC 2.8)
set rsu=server.createobject("adodb.recordset")
rsu.CursorType = 3
SQLString = "SELECT * FROM TASDISTRICTS ORDER BY TDID"
rsu.open SQLString, cn, 1, 3
Here's the scoop - when this code is executed - the CursorType turns back to 0. I use this code for all of my hookups and have never had any problems. It is currently running fine against a different SQL database. So that is how I have funnelled this problem down to the differences in databases and permissions. However, I see no differences between the two.
View Replies
View Related
I am just starting in asp and would like to get an image to follow the cursor (ie if the cursor was at x=100,y=100 then the image would be x=10,y=10) and would move as if locked to the cursor.
View Replies
View Related
i m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record. That can person at site B cannot use record until lock or cursor is released.
View Replies
View Related
How can we write a cursor in an ASP file.? Like how we write in oracle.
View Replies
View Related
i am getting a error in asp page ... i pasted below script in head section
<script language="JavaScript">
function setFocus()
{
form.empid.focus();
}
</script>
<form name="form" method="post">
<body onload="setFocus();">
<table><tr><td>
<input type="text" name="empid" value=""></td></tr>
</table></form>
my page is not showing the cursor in empid field.
View Replies
View Related
I'm building a text file from a database table using the ASP
Write Method and would like to position the cursor in a specific
column position before writing the fields. As I loop through and write
the fields into strings of rows, I want to be able to put field1 in
row1/column position1, field2 in row1/column position10,.....etc.
I've included the basic code to write a string of text. I understand
the process of how to write the fields and loop, etc. If you would be
kind enough to just show me in there the syntax for positioning the
cursor before the write I will then apply it to my code:
View Replies
View Related
I am trying to expose a table from a packege in Oracle. I am using a Oledb Connection. I only know how to see the data using a Packege with only inputs parameters. When i use a output parameter it is do nothing..
View Replies
View Related
i m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record .That can person at site B cannot use record until lock or cursor is released.
View Replies
View Related
I'm using the following function, which uses a recursive call. every time when I get a conf it opens a record set. So increases the cusor count. Some times I'm getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded.
How can I avoid this ? Code:
View Replies
View Related
We are receiving an error in our ASP website that used to run fine on our old servers but seems to be struggling on our new ones, I'm wondering if you've seen this error before?
Microsoft Cursor Engine error '8007000e'
Out of memory.
/oob/activities/default.asp, line 470
The last line that shows where the error happening is different on every page but it appears at the first database connection on each page.
The only way to get rid of the error and get the site working again is to recycle the application pool for the site (or restart IIS).
We have two servers, one running IIS and the other running MSSQL 2005. Both are the following specs:
Windows Server 2003
HP DL385
Single AMD Opteron / Dual Core 2214
4 GB DDR
146 GB SAS
146 GB SAS
SCSI RAID controller
I'm completely lost on this one, as the code has not changed at all between old and new servers so there must be a config setting I've not migrated across somewhere.
The most bizarre thing is that other sites on the server are unaffected, once this out of memory error hits this site on the server all other sites still run and connect to the same database without any problems at all.
View Replies
View Related
I want 2 know how can I pinpoint the location of a visitor to my site thru his IP addr or is there some way else 2 do that??
View Replies
View Related
I have a client application that uses web services. When the client application an web services are in the same machine, they work fine. But when the application call the same web services hosted in other server, the server return: Code:
View Replies
View Related
I am using frames in html.
How can i redirect to an asp file in a new browser window.So that the redirected page opens in new window instead in a frame..
Code:
Response.Redirect "../pm/scriptlogon.asp"
View Replies
View Related
If there a scriptfunction I can find a word placement in ASP? I mean, like I give a string, and it returns and word's placement
View Replies
View Related
Is there a way to set the location where the input type="file" option gets its files from. I know you cannot set a default file, but is there a way to set where it starts looking.
View Replies
View Related
tell me anything they know about locating WAP users. I assume that there must be some information on their current cell sent in the WAP request headers, but i'm not sure. I want to make a WAP site that appears differently depending on the users cell location.
View Replies
View Related
I have created a global.asa file, but somehow it doesn look like it is working...I have only one simple sub-routine in it.
Is the name case-sensitive? I have placed it under [ www/myfolder/global.asa ]
View Replies
View Related
I attempted to find the cookie 'Prospect' in my Temp Internet Files in IE6
after I had set it in ASP:
Response.Cookies("Prospect").Expires = Date() + 2
Response.Cookies("Prospect")("u_id") = u_id
Response.Cookies("Prospect")("u_name") = sName
Response.Cookies("Prospect")("VisitorIP") = VisitorIP
....However, it does not appear to be there? Am I looking
in the wrong physical location?
View Replies
View Related
This is a dumb question but i am just starting out with ASP. I am working in vbscript and i am trying to do a OpenTextFile the problem is that i am editing my page on a different computer from where the server is. I know that if i were trying to open the file from the server i would type:
filesys.OpenTextFile("c:inetpubwwwrootfolder namefile name")
but i am writing this file to a server and i don't how enter the location, it is not on my c drive.
View Replies
View Related
I am use to the include file on classic asp for maintaining MS Access
database location. On using Visual Web Developer Express, I can only use the
MS Access database if it is located on the same folder with the web app. Is
there a way that I can locate MS Access as my database but the location is
not located on the web application?
View Replies
View Related
We have special kind of service that covers just north on America (US and
Canada), so we want to redirect users comming from another country to
another page.
I am looking for a web service or similar thing that tells me the country
and state/province of incomming IP address. I am sure it is possible but i
don't know who sells that service.
Could anyone refer me to any resources related to that ?
View Replies
View Related
Is it possible to get the filename, and more importantly the path, from inside an ASP file, when that file is included? I know it can be done for the base file using Server variables, but I can't figure out how to do that for an included file.
I need to write an application that uses include files, and that may be moved to another folder on the server...
View Replies
View Related
