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.
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.
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?
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....
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
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
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:
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?
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?
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?
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.
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.
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)?
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.
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'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.
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.
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"
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.
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.
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.
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.
