I am working on a project where my client is migrating from MS Access to Coldfusion and SQL Server 2005, with AS400 as a transaction db. I have setup a Linked Server in SQL and created a datasource in CF. Since I am not perminent I can't get access to the AS400. What I like to do is pass user authentication from CF to AS400 or Linked Server to AS 400. Is there anyone out there that have seen this before and can help me with this? Also, I am using a query to return a value against a "WorkOrder". Someone else wrote the query except for '%#FORM.workOrder#%'.
SELECT A.ORDNO, A.FITEM FROM AMFLIBQ.MOMAST A INNER JOIN CD_COMDTA.DOMLP100 B ON (A.FITEM = B.LPTM#) WHERE A.ORDNO = M AND '%#FORM.workOrder#%' AND B.LPSTAT = A