I tried to pulling ID from SQL, then from Access and then QoQ, But the problem is Sql return me only one ID but Access will return all the id has (30000 records) and then perform QoQ which takes all the time in world and thus will hang up the server...
So I changed my Query like the following:
<cfquery datasource="MasterSQL" username="***" password="***" name="SQLQRY">
Select Employee.Emp_Name, Salary.Emp_ID
From Employee inner join Salary on (Employee.Emp_ID = Salary.Emp_ID) AND (Employee.SectionName = Salary.SectionName)
Where Emp_Name like <cfqueryparam value="%#arguments.search#%" cfsqltype="Sql_VarChar"
<cfquery datasource="MasterDB" name="AccessQRY">
WHERE Emp_Pro.Emp_ID like '%#Right(SQLQuery.FormNumber,4)#%'
<cfquery datasource="MasterDB" name="AccessQRY2">
From Emp_Info inner join Emp_Pro on (Emp_Info.Emp_ID = Emp_Pro.Emp_ID) AND (Emp_Info.Con = Emp_Pro.Con)
WHERE Emp_Info.Emp_ID IN
Now the issue is the firts query will return an ID but access is always hung up on the very first ID it get, so if the i get the new ID from SQL, access shows me records from the previous Id.
Please let me know if something is wrong with what I'm trying to do...
I really appreciate your help...