Re:Different query results in Access/ColdFusion

[Christina Robson]

Good idea, Bryan. :)  Ok, here's my SQL statement!  This gives me different results depending on what I sort on.  I've yet to find a way to ensure it always gives me the right results, regardless of how I sort it. Argh. :)

Thanks!
Christina

<cfquery name="getpropinfo" datasource="#application.dns_name2#" dbtype="ODBC">

SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
WHERE CivicAddressStreet LIKE '%#Form.civicaddress#%'  
AND Municipality = '#Form.municipality#'
AND DocType = 'CONVEYANCE'
ORDER BY CivicAddressNumber asc

</cfquery>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---