|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#16
March 7th, 2006, 07:32 AM
|
||||
|
||||
|
The original would have been Access 2000.
Attached is a 97 conversion of the database.
__________________
-
thought-after | my thoughts on web development Get Firefox, the developers browser Budget hosting - recommended [/left]
|
|
#17
March 7th, 2006, 08:53 AM
|
|||
|
|||
|
Thank you, that is what it was.
|
|
#18
April 1st, 2006, 07:18 PM
|
|||
|
|||
Getting the ID's to write to a database
If you want to get the IDs to write to a database, how to find the string name is set out in this post
|
|
#19
April 10th, 2006, 06:20 AM
|
|||
|
|||
How to get the list boxes on seperate lines????
Hi,
I have been trying to get the listboxes on seperate lines instead of one line ie: instead of Select Country Select City I would like Select Country Select City After adding in an extra & VbCrLf all over the place line by line, and then trying a Code:
%> <br> <% all over the place, I can only get the whole row to move down, but not get the boxes on 2 lines. I have finally worked out that it has something (I think) to do with the following line Code:
<%= buildLinkedList("listCountry",0,1,1,"Select a country","width150","listCity",2,3,1,"Select a city","width150") %>
Can someone please help? 
|
|
#20
April 10th, 2006, 06:22 AM
|
||||
|
||||
|
you need to add "<br />" after the "</select>" html.
|
|
#21
April 10th, 2006, 06:31 AM
|
|||
|
|||
|
I have tried that!
For example current code is Code:
strList1 = strList1 & "</select>" & VbCrLf I have tried Code:
strList1 = strList1 & "</select>" & VbCrLf %> <br /> <% and Code:
strList1 = strList1 & "</select>" & VbCrLf & VbCrLf but it will only move the whole line down, but the 2nd box to the second line The </select> s are all in a function. Any other ideas will be appreciated Last edited by hauruapai : April 10th, 2006 at 06:33 AM. Reason: adding more info
|
|
#22
April 10th, 2006, 06:53 AM
|
||||
|
||||
|
what you tried is wrong.. instead, have this:
Code:
strList1 = strList1 & "</select><br />" & VbCrLf
|
|
#24
April 19th, 2006, 04:19 AM
|
|||
|
|||
|
Thank you for this code. I can't believe i missed it oh well.
Inserting works like a charm.. I have a small request about using this when updating my rs. I'm trying to get the data out of the database and i want it to say selected but it comes up with select a category. If anyone can throw some help my way i'll appreciate it. I just need to be able to tell the data to read in the variables i've set on the page which are "cat_id" and "subcat_id" All help would be appreciated webb
__________________
Life is Good
|
|
#25
April 19th, 2006, 09:36 AM
|
|||
|
|||
This may help
Look for the following lines of code and change the bits in red to what ever it is that you want
Code:
<form id="testform" method="post">
<%= buildLinkedList("listCountry",0,1,1,"Select a country","width150","listCity",2,3,1,"Select a city","width150") %>
</form>
|
|
#26
April 19th, 2006, 09:53 AM
|
|||
|
|||
|
I've done the insert but whe it's time to do an update the values come up blank.
The items in red are the prompts that say select a city or select a country. How would i change this to the values of my variables???
|
|
#27
April 19th, 2006, 06:24 PM
|
|||
|
|||
oops...
apologies, I didn't understand properly... so I will try again!
Look for these lines of code and change the bits in red to your values. Code:
'Construct SQL statement strSQL = "SELECT x.countryID, x.countryName, y.cityID, y.cityName FROM tblCountry AS x INNER JOIN tblCity AS y ON x.countryID = y.countryID ORDER BY x.countryName, y.cityName;" Leave the x and the y in place - x will be your first table and y will be your second table
|
|
#28
April 19th, 2006, 09:06 PM
|
|||
|
|||
|
i've done all that and it works very well.
I insert the data from the listboxes into another table called products. Now when i want to update the data in the products table i need the listboxes to repopulate with the variables from my code and then say selected so i can see the values i chose earlier. I have given the listboxes names from my variables cat_id and subcat_id. I know there's a way but i'm not up to it... Any more ideas......i'm almost there webb
|
|
#30
April 20th, 2006, 06:36 PM
|
|||
|
|||
|
Adding URL
Great example - worked first time! Quick question, being a newbie how do I add a param or the option to go to a specific url once you have made a selection from the populated list?
cheers,
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Dynamic dependant listboxes |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
