Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- 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]
