View Single Post
Old May 25th, 2004, 04:53 AM
Daniel Walker Daniel Walker is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts

quote:Originally posted by sencee
 When u put say 31 in the search. It outputs all the records in the talbe (regardless whether they match the criteria or not) and also displays in the FaultID columm, 31 for every record.
Ah, right. I'm with you. Just select fa.FaultID instead. f.FaultID is going to be 31 in every case, since you actually stipulated that in your WHERE clause :).

Frustrating when it does exactly what you tell it to, instead of exactly what you mean, isn't it?