Why would some code work some of the time and not others?
It's a CFC call passing a value, which I can see in the error text.. I
manually run the query and I get a result however the error text is
showing [empty string]
The actual error is:
Detail If the component name is specified as a return type, it is
possible that either a definition file for the component cannot be
found or is not accessible.
Message The value returned from the getmem_id function is not of type numeric.
The 2 valuable bits of information is
MEM_ID [empty string]
NEW_ID 3220
In the form struct..
<input type="hidden" name="new_id"
value="#variables.member_id#" />
<input type="hidden" name="mem_id" =
value="#qMember.mem_id#" />
MEM_ID is populated by a query from a CFC:
<cfset qMember =
application.memberGateway.getByAttributesQuery(new_id=variables.member_id)
/>
All this does is select from the member table where the new_id is
3220.. I can run this manually fine.
what I'm wondering is since this is a new design and launch we're
probably getting a lot of hits.. Maybe DB related issue? Connections
or something.. I'll go to query the DB and get some "A transport-level
error has occurred when sending the request to the server"..
We're using MSSQL 2005 and CF 9 Standard.
What all can I check in the CFadmin and what all can I email the DB
team and ask them to check? I'm 100% it's not code related.. it's
something else.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347234
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
