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?
I am struggling with opening a database and reading data from it via SQL. Please tell me what is wrong with this code. I am trying to open up different tables and get information from them and put it on the one page. Code:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
This is the error I recieve when trying to run my site. I know why. I am passing a non existed URL Parameter. However I would like to recieve a MsgBox that says that such record doesn't exist. Code:
I have several pages I set up in my web site and I am having trouble with two of them - search and results. The stat_search uses a form which seems to work right and when I test the recordset on the stat_results page and enter a value it returns the right results.
When a value is entered from the stat_search page the results page displays the records with the right value and the Records _ of _ indicates the right number of records but when I use the Next or Last arrows to move to the next record I receive the ADODB.Field error. Code:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/ism5315/readtrends.asp, line 46
What I'm trying to do is select the records from my table that match the sensor and gauge the user selects. I have time fields that are optional, and I'm trying to get the page to work if the user selects no time frame first.
Of course, there can be mutliple records for the gauge and sensors, so I created a loop that should run thru and select them all. But I am getting the above error. But I know I am getting into the loop because I have included a response.write sql to verify I am selecting the correct objects. Code:
ADODB.Fielderror '80020009' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /admindemo/profiles_browse.asp, line 0
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.
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
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:
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.
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.
