Type: Posts; User: Bill Wilkinson
Search took 1.05 seconds.
starttime = "18:59:00" ' string
endtime = "05:59:00"
starttime = TimeValue(starttime) ' time
endtime = TimeValue(endtime)
In other words, something as basically simple as this:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD...
Well what I would do is consolidate *ALL* the above into a single web page.
Then just use an IF in the Page_Load:
If the user's credentials were invalid, just display a message to that effect...
And, finally, why mention the History table? You aren't using it in that query, at all.
One thing you could have done, to simplify the coding considerably, would have been to have a table of...
Why would adding a new user EVER cause problems for this query?
The query is just getting a SUM of all pay in a given month. It doesn't even LOOK at users or care how many users there are.
I don't understand. Yes, this could be done, but essentially you are asking SQL Server to DUPLICATE the work.
You will get all the information for the prior month (all the months from January...
Assuming CMI is the name of the database and CORE is the name of the table you are looking at:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=sqloledb; Data...
Okay, then the redirect should do okay for what you have so far.
HINT: Show your code. Hard to know what you might be doing wrong without that.
User.Identity.Name is only going to work if you are using the .NET package that uses that structure (and maintains...
One more time: *WHAT* is the error you get?????And error 500 MEANS NOTHING. You need to either change your ASP server so that it shows the details of an error (and then also change your browser to...
So you said "I add a new Web page to my aspx project ". Fine. But then what did you put in the <form> of that web page? And why would you Redirect on the page_load event? You should only...
But there's really no reason to close the recordset or set it to nothing. ASP will do that for you, automatically. There was a bug, in 1997, where ASP would occasionally not do so. The bug was...
DEBUG DEBUG DEBUG!!
Trap the error:
On Error Resume Next
If Err.Number > 0 Then
Response.Write "Error on close: " & Err.Description & "<hr/>"
Sure, there are several ways to do this.
If you want to duplicate the ASP/ASP.NET code on each server, then you could just submit the <form> to all 3 sites.
A better way would be to have the...
Show the rest of your code. That code you showed will *NOT* create any file. It just creates an object that *THEN* can be used to store FDF to a file.
strRecords = "" & vbNewLine
do while not rs.eof
strRecords = strRecords & _
"<a href=""maint_print.asp?RdID=" & _
rs("RdID") & "&WONum=" & rs("WONum") & """>" & _
You certainly need to specify full path names for the .htm and .pdf files!
Else they will be assumed to be in a C:\windows\xxx directory and you
will *NOT* have permission to write there and maybe...
Nothing to do with ASP. Should have been asked in a PHP forum.
But really he should be getting the username and password
from whomever administers his site.
How do you know the problem is with sessions?
Assuming you are right:
Remember that sessions depend upon cookies working.
If somehow your site has been marked as a SPAM producer
by the major...
And how does ASP code return two values to the AS3 code??
Is it as simple as
Response.Write value1 & "," & value2 & vbNewLine
Response.Write value1 & vbNewLine
There is no need to use the table prefix (WorkOrders.WONum)
when there is only one table in the SELECT.
classicASP: Bad answer. Means he has to alter EVERY FILE that needs this redirection.
Rajesh: Learn to use your web.config file. It can easily do this (and much more) by just creating a set of...
icount = request.form("icount")
For i = 0 to icount
cat = Replace( request.form("category" & i), "'", "''" )
id = request.form("id" & i)
SQL = "UPDATE event SET...
No, my point is that you have been coding here and posting here for a long time, and I was truly surprised to see you posting code that couldn't possibly make sense.
I *STILL* think you are using...
So very much of that code makes NO SENSE at all.
First of all, you create a new record, referenced by the RS variable. And then you *OVERWRITE* that value by the useless line