Tearing my hair out and please need just a touch of help.
Basically, I need to share a huge database between two servers.
Here's what I've got.
1. website with a login form on one server. (SiteA)
2. Website with database and needed stuff on another
server halfway around the planet. (SiteB)
So, on SiteA is my login form with "username" and "password" fields. I
need to check this against the database on another site. So, on my form
processing page I've got:
<cfinvoke webservice="www.MyRemoteSite/siteA_process.cfc?wsdl"
method="getLOGIN"
returnvariable="getLOGIN"
username="#form.username#"
password="#form.password#" >
On "siteA_process.cfc", which is on SiteB, I've got the function set up:
<cffunction name="getLOGIN"
access="remote"
returntype="query">
<cfargument name="username" type="string" required="true"/>
<cfargument name="password" type="string" required="true"/>
<cfquery name="getLOGIN">
SELECT userNAME,
userPASS,
customerNUMBER
FROM ClientInfo
WHERE userNAME = (#arguments.username#)
AND userPASS = (#arguments.password#)
</cfquery>
<cfreturn getLOGIN>
</cffunction>
When I run this I get an error:
[coldfusion.runtime.MissingArgumentException : The parameter USERNAME to
function getLOGIN is required but was not passed in.]
I've double checked my form names:
<input id="username" name="username" type="text" />
<input id="password" name="password" type="text" />
Look right to me.
Why is the username not getting passed?
The entiretly of SiteA is completely dependant of using web services to
get/put/share data over to the database on SiteB. Heck, if I can't even
get the stupid login form to work, I'm in big trouble.
As a test, a simple query function *does* work. Variables just don't
seem to be getting passed.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263679
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
