RecordSet.Move

I'm trying to use either one of these methods to position the cursor in a specific position inside a recordset, but neither one seems to work. For example, I have 10 records in my rsData recordset, and I issue this command

rsData.Move 5, 1 'move to #5 from beginning

I then retrieve rsData("field_name"), expecting that it'd return field_name of record #5, but it doesn't seem to work like that. What am I missing? Is there a restriction on what type of cursor a recordset must be opened in?

I'm using W2K/IIS5/ASP.

View Replies


ADVERTISEMENT

Move To ASP.net

I've been writting small simple webpage for years using FrontPage and ASP.
I'm thinking it might be time to take a look at ASP.net but am not sure
where to start. Is there a suggested site that would help someone move from
just ASP to ASP.net? Things like in ASP you'd write the code like X and in
ASP.net you'd write like Y.
Is there a (Free is possible) application that I should use to develop
ASP.net code in? I assume that FrontPage isn't going to cut it.

View Replies View Related

Move Row Up Or Down

I'm building a small CMS, and i've run into a "small" problem. I need a simple way to sort menu-items, have up/down arrows, to move menu-items. my table

id, item_name, item_order, stamp

1, Main, 1, 20060822
2, Contact, 2, 20060822
3, News, 3, 20060822

any clues?

View Replies View Related

Move To Dot Net

I have been running asp for several years and want to know if I could, what would I need to do to run asp and dot net on the same server. In other words, what more would I need to install on my server.

View Replies View Related

Move To .net

what do you think about moving to asp.net? All the code must be rewritten! asp.net a lot more faster than asp ? is it only advantage?

View Replies View Related

Move To Next Field

i have a page that calls images from a database, that is 3 images a page but in my database i have more pictures for one record, so i want to have something like a link that will call the next field that has an image and i want it to replace the ones that i already have.

View Replies View Related

How To Move Asp From IIS To Apache ?

I have asp pages running on IIS of XP prof.
I want to move to the apache web server

Can anyone explain how to do that?

View Replies View Related

Move To Next Field

i have a page that retrieve images from a database, but know the thing is i can only retrieve 3 images per page and i have a link that must call more images from the same record but replacing the ones that i already have!

View Replies View Related

Move Records From One Db To Another?

i was wondering if there was a way to move a set of records from one database into another database??

Basically i want to archive a whole heap of records that i already have in on database.

Im using an access database as well

Even moving them into a nother table would probably do as well.

View Replies View Related

Move Onto Next Line

i have a text area for user to enter remarks. and their remarks can be very very long
my output page is a table which i underline the lower boundry of the table.

when i wan to output the remarks on this line,it will over shoot the line and page.how do i make it such tat it will move onto the next line?

View Replies View Related

TAB MOVE FOCUS

I have a SSN Field which include 3 text boxes. How do I move the focus from one box to another as soon as user enter the max characters in the text box.

For example:when users enter 123 in the first text box of ssn control should move to next text box.

View Replies View Related

Move To Next Record

I have about 10 records within my database and would like each one to be on a featured page - I would like my SQL query to scroll through and display the next record with the database every 1 month.

As I only have 10 records, I would like the query to infinitely repeat this process. What should I add to my SQL query to allow me to do this?

View Replies View Related

How Can I Move First Value To Last In An Array

I'm trying to figure out how I could move the first value in an array to the end of the array so that the second value would then be the new first. I can't really wrap my mind around how I would do this.

View Replies View Related

Move Forward Next Data

I want to move to next data in the data set, however i am not sure what is the syntax.
Can anyone who know please advise me?Code:

strsql = "select main_cat_id, cat_name from main_categories where main_cat_id in (26,27,28,29)"
set rs = connectdb(strsql,strconn)
for i=0 to rs.recordcount
response.write rs("main_cat_id")&"<BR>"
rs next
next

View Replies View Related

Trying To Take Database And Move It To Textbar.

I am trying to make it where when the highlighted item from the pull down menu is selected then a small descripion will appear in the text box next to the pull down menu. Any ideas, I am sure it is simple, but I keep banging my head off the walls trying to get it. Code:

View Replies View Related

Move Contents Of One Folder To Another

Is there a function in ASP/VBScript that allows you to move/copy files from one folder to another. I have an application that run a script on some files and once this is done they need to be moved to a backup store.

View Replies View Related

Drag And Move An Image

how can i do an swapping of images by dragging an image into another image to swap their position.

View Replies View Related

Move To Last Record And Print?

I have a database with a table containing user names and I want to be able to move to the last record and display the user name.....so the end result is that I can display on my main page:

"Welcome to our newest member: XXXXX"

For some reason I cant seem to do this, it says to me that objRst.MoveFrist is ok but objRst.MoveLast cannot be accepted. Here is my code:

View Replies View Related

Move Site Without Downloading

I'm curious as I am in need of advice on how I can move a site from an old Win 2K server, to it's new home on a Win 2003 server, without having to mess around with downloading/uploading the file's (there's over 30,000 file's/folders, so it would take forever to do it manually).

I've heard of an ASP script thats capable of this, but can't seem to locate it.

View Replies View Related

Move Oracle Database To Another System

i have written a small asp code with backend as oracle.i have created a small database which is accessed by asp. now suppose if i have to move the database to another system along with code what should i do.

View Replies View Related

Button To Move To The Previous Page

I am trying to put a buuton into my page which will take the user back to the previous page. The reason i am doing this is that the user may come to this page from more than one other page.

I am using this code for the button, which i have seen on many code examples, but when i click on the button, it results in an error as if the existing page is trying to load itself up again.

<form>
<td width = "325" align="left">
<input type="submit" name="back" value="Back" onClick="javascript: history.go(-1)">
</td>
</form>

have also tried using the javascript: history.go(-1) code in the form declaration as the onSubmit attribute, but this just makes the same page load up again.

View Replies View Related

Error Type: ADODB.Recordset (0x800A0BADODB.Recordset (0x800A0BCD)

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?

View Replies View Related

Recordset Controlled By Another Recordset Within A Loop

I have created a forum, in which I have 3 tables:

1: Table_Forum
2: Threads
3: Replies

I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.

I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:

View Replies View Related

Recordset

I basically created 5 different recordset with names of
ObjRS2 ---> ObjRS6
The code is pretty easy to understand, but I'm missing something

<%
for (i=2;i<=6;i++)
{
%>
all of my HTML code calling the Recordsets....example
<tr>
<td>
<%= objRSi("something")%> <----- the "i" is where i want the counter obviously
</td>
</tr>
}

how would one make this work?

View Replies View Related

Recordset

I have a database set up for a survey where in the Answers table I have columns QuestionID, SurveyID, and Answer. Because my survey has about 300 possible questions it's impossible to make a column for each answer. So if I need to select the answers from a specific survey for a specific question and I have about 50 entered in the database my loop will have go keep going for about 15000 times. What I'm trying to find out is if there is a way to create a record set by selecting a survey by it's ID and then when I only have about 300 rows in the record set select answer from the record set using the questionID.
This is to update the answers for the survey. Also, another possibility would be update the recordset and then update the database. Is it possible to do that? Any directions to some code?

View Replies View Related

A Recordset Value

Doing a "modify a registry" html, I need to use the content of a recordset as an initial value for a text input , but it does not function the way I need to; this code gives me an error, look:

<input type="text" name="apeynom" size="25" maxlength="20" value=<% ob_rs("apeynom") %> >

the error shown is "Error de Microsoft VBScript en tiempo de ejecución error '800a01c2' Número de argumentos erróneo o asignación de propiedad no válida: 'ob_rs' "

how should be the sintax?

View Replies View Related

Recordset

I need to format a recordset into a particular format i.e.

Dim myDataStore

MyDataStore = ...

so that myDataStore =

[ 'record1field1',
'record1field2','record1field3','record1field4','record1field5'], [
'record2field1',
'record2field2','record2field3','record2field4','record2field5'], etc

I can do this OK for 1 record and know I need so kind of loop but am not
sure how to go about for the whole recordset?

View Replies View Related

Recordset

i ahve a recordset which takes data from a database using the shape command in a SQL statement. now i want it to show the data in a tabular fom such that the parent field has to it's right the child fields with out repeating the parent field again and again. And this done, the child field in the table should have the grandchild fields to is right and as before without repetition of the child field. and all of this in a tabular form!!!
i use a similar sql statement as below:
SQLTRY = "SHAPE {SELECT * FROM A} APPEND ( ( SHAPE {SELECT * FROM B} APPEND ({SELECT * FROM C} RELATE MachineNum TO MachineNum) AS rsparts) RELATECategoryNum TO CategoryNum)"

View Replies View Related

Recordset

I have the following code:
Code:
Set RS = Server.CreateObject("ADODB.RecordSet" )
RS.CursorLocation = 3
RS.Open ("SELECT * FROM " & the_table_name & " WHERE " & job_id_field & "=" & request.querystring("job") &""), cn, adOpenDynamic
Both have connections via the following string:

Code:
set cn = server.createobject("adodb.connection")
cn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(database_map_path)) & ";"
Only difference is that the newer version has the connection string included in another file, and the "RS.OPEN ..." line on the recordset code gives an error: "Too few parameters". Expected 1.

View Replies View Related

Recordset

When it pulls the user info from the db, it's fine, but when i come to display the info for editing, it doesn't populate the interests column.

Also, do you know how to change a form so that a certain field can send a blank string, or at least so that it doesn't require any input? Code:

View Replies View Related

Recordset?

can anyone explain to me what the code is trying to do?

if rsHistory(2) = "i" then
v_HistOperation="Clock - In"
v_HistTime=rsHistory(0)
else
if rsHistory(2) = "o" then
v_HistOperation="Clock - Out"
v_HistTime=rsHistory(1)
end if

View Replies View Related

Recordset

I'm working on a website where a compiled object returns a recordset. When I access the recordset, the memo fields are truncated. Is there anyway to get the full data from the existing recordset or is that a problem with the object itself and how the data is being queried (from SQL Server)?

View Replies View Related

Recordset

I have a recordset full of data from form input. I would like to insert this data into a table where the recordID = the recordID from a query string. Is this possible with recordsets? To specify where to add the record, as opposed to just inserting a brand new record?

View Replies View Related







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