Hello John,
My first thought is not to redefine QUERY, which is an inbuilt
function which may very likely be used by port handler code.
But I see the real reason:
pgsql://xxxx:[EMAIL PROTECTED]:5555/mcdb?
How does rebol know to reduce "line" in this url ?
Answer: it doesn't. :)
Solution:
rejoin [pgsql://xxxx:xxxx@ line ":5555/mcdb?" ...]
or
join pgsql://xxxx:xxxx@ [line ":5555/mcdb?" ...]
(I left out the "select ...")
A further suggestion, if each line reliably contains an ip, then
I suggest calling it 'ip:
ips: read/lines %ip.txt
foreach ip utilip [
print ip
...
]
Yes, you don't really need the function in there at all.
Regards,
Anton.
> 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.
