Populate Dropdown With Image AND Text From The Database?
I have two columns in my microsoft access database.
1st column is company_logo (jpg image)
2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
Does anyone knows if this could be done?
Maybe I should stick just with the textual part?
View Replies
ADVERTISEMENT
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 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 would like to populate a dropdown box with monthly names. Jan- Dec.
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'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
i am in desperate need of help with ASP and populating an optgroup dropdown box.I have one table which has 3 fields within a SQL Database, the first is ID numbers, the second is Country and the third is City (within that Country)Eg: I have 1; United Kingdom; London.
What I am trying to do is have an “optgroup” dropdown box with the Countries as the optGroup label and the cities related to each country under that optGroup. I want to populate the dropdown box with this data, preferably in alphabetical order of city. Is there a way to do this in ASP?
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'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'm brand new to this forum AND learning ASP via problem-based learning (not the easiest or sound way to do so, I know).
In any case, I have a form that uploads an image to my server. It does so via a form action to a new asp page. The new page has a link back to the original page. On the original page, I want the name of the file to appear in a text field e.g. Code:
View Replies
View Related
in a text field e.g.
<INPUT TYPE="text" NAME="Homepage Email Address" SIZE="25">
How would I pre populate that text box so that when a user opens the page there is already text in that box?
View Replies
View Related
I need to populate an array with two columns of data from a database eg Firstname and second name and sorte alphabetically. So both of these columns go in to one array, I found this code.
View Replies
View Related
I have a dropdown box whose contents i want to automaticaly display in a accompanying text box when a selection is made in the dropdown. My dropdown box is populated by a access database query and when someone chooses one of the options, i want that option to display in the accompanying text box. I hope this makes sense. I'm not sure how to use the "onclick" javascript function.
View Replies
View Related
I have a dropdown that is dynamically populated. The value = a numeric code which I save in the DB. The text = the description. I know how to get the value of the selected item but I need the text of the selected item. I know how to do this in javascript but where I need to gather the text is during an ASP routine.
How do you get the text portion of a dropdown? I saw one post where you can add the numeric code and description together and then use split() to seperate them. I'd rather not do it this way. Is there another way?
View Replies
View Related
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies
View Related
I have the following code that pulls a record based on a form submittal then populates a form with the fields so the record can be updated. My problem is in my query line more than likely in my keyset types and what not. Code:
View Replies
View Related
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
View Related
I have an .asp page containing a form with (multiple) select/dropdown boxes. The page is submitted to itself.
Is there any way of retrieving the selected values (i.e. the text) in the select boxes server-side?
I'm looking for something like Request.Form("Select1").Value.
View Replies
View Related
It gives me a blank dropdown when there are values in the Currency Table and
it also does not display any form element that I place after this code.
<select size="1" name="Currency" >
<%
SQL = "Select CurrSymbol FROM Currency "
SET RS = CONN_STRING.Execute(SQL)
While NOT RS.EOF%>
<option value="<%=RS("CurrSymbol")%>"><%=RS("CurrSymbol")%></option>
<%
RS.MoveNext
WEND
Set RS = NOTHING
%>
</select>
View Replies
View Related
I'm trying to display thousands of people's names so a user can pick
one. Is a dropdown the best way to do this? Is there a better way? I've
never had to deal with that many names, so I don't know how it will affect
performance.
View Replies
View Related
This code only allows for 1 date from my database to be added. I need to be able to populate it with all matching dates. I'm not to sure on how to do this.
<select name=""select"" size="1">
<option value="date"><%=get_notes("date")%></option>
</select>
View Replies
View Related
I am trying to list a database (SQL) i a dropdown list but I just cant get it to work... I am writing in ASP. This is some of the code:
mySQL="SELECT ras.raser FROM ras ORDER by raser"
<tr>
<td width="220">Raser</select></td>
<td width="342" height="23">
<select name="idRas">
<%do while not rstemp.eof
pRaser= rstemp("raser")
%>
<option value='??????????' </option>
</select>
</td>
</tr>
View Replies
View Related
I have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
View Replies
View Related
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user
has selected one value from the dropdown it should show values from
(tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a
button "GO" it should show all the value's from the database that been
selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
View Replies
View Related
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
<select name="ccType">
<option value="Visa" selected="<%=rs("cardtype")%>" >Visa
<option value="Mastercard" selected="<%=rs("cardtype")%>">MasterCard
</select>
View Replies
View Related
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
View Replies
View Related
Just wondering if anyone knows of any scripts/component that will allow me to create an image of a text on the fly?
View Replies
View Related
is there any component to make it.. i want to make user registiration page..
in this page i want to place a image which has a text and a user must be
type this text to a text box and after that i will check the textbox value
and image text value.. how can i make it.. do i need a component. if there
is a component what is its name .. and i need a free one...
View Replies
View Related
I would like to dynamically add a text as a watermark on images.
I managed to do that with aspsmartimage but as the watermark is added
when the image is sent to the browser, it takes too much ressources on
the server, due to a big number of images to diplay simultaneously.
Is there a way or an other component to do that more efficiently. I
can't add the watermark when uploading the file because it has to be
written when the image is displayed.
View Replies
View Related
I need to add a text into an image, I mean you have any picture and want to show the picture with some copyright in the picture. I know about the library cximage and there is a function drawstring, but I can't use correct that function.
please if somebody has experience with the free library cximage or you know another one how to make this porpouse, let me kno it.
View Replies
View Related
I need to get text posted from a webpage to a image. The text needs to be displayed with fonts that I can't use in a webpage. This is to be used submitting textadds from the web, later to be published in a newspaper.
The image it self will not be published, I need it to calculate the price for the add.
There for I need it with the fonts used in the newspaper. Don't now if this is the right group.
View Replies
View Related
I 've built a site for a client using .asp and eveything is working fine except I cannot figure out how to wrap text around an image. Everything is pulled from the database so the code works correctly but I've been searching for weeks about info on how to do this -to no avail.
View Replies
View Related
On my index page I have got an area for one product to be displayed randomly from the
database. I have got it workign, but there is one problem i cant get my head around, here is the code so far:
' Initialize ASP RND() function
Randomize()
intRandomNumber = Int (1000*Rnd)+1
strsql = "SELECT TOP 1 art_Artist, art_Title, Rnd(" & -1 * (intRandomNumber) & "*cat_ID)" &_
"FROM eventDisplay " &_
"ORDER BY 3"
The code above isnt working and its when i try and draw out more that one value, as in art_Artist and art_Title.
It works fine if all I want is art_Artist, but as i said when i try to draw out more than one value the randomize function doesnt work.
View Replies
View Related