OK...I give up....here's the code:
<cffunction name="getHail" access="remote" returntype="query"
output="false" hint="Retrieves a core hail out record (hail
numbers/licences/trip types/periods can be retrieved via other available
methods). If a hailID and hailNumber are passed in, the hailID will be used
instead of the hailNumber">
<cfargument name="user" type="string" required="yes">
<cfargument name="pwd" type="string" required="yes">
<cfargument name="hailNum" type="numeric" required="yes"
hint="hail number of desired hail record (pass a zero if you want to ignore
this argument)">
<cfargument name="hailID" type="numeric" required="yes"
hint="activity ID of desired hail record (pass a zero if you want to ignore
this argument)">
<cfargument name="hailType" type="string" required="yes"
hint="type of hail (valid values are OUT and IN)">
<cftry>
<!--- we will lookup hail by activity ID for provided hail number -
lookup activity ID --->
<cfif Len(Trim(ARGUMENTS.hailNum)) AND NOT
Len(Trim(ARGUMENTS.hailID))>
<cfquery name="qGetActID" datasource="#datasource#"
username="#ARGUMENTS.user#" password="#ARGUMENTS.pwd#">
SELECT act_act_id
FROM #oschema#.hail_number
WHERE haiul_no = <cfqueryparam value="#ARGUMENTS.hailNum#"
cfsqltype="CF_SQL_NUMERIC">
</cfquery>
<cfset activityID = qGetActID.act_act_id>
<!--- hail number and hail ID (activity ID) passed to method - ignore
hail number and use hail ID to lookup hail --->
<cfelseif Len(Trim(ARGUMENTS.hailNum)) AND
Len(Trim(ARGUMENTS.hailID))>
<cfset activityID = ARGUMENTS.hailID>
</cfif>
<!--- lookup hail out record --->
<cfif Trim(ARGUMENTS.hailType) eq "OUT">
<cfset qGetHail =
CreateObject("component","appcfcs.fos.hails").getHailOuty(ARGUMENTS.user,ARGUMENTS.pwd,activityID)>
<!--- lookup hail in record --->
<cfelseif Trim(ARGUMENTS.hailType) eq "IN">
<cfset qGetHail =
CreateObject("component","appcfcs.fos.hails").getHailIn(ARGUMENTS.user,ARGUMENTS.pwd,activityID)>
</cfif>
<cfreturn qGetHail>
<cfcatch type="any">
<!--- <cfset qGetHail = packageError(cfcatch.errorMessage)> --->
<cfdump var="#cfcatch#"><cfabort>
</cfcatch>
</cftry>
</cffunction>
I have forced an error by calling "getHailOuty" instead of "getHailOut"
(this condition is met <cfif Trim(ARGUMENTS.hailType) eq "OUT">). The
cfcatch does NOT fire off and no dump of cfcatch scope occurs....instead I
get a standard fairly useless CF webservice error.
Anybody?
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
