Recordset Based On Records Selected Freom Previous Page
What I want to do is have a recordset with all records in and display a list by title with a tick box next to them, then goto a new page which the recordset is all the records that the user selected on the previous page.
View Replies
ADVERTISEMENT
I am doing a project that uses ASP VBScript on Dreamweaver. I try to display data based on the hyperlink on the previous page, where I click on the hyperlink("ID of the informationfile") and the following page will show the detailed information of this particular file.
However, I can't display the next page even if I add the hyperlink and the required parameter on the records that are shown on the first page. I need to ask how can I display the detailed information based on the hyperlink, or in fact the fileID from the first page ??? Code:
View Replies
View Related
How can I get a new Option based on a the previous select. When you select a room from selRoom (orange) I want the available equipment (red) that match on a foreign key (CampusID 'Not Displayed') to be displayed. Code:
View Replies
View Related
I have a series of tables, within one database, which each hold unique information, all of which relates to one main table.
I would like to have 4 DropDownMenu's populate themselves based upon the choice of the previous menu.
Example.
Menu A contains four names - John, Henry, Larry, Ed.
When user selects Henry from Menu A, Menu B will show the following choices - Bread, Peanuts, Pickles, Chips.
When user selects Chips from Menu B, Menu C will show the following - BBQ, Ranch, Plain.
When user selects Plain from Menu C, Menu D will show the following - 1 oz., 5 oz., 8 oz.
All of those fields relate to individual tables that all contain a relationship to the main table. Is there a particular way in which I can populate multiple tables based upon the preceeding menu?
View Replies
View Related
Is it possible (and if so, how?) to have an asp form page that based upon a user's selection on a field, would generate a input field b that the user selects?
For example:
User selects "name" in a select statement which would list the possible names to select from or if the user selects "telephone" in the same select statement then it would list the possible telephone numbers to select from.
Or simpler:
If user selects A then show P to select from or
if user selects B then show Z to select from.
View Replies
View Related
I am trying to build a commission calculator for my sales team. Commissions are calculated every month. What is the syntax to pull all records from the previous month?
In other words, at the beginning of December commissions will be paid on November sales so I need to pull all sales recorded in November.
I found this code to pull the current month:
month(now())
so I added a -1 at the end for this
month(now())-1
I haven't tested it yet as I still have many things to do before I can upload to the server to test it. Is that the correct syntax? If not, what is? Also, how can I get the month AND the year?
This will be a default value of the Date field, so I need it in asp, not SQL.
View Replies
View Related
I have an asp page which displays a list of records depending on what was selected via another form.
I want to have these results broken down, displaying only 10 records, with links underneath to display as 'Previous' and 'Next' Code:
View Replies
View Related
I have an ASP page which pulls a number of records into a recordset and then displays the first record, by default, in an HTML form.
I'm tryina to make a button (or a link, which ever is easiest?!) which loads the next record from the recordset into the form.
For example, if I had a recordset with 2 records as follows:
Firstname Lastname
Firstname1 Lastname1
Firstname2 Lastname2
...and a form with 2 text boxes containing 'Firstname1' and 'Lastname1' when the page is loaded - I need a button or link to load 'Firstname2' and 'Lastname2' into these boxes.
If possible, I'd like to be able to do this without refreshing the page....but if not it doesn't really matter too much....
View Replies
View Related
I have created a recordset with cursortype 'adOpenDynamic'. i have used "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
connectionString to open connection.
The problem is that ASP renders Operation is not allowed in this context' error when i call the moveprevious methord of that recordset. I have discovered that it doesnt move previous when i used a joined query. and it works perfectly when i use single table query. the recordset code is:
Set client = Server.CreateObject("ADODB.Recordset")
client.ActiveConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
client.Source = "SELECT * FROM customer c inner join business b on c.id=b.cid"
client.CursorType = 2
client.CursorLocation = 2
client.LockType = 3
client.Open()
View Replies
View Related
I wish to update certain records in a access database where the placeID is a certain number and the coststypeID can be other numbers. I am using the following code:
View Replies
View Related
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
View Replies
View Related
I am using ASP/Javascript/Access. How would I go about selecting all the records >= todays date?
View Replies
View Related
I currently have entries in my dbase with time stamps. Does anyone know how I would display only those records with the time stamp that reflects a particular day. For example I want to display all records from today which would be 8/23/2004 on the page.
Im assuming this has something to do with the Date () function but i dont understand how it could incorporate it into code.
View Replies
View Related
is this possible in asp
i have a validation page and need to send people back to the previous page if validation fails
this validatation page is a standard one for all forms... thats why i dont know which page it has come from
View Replies
View Related
I'm writing you because I have a question for you all: how can I capture the previous page from an ASP file? I need to add the URL (with parameters if possible) of the previous page to a table in SQL Server.
For example: the page that captures the info is anydomain.com/asppage.asp and if the previous page in the browser history is otherdomain.com/otherpage.asp, I need to be able to capture that information , If possible, of course...
View Replies
View Related
I have an access product inventory DB which has a Last_modified field associated with each product. I need an ASP function that will display all records that have been added within the previous week. Aka, SELECT * FROM TBLINVENTORY WHERE .....
The format of the date and time stored is like this: 18/02/2004 6:15:55 PM ...
View Replies
View Related
How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"
I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .
View Replies
View Related
I want to call a recordset based on whether the 'expiration_start' date and 'expiration_end' date are within the current date.
I've tried a few things but can't get it to work?
Here's my non-working SQL statement:
Code:
sSQL = "SELECT * FROM poll WHERE #" & date & "# BETWEEN expiration_start AND expiration_end"
I'm simply using 'date' to call the current date. I'm not sure if that's correct but it seems to work ok when I use it in an "if" statement like this example:
View Replies
View Related
How do you do something like the user pressed the "back" button in the browser? Currently, I have a redirection after a pause working
with the line,
Response.Write("<meta http-equiv=""Refresh"" content=""3; URL=http://localhost/MyWeb/CompsOut.asp"">")
I am doing a check on wether or not all of the inputs were filled in on a form. If not, I want it to basically just go back and not reload the previous page and resend the data and such. Just go back, fill in the field, and re-submit.
View Replies
View Related
I am trying to have my asp page direct the user to the page that called the current page, but the only code that I have found is on the MIcorsoft MSDN Knowledge base and it won't work.
View Replies
View Related
What is the code for redirecting the page to the previous page from which we have come to the present page.
View Replies
View Related
The users of my website can request to login from different pages. after login they are redirected ro index.asp but I want them to be redirected to original page where they came from
I tried to use
<%
Dim backpage
backpage = ServerVariable("HTTP_referrer")
response.redirect(backpage)
%>
with this code I get NOT FOUND PAGE ERROR.
View Replies
View Related
i want to know the previous page address.ie,from which link the current page come here.
Is there any function in ASP to find that........?
View Replies
View Related
I am trying to put a buuton into my page which will take the user back to the previous page. The reason i am doing this is that the user may come to this page from more than one other page.
I am using this code for the button, which i have seen on many code examples, but when i click on the button, it results in an error as if the existing page is trying to load itself up again.
<form>
<td width = "325" align="left">
<input type="submit" name="back" value="Back" onClick="javascript: history.go(-1)">
</td>
</form>
have also tried using the javascript: history.go(-1) code in the form declaration as the onSubmit attribute, but this just makes the same page load up again.
View Replies
View Related
How can I auto redirect to the previous page?Anyone an idea?
View Replies
View Related
I have an ASP page that lists a recordeset that can have dozens of records, at the end of each line is a details link that links to a page giving more detailed information about the record where a user can add and update information to that record.
At the top of the update record page I have a Back to Record List page. The problem is that when a user hits the Back to Record List page they are taken back to the Top of the list, I'd like to create a link that will take the user back to the record they just updated. I am carrying the data record number through the querystring.
View Replies
View Related
how can i get the data submitted by the previous form using " for each x in Request.Form " and display them same as the the previous form before and the only different is tat this time the all the data in this form is being disabled. (the data may consists from text box, combo box, radio button, etc.) . just wondering is there any way to perfrom like this..
View Replies
View Related
I am creating a form with checkboxes that contains in the value property, the ID of the image. The filename of the image displayed above the checkbox along with the image.
On that page, I am storing the "checked" information in a cookie. When the user clicks submit, I need to retrieve the actual image that they selected on the previous page and display it along with the image name which I get from the value property.
Right now the only data being passed is the value in the checkbox input tage which is a text string and not the actual image. How do I retrieve the images my users checks off. I hope this make sense. Sort of like a shopping cart, but I only want to be able to select images and post back the ones selected.
View Replies
View Related
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
View Replies
View Related
what the easiest way is to get the number of records in a recordset, or the number of records returned by my query. I can't get this rs.recordcount thing to work. it just returns -1 all the time. I read on asp101 that it only works when you're using the right cursor type but I tried using the cursor type they said to use and it still doesn't work. I also did the test they gave to check if your record set will allow recordcount()
Code:
If rs.Supports(adBookmark) Or rs.Supports(adApproxPosition) Then
Response.write "will work"
End If
and that works...
So can anyone help me plz!
ps. whithout looping through the records and counting them if possible plz! there must be a shorter way than that.
View Replies
View Related
I want to create an ASP page, which can copy the real PDF files into
the clipboard and then the user can paste it in Outlook message as
attachments(it's like inserting attachments)
My idea is: When user checked the checkboxes for the requested PDF
files from ASP page and press the "Add To Clipboard" button, all
requested PDF files will be copied into clipboard. Then, the user open
MS outlook message and right click -> Paste all PDF files as
attachments.
But, my code is just can copy the filepaths into clipboard not the
REAL PDF FILES. How can I copy the REAL PDF FILES? Code:
View Replies
View Related
I have a query that is supposed to return only 1 record, however I recently found that because of an error in the database it can return more than 1. So what I need to do is capture if it is more than 1 record and alert the user to contact the database administrator. How can I get the count of records returned by a recordset? Is there no way besides looping through with a counter variable?
View Replies
View Related
If I want to display the last X number of records in a recordset, how would I do it? Say I have ten records and I want to display them showing the smallest amount first: Code:
View Replies
View Related