> > > I found this thread in the archives and was wondering if it was ever > resolved: http://www.mail-archive.com/[EMAIL PROTECTED]/msg17293.html > > I am experiencing the same thing, (I am just using a home > grown tool to execute arbitrary SQL from Vim and output to a > new window). > > I've tried setting RaiseError to 0 before the > $sth->{NUM_OF_FIELDS}, and putting the $sth->{NUM_OF_FIELDS} > in an eval, and both, but it dies no matter what I've tried > with: Describe failed during > DBI::st=HASH(0x1999248)->FETCH(NUM_OF_FIELDS) at ... > > Jeff Urlwin said awhile ago: > > b) DBD::ODBC should probably handle prepare()/execute() on DDL > > statements better -- but I suspect it's the ODBC layer giving the > > trouble here as do() doesn't call the same sequence as > > preare()/execute()/NUM_OF_FIEDS. I guess that most drivers return 0 > > for the NUM_OF_FIELDS in this > case??? > > Actually the two other databases I've tried return '0E0'.
Have you tried using do() instead of prepare/execute? What were the other two databases? Regards, Jeff
