Breaking While Loop
How can i break out from a while loop or for loop in vbscript.
in jscript we can use break etc..
in vbscript how can i do it. can i go to statment.
How can i break out from a while loop or for loop in vbscript.
in jscript we can use break etc..
in vbscript how can i do it. can i go to statment.
I'm trying to break this loop for 4 different contacts to be inserted into the system.
For new inspections I want to be able to search the DB for the Owner, User, Contractor, and Cert_Recipient for new boilers the certificate will be mailed to the contractor which will be the Cert_recipient first.
then for annual inspections I want to be able to search for Owner, user, and Cert_Recipient for annual inspections I will have to search the DB for either the owner or User as the Cert_Recipient
For some apparent reason I can't stop the search, it keeps going thru the loop. I must be missing something. Code:
Can anyone tell me why the funciton checkCode returning in the middle of the for loop breaks the for loop? ie. If I remove the section:
if checkCode("0011") = 1 then
response.write "<br />Passed submission of user code"
else
response.write "<br />failed submission of user code"
end if
from the code snippet below, then the code will successfully loop through and print out all the post var fields (there are in fact 4).
If however you leave this in, the function returning seems to break the for loop from continuing through all the other post variables after "user_code" Code:
Im new to ASP.NET as well as classical asp. To become strong in .NET, should i learn vb verywell (because im relatively new to it but it doesnt look that foreign working with vbscript) or the .net framework such as classes and server controls?
View Replies View RelatedI am wondering if any body can guide me on how to break up a string so that i can use the first letter as a querystring.
View Replies View RelatedI need to break out of the frames in the following line, or a line that does a similar thing:
Response.Write("<meta http-equiv=""Refresh"" content=""2; URL=http://localhost/MyWeb/Loanerz.asp"">")
I have a string of text which I have managed to seperate with commas
e.g. test,test1,test2,test3,test4
if anyone knew how to split this up into individual words. so i can write them to a databse.I have been stuck on this.
I am trying to merge 2 strings together from the database to create a meta tag. It comes up as
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="description" content="Looking for Architects in NY? Click here for Architects in New York."><meta name="keywords" content="architect, local, builders, home design, remodelling, construction, Albany County, Albany, Colonie, Saratoga County, Rensselaer County, Troy, Schenectady County, Schenectady, Montgomery County
">
It works fine, however the the last "> breaks off to the next line which shouldn't be happening. I tried searching for "<br>" and chr(34) (the carriage return),but there's nothing.
I have a script that allows you to edit an html page (the html being stored in a database). The problem is that any characters in the html disappear when viewing the page for editing. Is there some way to escape them?
View Replies View RelatedI would like to prevent a page from breaking out of it's iframe when indexed by a search engine. I would like to use asp (which I am just starting out in) and I know it is somewhere along the lines of "yourframespage.asp?id=pageid".
Can anyone give me a rundown of how I do this exactly because I cannot seem to work out how to do it.
The login state in my site relies on a combination of session variables and encrypted cookies. Some of my users are reporting that they are being "logged out" by the system - which seems to be related to their cookies being blanked out. I've checked all of the code and now that it's not being overwritten by my ASP.
The weird thing is that my site has two domain names, both pointing to the same pages and directories (no redirect). If this problem is happening to them and they switch to the other domain name and log back into the site, they stay logged in no problem. It also seems to not recur if the person is "logged out" and then logs back into the site on their own.
I had one problem like this in the past, because I had a tracking cookie that was being written on every page, and found that some browsers (don't remember which) had a limit of how many cookies could be written - and when they hit the limit the oldest cookie was tossed out. However, I don't have any code doing this now.
Anybody have any ideas what could be going on? Are there any session variable/cookie limits on the server side?
Is there any way that I can break up text in a text field to spread across multiple fields in an access database? I've got a FAQ section that I want admins to be able to edit via an online interface. Unfortunately, it often doesn't fit into the 255 character restriction that access has. Any ideas?
View Replies View RelatedI skinned an LMS (Learning Management System) using CSS and Javascript. The forms were skinned with niceforms.js, the site works perfectly in FF, IE 7 and IE6 but in ASP the javascript doesn't replace the images with the skinned elements. All the javascript functions initialize but the images are not placed in. Code:
View Replies View RelatedI'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:
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 RelatedI 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
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
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?
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%>
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
%>
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 Relatedis 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
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.
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>")
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 %> ...
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
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.
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
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.
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
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 RelatedHere'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:
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>.