How can I use the date() function in ASP with SQL statement.
I want to retrieve the records with today's date:
"SELECT * FROM Table WHERE [Date]=" & Date
where [Date] is an SQL Server datetime.
How do I separate the date from datetime so this statement can work properly.
How do you determine if a given date is a weekday (Mon-Thurs) or weekend (Fri - Sun)? Is there a built in function?
View Replies View RelatedI need to figure out if this file is over a day (or however many hours) and if it is, i need to delete it. If its not i redirect the user to it
Code:
If (fs.FileExists(workFile))=true Then
set f=fs.GetFile(workFile)
If (f.DateLastModified > Date-1)
Response.Redirect "/" & tFileName & "/" & reqString & ".html"
Else
f.Delete
End If
set f=nothing
End If
obviosuly the date-1 is wrong, i can't fid the appropriate syntax to save my life.
here is some background on the page I made. It's a calendar page with events listed. No database, just used id="" to display certain months depending on the option chosen from the jump down menu.
The question I have is this: I would like to display the current month's events when they land on the page. I used
<%
id=request.querystring("id")
%>
and created an <%elseif id="1" then%> and so on for each month. Is there a way can request the month and display that id? Thanks for you help. I have the code for the page if need be
Is there a way to determine the actual width and height of a image file ?
I'm using aspsmartupload to upload the image, how can determine and save the
width and height value ?
seems that aspsmartupload doesn't have this property.
If so, is there any method to determine it in asp in the simpliest way? I
will prefer to maintain the aspsmartupload method.
I have many servers which will be reghosted everyday with different OS
(Win2000, Win2003, WinXP...). How could I write the ASP code to get the
information of other servers' OS?
Let say the asp page is hosted on Server A, how can I check the OS version
of Server B and Server C?
Somewhere in my program I ask users to provide their website URL. I would like to determine if the given website exists or not.How can I determine a website with given URL exists?
View Replies View RelatedI am creating an ASP page for members of my team to add and delete records from specified tables. This table is choose by the user and I am dynamically creating text boxes. I also wish to include the type of the attribute to assist the user.
<%
for s_intCounter=0 to objRs.Fields.Count -1
%><tr>
<td width="34%"><% objRs.Fields.Item(s_intCounter) %>: <input type="text" id = <% objRs.Fields.Item(s_intCounter) %> > </td>
<td width="66%">Type: <% INSERT ASP FOR RETRIVING TYPE</td>
</tr>
<%next%>
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
<td><%=strAddress%> </td>
My web hosting account lets me use ASP and so I thought I'd try to learn and use some.
There is only one thing that I would like to know, and that is how to find out what version of ASP is running. Preferably, what I am looking for is something similar to the PHP php_info() function. Is there anything like this for ASP?
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.
This may be a trivial question, but I was wondering how can you determine if a value contains an Integer or Float. I know there is a function called IsNumeric, however you can't determine what type it is.
View Replies View RelatedI built a simple scheduling application using an access db.
The relevent fields are eventRoom, startDate, startTime and endTime.
When I go to add a new event, what method can I use to make sure the
eventRoom is available for the selected date and time slot? Id like to just
display an alert with the conflicting times and suggest the next available
startTime.
Anyone knows how to determine an image's dimension using Classic ASP?
Like How do I know the width, Height of this image using ASP?
Just wondering if anyone knows how to determine someones connection speed in asp the reason for this being so i can redirect the user to a different media file depending on their connection speed.
View Replies View RelatedI have a recordset with two three fields. One is an autonumber field called ID , one is a text field called Name and the last is a date/time field called DateEntered. How can I programatically determine the autonumber field ? Code:
View Replies View Relatedis there anyone here who can help me to determine google's pagerank with asp code. Just like pagerank tools are doing, where do they request data from, how do they get it, etc..
View Replies View RelatedIs there a way to determine the user operation system in vbscript and javascript?
View Replies View RelatedFirst I would question why you want to do this. If they get to the page by any means it should respond appropriately, whether refresh or by link. This is a stateless environment after all.
That being said...
I would take the approach of setting a session variable that gets set the first time they hit the page:
<%
if session("NotTheFirstTime") = "" then
'write the onload
session("NotTheFirstTime") = true
end if
%>
then based on that variable write or don't write the onload.
Of course, if the user can access the page from multiple links and the onload is valid for each link, regardless of how many times they hit the page, this won't work....
I still don't know how to determine a empty folder....
View Replies View Relatedhow do i determine how many items are in an array? the following code creates an array of values each time a space is found in a name field. the problem is that sometimes names have middle initials and sometimes they do not. so i want to determine how many items exist in this array created bythe split BEFORE assigning values:
name_of_customer = Split(customer_name," ", -1, 1)
first_name = name_of_customer(0)
middle_initial = name_of_customer(1)
I have a database i want to be able to determine its size from an asp page, Also is it possible to list tables and column names list what tables are in the database and column names of each table contained?
View Replies View RelatedI have an asp script that lists the files in a directory:
CurrentPATH = "c: emp"
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFolder = oFSO.GetFolder(CurrentPATH)
Set oFolderContents = oFolder.Files
For Each oFileItem in oFolder.Files
.....
next
before doing the "For..Next" loop, I want to determine the number of files
in oFolderContents. How can I do this? Is there another way to determine the number of files in a given directory?
Anyone knows how to determine an image's dimension using Classic ASP? Like How do I know the width, Height of this image using ASP?
View Replies View RelatedI am connected to a MySQL db and I want to see whether a certain user already exists.
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "my_dsn"
'check if the user exists
existing_user_query = "SELECT * FROM admins WHERE username = '"& vUser&"'"
Set RS_existing = MyConn.Execute(existing_user_query)
when I am testing for the RS_existing.RecordCount property, I am always getting '-1'. it might not be supported on the server I am using.
Our central site has set up a VPN for us so we can access our network from home. Unfortunately, our Intranet won't come up. We've been told it is because the Intrusion Prevention System on the firewall is blocking it because the headers are too large. How can I determine how large the headers are?
Would it be the total of all of the Request.ServerVariables? They tell me the default settings are 2000 bytes. Which seems awfully small to me.
I've got a subroutine, defined as Private, takes two parameters, that is
called lots of times from different ASP scripts. I need specific error
handling when it is called from only one particular section of my code - and
from the page it's called from, it's called multiple times from there, too,
so I can't check by page.
I thought about adding an additional parameter, but it's called so many
times that it would be unwieldy to do so.
Is there a way I can tell a Private Subroutine what piece of code called it?
I want to determine the operating system using ASP (or VBScript inside of ASP). I tried to get it using the Request. ServerVariables(EnvironmentVariable) method. On the web page about ASP in which I found this method, it gave a list of possible values for the
EnvironmentVariable parameter.
One of these, which is the one that I tried to use, was HTTP_UA_OS. However, this value did not seem to work, and when I displayed a list of possible values using a For Each loop, it was not in the list, and none of the other variables looked like they could determine theOS either.
How do you determine whether a user allows cookies or not.
Many people told me that it can be done by writing a cookie and then retrieve it to test this feature, but it simply doesn't work.
What else can i do?
We're using the subroutine below to send emails via our classic ASP
apps. However, we'd like to know if an email address isn't good -- in other
words, it bounced back. Is there a way to do that with the CDOSYS email
method? The From email is just some generic text and not a real email
address in our apps.
One brute force technique is to hit the Active Directory and see if the
email's on it. Is there any other way? Does the CDOSYS method throw any
errors that can be trapped? It sends emails to bad email addresses just as
quietly as to good ones....
does any one here know of a good way to to determine whether or not a
given path is a directory (e.g., "c:mydir") or a file (e.g., "c:mydir
myfile.txt")?
i started attacking this problem by using filesystemobject to check
whether or not a directory existed for the path. if so, it was a
directory path. if not, i checked to see if a file existed for it. if
so, it was a file path. Code:
Currently I am developping a internet "directory browser"
My page 'default.asp' has following entries:
CurrentPATH = Request("MyLink")
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFolder = oFSO.GetFolder(CurrentPATH)
Set oFolderContents = oFolder.Files
this works fine with 'default.asp?MyPath', where "MyPath" stands for i.e.
c: emp
but NOT with 'default.asp?MyFile', where MyFile stands for i.e.
c: empfile.txt
Is there a way to determine if the link contains a file or a path? Of course
you can check for a dot (after dot, normaly it is an extension, thus a
file), but I want to have it possible also to have dots in my directories...
Anybody?
Is there a fast way, with Classic ASP, to determine if a user agent is a search engine
spider?
I know that ASP.NET has Request.Browser.Crawler, I'm looking to see if classic ASP has
something built in, or do I have to look for strings in the user agent.