Jevo
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 11:39 AM
To: CF-Talk
Subject: Re: Different query results in Access/ColdFusion
Post the code ;-)
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]
