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>
--------------------------
> Post the code ;-)
>
> Bryan Stevenson B.Comm.
> ----- Original Message -----
> From: Christina Robson
> To: CF-Talk
> Sent: Thursday, February 05, 2004 10:38 AM
> Subject: Different query results in Access/ColdFusion
>
> Hi there,
>
> I'm about to pull my hair out over this problem, so I'm really hoping
> someone can shed some light on the situation.
>
> I have a query (written in SQL) in my CF code that connects to an
> Access database. The user enters a street name, and the SQL query
> pulls out all the addresses containing that street name.
>
> Sounds simple enough, right?
>
> When I copy the SQL into the Access query designer, it gives me the
> correct results - it finds all the addresses with that street name.
> But when I embed that exact same SQL statement into my CF page, it
> doesn't give me the right results.
>
> And here's the kicker - depending on what field I sort on, I get a
> different number of results!!! And the number varies depending on
> which street name I'm searching for! For a certain street name, I
> might get all the results when I search by Date, but only a few when I
> search by something else. But that could be different for other stret
> names.
>
> It's really the weirdest thing, and I have NO IDEA how to go about
> fixing the problem.
>
> Anybody have any ideas??
>
> Thanks!
> Christina
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
