Loop + Adding Records

I have loop displaying certain records depending on an id number in my sql database. What i need to do using asp is total all the numbers in one of the fields and display that as a response.write.

View Replies


ADVERTISEMENT

Adding To A Db Using A For Loop?

i am tryin to add to a database using the code below. i wanna add some data s amount of times and a different set of data t amount of times. basically i am addin the same data for the time been a set number of times eact time any ideas?

View Replies View Related

Adding Variables Whilst In A Loop.

I basically want to add together variables whilst my loop is running so I get a grand total at the end.

heres my loop (I've stripped out most of the code so it stays simple)

do while NOT oRSeofd2.EOF

varPrice = oRSeofd2("Price")
varDiscount = oRSeofd2("Discount")
varQty = oRSeofd2("Qty")


oRSeofd2.Movenext
loop

'What I would like to do here is to calculate the total of all the combined prices and qty. i.e. Code:

View Replies View Related

Loop Twice Through Records

I have what may be a simple question, how do I loop through a set of records twice? Here's a snapshot of what I have.

x = 0
do while rs.EOF = False
dim i
i = x
%>
<input type=text name="FirstName<%=i%> " value="<%=rs("Child_First")%>">

'I'd like to be able to have these input fields posted twice for each record.
<%
x = x +1
rs.movenext
loop
>

View Replies View Related

Loop Through List And Add Records

I have a list in a form where allows multiple selections

<select name="writerID" size="4" multiple >
<option value="no" selected> ---- writer ---- </option>
<%
do until RS.eof %>
<option> <%=RS(0)%> </option>
<%
RS.movenext
loop
%>
</select>
How do I make the loop in the add section where I have to retreive the records and add the selections?:

For ??????
RS.AddNew
RS("writerID") = request.form("writerID")
RS.Update
next

View Replies View Related

Inserting Records Using A Loop

I want to insert records into a database using a loop. I've got a number of input fields named 1-50. I want to request each textfield and insert the data into a database table.

Whats the best way of doing this? I've tried a While... Wend loop but the loop seems to carry on.

View Replies View Related

Adding Records

I have a table with 2 fields, name and value

I need to be able to add multiple records quickly, for example I need to add

name value
abc 1
abc 2
abc 3
abc 4
abc 5
abc 6

etc etc, does each record have to be added separately, or is there a way I
can add a chosen number of records, lets say 10, and have the value field
increase by one each time?

sometimes I might have 30+ simple records that need adding quickly, and each
time the first records value will be one, and each record after will
increase by one, is there a way to solve this problem or does each record
have to be added separately?

View Replies View Related

Adding Records

I have a drop down which has numbers from 1 to 25

When a user selects 3 he will see 3 first name textboxes and 3 last name textboxes

the user fills them out and hits the submit button

three records are added to the table

i have a for loop for adding records

Here is my code:

View Replies View Related

Adding Different Records

Just when you think something is working, suddenly something new comes along.this is my situation: I want to add intQuantity of all records that have the same prodID. I have tried all sort of variations but I don't seem to get it. I would imagine that it must be simple, that's why I can't get it.

SELECT SUM ( intQuantity) AS ItemTotal
FROM tblOrders
WHERE prodID = ? no clue

Or can I do that in ASP? doing something like (my example doen't work)
<%= (rsOrders("intQuantity") + rsOrders("intQuantity")) %>

in the mean time I'll be looking around for an answer to my lack of know how.

View Replies View Related

Deleting RS Records Using Loop Iteration

Can I loop through a recordset and with each record, see if the value of a field is higher than 5. If it higher than 5, just delete that record, not the whole record set and continue the loop.

I am accustomed to using a sql statement to selecting an entire recordset based on similar criteria and deleting the whole recordset in one swoop, but not this time. Code:

View Replies View Related

For Next Loop Issue With Empty Records

I am having an issue with a For Next Statement...

I have a query that is looking up Company ID's where Specific ID exists... across multiple Access DB's

Data is return ok, but if a specific ID does not exists a DB, the query loops the last Result in the NEXT statement for subsequents columns...

My question how do i get the FOR NEXT Statement to look at NULLS and return ZERO instead of loops the last results...

View Replies View Related

Deleting And Then Re-adding Records

I may have made a typo somewhere. I am trying to delete collections from RelProdCollection Table that has a certain record with Product ID number of __ and then readd them based on the user's choices on the edit form. Code:

View Replies View Related

Adding Values From Records

I want to add intQuantity of all records that have the same prodID. I have tried all sort of variations but I don't seem to get it. I would imagine that it must be simple, that's why I can't get it.

SELECT SUM ( intQuantity) AS ItemTotal
FROM tblOrders
WHERE prodID = ? no clue

Or can I do that in ASP? doing something like (my example doen't work)

<%= (rsOrders("intQuantity") + rsOrders("intQuantity")) %>

in the mean time I'll be looking around for an answer to my lack of know how.

View Replies View Related

Loop For Displaying Multiple Records From An SQL Query?

I have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.

Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:

View Replies View Related

Adding Records To Data Base?

I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:

View Replies View Related

Adding Records With Autonumber Field

I'm writing a database admin page in ASP. I had it adding records correctly. Then I added an autonumber field ("ID") to the table, and it stopped working. The sql I'm using is Code:

View Replies View Related

Adding Multiple Records With Checkboxes

SQL 2000 database with ASP

I've found many things "out there" regarding updating and deleting
multiple records with checkboxes but I can't seem to find anything
about adding them. A user wants to create a price list for their
client and they need to add parts to it in a separate table. I would
like to display the list of parts and the user would select multiple
parts to add to a price list by checking a checkbox and submitting the
form. Code:

View Replies View Related

Problem With Adding Records To A Table

There is something wrong with the adding code. It will add sometimes. It's a large database where I have to add records to multiple tables.

The products table doesn't work correctly. Maybe there's a typo somewhere that I don't notice. Please look at the bolded part of my code and see if you can catch something. Code:

View Replies View Related

Adding Records To Multiple Tables

i have an instance where I need to add records to 2 different tables. i know how to do it basically, but the problem is, one table is generating a key number and i need this number for the second table records.

how do i put the appropriate records into the first table, grab the id number and insert the records into the second number? the information is coming from a form. i'm developing in an access db but will be moving this to an ms sql db before it goes live.is there a stored procedure that might make this easier? i know nothing about stored procedures.

View Replies View Related

Adding, Deleting Records Using Global.asa

Can I do the following things in the global.asa file?

When sessions starts:

Add a record into my database

When session ends:

delete it where rs("sessionid") = Session.SessionID...

?

I'm pretty sure I can, but...I've heard not ALL things can be done in global.asa...

Do I create an object, and a connection? How would I do it? Since I want a database in MY database, not in memory like I've seen...

View Replies View Related

Error In Deleting,updating And Adding Records Using Asp!

I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:

View Replies View Related

Adding Records To Tables Via Dropdown Boxes

I have a form that uses Code:

<select name=player_id multiple>
<option player_id="<%=player_id%>"><%=FName%> <%=LName%></option>
</select>

To create a drop down selection list. What I want to send to a table is FName and LName instead of the ID. Any hints on how to do this.

View Replies View Related

Adding Records With Client-side Excel File

With ASP, how can I automatically add records to a database with an excel file residing on the user's machine? Assuming the excel file has the same field names/datatypes/order as my database table's fields.

View Replies View Related

Parameter Not Passed From For Loop To While Loop

I'm trying to pass a parameter from a for loop to the nested while loop
but only the first counter is passed. Here is the code:

View Replies View Related

Nesting One Loop Within Another, Using 1st Loop As Criteria For 2nd

I have a recordset that I loop through all of the data within a table, within the same loop, I am trying to add another loops that pulls information from the first recordset to base the second recordset off of: Code:

View Replies View Related

Systematic Updating Of Records Depending On Amount Of Records In Another Table

The problem concerns 2 tables, cart_products and cart_shoppingcart.

Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.

cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).

Now, what I want to do is this:

For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).

I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".

View Replies View Related

Pulling Records From End Of A Database Or Inserting New Records To The Beginning

I'm trying to pull the last 5 records from my database.

<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here

<%rs_article.MovePrevious
j=j-1
Wend%>

Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.

Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.

View Replies View Related

Grouping Records Within Another Group Of Records

I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".

I have the code correct for grouping by location. That code looks like this: Code:

View Replies View Related

Do While Loop?

I have a case statment like

select case code
case "01"
ups_desc = "OPTION1."
case "02"
ups_desc = "OPTION2."
case "03"
ups_desc = "OPTION3"
case "07"
ups_desc = "OPTION4"
case "08"
ups_desc = "OPTION5 "
case "11"
ups_desc = "OPTION6"
case "12"
ups_desc = "OPTION7"
end select


I then have table called "users" which has the following
id
UserID
Code

now the trick

I want to loop through the recordset of the user tables and populate a drop down where the code from the case and the user table are the same.

Something like

do while rs("code") = code
<option> This then is populated based upon the loop(I have this code)</option>
loop

View Replies View Related

Do While Loop

I need to insert recordes into a db based upon a number returned in a form
Somerthing like

AddRecords = Request.Form("NumberOfRecords")

Count = 0

if Count < AddRecords Then
Do while Count.eof

SQL Code....

Count = Count + 1

Count.move next
Loop
End If

View Replies View Related

How To Loop

i have 2 tables (A & B) with date records
now i loop table A and then table B, the output will be table A in the front
and table B in the back.how can i make the output show by date in both tables altogether?
do i need to combine tables before but the number of records is over 100K
which may spend a lot of processing power?

View Replies View Related

Asp Loop

on my classifieds site i would like to create a simple ads system. i currently have the ads site made but need some advice.

on my classifieds site i would like to display the ads down the left hand side.

however i dont want to over display ads.

if there is not many items listed i only want a small amount of adverts shown on the left hand side. however if there is lots listed
i would like quite a few adverts listed.

otherwise i would have a big list of adverts and only a small number of items listed making a big blank space on my page.

i am guessing this would have to be a loop or something.

the code i am using to show the text links is <%=adurl%>

View Replies View Related

For Loop

I am using a for loop in one of my asp page. Could someone let me know if I can do the for loop as follow:

[code]<% for i = 1 to 5 %>
my html code
my html code
my html code
<% Next i %>
instead of
[code]<%
for i = 1 to 5
Response.Write "<input name = 'id'"&i&" type='text' value = "&id& ">"
Next i
%>

View Replies View Related







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