Skip to main content
M
M phani kumar
Participant
January 29, 2013
Answered

ValueList function error after migrating CF8 to CF10

  • January 29, 2013
  • 1 reply
  • 789 views

Hi All,

We are migrating our reports from CF8 to CF10. (uninstalled existing CF8 and installed CF10) in 32bit OS.

After upgradation of CF10, tried to open our report, then we got the below error.

----------------------error --------------------------

The ValueList() function has an invalid parameter: DS_ODBC_LIST.entry.Parameter 1 of function ValueList which is now DS_ODBC_LIST.entry must be pointing to a valid query name.

------------------error-----------------------

-------------original code -----------------------------------

<CFREGISTRY

    ACTION=GETALL

    NAME="DS_ODBC_List"

    TYPE="ANY"

    BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI">

<cfset DSNnames = valueList(DS_ODBC_LIST.Entry)>

-----------------------------original code--------------------------

Then tried to dump / print the DS_ODBC_List using CFoutput/cfdump then we got error like:

Variable DS_ODBC_LIST is undefined

in CF Administrator the tag CFREGISTRY is in enabled tags list.

can some one suggest me what the alternate tag / any patch I can use to solve the issue ?

Thanks in advance!!!

    This topic has been closed for replies.
    Correct answer M phani kumar

    installilng mandate patch and hotfix-7 sold the issue, Thanks All

    1 reply

    D
    duncancumming
    Participating Frequently
    January 29, 2013

    At a guess it may be choking on the underscores in the query name.  You could try referencing it like:

    <cfset DSNnames = valueList(variables["DS_ODBC_LIST"].Entry)>

    M
    M phani kumarAuthorCorrect answer
    Participant
    January 31, 2013

    installilng mandate patch and hotfix-7 sold the issue, Thanks All

    Hello World!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices