SQL: How to use SELECT results as function input parameters

Question

Here is my query:

SELECT
  CASE
      WHEN hbn.users.showDistance = 'T' 
      THEN hbn.distance(u2.lat, u2.lon, hbn.users.lat, hbn,users,lon)
    ELSE 0
  END as distance,
hbn.users.id,
hbn.users.username,
From hbn.users,
(select hbn.users.lat, hbn.users.lon from hbn.users where hbn.users.id = '1') AS u2
where hbn.users.Id = '8';

This does not work! I need to use output of the second select statement as input for distance() function.

FYI, It looks like you have conflicting where clauses between your main query and your subquery hbn.users.id='1' and hbn.users.id='8'. I don't know if that's causing your problem though — Josh Darnell
– Josh Darnell, Commented Aug 27, 2011 at 20:11
Please explain what doesn't work about this query. Does it not even run? Does it just not give you the results you expect? Also, what results ****DO**** you expect? — Josh Darnell
– Josh Darnell, Commented Aug 27, 2011 at 20:12
Please post what is the error message you're having. In your CASE statement if the 'showDistance' is not equal to 'T', then you'll have the column 0. I'm not sure that's possible. And I also reinforce what jadarnel27 said. — Cassio
– Cassio, Commented Aug 27, 2011 at 20:37

James · Accepted Answer · 2011-08-27 23:52:42Z

1

It looks like you have commas instead of full-stops in the last parameter to hbn.distance?

answered Aug 27, 2011 at 23:52

James

2931 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

James Over a year ago

Also, is the comma after hbn.users.username valid?

Collectives™ on Stack Overflow

SQL: How to use SELECT results as function input parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related