Loop Of 20,000 Executes Properly
I've got a mailing list script which loops through up to 20,000 database records, and fires a customised email out to each via the bulk mail queing function of JMail Pro (email component).
Never having tested this with anything other than 100 records, I'm very wary about executing the script in case it times out or starts to misfire.Is there anything anyone can recommend to make sure this process goes smoothly, perhaps even giving the user feedback whilst it's executing e.g. "sending messages 1-1000", "1001-2000" etc?
View Replies
ADVERTISEMENT
Is there a way to count the number of times a while/wend loop executes. I'm using a while loop to display database records on a page, and I need to get a count of exactly how many loops occurred in a variable for use in a function.
View Replies
View Related
If I create the following ASP script:Code:
<script language="VBScript" runat="Server">
Response.Write("Hello from VB<br/>")
</script>
<script language="JavaScript" runat="Server">
Response.Write('Hello from JS<br/>');
</script>
and run it, I get the following output:
Quote:
Hello from JS
Hello from VB
As you can see, despite appearing later in the file, the JS is being executed before the VBS. How can I stop this happening? (I want to include a VBS file...)
View Replies
View Related
VBScript that executes using the cscript.exe. It needs to download the home page for each domain that has subscribed to the Hacker Protector service and compare the number of bytes to the previous days and if there is a change, notify the contact person via email that there has been a change.
View Replies
View Related
running w2k3/iis6 and trying to shorten the length of time that a simple 10
field ASP form takes to execute using CDOSYS. it takes about 50 seconds each
time...and I've no idea why?
any pointers here lads? on other servers the exact same script does it's job
in 3 seconds...but not this one?
View Replies
View Related
I created an RSS script for my readers to use, but I have been having some minor issues with it.
Actuallyit works fine and I have tested it in 3 feed readers without a problem. Still it does not output as perfect XML if you go here you will see what I mean. Code:
View Replies
View Related
The basic gist of this is that it makes downloading of podcast's available (currently) all the time. However I need it to make them available if and only if the date is the day after the podcast is recorded.
Currently the site is making them available the day before they're actually ready. How can I code this so that the asp page knows that the podcast should be available only on the day it is actually ready? Code:
View Replies
View Related
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
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
All i want to do is have a form with 17 checkboxes that writes a value to the database. At this point I don't even care, true/false this/that 1/0 whatever! Setting the Access Database fields to yes/no was not working even 1 bit in the least. They would all be set to off no matter what.
Changed it to text and inserting "That" for off and "This" for on, it comes up, but does it all funky, not in order, all "That"'s at the top, all "This"'s at the bottom, and not even in their respective fields. Code:
View Replies
View Related
Pretty simple task ... page1.asp calls page2.asp and I want page2.asp to show the HTTP_REFERER (which I expect to be page1.asp).
It's blank when I try from my local machine and from other machines. HTTP_HOST, URL and various other server variables work fine so there is a work around, but I'd like to know why HTTP_REFERER doesn't seem to work
View Replies
View Related
I am unable to get this function to output the correct output. The Subtotal works fine, but the GST and TOTAL are not working properly. GST only shows the integer value and nothing after the decimal places. Code:
View Replies
View Related
I am using what seems to be a fairly simple calendar program that is ASP. I have been successful in adding fields to this App, but for some reason, I must be missing something because when I go into the program to edit an entry, one of the value's (Location) doesn't populate properly.
It pulls up the LAST option (Other) within that dropdown field, instead of the one that had previously been selected. I'm not sure what I've missed, but could someone help? Here is a portion of the code: (let me know if you need additional info). Code:
View Replies
View Related
I have a number value in database and same number value from form. For some reason these are not equal. How can I compare these properly? Code:
View Replies
View Related
When I try to open an aspx file located on my computer it doesn't load properly (i.e not all objects are visible like text fields and such) and it gives me a syntax error stating that it expected a semi-colon (;) on one of the lines.
My page language is VB and so no semi-colon is required and when I load the file through my web server by typing
http://myIPaddress/myfile.apsx
the page loads correctly and functions normally.
Several hard drive formats ago I was able to open aspx files with internet explorer without going through my web server. I am pretty sure I have everything installed like IIS 5.1 and the .NET framework.
View Replies
View Related
I have a process that creates a whole bunch of files in a specified directory. The names of the files are the employee IDs with an .txt extension, so they are like
EMP001.txt
EMP002.txt
EMP003.txt
The background is a bit more complicated so I won't bore you with it, but I hope that I can add a button on the asp page that would
1) go to that specified directory, which is database-driven by the department id, such as
D:DepartmentDEPT001
and I'll be able to figure the directory path from the existing code
2) then loop through each employee id and append the employee name, so the above will become
EMP001JohnDoe.txt
EMP002MaryJane.txt
EMP003PeterKay.txt
The employee names are also database driven and my asp page will be able to provide the information.
What I would like is to have a button that would open the cmd.exe and make the appropriate changes, and then do the rename, and then close the cmd window.
I know that you can have something like: Code:
View Replies
View Related
Ok, I've been hung up on this issue for quite some time now and I would
like some help in getting it to work. I think this may be a setup issue
but I'd like to ask your eminences first.
Here's some backstory: I need to create a VB.NET classlibrary (or another
structure) to use objects for our business logic. However, as our upgrade
is an ongoing process, I must enable this structure to be run in both ASPX
and ASP pages.
Here's what goes wrong: I create a new solution. Create two projects, one
a ASP.NET web app, the other a classLibrary. I put a basic hello world
object into the classlibrary then get a return string from it in both an
ASP and ASPX page. Yes, the classlibrary has the build option checked to
"register for COM interop."
Now, the ASPX page runs fine - but the ASP page gives me the following
cryptic error:
Error Type:
(0x80070002)
/webApplication1/test1.asp, line 3
Line 3 is the Server.CreateObject command for the object in question.
No error string. The error code, when googled, reveals that it's "file not
found." That's about as useful as a kick in the ass. What am I doing
wrong? Why can't my ASP page use this object? If I can only get this
functional then I will have no further issues - we can start moving our
business logic and data logic from the legacy ASP pages to an object-based
back end.
View Replies
View Related
How to do if I have 2 cutoff date for online registration. There are 2 set of fee when user regiser. Early registration and after registration example
below code won't work
today = date
if today < 8/10/2007 then
sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/10/2007#
order by id asc"
else
sql1 = "Select * from MasterDefault where field_name='Registration_For'
and Status=true and RSRV_Field_1=#8/11/2007#
order by id asc"
end if
View Replies
View Related
I have a textbox which I need to display the data stored in a variable called "fname".
So, what I've written is:
Response.write("<input type=""text"" name=""fname"" size=""20"" value=" & fname & ">")
assume that fname="jason smith"
and, the textbox only ends up displaying "jason". So, anything after a space isn't displayed.What could be wrong? I know the <%=fname%> thing works, but that doesn't work within a Response.write.
View Replies
View Related
The following code is not working properly in IE6 but it does work for mozilla firefox. I am trying to open a new popup window without affecting the frame from "where" it came. But what happens when I click on the link is that the popup window is displayed correctly but the frame then changes to my default.htm. It is supposed to stay the same
here is my code
Response.Write "<td><a href=" & """" & """" & " onclick=" & """" &
"javascript:window.open('desc.asp?msg=" & tempdesc & "','" & rownum &
"','toolbar=no,location=no,directories=no,status=no ,menubar=no,scrollbars=yes,resizable=no,width=600, height=600,left=300,top=300')"
& """" & ">" & left(tempdesc,50) & "....</a></td>"
View Replies
View Related
Code like this
=======================
Select case q
Case "a"
Dim arr(5)
Case "b"
Dim arr(2)
end select
=====================
returns an error saying variable arr redefined.
Should it be like that or an I using Select incorrectly? Perhaps something
similar to break needs to be used?
View Replies
View Related
I used onMouseOver and onMouseOut to switch the image when mouse over the image. But for some images, this event doesn't work and some yes while i'm using the same method to call the event. Code:
View Replies
View Related
I am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:
<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>
The FirstName, MiddleName, LastName vars are supposed to take the array values later.
View Replies
View Related
I'm having a problem with a couple of things. The first is that I am using a loop to populate my table with the proper variables. When it comes across one that is empty it is leaving the cell blank.
The problem isn't that it is leaving it totally blank but that it isn't even putting an outline for the cell. This leaves huge chunks of white space here and there and looks bad. Code:
View Replies
View Related
I am attempting to send an HTML email which a hyperlink that will change based on the user's session ID. I need the hyperlink to display as:
http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id=
WHERE the id = Session("MM_UserID")
However I cannot seem to code this into the html string in the correct syntax, to where id=1 or id=2, etc. Does anyone know the anwser to this problem?The basic code I am using can be found below.
html = html & "<a href=""http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id="">"
html = html & Session("MM_UserID")
html = html & "<IMG SRC=""myImage2.gif""></A><BR><BR>"
html = html & "</br>"
View Replies
View Related
Am facing a problem when trying to display a carriage return in firefox in a title attribute,i ve tried using VbCr and chr(13) ,in either cases a strange character appears instead of the carriage return. does anyone know about this error. The code looks like this:
titles(iday) = titles(iday) & chr(13) & objRS("event_title")
<a href="javascript:showevent('0<%=links(i)%>')" title=" <%=titles(i)%>"><%=i%></a>
Am not having this strange character when running it on explorer.
View Replies
View Related
I have a page with 2 frames. The first one has a link that loads a page in the second frame. This page has a button on it. When the button is hit, the page does some processing and loads another page in the same frame (the second).
I use ASP and response.redirect or javascript in the onclick event of the button to do the redirection. When I refresh the page by clicking the button on the browser (IE), the second frame becomes empty. Please note that the src attribute of the frame is not set.
If I set the src attribute of the second frame to some asp page and then navigate to another page inside the same frame, when I refresh the page, the initial asp page is loaded in the frame regardless of the asp page currently loaded into the frame.
It seems that when you refresh the page, the frames are reinitialized no matter what pages are currently loaded in the frames.
I solved the problem by redirecting to the main page in the top frame, passing some parameters and resetting the src of the frame to the desired asp page. Thus, when the page is refreshed, all the frames are properly refreshed too.
View Replies
View Related
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
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
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
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
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
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 Related
