Login or Register to Ask a Question and Join Our Community


Web Development

How to: IFNULL(SELECT ...,0)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development How to: IFNULL(SELECT ...,0)
# 1  
Old 10-22-2010
How to: IFNULL(SELECT ...,0)
Hi all,

Wondering is this possible:

SELECT id AS cid, name, phone, url, streettype, IFNULL((SELECT ROUND(AVG(stars)*2, 1) / 2 FROM " . $dbconf{'prefix'} . "reviews WHERE location=cid) AS avgstars,0), ...

OR should it be:

SELECT id AS cid, name, phone, url, streettype, (SELECT ROUND(AVG(stars)*2, 1) / 2 FROM " . $dbconf{'prefix'} . "reviews WHERE location=cid) AS IFNULL(avgstars,0), ...

I am fairly sure you can see what I am trying to achieve here.

In other words, two tables, one with id's and another that relates those ID's to star ratings.
I want to extract the AVG(stars) rating AS avgstars to operate on it later, but, if there is no results for the query: ie. no row exists with the "location" specified, can I make the return "avgstars" equal zero rather than simply NULL.

Thanks,
Aaron.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Select command

Hi I'm using the "select" command in the global_env.sh to log in to the application directory. This file is called in .bashrc profile. Sample code: Filename: global_env.sh set -o vi export severname=$(uname -n) printf '%s\n%30s\n%s\n' "***********************" "Welcome to $severname"... (6 Replies)
Discussion started by: cheers799
6 Replies

2. Programming

Socket and select

I have created two sockets and binded both. My requirement is that 2nd socket must send/ recv data only on expiration of timeval(tv). but the 1st socket must keep on send/recv the data without waiting for the 2nd socket completion...... I have posted my code below...... In this code the 2nd... (3 Replies)
Discussion started by: naresh046
3 Replies

3. Boot Loaders

Reboot and Select Proper Boot device or insert Boot media in select Boot device and press a key

Hello, I have kubuntu on my laptop and now I decided to switch to Windows 7. I made the bios settings properly (first choice is boot from cd\vd) but I see the error " reboot and select proper Boot device or insert Boot media in select Boot device and press a key " I have tried CD and... (0 Replies)
Discussion started by: rpf
0 Replies

4. Programming

Problems with select

Is select only supposed to report state changes on an FD's, state, whether or not it had pending input available in the first place? I've got a situation where select() repeatedly reports no FD's ready for stdin when there's lots of data available. And if it only reports changes, how is this... (2 Replies)
Discussion started by: Corona688
2 Replies

5. Shell Programming and Scripting

Select everything before a pattern

Hi I have i doubt, actually i have to select everything before a word(pattern).For that i am using sed i am using the below line of code but it is not working i am getting a blank instead.. sed -n '/regexp/{g;1!p;};h' file1 Can anyone help? Thanks (15 Replies)
Discussion started by: usha rao
15 Replies

6. Shell Programming and Scripting

select a column

I've a file like this: andrea andre@lol.com october antonio@lol.com marco 45247@pop.com kk@pop.com may pollo@lol.com mary mary@lol.com can I select only the column with email adress? can I utilise a filter with @ ? I want obtain this: ... (2 Replies)
Discussion started by: alfreale
2 Replies

7. UNIX for Advanced & Expert Users

Doubt regarding Select()

Please provide the solution for the following scenario: 1) There are two process named as ProcessA and ProcessB 2) ProcessA has opend a named pipe in read mode.This has been made as blocking mode. 3) ProcessB opens this pipe and writes in Blocking mode.So wat happens is even if Process A goes... (2 Replies)
Discussion started by: sunil_ktg
2 Replies

8. Shell Programming and Scripting

How to select Shell

We are using the line #!/usr/bin/ksh in the script, to run the script in ksh. If I have Bash shell and Ksh, how to select the shell to run the script during runtime? Thanks in advace Victor (2 Replies)
Discussion started by: mvictorvijayan
2 Replies

9. IP Networking

select vs poll

Hi, Off late I had been looking at the differences b/w select() & poll() system calls. The requirement is to reduce the overhead, processor power in waiting for the data. In the kind of connections under consideration there would be very frequent data arriving on the sockets, so poll() fares... (12 Replies)
Discussion started by: smanu
12 Replies

10. UNIX for Dummies Questions & Answers

Select ALL in VI Editor

Hi all, How can i select all and copy text in VI Editor. Rakesh Gupta (22 Replies)
Discussion started by: rakish
22 Replies
Login or Register to Ask a Question

LEARN ABOUT HPUX

cmpt_get_peer_cid

cmpt_get_peer_cid(3)					     Library Functions Manual					      cmpt_get_peer_cid(3)

NAME

       cmpt_get_peer_cid(), cmpt_get_endpoint_cid() - get the compartment IDs for INET domain communications.

SYNOPSIS


   Parameters
	      s      INET domain socket or stream.

DESCRIPTION

       The and functions return the compartments associated with an INET domain transport endpoint (a socket or a stream).

       The  function  returns  the  compartment  ID (cid) associated with the transport endpoint s.  The cid of a transport endpoint is set to the
       process's cid at the time of creation, and does not change even when it is transferred between processes or the	creating  process  changes
       its compartment.

       The  function returns the compartment ID of the peer that the transport endpoint s is communicating with.  For loopback communications, the
       cid is the one associated with the peer transport endpoint.  For communications over a network interface, the peer cid is the  one  associ-
       ated with the network interface where communications are being received.  For TCP communications, the peer cid is persistent once a connec-
       tion is established.  For other protocols, the peer cid may change for each packet that is received.

       The function returns an error if a connection is not established (for TCP) or no communication has been received (for all other protocols).

RETURN VALUE

       and return the following values:

	      Successful completion.
		      The function returns a valid compartment ID.

	      Function failed.
		      is set to indicate the error from the underlying system call.

ERRORS

       See ioctl(2) for errors indicated by

DEPENDENCIES

       These functions are a part of the library.

SEE ALSO

       compartments(4), compartments(5).

															      cmpt_get_peer_cid(3)