• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Can we?

Explorer ,
Dec 07, 2006 Dec 07, 2006

Copy link to clipboard

Copied

Run a query out of a ValueList(MyField, ";") variable? My value liste is set like <cfset MyVariable = ValueList(MyField, ";") >

Or transform the value liste to some king of ??? that can by queried after?
TOPICS
Advanced techniques

Views

240

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Dec 07, 2006 Dec 07, 2006

Copy link to clipboard

Copied

The ValueList function requires a query to be used, so I'm not sure why you might need to reconvert it to a query again. However, you can transform the ValueList back to a Query object. I attached some code to this post that:
1. Runs a fake query on US States
2. Converts the name column from the query into a list with ValueList()
3. Create a new Query with the QueryNew() function
4. Loop over the list, adding the new row and column information
5. Do a QoQ to extract, sort, etc.

You can also look into some of the List functions (converting the list to an array, sorting the array, searching within the list, etc.).

Hope that helps!
Craig

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Dec 07, 2006 Dec 07, 2006

Copy link to clipboard

Copied

LATEST
OK, I get the concept and I can play with that.

Now, is their a way to evaluate 2 queries and display only what is not the same.

What I need to do is to evaluate what have been changes from the same table before and after an unpdate true a form.

This is why I've been creating ValuList before the update and an other one after the update, obviouselly, both ValueList containe information that are the same but I need to display the one that are not either if they've been added, change or delete.


regards

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation