Re: Can I use replace function on a string to create form drop box options?

why not just: cfloop list=#option1# index=i option value=#i##i#/option /cfloop On 10/20/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I've got a database field called option1 that contains two colors seperated by a comma: red,yellow. What I'm trying to do is create a drop down form

Re: Can I use replace function on a string to create form drop box options?

and just because if i don't say it, somebody else will... it's generally not a good idea to store lists (delimited data) in relational databases. you've got a one-to-many relationship and would probably run into fewer issues in the future if you were to break it out as such. On 10/20/06,

RE: Can I use replace function on a string to create form drop box options?

select name=option1 class=formbox cfloop list=#option1# index=listItem option value=#listItem##listItem#/option /cfloop /select -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 1:27 PM To: CF-Talk Subject: Can I use replace

Re: Can I use replace function on a string to create form drop box options?

That worked perfectly. So simple too. Yes, I understand the practice is not the best, and I see potential problems in the future by storing this string in the field. This is just a one-time thing, used for just two records that I was hoping for a quick shortcut that tutned into a

Re: Can I use replace function on a string to create form drop box options?

and just because if i don't say it, somebody else will... Argh... I was affraid someone would indeed :-) This is right IN THEORY, and in most cases, but in practice, when the list has only a few elements, and is not expected to have many ever, a list in one field is a much simpler and more

Re: Can I use replace function on a string to create form drop box options?

i said GENERALLY :P On 10/20/06, Claude Schneegans [EMAIL PROTECTED] wrote: and just because if i don't say it, somebody else will... Argh... I was affraid someone would indeed :-) This is right IN THEORY, and in most cases, but in practice, when the list has only a few elements, and is

RE: Can I use replace function on a string to create form drop box options?

Argh... I was affraid someone would indeed :-) This is right IN THEORY, and in most cases, but in practice, when the list has only a few elements, and is not expected to have many ever, a list in one field is a much simpler and more efficient solution. I'd actually rather brush my teeth

Re: Can I use replace function on a string to create form drop box options?

i said GENERALLY Good point ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks.

Re: Can I use replace function on a string to create form drop box options?

I'd actually rather brush my teeth with a chainsaw than store a delimited list in a database field You see? This is unbelievable what kind of weirdness people can do when they go by the book ;-) -- ___ REUSE CODE! Use custom tags; See