Need to... double parse?

[Guest]

Okay, I have an application that can change frequently, as such, I need to run a query that tells my main query what it needs to update. So one query provides the other all the fields it needs to update. The main query and function are attached. The Insert part works fine, but the values part isn't working. The output looks like
INSERT INTO moves(name, damage, type, accuracy, recoil, minlevel, price, Boxing, Wrestling, TaiKwonDo, Karate, Capoeria, SAMBO, Ninjitsu, KungFu, Kempo, Savate, KickBoxing, MuayThai, description ) VALUES ('Blah', '1', 'Wresting', '25', '13', '7', '5', '#form.Boxing#', '#form.Wrestling#', '#form.TaiKwonDo#', '#form.Karate#', '#form.Capoeria#', '#form.SAMBO#', '#form.Ninjitsu#', '#form.KungFu#', '#form.Kempo#', '#form.Savate#', '#form.KickBoxing#', '#form.MuayThai#', 'Test')

See how it is just plugging #form.Fightingstylename# instead of actually finding the value of that field. How can I make it actually find the value of the field it is creating? I hope this makes sense.

[Newsgroup_User]

Start with the evaulate() function.

Ninety percent of the time this type of logic can be rewritten to make
it simpler and not need this type of double evaluation.

[Guest]

Thanks for the info, I'll check into the evaluate function.
There probably is a better way to do this, but I'm a terrible programmer, so unless you have any better ideas, i think I'm gonna have to roll with it.

[Newsgroup_User]

see if this works:

<cfloop query="fetchStyles">
<!--- Desired output of this look looks like '#form.boxing#' --->
'#form[ReReplace(fetchStyles.name,"[[:space:]]*","","all")]#',
</cfloop>

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Guest]

Thanks for the reply. This was the magic setup that did the trick...

<cfoutput>
<cfloop query="fetchStyles">
<!--- Desired output of this look looks like '#form.boxing#' --->
<cfset prestring = "##form.">
<cfset poststring = "##">
<cfset mainstring = ReReplace(fetchStyles.name,"[[:space:]]*","","all")>
<cfset wholestring = prestring & mainstring & poststring>
'#evaluate(wholestring)#',
</cfloop>
</cfoutput>