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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
how can i do an swapping of images by dragging an image into another image to swap their position.
View Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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