Kewl. I tried the join stuff but I was trying to join the commands. Cmd: xxxx:xxxx@ Cmd2: copy line Cmd3: join cmd cmd2 And then pgsql://cmd4:5555......
But it was still outputting the same thing about not knowing what "line" was. I didnt think of using the join inside the sql itself. Thanks. John -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Anton Rolls Sent: Wednesday, June 28, 2006 2:46 PM To: [EMAIL PROTECTED] Subject: [REBOL] Re: subquery in a loop 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=20 ... ] 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. >=20 > 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 =3D3D 'true' and epid in (select epid from > v_ev_cus_snmp_contact where snmp_host =3D3D '10.1.0.20')"] > query line > print query > ] >=20 > 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 =3D3D 'true'... >=20 > So it's using "line" instead of the ip. >=20 > The "print line" printouts the actual IP which is ok. >=20 > Thoughts? >=20 > John --=20 To unsubscribe from the list, just send an email to=20 lists at rebol.com with unsubscribe as the subject. -- To unsubscribe from the list, just send an email to lists at rebol.com with unsubscribe as the subject.
