I'd try single quotes - maybe you've getting some sort of variable
interpolation?


On 08/09/05, Graham <gandalfmeister / gmail.com> wrote:
> Quick question: I just need another set of eyes on this as I cannot see
> what is wrong:-
> sth = $dbh.prepare("select sal.isid, sal.access_level from
> roles_dev.spig_access_list sal, filer_uncs stdy where
> stdy.foldertype_qualifier=sal.spig_project and
> stdy.foldertype_qualifier=? ")
> 
> when executed generates an error of
> C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:384:in `parse':
> ORA-01003: no statement parsed (DBI::DatabaseError)
>         from C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:253:in
> `initialize'
>         from C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:124:in `new'
>         from C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:124:in
> `prepare'
>         from C:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:624:in `prepare'
>         from U:/Ruby_progs/sync/sync.rb:179
> 
> However - if I comment out this block of code, and skip to the next
> block of code which reads:
> sth = $dbh.prepare("select isid from
> table(ldap.find_by_department(?))")
> 
> ... this works perfectly.
> I cannot see any difference here. Can anyone see anything obvious?
> Thx
> 
> 
> 


-- 
Rasputin :: Jack of All Trades - Master of Nuns