I'm breaking all of my SQL out into a CFC library as a first step
towards supporting multiple database types. It's a pretyt sizeable
task, and, obviously, I'd like to be able to reference the
self-documenting features of CFC's. The problem is, when browsing
directly to the CFC in the hopes of seeing the generated documentation
(http://localhost/lib/cfc/mssql.cfc in my case) I get a blank page.
Here's a snippet of my cfc:
<cfcomponent displayname="Microsoft SQL Server Component" hint="This
component contains all Microsoft SQL Server database access code."
style="RPC" output="Yes">
<cfset msg = "">
<!---
**** Security & Authentication ****
--->
<cffunction name="login" access="public" description="Logs in user."
output="No" returntype="query">
<cfargument name="username" required="Yes" type="string"
default="">
<cfargument name="password" required="no" type="string"
default="">
<cfstoredproc procedure="spAuthenticateUser"
datasource="#request.app.dsname#" returncode="Yes">
<cfprocparam type="In"
cfsqltype="CF_SQL_VARCHAR"
dbvarname="username" value="#arguments.username#" null="No">
<cfprocparam type="In"
cfsqltype="CF_SQL_VARCHAR"
dbvarname="password" value="#arguments.password#" null="No">
<cfprocresult name="loginQuery" resultset="1">
</cfstoredproc>
<cfreturn loginQuery>
</cffunction>
</cfcomponent>
Anything obvious that I'm doing wrong? The methods all work
perfectly, so I'm pretty sure it's not my code. I'm using MX7 on
WinXP/IIS.
Thanks,
Pete
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238262
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
