Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
Here's my code...-------
<cfquery name="Recordset1" datasource="MainInventory">
SELECT *
FROM dbo.tbl_Main
LEFT JOIN dbo.tbl_Order
ON dbo.tbl_Main.Reference_Code = dbo.tbl_Order.Reference_Code
WHERE dbo.tbl_Main.Prep_Date <> '1/1/1900' AND dbo.tbl_Main.Fleet_Delivery_Date IN ('1/1/1900',' ')
ORDER BY dbo.tbl_Main.Stock_Number
ASC
</cfquery><cfquery name="Recordset2" datasource="ElitePlus_Internal">
SELECT * FROM dbo.Vehicle WHERE StockNo = '#Recordset1.Stock_Number#'
</cfquery><cfloop query="Recordset1"> <cfoutput>
<tr>
<td>#Recordset1.Stock_Number#</td>
<td>#Recordset2.VehID#</td>
<td>#Recordset1.GSO_Number#</td>
<td>#Recordset2.Model#</td>
<td>
<cfif #Recordset1.NTG_Delivery_Date# EQ "01/01/1900">
- - - -
<cfelse>
#LSDateFormat(Recordset1.NTG_Delivery_Date,'M/DD/YY')#
</cfif>
</td>
<td>
<cfif #Recordset1.Prep_Date# EQ "01/01/1900">
- - - -
<cfelse>
#LSDateFormat(Recordset1.Prep_Date,'M/DD/YY')#
</cfif>
</td>
<td>
<cfif #Recordset1.Fleet_Delivery_Date# EQ "01/01/1900">
- - - -
<cfelse>
#LSDateFormat(Recordset1.Fleet_Delivery_Date,'M/DD/YY')#
</cfif>
</td> </tr>
</cfoutput>
</cfloop>
I am trying to pull information from two databases via two separate, yet incorporated cfquery.
Yet the output gives me the same repeated field value forRecordset2.Model and Recordset2.VehID
I want those values to change based on which Stock_Number is running in the first query.
I figured it out...
Ran a THIRD query that combined the RESULTS of the first two.
<cfquery name="Recordset1" datasource="DB1">
SELECT *
FROM dbo.tbl_Main
LEFT JOIN dbo.tbl_Order
ON dbo.tbl_Main.Reference_Code = dbo.tbl_Order.Reference_Code
WHERE dbo.tbl_Main.Prep_Date <> #CreateODBCDate("1/1/1900")#
AND (dbo.tbl_Main.Fleet_Delivery_Date = #CreateODBCDate("1/1/1900")# OR dbo.tbl_Main.Fleet_Delivery_Date Is Null)
ORDER BY dbo.tbl_Main.Stock_Number
ASC
</cfquery><cfquery name="Recordset2" datasource="DB2">
SELECT * FROM dbo.Vehicle
</cfquery><CFQUERY NAME="combined" DBTYPE="query">
SELECT *
FROM Recordset1, Recordset2
WHERE Recordset2.StockNo = Recordset1.Stock_Number
</CFQUERY>Thanks!
0 
 |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
