Try this :
sql: {
select name, epid, active
from v_ev_cus_prof
where
Active = 'true'
and epid in (
select epid
from v_ev_cus_snmp_contact
where snmp_host = '10.1.0.20'
)
}
get-info: func [line][
read rejoin [
pgsql://xxxx:xxxx@
trim/all line
":5555/mcdb?"
sql
]
]
utilip: read/lines %/opt/nms/scripts/ip.txt
foreach line utilip [print get-info line]
;----------- end -----------
The only important modification here, is the addition of 'trim/all
function to clean up your 'line content read from file (may contain
blanks or other unwanted characters).
If you still getting an error in open-proto function, add this line at
the beginning of your script :
trace/net on
Then publish here the output so we can analyze this deeper.
Btw, you really have so much Postgresql servers, each running on port
5555 (not the default pgsql port) ?
Regards,
--
DocKimbel
John Blake wrote:
> Ok,
> I've been hitting my head over this the past 2 days and I've finally
> decided to go to the group.
> I'm reading in a list of ip's from a file and need to sql to each of
> those ip's.
> I have it outputting the ips correctly but I can't get it to connect to
> each one.
> Its not using the "variable" of the ip.
> I'm trying to use a function now.
>
> utilip: read/lines %/opt/nms/scripts/ip.txt
> foreach line utilip [
> print line
> query: func [line] [read join
> pgsql://xxxx:[EMAIL PROTECTED]:5555/mcdb? "select name, epid, active from
> v_ev_cus_prof where Active =3D 'true' and epid in (select epid from
> v_ev_cus_snmp_contact where snmp_host =3D '10.1.0.20')"]
> query line
> print query
> ]
>
> The output is;
> connecting to: line
> ** Access Error: Cannot connect to line
> ** Where: open-proto
> ** Near: read join pgsql://xxxx:[EMAIL PROTECTED]:5555/mcdb? {select name,
> epid,
> active from v_ev_cus_prof where Active =3D 'true'...
>
> So it's using "line" instead of the ip.
>
> The "print line" printouts the actual IP which is ok.
>
> Thoughts?
>
> John
>
--
To unsubscribe from the list, just send an email to
lists at rebol.com with unsubscribe as the subject.
