How can I expand a variable which is embedded within a table column, itself expanded by a cfquery output?
A query, FilesInfo.description, is enclosed with cfoutput tags (see below). This is a column inside my sql table, data type varchar.
I want to edit the contents of FilesInfo.description and insert a variable in the middle of the text. When FilesInfo.description is expanded, the new variable is also expanded.
I guess you can see this as a variable within a variable, and it seems to me I read one cannot do this. But I'm hoping there is another way.
Here's the contents of "filesInfo.description".
"Story of a group of filmmakers traveled to Skull Island. <cfoutput>#variable#</cfou
The problem is when expanded, #FilesInfo.description# displays my embedded variable name like this:
"This is the story of a group of explorers and documentary filmmakers traveled to Skull Island. #variable# There they intend to investigate legends of a giant gorilla named Kong."
The variable is not expanded. Is there a workaround or a different method to do this without having to change my database design?
<cfquery name="FilesInfo" datasource="Library">
select description
from areas
where area_id = #area_id#
</cfquery
<cfoutput>#FilesInfo.descr
- Georgia
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
The evaluate function wasn't working in my testing. You can also approach your problem this way.
<cfquery name="FilesInfo" datasource="Library">
select description
from areas
where area_id = #area_id#
</cfquery
<cfset var = "12345678">
<cfset newText = Replace(FilesInfo.descript
<cfoutput>#newText#</cfout
CodeParadise,
The evaluate function didn't work for me either, but your solution does. I should have thought of it. Makes sense. However, to get it to work for me, I had to do this:
<cfset newText = Replace(FilesInfo.descript
babygunk is just some text I know I'll never use so it's unique and does not need to be a set variable. It replaces babygunk with my defined variable, var.
Thanks for your help, and thanks, pegarm, for the attempt.
- Georgia
Business Accounts
Answer for Membership
by: pegarmPosted on 2006-11-09 at 01:20:58ID: 17904925
Try this:
<cfquery name="FilesInfo" datasource="Library">
select description
from areas
where area_id = #area_id#
</cfquery
<cfoutput>#evaluate(FilesI