Loop With Multiple Conditions
I have a recordset that returns say 5 records. I want to loop through the recordset until three specific conditions are meet in one of the records. Code:
View Replies
ADVERTISEMENT
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:
Conditions
I'm using SQL/ASP, I'm trying to pull a record from one mdb table and copy it to another mdb table, but i'm having some problems.. here is my code:Code:
Sql_sel = "SELECT Top 1 CUSTID FROM cust ORDER by CUSTID DESC"
CUSTID = Sql_sel
response.write(CUSTID)
Line 1, CUSTID being the ID field, cust being the table which holds the records.
Line 3, is a test to see if it pulls the right data, unfortunately it doesn't infact where i was expecting to see the lastest CUSTID displayed it infact just displays Line 1 as i have written it. This mkaes me beleive that i have made a simple syntax error.. can anyone spot any faults?
If Conditions
I need to make sure that all the If conditions are true before proceeding, but I'm not getting the synthax right.
If Len(Request("txtFName")) <= 20 and Len(Request("txtLName")) <= 20 and Len(Request("txtAddress")) <= 255
For example in another script, it would look like this:
if (Len(Request("txtFName")) <= 20 && Len(Request("txtLName")) <= 20 && Len(Request("txtAddress")) <= 255)
What's the right VBScript synthax?
If Else With 2 Conditions
<% if Recordset.Fields.Item("Question1").Value = "No" & Recordset.Fields.Item("Question2") = "Null" then %>
This doesn't seem to be working for me. Am I not joining the two conditions correctly?
SQL Query With Two Conditions
I want to add another condition in the SQL statement below:
strSQL="SELECT * FROM Table WHERE Subject LIKE '%" & strKeyword & "%' AND ReplyID=0;"
Is this correct?
Two Conditions Adding Each Other
why do conditions add themselves together if they are ints in a for loop?
for x = (iCurrentPage*10)-9 to iCurrentPage*10 OR searchRS.recordcount
response.write("hello")
next
iCurrentPage = 1
searchRS.recordcount = 4
The two conditions to end the loop add eachother and the loop prints hello 14 times. How can I have two different conditions in my for?
Meeting All Conditions Of Query
I am working on a login form that asks for either a login number OR first name and password. When all three fields are completed on the form, my query only checks to see if the first condition is true. I need code that keeps users from only filling out the first condition (login) or the second condition (first name and password), but not both. Code:
View Replies View RelatedVerify New Password Meets Format Conditions
I'm working on a site which is password protected using ASP and an Access database.
I need to require that new passwords be at least 8 characters and contain at least one character from upper case, lower case, number and special characters. I've searched but haven't found anything that looks like it would work - only scripts to prohibit certain characters.
function mt_valForm(val)
{
var passed = true;
var mt_error = '';
if (val.txtusername.value == ""){passed=false; mt_error+="Please provide a user name
"}
if (val.txtpassword.value == ""){passed=false; mt_error+="Please provide a password
"}
if (val.txtemail.value.indexOf("@") == -1 || val.txtemail.value.indexOf(".") == -1){passed=false;
mt_error+="Please provide a valid email address
"}
if (mt_error!= ''){alert ("There were errors - please correct these:
" + mt_error)}
return passed;
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:
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 RelatedSQL Server - Update/Insert Multiple Cols Into Multiple Tables
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
Searching Multiple Memo Fields In Multiple Tables In Access
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
How To Update Multiple Records With Different Multiple Value
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
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
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
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?
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%>
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
%>
More Than 1 Do Loop
I am using ASP and need a DO LOOP to get some info back from the db. but the asp reads the first do loop but does not read the second one ......
View Replies View RelatedWhile Loop
is there any function or statements that work the same as the 'break' statement in C++ language?
for example:
While Not rs.EOF
If rs("LoginID") = userId Then
break 'what shd i use for ASP???
Else
rs.movenext
Loop Within A Loop
im writing some script to add records to my db. but if a value thats about to be added exists, then dont add that record.for example: if i want to add 7 records to my db with the values 1 - 7, but the db already has 3, 5 and 7, then it should only add 4 new records (1, 2, 4 and 6).
i have a record returning all records form my db, and an array with the values i want to add. i want to loop through my recordset of all existing entries, then for each loop, start another loop to see if the value exists, and if it doesnt , then add a new record.
For Loop Or Do While Loop
How to use the for loop or do while loop to create the age range from 10 -100 to let the user to select from the form object - list/menu by using asp? The coding below is just a concept. For example
Response.Write("<select name=""select"">")
for (a=0; a<101; a++)
(
Response.Write("<option value=""" & age & """>" & age & "</option>")
)
Response.Write("</select>")
If Then Else Loop
I'm trying to create a page where images are displayed based on an id in a sql table (basically its an unlit candle until a value in the id field exists). I'm not getting an error with my code below - but its not working right either. Code:
<% If rs("my_id")="2" Then Response.Write "<img src=""images/07.jpg"" width=""56"" height=""97"" alt="lit candle">"Else Response.Write "<img src=""images/UNLIT_07.jpg"" width=""56"" height=""97"" alt=""unlit candle"">" End If %> ...
Sub And For Next Loop
I have a SUB which has input variables. If I run it once its okay, but I need to include it in a for....next loop. Can this be done ?
for i=0 to 100
call mySub(arr(0,i))
next
sub mySub(var)
.....code
end sub
RS Loop
I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range
(null)
/database/data_entry.asp, line 90
Line 90 is shown below...
// count the total records by iterating through the recordset
for (rsProducts_total=0; !rsProducts.EOF; rsProducts.MoveNext())
{ <---- Line 90
rsProducts_total++;
}
This is an access database, connected to via a DSN. Any help will be muchly appreciated! I'm stuck on this one.
For Next Loop
I'm using three loops on a page and would like to set the loops individually to start at either 0 or -1 based on a condition. As an example, I would want the loop to start at either -1 as shown or 0.
Dim r
For r = --1 to Session("TotalRowsF")
code...
Next
Or, based on the condition it could be
Dim r
For r = 0 to Session("TotalRowsF")
code...
Next
ASP Loop
I can display some text 5 times using a loop and i want to pass those printed
values to another page when i clicked send button.
Loop D Loop
I'm trying to give the variable sStart a new name on each loo
EG
sStart1 = value1
sStart2 = value
however the following piece of code doesn't work
set oNodes=xml.selectNodes("/Project/Tasks/Task/Start"
for each oNode in oNode
sStart=oNode.tex
response.write("<BR>"
for i=0 to 10
response.Write(sStart(i)
nex
next
Next Or Loop?
I've been coding now for around 3 years. A year ago, I inherited a forum from a friend who didn't have the time to run it anymore. It's an old, very old, version of the WebWiz template, much modified. So modified in fact that upgrading to a newer version is impracticle, the best I can do is add features that you'd expect a forum to have these days. Code:
View Replies View RelatedDo While Loop / ASP
Here's my problem (aside from the fact that I'm a newbie.) I'm using ASP to call an Access database with four separate tables. The first three are working perfectly. The fourth is a little more tricky. I'm pulling the information based on a registration number (entered via a form). In the fourth table, each registration number is listed multiple times with production information for each year and quarter. For example:
(reg number, year, quarter, # lbs, amount)
A008374 - 2001 - Q1 - 840 - 232
A008374 - 2001 - Q2 - 520 - 164
A008374 - 2001 - Q3 - 8256 - 3368
.
.
.
etc.
I want to use a Do While...Loop (print the information while the registration # is equal to the one entered) to print out the information for each entry. Code:
Loop-de-loop
what's causing the error "loop without do"? whenever i put a do in it keeps coming up with more errors. Code:
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#E8E8E8">
<tr>
<%Do Until RS1.EOF%>
<td align="center" width="25%"><font face="Trebuchet MS" size=2 color=<%IF RS1("Status") = "Booked" THEN%>FF0000<%ELSE%><%END IF%>><%IF
RS1("B.Room") = "Booked" THEN%><a href=blah><%=RS1("B.Room")%></a></td>
<%RS1.MoveNext%>
<%
loop
%>
</tr>
</table>.
For Each Loop
I have a form with a select object ("Select") that will allow me to select multiple values. I put the following code in my asp file to display the values:
for each Item in request.form("Select")
vValue = request.form("Select(Item)")
response.write(vValue & "<br />")
next
The above code produces only multiple blank lines for the selections.