Tricky Question on using StructFind or StructFindValue

Posted on 2004-09-15
Last Modified: 2013-12-24

I am trying to write this query that has some conditional logic.  I urgently need a solution if anyone is around.

I get the error (below) when trying to do this:

You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members.

My code snippet from the actual query is as follows:

<cfif StructFindValue(#currentStructure.List#, "ABC")>,Some_Code, Some_Amount</cfif>

and then in the   VALUES part of the query I have:

( <cfif StructFindValue(#currentStructure.List#, "ABC")>,'XL',40</cfif>

I am trying to find the value "ABC" in the structure and if so, then add the columns Some_Code and Some_Amount with values of  'XL' and '40'

Can someone PLEASE tell me where I am going wrong?  Should I use StructFind? or StructFindValue?

Question by:Westside2004
  • 2
  • 2
LVL 10

Expert Comment

ID: 12063366

How does your structure look like? (use cfdump)
What is in #currentStructure.List#

if #currentStructure.List# contains 'abc' (string and not a structure) try this:
StructFindValue(#currentStructure#, "ABC")

LVL 17

Expert Comment

ID: 12070244
Are you trying to find a key in the structure or a value in the structure?
Use structFind to find a key and structFindValue to find a value

are you sure currentStructure.List is a structure and not a list , i.e. string?

Author Comment

ID: 12071747

I think its a list.... i did a dump and its comma separated....

Is it possible it could be a list within a structure?


LVL 10

Accepted Solution

Mause earned 250 total points
ID: 12072137
Yes you could have a list in a structure
to see if  "ABC" is in the list

#ListFind(currentStructure.List, "ABC")#

Author Comment

ID: 12081580
Yes, that worked.

Thanks a BIG BUNCH!!!

HIGHLY appreciated!

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Time Sheet Help 6 44
RewriteRule to Include HTML, but Not Affect Images 4 71
Web server load balancing technologies and methods 3 85
Tool to email me when a website changes 29 118
This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
A web service ( is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

939 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now