Ask a Question related to Coldfusion Database Access, Design and Development.
-
quiero mas #1
two select rethink - user fiendly?
I am using the cf two select related tag from the exchange and have great
sucess with it populating the drop down menus
I simple entered my categories manually into to the option sections so i can
get and area and language mix.
central area + English etc
My question
On my search page i have the drop downs populating but how do i get what the
user has chosen to query on the result page.
First i must write the sql - then
What do i have to conider?
Any advice most appreciated
P.s Thanks dan for making me rethink where i was going with the project many
thanks
quiero mas Guest
-
Select user for cam: no users in list
hey everyone i have setup flashmediaserver2 (win) and it connects and all that, but users arent appearing in the select user pulldown? i have opened... -
New user can't select text
Hi Folks, Just got Illustrator CS after years of using AI8 and I'm bogged down already! I'm building a web page, so I started with the "blank"... -
Select all the user table
Hi, Is there a way to select all user tables? For example, I created 5 tables. In SQL analyer, I want to select table name and strutures of tables... -
user cannot select systables
All, I'm new to Informix but not new to databases. I have a user who cannot select from the systables in their own database. As user informix... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id, -
Dan Bracuk #2
Re: two select rethink - user fiendly?
Originally posted by: quiero mas
I am using the cf two select related tag from the exchange and have great
sucess with it populating the drop down menus
I simple entered my categories manually into to the option sections so i can
get and area and language mix.
central area + English etc
My question
On my search page i have the drop downs populating but how do i get what the
user has chosen to query on the result page.
First i must write the sql - then
What do i have to conider?
Any advice most appreciated
P.s Thanks dan for making me rethink where i was going with the project many
thanks
I think the way I did it was.
For select number 1 (which controls number 2), run a query to get the selected
value. That part is easy.
For select number 2, you need two queries. The first is a Q of Q from all
available values to get just those that are related to the selected value in
select 1. The second is to get the selected value.
Or it might have been something else. All that stuff is at work. I am not.
Dan Bracuk Guest
-
quiero mas #3
Re: two select rethink - user fiendly?
Ok ill give it a try - as you say te first one should be too much trouble. However the second one is going to be tuff.
thanks again
Mark
quiero mas Guest
-
Dan Bracuk #4
Re: two select rethink - user fiendly?
Originally posted by: quiero mas
Ok ill give it a try - as you say te first one should be too much trouble.
However the second one is going to be tuff.
thanks again
Mark
Actually, it's even easier. You already have the js function written. Just
call it as part of your body onLoad event handler.
Dan Bracuk Guest



Reply With Quote

