Current Grade
To cut down on maintenance,I'm tracking 500 or so students via their graduation year, rather than their current grade,so I don't have to go in every summer and ratchet up all the grades.
I need to allow the teachers to search for them based on grade(9, 10, 11, or 12).So what I need is to be able to compare the grade chosen on any given day of the year,and have the code figure out what grad year that person is in, assuming a constant of the 4 year plan, and do a SELECT * WHERE gradYear = 2009
The problem is that I could take the nowYear or something, but that changes half-way through the school year (stupid northern hemisphere) and I'm stumped on how to compare more complicated dates.
View Replies
ADVERTISEMENT
I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.
So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.
View Replies
View Related
Im trying to get the current url where the user is at and store it into a variable. I want this to be done automatically, not when a user clicks a button. Any ideas?
View Replies
View Related
a way to get the current URL AND the variables in it, all in one command? There probably isn't, seems to simple, right?
View Replies
View Related
I'd like to know how to display the current URL on the web page as a footer. This seems to be a fairly simple task, but everything i've found on the internet either doesn't work for some reason, or is asp.net specific....
View Replies
View Related
Is there a way that I can read the current url.
I have an asp page currently such as default.asp?x=1&y=2&z=3
Now I want to keep the existing parameters and attach another parameter
to it and resend to default.asp
As the original parameters are dynamic, and may or may not be
generated, the only way is to read the current url and to simply add my
new parameter such as h=5 to the url.
I don't know how to read the current url.
I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include
the parameters. i.e. it just returned the default.asp
View Replies
View Related
Does anyone know where I can find information about Reading current
connection value from performance counters into ASP page. I wanted to
know how I can call the current connection value in my ASP page
View Replies
View Related
how to print or get the name of current page using ASP
View Replies
View Related
I'm not sure if someone has requested in the past (I know I've looked for a solution for a while) but I've just developed a very neat way of getting the current page name in ASP:
url = request.ServerVariables("URL")
page = right(url, len(url) - instrrev(url, "/"))
I've finally found a use for the instrrev function
View Replies
View Related
I've created a form whereby the user fills in there details into a datbase.Once there details have been entered into the database I want to show the Primary Key(there generated ID number).This is the code I have right now
<%
SQLQuery = "Select * from StudentReg"
Set GetDetails=MM_dbconnect_STRING.Execute(SQLQuery)
%>
<%=GetDetails("ID")%>
This however will only show the frist ID number in the database, not the one the user just entered. How do I get the current ID within the new record?
View Replies
View Related
i need a button or a link, that when clicked on, grabs the current date. It then puts this date inside a textbox.
View Replies
View Related
How can I query the current user logged on to the local machine and store the username, the first name of the person, and the last name of the person in variables?
View Replies
View Related
I have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
View Replies
View Related
How can I retrieve the current page url(and parameters/arguments) using ASP code? The current page is an asp search results page so the url includes the page name and the criterion(sorry I don't know what they're called) I had the 'post' method tag on the end.
I need to get it and store it so I have an easy way of getting back to this page at a click of a button a few pages down the track. I've tried using location and history but I'd like to manage it myself.
View Replies
View Related
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. I am moving my webserver from NT4 using SQL to win2003 using SQL 2003. I get the above error when my asp page does teh line:
Rs.absolutepage = intCurrentPage
I tested teh value of intCurrent page and teh value is 1. Any ideas? The .asp Page works perfectly fine on teh old machine.
View Replies
View Related
Thingy to call to figure out what the current file is (ie: index.asp)? I thought it was request.servervariables("something") but just can't find it .
View Replies
View Related
is there a command in asp to get the name of the current page?
furthermore, is there a way to retrieve the name of the current page within
an 'included' file (not the name of the included page, but the name of the
page that is including the file)?
View Replies
View Related
I am coding an ASP page and need to know how to pull the current date.
Here is my code:
SELECT tenant_id,fname + ' ' + lname as [name],
FROM TENANT
WHERE start_date < [TODAY'S DATE] AND [TODAY'S DATE] < end_date
View Replies
View Related
i'd like to know if their is a way to get current rates to use them in an asp script that makes currency conversions?
View Replies
View Related
I am using an include for a navigation bar, This nav bar appears on many different pages and the help facility a button on the navigation barneeds to launch a help box relating to the page it is included in.
The help files are .html but the file names relate directly to the asp page in which the navbar is included. To get the javascript in the navbar to correctly display the correct help window, I need to get at the page name. I am using
dim thisPage
thisPage= request.ServerVariables("URL")
This will hopefully return me the full file path of the page that the navbar is included in. I then need to take the filename out of this URL and remove the .asp from the end so that i can use it in my javascript function to open the corresponding .html help file.
View Replies
View Related
I am trying to create a facility which returns all records where the date is equal to or greater to the current date. I currently have the following which returns all records:
I now need to do the following:
select * from shows where showDate >= today
Anyone know how I do this?
View Replies
View Related
I'm just working on this big newsletterscript, wich will be working with templates (preformatted html code), stored in the database. I've already started but i'm still looking for suggestions or methods to do this more easily then i'm up to right now. So when you you chose another design your content will be loaded in this other template/ html design.
Right now i'm having troubles with the fact that i have a page; nice formatted with the right content! Generated from asp visual output in pure html in my browser. What i want to do now is to get this page structure/ content as it is shown in my browers (html output) INSERTED into MS Access.
View Replies
View Related
I have an event that update my database, I would like to record the current date and time when the record was updated. Not quite sure of the command.
View Replies
View Related
how you convert an integer such as 5 into an hour string so the system identifies it as an hour instead of just the number 5 and then once you do that ("if you need to do that at all") add 5 hours to the current time...
Also is there a way way to add lets say 50 hours to our current time and date so when it is calculated it shows 2 days and 2 hours away from now... If you cant do that it would be nice to know how to change 7.85 into just 7... or 8.94 into just 8... no rounding up or down just the first number before the decimal.
View Replies
View Related
how do i collect current user using ldap and asp, i want to know who's doing what, so when a page loads can i check who's logged in to the domain?
View Replies
View Related
I am wondering if there is a command to determine what the current directory is.
My reason for this is that i have a include file called connection.asp sat in a folder called Data. My connection.asp file holds the connection details. I need to determine whether the file calling the include is in the root folder or not.
EG. if it is the root folder the location of the db will be "Data/dbMarkShop.mdb" but if it is another folder, say a Scripts folder, the location of th db would be "../Data/dbMarkShop.mdb"
View Replies
View Related
How can I find out the full directory path (i.e. c:path ofile) of a file? I'm logged into a server and the of course, I have an FTP directory root, but I need to know the absolute path.
View Replies
View Related
Is it possible to get the current user that is logged on to the computer? I
want to use this as the basis of my validation on the site instead of asking
them to login in again. I know it could be a security issue if they keep the
computer unattended.
View Replies
View Related
I'm trying to add logging to my web application, but I found a strange problem. Whenever I execute a Server.Redirect(Page1.asp) I can use the request.ServerVariables("SCRIPT_NAME") to get the current page name. However, if I use Server.Transfer(Page1.asp), the value of the server variable equals the refering page (In this case default.asp). How do I get the value of the working page regardless of the transfer method.
View Replies
View Related
I want to check if the name of my current page is index.asp for example, to specify a certain css class but this doesn't work
<li <% if Request.ServerVariables("SCRIPT_NAME") = "index.asp" then Response.write "class=""here"""%>>
What's the proper method?
View Replies
View Related
I would like to know how I can save my current ASP page
to the server side in html file format.
Then I would like to stream it back to the client side.
View Replies
View Related
i have an ads website which i have developed for my coursework but want to make it that bit better. Code:
View Replies
View Related
I have my webpage (ASP) in domain (IIS 6.0).I need to make a popup with fullname of current user.How can I do this?Maybe someone have any examples?
View Replies
View Related
