Cold Fusion and embedded SQL

[programmher]

This one has me stumped!

I have three queries. They are almost identical except the only difference is the fields that are output.

One query outputs the hardware for the querying user (based on the user's stored session variable.

The other query outputs the querying user's software.

The last query outputs the querying user's equipment.

My problem is that 2 of the queries return results. One does not return any records. I thought I might have mis-keyed a field name; but, when I cut and past the SQL into SQL Server's query analyzer, it successfully runs and returns the correct result.

WHAT COULD I BE MISSING?!?!?

 

[tleish]

What does the code look like?
- tleish

 

[programmher]

tleish,

Thanks for the offer; but, the original developer has decided to use a stored procedure rather than embedded SQL.