Populate A Popup Window With Clickable Records From An Access DB And Upon Clicking, Populate A Selectbox On The Original Webpage With The Clicked Record
We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)
We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)
We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.
(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.
View Replies
ADVERTISEMENT
I am trying query the data from db and populate in the web form's textbox field. so far I cannot put that record into the text field box. anyone has idea on that, below is my sample code:
View Replies
View Related
Looking to populate an access db table 'ole object' field through asp code.
View Replies
View Related
I have a main window which shows all records from a table. When a user clicks on "Edit" for a record, a popup showing information of the selected record is displayed.
The user then changes the information on the popup and clicks "OK" button which calls an ASP page to update that record in the table. Everything works with no problem up to this stage.
My problem start after the update process. I need to know how to close the popup and then refresh the main window showing the updated information....
View Replies
View Related
1. I have a form, with a textbox and a button. I have to enter a value in the text box and then i have to click the button, which opens a popup window. Here i want to pass the value of the text box which is entered in the parent window to popup window.
I have to use that value in the popup window's form_load event in the Code behind, and i have to take the values from the database using the value which i have entered in the parent window. Code:
View Replies
View Related
I want my asp code(recordset) to populate a table structure like below...How will I do that ? I have the corresponding day(monday,tuesday,etc) stored in my db...This is a weekly schedule for all drivers..A sample db table output would be : Code:
View Replies
View Related
I'am not familiar wit ASP but I have to maintain an application. In a window there are some text selection fields and a search button. If you press on the search button record list is build according to what is filled in the selection fields. You can select a record and then a detailed window is shown or in another occasion a popup window is shown.
The request is now if the opened window or popup window is closed, then the opener window has to be opened with the same content (content selection fields + record list) as it was before the window or popup is opened.
Now I thought that I have read that every window which is opened gets an ID and that it is possible to call up that window by the ID from the cache again. Is that right? And if so? Or has somebody a better idea. Code:
View Replies
View Related
I am running it on IIS, access db, and ASP.
The user selects from several dropdown boxes, on different pages assessing different faults with a particular job. Finally it comes to the last page and displays all the various bits and pieces that have been selected along the way,
THE PROBLEM, ERR CHALLENGE....
It also needs to populate an email link to display the info selected and then which is emailed to an administrator for approval.
And then exported to excel format.
View Replies
View Related
I have a form with a select control called "Last Name" and 1 text box called " First Name". In the select drop-down I have a list of last names pulled from the database. Also the second text box first_name value will be pulled from the database also.
When a user selects a last name from the list I want it to automatically update the first name textbox based on their selection. Ie. The persons first name is put into the textbox.I need to take the values of both(First Name and Last name) and send them to another page
View Replies
View Related
I have an ASP web form that I want to populate fields based on the first
field choice. Example I have 4 fields item, price, delivery, availability. I
have all these items setup in an access table. When a user chooses an option
from the item drop down, the price, delivery, availability will then
populate. I have already made my connection to the database, and created the
drop down for field one from the choices. How do I now populate the
corresponding fields.
View Replies
View Related
Im new to asp and I'm having trouble with listboxes.
I have two listboxes, the first is populated from a database and I need to fill a second listbox with items from the database that are dependant on what was selected in the first list box.
View Replies
View Related
I've been hunting around the forums for ages trying to find a solution to this but no joy so far, hopefully someone can help?
Basically I'm a bit of a newbie to session variables, and was wondering if they are they best thing to use for the following problem I have;
What I want to do is capture a referral ID from a URL i.e. www.mysite.com?ref=1234567 and then store it in a session variable and if the person signs up for a service, it automatically places the referral ID in a text box on the order form.
Does anyone know if this is possible or know of any tutorials? I've had a good look on google, but no joy so far.
I think the key bit is how I capture the ID into a session variable?
View Replies
View Related
I want to populate a dynamic schedule table M-Sunday like this. My db doesnt have a column called monday,tuesday,etc.
I want to create a loop that get the data from access then fill the cells for date and route..Any day may have 2 or more schedule.
View Replies
View Related
I have this code which populates a multiple drop down
getedu=rs("Education")
when i do a response.write getedu the output is
Bachelor, PHD
then i use to select the values in drop down
and its not working any ideas why Code:
View Replies
View Related
Which of the method is used. ? Writing an SQL statement in ASP to populate a recordset OR Calling a stored procedure to return records to populate a recordset. Which of the above two methods is more useful and faster.
View Replies
View Related
i have learned how to populate a webpage with images from a database. however, i would like to go a little deeper:
i would like to create a recordset (in dreamweaver) with a drop-down list of my product lines:
product line A
product line B
etc
etc
this is not a problem. i can do this. however, once the user has selected from the list, i would like the corresponding images to be displayed in the webpage. i am not sure how to go about this. tips for doing this in dreamweaver would be excellent.
View Replies
View Related
I have two form items listbox 1 and textarea 2 and a button. I populate the listbox 1 with a SQL query. i want to add the following functionality:
i choose something from the listbox push the button and then the selected item must appear in the textarea( or listbox ) when i choose a second item from the listbox it must appear beneath the first choosen item etc.
View Replies
View Related
i have already populate a list from my database using the following code . Code:
<form method=post action="ProcessOrder.asp">
<select NAME="TEST">
<% Do while NOT rsHis.EOF
response.write "<OPTION VALUE=' " & rshis("pic_id") & " '> "
response.write rshis("title")
rsHis.MoveNext
loop%>
</select>
But i dont know how to present the results from the combo box.
View Replies
View Related
When the app is ran you get a list of checkboxes to choose from which passes values to crystal reports. All I need to do is change those checkboxs to dropdowns. Can someone give me some assistance here?? Code:
View Replies
View Related
I have created a form that asks the user to select an item within a drop down list, once they have selected the item i would like it to populate one of the other fields with a code depending on which item was selected within the drop down list. How would i do this?
View Replies
View Related
I have a drop down menu that is populated from a database. the problem that I have is that alot of the numbers in the field are duplicated ie the field in question has years in it and may of the years are the same.
is it possible, when there are duplicated years, to populate the dropdown menu only once with that particular year. This would grately shorten the menu for me.
View Replies
View Related
Can one form be set up to populate two or three tables? If so, how?
View Replies
View Related
I am trying to populate a dropdown box with 2 date variables called today date and tomdate. First it will show "-choose-", followed by todays's date and then tomorrow's date.
The selected date needs to be validated by my hidden function called Validate. This I can do, but I can't figure out the syntax for the dates. Following is another dropdown box which you can make the changes to so I can see the proper syntax.....
View Replies
View Related
I have an array - ListOfFiles - that i want use to populate an combo.
I've attempted to do it like this:
<select name="txtAvailable" rows="4" id="txtAvailable">
<Script Language = "vbscript" Runat = "Server">
For i = 0 to Count -1
Response.Write"<OPTION>" & ListOfFiles(i) & "</OPTION>"
next
</script></select>
I placed the vbscript in the approprate place in the body. But when i
open the page instead of writing the HTML where i placed the code, it
has appended it right at the bottom of the page. Does anyone know
where i'm going wrong or if there's a better way of doing this?
View Replies
View Related
I would like to populate a dropdown box with monthly names. Jan- Dec.
View Replies
View Related
sql = "SELECT [R.oriAddress], [R.oriCity], [R.oriPostcode], [R.oriState], [R.oriCountry], " & _
"[R.mobileNo], [R.homeNo], [R.resDate], [R.resTime], [R.surveyDate], [R.surveyTime1], " & _
"[R.surveyTime2], [R.moveDate], [R.moveTime1], [R.moveTime2], [R.destAddress], [R.destCity], " & _
"[R.destPostcode], [R.destState], [R.destCountry], [R.resType], [R.resStatus], [R.staffCode], " & _
"[S.staffCode], [S.staffName], [C.custName], [C.custIC] " & _
"FROM (Reservation R " & _
"INNER JOIN Customer C " & _
"ON R.custCode = C.custCode) INNER JOIN Staff S " & _
"ON R.staffCode = S.staffCode " & _
"WHERE R.resCode = " & id
i used sql code above to display data in a table. basically, the flow is like this. when there is a new reservation, a staff will be assigned to handle that reservation from the beginning until the end. before this, i just display a staffCode that retrieved from Reservation table.
then, i made changes to display staffName and removed staffCode from the table (based on requirement). but, because previously, there are some reservations that have been assigned to staff, i do not have any problem to view all data in the table.
but, when i click other reservations that have not assigned to any staff, an error page came out. the default value for staffCode in the Reservation table is null. because this null value, i've got an error page. is there any steps i can use to solve it?
View Replies
View Related
I am building an online shop, i wish to select all the sizes out of a table and polutate a drop down list with the selection, then dependant on what size you selected it offers the quality available in another dropdown list based on the amount recovered from the database relating to that size.
I know this can be done is javascipt, but have no idea what to search google for, nor where to start, any ideas would be good .
View Replies
View Related
I have two tables (in an access database) acting like a product catalog (one table for the categories and other for the products) Something like this:
Table1:
CatID, CatName
============
1, Cat1
2, Cat2
3, Cat3
Table2:
ProdID, CatID2, ProdCat
==================
1, 2, 1
2, 3
3, 3
In a form (to add a new product to Table2) I need to populate a dropdown with the CatName. So far so good. Now, I will go to have special categories with just one product. When that happens the ProdCat value is '1' (that means that the category is not going to have any more products).
So when populating the dropdown with CatName in those cases where ProdCat is equal to '1' I don't want the corresponding category being showed in the dropdown. How to do this? I have the following code but I know it's not correct and maybe I'm completely out of track: Code:
View Replies
View Related
I have created this array...
For x = 0 To rs.fields.count - 1
Response.Write("sampleValues[" & x & "] = '" & rs.fields.item(x).value & "';")
Next
because I need to x values to get the indexes of rs.fields.item(x).value into my asp page for use on the next page. Further down the page
I have a number listboxes created thus....
Code:
View Replies
View Related
I am using what seems to be a fairly simple calendar program that is ASP. I have been successful in adding fields to this App, but for some reason, I must be missing something because when I go into the program to edit an entry, one of the value's (Location) doesn't populate properly.
It pulls up the LAST option (Other) within that dropdown field, instead of the one that had previously been selected. I'm not sure what I've missed, but could someone help? Here is a portion of the code: (let me know if you need additional info). Code:
View Replies
View Related
I have a DB with a date field that is empty
Because of this the records sometimes get included in searches because their
contents are less than a particular search.
so..I had planned to populate them with any old date.
BUT I CAN'T!!!
I have tried all sorts..and nothing seems to work.. Code:
View Replies
View Related
I'm trying to populate a drop down list with values found in the Project and ProjectAllocation.
The Project Table consist of all the Project Details like Name,Location, Date,etc.
Whereas the ProjectAllocation consist of only 2 fields, ProjectID & EmpID (this is bcos one project can have many employees). Code:
View Replies
View Related
I'm trying to populate a dropdown box with the results of a query. There is current code that does this but it populates with team name whereas I want division name.
The database is set up as:
League - connected to - Division - connected to Team
I want to be able to have someone choose a league and then on the next
page populate a dropdown with all the divisions in that league.
Here is the working code:
View Replies
View Related