Re: Re: bind not working with DBI?

I'm not familiar with the qw(:sql_types) part. I know that I can quote some subroutine name after the module name on the use line to only import that subroutine into the main package, but I didn't see a sql_types subroutine in the documentation for DBI 1.13. What's the colon supposed to do?

I did try specifying the type parameter for the bind_param method. I used the number 12 instead of the descriptive name (VARCHAR2). I got that number after printing out all of the types for this database using the type_info_all database handle method.

I still haven't had any luck.

GM

Comment on Re: Re: bind not working with DBI?

Replies are listed 'Best First'.
Re: Re: Re: bind not working with DBI? by runrig (Abbot) on Jul 30, 2003 at 19:07 UTC
I'm not familiar with the qw(:sql_types) part. ... I didn't see a sql_types subroutine in the documentation for DBI 1.13. It was added in 0.88, so I believe you should have it. It imports sql type constants such as 'SQL_VARCHAR'. You can see what it imports with this (which is straight from the DBI docs): `foreach (@{ $DBI::EXPORT_TAGS{sql_types} }) { printf "%s=%d\n", $_, &{"DBI::$_"}; }` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: Re: bind not working with DBI?
by runrig (Abbot) on Jul 30, 2003 at 19:07 UTC

I'm not familiar with the qw(:sql_types) part. ... I didn't see a sql_types subroutine in the documentation for DBI 1.13.

foreach (@{ $DBI::EXPORT_TAGS{sql_types} }) {
  printf "%s=%d\n", $_, &{"DBI::$_"};
}
[download]

[reply]
[d/l]