I think you'll have to concatenate that in your query for that to work
the way you want. Just add the concatenated field to your query and
use that in your flash form and you should be fine.
Matt
On 6/6/06, Ray Hughes <[EMAIL PROTECTED]> wrote:
Hi All
I have a piece of code that works which I built. Now I want to extend it
such that the value field is a concatenated value of two fields from the
database.
Working part:
<cfformgroup type="page" label="Provider">
<cfselect name="Provider" label="Provider:" query="getAllProviders"
queryPosition="below" display="Provider"
value="ProviderLocation">
<option value="9999999999" selected>Any Provider</option>
</cfselect>
</cfformgroup>
This is the same:
<cfformgroup type="page" label="Provider">
<cfselect name="Provider" label="Provider:" query="getAllProviders"
queryPosition="below"
This display function I want to extend.
I want to display the concatenated value of two fields from the database.
display="Provider & ProviderLocation"
This is the same:
value="ProviderLocation">
<option value="9999999999" selected>Any Provider</option>
</cfselect>
</cfformgroup>
Has anyone attempted to do this before?
This is the error I receive. I have tried several different combination.
Query column invalid or missing.
You must specify the name of a column in the query "getAllProviders" for the
Display attribute of the CFSelect tag.
Regards
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
Matt Woodward
[EMAIL PROTECTED]
http://www.mattwoodward.com
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
