problem reading variable in script

[DWillis]

I'm trying to run the following command:

tmp=$(psql --quiet --tuples-only -U opennms -d opennms -h localhost -p 5432 -c "select nodeid from ifservices where ipaddr = $HOSTNAME limit 1;")

But I keep getting an error when inserting the script variable '$HOSTNAME'. The error I get is the following:

[quote]
ERROR: syntax error at or near ".128" at character 52
[quote]

what is causing this error and what do I need to do in order to correct the problem?

thanks in advance.

[tpl]

$HOSTNAME is not a command; try `echo $HOSTNAME`

[thedondj]

Is the error coming from the database?

Try enclosing the variable in quotes:

tmp=$(psql --quiet --tuples-only -U opennms -d opennms -h localhost -p 5432 -c "select nodeid from ifservices where ipaddr = \"$HOSTNAME\" limit 1;")