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]
