Loop Times Out
There is 600 lines of code. This page gets available rooms from RoomInfo and compares the rooms againest rooms in use from EventRoom by RoomID. RoomInfo RoomID field is text. It can contain multiple rooms (i.e. 5,6,7) based on room setup type. I had to do it this way so that users could book multiple rooms based on configuration and how many people.
Line 412 is where the time out occurs. Also if I use split on rs2(RoomID) {line 415} then I can't start at 0, I have to start on 1. Which means 1 room is not being checked. I tried to annotate the code as best as possible. The page is zipped so you can download and view it. It will bomb if you try to run it on the server it is being hosted on.
View Replies
ADVERTISEMENT
I am creating a news page for a fun website just to learn, it has a simple html form that lets me post new news items to a MSSQL database.
The thing I am trying to do now is have the loop only run about 5 times, so that it displays only the last 5 news items from the database, I will then create an archive page which will display them all.
I have a book that I read and I found the for..next statement and I t would work nicely from what I am reading,
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
well, the following script that i wrote using the aspSmartMail component, keeps timing out on me. i tried setting the timeout higher through both IIS and in the script itself, but all that does that it take longer for it to timeout.
i have written a few email programms using this component, so i don't think it is the component. i have just never tried sending emails with it automatically that each have certain unique fields in it. well anyways, here is the code:
View Replies
View Related
I need to show how long a given file size will download.
View Replies
View Related
I've written a page that uses a emailer component and it keeps timing out.
It takes 2-3 seconds to send each mail, gets part way through the list of
recipients and dies.I have tried changing the Script Timeout setting in IIS to some huge number(2147483647?).I hve tried setting Server.ScriptTimeout = 0 and Server.ScriptTimeout =2147483647.
None of these make any difference. What can I do now?
View Replies
View Related
I want to compare two times 1 time is in a variable and the other time is todays time.
i want to get the time in h.m.s
e.g.
12.30.00
13.00.00
this would then output
00.30.00
which i then can then split and if their are 0 i can have get 30 min out of it.
View Replies
View Related
I need to subtract two times
Example : 1:45 AM - 2:55 PM or 5:45 PM -1:00 AM
View Replies
View Related
I have a asp page which pulls alot of data back from a SQL database, is thier any way to show the page while its loading.
I did some diging and found this:
<%
response.buffer=true
response.flush
%>
View Replies
View Related
I have a class that access an MS SQL database.I have another class also accesses an MS SQL database and this second class uses objects from the first class.I have a third class using the DB and objects of the second class.
Each of these classes contain all the code needed to access the database and this means much duplicated code. What I'd like to know is if there is a way to avoid the duplicated code?
I know I could write the code once,then do an #include to include the code into the class,but that still means multiple occurances of the code.
View Replies
View Related
I've done this before but cannot remember how. I have a field (FIELDNAME) in a sql2k environment. I just need to know how many times an "_" appears in that field. I cannot figure it out right now.
View Replies
View Related
I am trying to calculate (in minutes) the difference between two times. In the database the times are in this format:
Start Time (Game_Time): 1/1/1900 12:00:00 PM
End Time (GameEndTime): 1/1/1900 1:00:00 PM
Here is the code I'm trying:
Code:
GameLength = DateDiff("n",Game_Time,GameEndTime)
The result is: 780
I would expect it to be: 60 minutes
What am I doing wrong?
View Replies
View Related
I need to be able to display an image if the time is between two times. Here's the code I have, but it doesn't work.
dim strLink1, strLink2, strLink3
dim tcurrent, tstart1, tend1, tstart2, tend2
tcurrent = now()
tstart1 = "3/1/2006 7:00:00 PM"
tend1 = "3/1/2006 8:00:00 PM"
If Now() >= tstart1 OR Now() <= tend1 Then
'if tcurrent > tstart1 or tcurrent < tend1 then
strLink1 = "/images/2.jpg"
else
strLink1 = "/images/1.jpg"
end if
When I look at the page, the image never changes. It just always displays 2.jpg and not 1.jpg. I need help ASAP!
View Replies
View Related
How would I do it for DATE instead of Day of the week?
View Replies
View Related
I am trying to simply print to screen all the data in a colum from a .mdb file. Later I will do more advanced things but for now this would be good.
What I have WORKS, but takes a LONG time to retrieve the first record, if I tell it to retrieve more than one row it will time out. I was hoping to connect to the file directly and not have to create an ODBC connection. The code seems simple enough and the server is no dud (p4 2.4ghz) so do I need to setup a DSN and connect to it that way? Code:
View Replies
View Related
im making the web site for a small internet radio station and would like to add the feature to show which DJs are currently on air. I would like to do this by swaping an image at certain times or even dates.
For instance
dim image
if time = 05:15:00 then image = bob else
if time = 23:30:00 then image = dave
end if
Something along those lines but I dont know the exact code required to do this.
Would be really greatful for any help, I think it would be a nice feature for our listeners.
View Replies
View Related
I'm currently developing on IIS 5, ASP 3 and MySQL 4.1 using the latest ODBC driver from MySQL.
Any time field I have return from the database is returned as the current date. I've tried every table which has a date, created tables which soley keep records on the date.
I've submitted the date from MySQL Query browser using CURRENT_TIME and from an ASP page. Both submit fine.
I've returned the record using a Recordset to move through each and filled an array using GetRows().
View Replies
View Related
My interest is to guarantee that my users never need to logon again. Can’t put a session.Timeout to high because of memory on server. So how can I get the session refreshed before session times out?
View Replies
View Related
I'm sure you've seen them all over the place. Before downloading a file, it tells you the size of the file and the approximate download timedepending on your connection.
I have found a lot of javascript calculators out there where you input the size of the file and it calculates the time you need. These provide the end result I need, but 1) I hate javascript with a passion and 2) I want the download times to be displayed automatically when you select a file to download.
As a last resort, I can spend some time re-writing it for ASP, pulling the file info directly from the file in question (which would be a variable) rather than requiring an input of the size; but I'm wondering if anyone has an ASP version already done. Save me some time and hassle that way.
View Replies
View Related
I ported a script I made over to SQL Server 2k from Access and went from queries that took a tenth of a second to up to 30 seconds! Typically they are between 5-10 seconds.
All I can think of is I screwed something up in the connection procedure, and here that is:
Code:
set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout=30
objConn.Open "Driver={SQL Server};" & _
"Server=ipaddress;" & _
"Address=ipaddress,1433;" & _
"Network=DBMSSOCN;" & _
"Database=databasename;" & _
"Uid=userid;" & _
"Pwd=userpass"
set recordset=server.createobject("adodb.recordset")
View Replies
View Related
I'm almost finished creating a simple events calendar that will allow users to book rooms and see at a glance, which rooms are booked, and at what times. Unfortunately I've hit a brick wall with the final stages of development.
I've created a screen shot of what I would like to display on the screen (see below). I can't for the life of me figure out how I'm going draw each cell and populate it with the database information (should it require populating).
View Replies
View Related
I have a project where I want an email to be sent at a certain time, say 10 PM every night if there are new hits to my site. The email will be only going to my email address. does any one know of a way to do this?
View Replies
View Related
I have an html page with standard contact us type form. This when posted goes to an asp page which stores the data and then sends an email to me. It then redirects back to the original email form with a message thanking the user for the contact.
The problem is I am getting multiple spoof emails which are being generated form the asp page. Some one is accessing and then just refershing the page so it generates numerous emails.
Is there a way of either hiding the asp page in the original HTML form or checking that the page has been called by the html form rather than just refreshed.
View Replies
View Related
The object I have is a barcode:
<%
RMABarCode = Session("rmaID")
IF Len(RMABarCode) Then
response.write "<img src='barcode.asp?code=" & RMABarCode &
"&height=25&width=1&mode=code39'>"
End If
%>
But I need to be able to display that barcode multiple times.
Say the user needs 4 displayed, he/she will enter the number and it
shows that many.
View Replies
View Related
I am using the XMLHTTP object to request a page from within another ASP page. For my scenario, the two pages should operate in the same session. However, when I request the second page, a new session is created. This makes sense since it is coming from a different client (the XMLHTTP object as opposed to my browser).
I've tried to pass the ASPSESSIONID cookie along with the XMLHTTP post, but every time I pass the valid cookie, the XMLHTTP request times out.
Has anyone experienced anything similar to this? Is what I am trying to accomplish even possible?
View Replies
View Related
I am testing a mass emailer that I will be sending out this week. I use ASP to read email addresses from a db table which is contains a list of email addresses of those who will receive the email blast. I have included myself to see the results of the test. I noticed when I received the email, the body or content of the email was repeated as many times as there are people in the email list the code was reading from.
Can someone tell me what I did wrong in the code below?
Code: ....
View Replies
View Related
Does anyone know how to display movie times from a particular zipcode stored in a DB? I need to find a website out there has a data feed that can be accessed with movie times. Anyone have any ideas?
View Replies
View Related
basically what i'm trying to do is find the closest time (which are linked) to the current time (which is in red) and then forward a customer to the url.
the linked times are populated from an array, so i think one method would be to sort the array in time order then forward the customer to the first link it finds in the array.
I have no idea how to do this by the way as there doesn't appear to be a sort function in ASP does anyone have any ideas on any ways I could achieve this?
View Replies
View Related
1. How do I create my asp in a way where it does not allow the user to key in wrong password for more than 3 time. It will lock the account once three times has exceeded.
View Replies
View Related
I use following code in an ASP page to generate a GUID:
<%
dim obj
Set obj = Server.CreateObject("Scriptlet.TypeLib")
Response.Write(obj.guid)
Set obj = nothing
%>
It worked fine on my WIN2000 computer running IIS. I recently bought a
new computer with XP Pro and this page times out. I now it is the call
to obj.guid. I have seen the same behaviour on another XP machine as
well.
The funny thing is if I paste this code into VB and display the guid
in a message box, it runs without a problem.
Any ideas, is this not supported in XP?
View Replies
View Related
I need to get the number of seconds when subtracting two date/times.
With the code I am using below I subtract the two date/times and end
up with a total of days like "1.56".
Then when I multiply it to get
the number of seconds I am not getting an accurate number. I should
only have whole numbers of seconds with nothing past the decimal
point. I would like to be able to subtract the two date/times and get
the number of seconds without multiplying to get it. Is this possible?
Does anyone have a better more accurate way to do this? Code:
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
