> The obvious thing is to make sure you can access the cobol server
> from
> the cfmx server. Log into the cfmx server with the credentials cfmx
> runs
> under then see if you can navigate to the cobol server.
Thanks for the idea, but this isn't the problem as every other page on
the site (100+) work.
It seems the problem is related to string formatting. Here's my query:
SELECT DSMAFLG1, DSMAFLG2, DSMACOU
FROM DSMAFIL
WHERE
DSMADST_RCN = <cfqueryparam value="#Attributes.RCN#"
cfsqltype="cf_sql_varchar" maxlength="11" />
AND DSMADST_RCN IN ( <!--- only allow specific users in! --->
<cfqueryparam value="50" cfsqltype="cf_sql_varchar" maxlength="11"
/>,
<cfqueryparam value="1766001" cfsqltype="cf_sql_varchar"
maxlength="11" />,
<cfqueryparam value="1767101" cfsqltype="cf_sql_varchar"
maxlength="11" />
)
AND DSMACOU IN (
<cfqueryparam value="USA" cfsqltype="cf_sql_varchar" maxlength="3"
/>,
<cfqueryparam value="CAN" cfsqltype="cf_sql_varchar" maxlength="3" />
If I comment out the WHERE DSMACOU part it works fine. I then changed
that part to:
AND DSMACOU IN ( 'USA', 'CAN' )
and it still fails.
I'm going to play with it some more to see if I can work out the exact
problem, and this time I'll do it within Access so as not to kill the
web server ;-)
I'll let you know what I find.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
