Skip to main content
I
iccsi
Inspiring
October 9, 2013
Question

set form value from MyQuery

  • October 9, 2013
  • 1 reply
  • 508 views

<cfif structKeyExists(MyQuery, "MyID")>

<CFSET form.MyID= MyQuery.MyID>

</cfif>

<cfif structKeyExists(url, "MyID")>

<CFSET form.MyID= url.MyID>

</cfif>

I use above code to check if query ID exists then assign value to my form variable.

It seems that it does not work, but it works for url.

Can you please help and advise are there any way to check value in query and assign to the form if it is defined?

Your help and information is great appreciated,

Regards,

Iccsi,

    This topic has been closed for replies.

    1 reply

    NegiCF
    NegiCF
    Participant
    October 10, 2013

    For assigning the value to form field you can directly use value="#MyQuery.MyID#"

    For eg:<cfform><cfif structKeyExists(MyQuery, "MyID")> <cfinput type="text" Name="MyID" value="#MyQuery.MyID#"></cfif></cfform>

    So the input text will be visible if value in query is defined else the correct data will be populated to form field MyID

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