- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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>
Views
Replies
Total Likes