[ruby-oci8-devel] rowid?

Amos a.goo0h at gmail.com
Wed Jan 16 15:10:42 EST 2008


It's gross, but this will work for now....

cur.exec
while r = cur.fetch()
  p r
  rowid = r[0].inspect().sub(/#<OCIRowid:/,'').sub(/>/,'')
  puts rowid
end
cur.close



On Jan 15, 2008 2:04 PM, Amos <a.goo0h at gmail.com> wrote:

> Well, I notice that when I use the latest code in Subversion, I can
> specify the column "rowid" with the "select" SQL command. That's more than I
> was getting before. The results now looks like:
>
> [#<OCIRowid:AAAOfjAAJAAAQFMAAE>, ..., ..., ...]
>
> However, still not sure how to pull out that value to something I can
> use....
>
>
>
> On Jan 15, 2008 10:23 AM, Amos < a.goo0h at gmail.com> wrote:
>
> > Since the original thread back in Sep 07 didn't appear to have ever been
> > answered, I thought I'd post my query here too.
> >
> >
> > http://groups.google.com/group/comp.lang.ruby/browse_frm/thread/72ff2e12eafe116a/6939895cda0a6bc6
> >
> > I'm not especially eager to convert my stuff over to Java. ;-)
> >
> > Amos
> >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://rubyforge.org/pipermail/ruby-oci8-devel/attachments/20080116/ea38600e/attachment.html 


More information about the ruby-oci8-devel mailing list