Prev: pdf file
Next: Apache HTTPClient
From: myis10 on 25 Sep 2006 05:38
Solution: #jsstringformat()#

Example:
<cf_select name="PraticeArea" formname="test"
passthrough="style='background-color:##000000; color:##ffffff;'">
<cf_option value="">Select Pratice Area</cf_option>
<cfoutput query="getpa">
<cf_option
value="#jsstringformati(PraticeAreaID)#">#PraticeArea#</cf_option>
</cfoutput>
</cf_select>


<cf_select name="BiBs" parent="PraticeArea" formname="test"
passthrough="style='background-color:##000000; color:##ffffff;'">
<cf_option value="" parent="">Select Bib</cf_option>
<cfoutput query="getBibs">
<cf_option value="#jsstringformat(BIBSID)#"
parent="#jsstringformat(PraticeArea)#">#Title#</cf_option>
</cfoutput>
</cf_select>


thanks for all the respond!



"is" <myis10-noreply(a)covad.net> wrote in message
news:eeu0uv$s3p$1(a)forums.macromedia.com...
> Hi,
>
> Has anyone successfully used CF_Select from Masrizal? I bought the code
only
> to find that it's not working with dynamic options.
> Would appreciate suggestions on how to get this to work. TIA
>
> THis error is coming from this code in the Tag.
>
> <cfquery dbtype="query" name="qryTemp">
> select * from qryTemp
> order by parent
> </cfquery>
> Error Executing Database Query.
>
> Query Of Queries runtime error.
> Query Of Queries runtime error.
> Unsupported Numeric type conversion in Query of Queries.
>
>
>
>
>
>
>
> My Code:
> <cfquery name="getPA" datasource="bibs2">
> select PraticeArea, PraticeAreaID from bibs_tblPraticeArea
> where DeleteFlag = 0 order by PraticeArea
> </cfquery>
>
> <cfquery name="getBibs" datasource="bibs2">
> Select *
> from bibs_tblBibliographies
> where DeleteFlag = 0
> Order by DateModified Desc
> </cfquery>
>
>
> <table border="0">
> <form name="test" action="example.cfm" method="post">
> <tr><td>Pratice Area</td>
> <td>
> <cf_select name="PraticeArea" formname="test"
> passthrough="style='background-color:##000000; color:##ffffff;'">
> <cf_option value="">Select Pratice Area</cf_option>
> <cfoutput query="getpa">
> <cf_option value="#PraticeAreaID#">#PraticeArea#</cf_option>
> </cfoutput>
> </cf_select>
> </td>
> </tr>
>
> <tr><td>Bibs</td>
> <td>
> <cf_select name="BiBs" parent="PraticeArea" formname="test"
> passthrough="style='background-color:##000000; color:##ffffff;'">
> <cf_option value="" parent="">Select Bib</cf_option>
> <cfoutput query="getBibs">
> <cf_option value="#BIBSID#"
> parent="#PraticeArea#">#Title#</cf_option>
> </cfoutput>
> </cf_select>
> </td>
> </tr>
>
> <tr>
> <td>
> <br>
> <input name="Submit" type="Submit">
> </td>
> </tr>
> </form>
>
> <!--- view posted form --->
> <cfif isdefined("form.Submit")>
> <tr>
> <td >
> <hr>
> <cfoutput>
> You have selected this:<br>
> <cfloop collection="#form#" item="key">
> <cfif key neq "fieldnames" and key neq "submit">
> #Key#: #evaluate("form.#key#")#<br>
> </cfif>
> </cfloop>
> </cfoutput>
> </td>
> </tr>
> </cfif>
> </table>
>
>
>
>
>
>


 | 
Pages: 1
Prev: pdf file
Next: Apache HTTPClient