Figured it out finally . logic flow problem!!
Thanks to all that scratched their heads a bit!
> So basically, I can't delete whatever was previously selected, I can
> only select something different.
~|
Adobe® ColdFusion® 8 so
just trying to USE the tools as they are :) and see how far they get me...
no other good reason :)
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Wed, Oct 15, 2008 at 10:43 PM, Charlie Griefer
<[EMAIL PROTECTED]> wrote:
> why not just use
yeah thats what i did :)
but i was just wondering if there was a cf way around it... thanks!
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Wed, Oct 15, 2008 at 10:23 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:
> create a column in your que
why not just use a ?
On Wed, Oct 15, 2008 at 7:23 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:
> create a column in your query that concatenates the data you need and
> use that column in the display attribute of cfselect:
>
>
> SELECT id, name, value, name + ' (' + value + ')' AS name_value
> F
create a column in your query that concatenates the data you need and
use that column in the display attribute of cfselect:
SELECT id, name, value, name + ' (' + value + ')' AS name_value
FROM...
note: concatenation syntax is db-specific - check your db manual for
correct syntax to use!
>With the HTML SELECT tag, I can populate the option with a query (for
>instance, a listing of all states from a database), and then using another
>query with lets say user information, I can have the users state selcted
>using two queryies and CFIF statements like this...
Hey there is an open sou
On 1/23/07, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> selected="#qUserInfo.State_ID#">
>
> i'm not a cfform user, so i'm not sure about the pound sign usage there.
>
> Sweet. Thanks Charlie. Hope to see you at our first IECFUG once we get a
meeting place.
--
Bruce Sorge
"I'm a mawg: half ma
i'm not a cfform user, so i'm not sure about the pound sign usage there.
On 1/23/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> Hello list,
> With the HTML SELECT tag, I can populate the option with a query (for
> instance, a listing of all states from a database), and then using another
> query w
> With the HTML SELECT tag, I can populate the option with a
> query (for instance, a listing of all states from a
> database), and then using another query with lets say user
> information, I can have the users state selcted using two
> queryies and CFIF statements like this:
>
>
>
> qUser
Actually, from a performance perspective CFSELECT is much faster than
using
a CFOUTPUT in a SELECT tag. I, too have had this problem and here is
my
solution:
You have to put it in the SQL statement. Here is an Oracle example...
SELECT 0 AS carrier_ID, 'Select a Carrier' AS carrierN
Just my .02.
But I mostly stay away form CFSELECT, because I don't use CFFORM
you could just use
Select State
#name#
This I believe would get you what you want.
(but watch my typing, was just done on the spur of the moment ;o)
-Origi
Put the option tag before the output query.. Then in the select tag, make
the option selected.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 2:49 PM
To: CF-Talk
Subject: cfselect question
Does anyone know of a way to display a
You ought to look into cf_twoselectsrelated. This is a cool custom tag that
uses JavaScript without the page reloads.
Michael Bruce
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 12:00 PM
To: CF-Talk
Subject: cfselect question...
Hello c
Have you had a chance to try the TwoSelectsRelated tag yet?
It doesn't always play "nice" with a CFFORM but will with a little work.
> Hello cf-Talk,
>
> I'm using a CFSELECT on a page, and the selection determines the
> CFSELECT used on the following page.
>
> Is there a way to have anoth
No, I think cfselect NEEDS just a field name.
You CAN do what you want directly in your query. The syntax will differ
with DBMS, but with SQLServer you can do:
SELECT 'ratecenter '+substring(phonenum,6) as myRateField
and then you could use "myRateField" in your cfselect.
-Original Me
Sure. Do it in your query
SELECT Name AS FName + LName (use syntax for your DB here)
best, paul
At 12:23 PM 11/28/00 -0500, you wrote:
>Okay, pretty simple question here:
>
>I have a cfselect form field that is being populated by the LName column in
>my Contacts table:
>
>display="LName">
>
I usually do so in the sql select statement. By adding something like:
Select *, LNAME + ', ' + FNAME AS FULLNAME order by FULLNAME
Then I use the column FULLNAME in the cfselect.
Athelene Gieseman
[EMAIL PROTECTED]
-Original Message-
From: .elizabeth. [mailto:[EMAIL PROTECTED]]
S
17 matches
Mail list logo