Create you query statement to concate the fields.
Select 'Provider' +' '+ 'ProviderLocation' as mylocation
from my table
Use mylocation as the value.
or
If it is a true relational database, then can just use the ProviderLocation
ID and relate it back to the provider table.
Robert
----- Original Message -----
From: "Ray Hughes" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, June 06, 2006 9:21 AM
Subject: [DFW CFUG] Flash Form Concatenation Problem
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/
_______________________________________________
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/
