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

Cursor

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

Cursor Error

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

Persistent Cursor

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

Text Cursor

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

Cursor In Position

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

Cursor On First Control

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

Cursor Types

the cursor types and lock types while opening the recordset.

View Replies View Related

Input Box Cursor

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

Cursor In The Text Box

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

Cursor In First Text Box

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

ADO - SQL Server Recordset Cursor Changes

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

Image Tracking A Cursor

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

Lock Or Cursor Problem

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.?

How can we write a cursor in an ASP file.? Like how we write in oracle.

View Replies View Related

Placing Cursor In Input

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

ASP Write Method - How To Position The Cursor

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

Problem To Call A Package With Ref Cursor In ASP

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

Cursor And Lock Type Problem

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

Cursor Count Problem In Recursive Calls

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

'Out Of Memory' Microsoft Cursor Engine Error '8007000e'

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

Location Thru IP

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

Cannot Use Web Services From Another Location

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

Redirect Location

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

Word's Location

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

File Location

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

Location Finder Over WAP

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

Global.asa,location

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

Cookie Location After Being Set?

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

ASP OpenTextFile Location

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

Using Access Database On Different Location For .NET 2.0

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

Geographical Location Of Incomming IP

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

Included File's Name And Location

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







Copyrights 2005-15 www.BigResource.com, All rights reserved