Skip to main content
Known Participant
February 5, 2019
Answered

Invalid attribute value CF_SQL_STRING Error when submitting a Form

  • February 5, 2019
  • 2 replies
  • 4115 views

Hello,

   We using Cold fusion 2018 on Windows Server 2016.

When I am trying to submit a Form to call another page within the application I get an error which states "

Error Occurred While Processing Request. Please try again.

Invalid attribute value CF_SQL_STRING for attribute CFSQLType

The

error occurred on line 223

"

I am not sure why the string value is throwing up an error. Please advise

The code snippet used is shown below,

     <cfoutput>

                      <CFSTOREDPROC PROCEDURE="dbo.PKG_CFSTOREDPROC.proc_print_calc" datasource="#datasource#" username=#Session.UserName# password=#Session.password#>                                     

                          <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_STRING" VALUE=#ipn#>

                          <CFPROCRESULT NAME="RefEquation">               

                      </CFSTOREDPROC>

                     </cfoutput>

    This topic has been closed for replies.
    Correct answer EddieLotter

    Use CF_SQL_VARCHAR.

    2 replies

    iq11Author
    Known Participant
    February 6, 2019

    Thanks it works perfectly fine now. So should I replace all the CF_SQL_STRING with CF_SQL_VARCHAR 

    EddieLotter
    Inspiring
    February 6, 2019

    Yes, you need to replace all CF_SQL_STRING occurrences, because it is not a valid option.

    iq11Author
    Known Participant
    February 6, 2019

    Thanks , appreciate your help. I will do.

    EddieLotter
    EddieLotterCorrect answer
    Inspiring
    February 5, 2019

    Use CF_SQL_VARCHAR.