-
Using conditional MagicCell to choose whether or not to display a field
It's my understanding that I can decide whether or not to display a field by using the MagicCell conditional statement. Is this so, and if yes, how? Here is what I want to do...
<%
...
X.dbSQL = "SELECT StockNo,SerialNo,Yr,Make,Carline AS Ford,Carline AS Chevrolet,Color,Miles,C_Cst FROM CARLIST"
X.dbFilterFlds = "Make,Ford,Chevrolet"
X.dbFilterDropFlds = "Make,,Carlist,Make,,,,,Distinct;;;Ford,,,,Sel ect Distinct Carline from Carlist where Make like 'FORD%'; Chevrolet,,,,Select Distinct Carline from Carlist where Make like 'CHEVROLET%'"
...
%>
If they choose something from the Ford dropdown, I want it to only display the Carline field 'AS Ford'. And the same for Chevrolet. How can I get this to happen with magicCell?
Thanks!
Jason
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|