Times Being Returned As Dates.
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
ADVERTISEMENT
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
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
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
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 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 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
How is it possible to execute an exe from asp and get a returned string (no http headers in exe) ?
To run exe I use :
<%
cmdExe = sPath & "cgi-bin
equest.exe"
Set WshShell = Server.CreateObject("WScript.Shell")
sResult = WshShell.Run(cmdExe, 1, True)
Set WshShell = Nothing
Response.write sResult
%>
sResult always content "0" and not the string returned by exe file (something like "!!-1!blabla!blablablabla!")
- How is it possible to get the exe returned value ?
- Is there a solution with asp.net ?
View Replies
View Related
When I do a query that I know has 2 rows, I get rs.recordcount equals -1. Same thing when it's just one row. I need something that gives me the number of rows.
View Replies
View Related
I am trying to update a record but it returns this error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Function'.
/performaindia/security/functionssys.asp, line 210
Now at line 210, I have this function :
rs.Update.
View Replies
View Related
I am getting this error on selecting an option :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SystemUserOnly', table 'performaindia.dbo.SecurityTableFields'; column does not allow nulls. INSERT fails.
/performaindia/security/tablefields.asp, line 220
now the line 220 is an update statement :
rs.Update
View Replies
View Related
I have a bit of a situation here, I own a job board and have multi-posting comapnies posting jobs to our database and we have returned values going back to them to tell them if the job vacancy was posted succesfully or not.
The problem I have is that our main ASP guru is of sick and the other is off away on business. I have pretty good knowledge of ASP but not as much as these guys. So I need to know how to send a response back to the posting company whether it has been succesfull in posting the job vacancy instead of sending back a page back displaying whether it was successful.
View Replies
View Related
I define a recordset with a pagesize of 100 in my COM object and return this recordset to ASP. When I check my pagesize at the ASP level,it is 10 I assume this is the default.
I can set my pagesize at the ASP level after the COM function is called, but I would prefer to have this encapsulated within the COM.
View Replies
View Related
I am not sure what way to do this, i want a specific row returned and displayed in asp but not in a text box, in acess and vb i ahve done this and its just a label but not sure in asp.
View Replies
View Related
I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately.
I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method.
View Replies
View Related
I have a simple VBS to return some unless data (as a test) and it works correctly. Code:
View Replies
View Related