I have a recordset which displays a feild with the initial value of 1, I want to be able to increase the value with whatever numer I choose.if I set antall = antall + 1, It increases with 1 nomather what number you put in, how can I make it work the way I want.
I'm again having trouble putting ASP records INSIDE html link. Here's the string I put inside Access field:
No room number specified (<a href='contact.asp?subject=corrections/addition for AASG.info group ID <%=(Recordset1.Fields.Item('group_id').Value)%>'>update</a>)
but it is not working. The link created in my html output puts out asp part LITERALLY and does not put the VALUE of the recordset.
This didn't work either:
No room number specified (<a href="contact.asp?subject=corrections/addition for AASG.info group ID <%=(Recordset1.Fields.Item('group_id').Value)%>">update</a>
i have a a SQL stored SP bringing out one recordset, I have a loop reading out all the records, what I would like to do it compare each record to the previous one and if it is the same then do something. I'm having trouble figuring out how to do the comparison as I loop through the records
I have two records pulled from the same field in a table, so it would look like this
NAMES (Field name) John (forename) Smith (surname) There will always be 2 records
I need to take both these records and split them into two variables - one for the forename and one for the surname - (I need to insert these values into SQL statement)
Have tried the following code 'firstname' contains both the first and second name.
I am trying to soleve the following problem using an asp recordset (connects to sql) A column in the recordset contains integers between 1 and 5. I am trying to find a way of concluding which integer is the most common, then the second most common, then the third. (In the event of a tie, the higher integer 'wins').
Hence if in the record set there were 5 1s, 4 2s, 7 3s, 1 4 and 5 5s the output would be Most popular = 7, send most popular = 1 and third most popular = 5. I am familiar with rhe recordset objects ie looping through the records etc .
I am trying to filter a table of users to select only those records whose roleID matches a value in an array. There could be any number of IDs held in the array from one to a few hundred. The array is generated by splitting a comma delimited memo field from a second table in an Access DB. I can split the memo field OK, I can response.write its values, but what I now want to do is add a value from another table to my reponse write loop. Code:
I have an interesting situation that needs to be addressed ASAP.
I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned.
The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever.
In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null.
I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.
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?
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
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:
I have a main data entry form which has a link to a detailed data entry form. The value of the link in the main form is the sum total of all the line items in the detailed form. The detailed form has fields to capture the individual line items like contracted service expense, travel expense etc. I am capturing the total of individual line items using session variables so that when the values of the main form is saved these total of line item values get saved. However, if one gets to the mainform via login and tries to resave the values (which is already saved), the above session variables (from the detailed form that contains the sum of line items) get null values. However, just navigating to the detailed form through the link and coming back to the main form sets the value in the session variables.My question is how to get the session variable values without having to go to the detailed form and come back to the main
if it is possable in ASP i could store a value in one ASP page and look at it on anouther ASP page. for example:
On a login page i want that page to store a value called rights that is a number. when it goes to any of the other pages EG add user, Delete users if the user does not have the needed rights to takes it back to the main screen.
I wish to get and set values on child controls on a formview.For example. Changing the text in textbox. Hiding or unhiding child controls based on user. Replacing a blank with a default or calculated value that will need to be generated at runtime.It seems as though this should be thoroughly documented, but I'm not finding much.
i need to know if i have a loop that outputs values for each month how do i get it to add the values and only display them every 3 months,(every quarter)?
jan 123 feb 234 mar 432 first Q 789<---------how do i do this? Apr 125 may 548 jun 323 second Q So on..
I need to use the value=rs("image") in a javascript function, but i need the selected value of rs("iname") in an ASP array. Request.form("dd1") will always give me the value of rs("image"). Is there any way around this?
Using a query statement, I am trying to add values into the textbox of an ASP page to enable users to edit it. But it only displays the first word of the record. The rest of it gets chopped off. Code:
<P>Company Name:<INPUT NAME ="CompanyName" style="WIDTH: 371px; HEIGHT: 22px" size=47 Value=<%=objRec.Fields("company_name")%>></P>
The value in the textbox only shows R1 when the value in the SQL database is R1 International Pte Ltd. The datatype in SQL is char if it makes any diff.
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> }
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?
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:
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' "
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)"
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.
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
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)?
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?