Avatar

Level 1

Request: Can someone please provide me a link to a "good" example of using LC Designer to connect to a .cfc?wsdl file & populating a field with the results of the web service?

Scenario:

The first time client submits the form, the data populates the Parent table with a Project Name entered by the client. The next time the form is opened, I’d like to have a hidden field populated with the assigned PK of the record using a data connection to the CFC?WSDL file. I have a CFC, with remote access, that will query the database on the argument of Project Name and return the PK to populate this hidden field.

Webservice:

<cfcomponent>

          <cffunction name = “getID” access = “remote”  returntype = “numeric”>

              <cfargument name=”projectName”  type = “string”/>

                    <cfquery name="qgetID" datasource="devnetws">

                              SELECT projectID

                              FROM TABLE

                              WHERE txtprojectName = #projectName#

                    </cfquery>

            <cfreturn getID> 

</cfcomponent>