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

Script Times Out

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

Download Times

I need to show how long a given file size will download.

View Replies View Related

Pages Times Out

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

Compare Two Times

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

Substract Two Times

I need to subtract two times
Example : 1:45 AM - 2:55 PM or 5:45 PM -1:00 AM

View Replies View Related

Loading Times

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

Multiple Times

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

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 View Related

How Many Times Character Appear

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

Calculate The Differnce Between Two Times

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

Display Image Between Times

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

Display Image Between Times

How would I do it for DATE instead of Day of the week?

View Replies View Related

Long Response Times

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

Changing Image At Certain Times

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

TimeOut And Refresh Times

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

Approximating Download Times

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

Loop 5 Times Then Stop

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

Database Querying Times

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

Displaying Event Times

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

Sending An Email At Defined Times.

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

Email Code Run Multiple Times

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

Display One Object Multiple Times

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

Server Times Out With ASPSESSIONID Cookie

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

Run An Exe From Asp And Get Returned Values

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

How Many Rows Returned?

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

Error Returned

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

Error Is Returned

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

Returned Values

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

Pagesize Not Returned

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

Text Returned From Sql Db

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

Determine If More Than One Row Returned

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

No Data Returned.

I have a simple VBS to return some unless data (as a test) and it works correctly. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved