<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)
ORDER BY CivicAddressNumber asc
</cfquery>
If this give you different results in cf v Access, your
application.dns_name2 is set to the wrong DSN
Otherwise, your problem is in your form variables. Try outputting them to
see what they actually look like. Perhaps they are encoded.
HTH
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
