Hi,
Does anybody know if the most recent version of DBI works with Oracle
9i on AIX?
Thanks,
Stephanie
---
This message is the property of Time Inc. or its affiliates. It may be
legally privileged and/or confidential and is
Tim Bunce wrote:
In ODBC, a delimited identifier is equal to an undelimited identifiers
if it matches *case-insenitively*.
By "ODBC" I presume you mean windows ODBC using windows database like
Access or MSSQL", because on windows case-insenitivity is the norm.
Yes, correct, I checked against the
On Thu, Feb 20, 2003 at 06:57:37PM +, Tim Bunce wrote:
> Does anyone have a reasonably working implementation of column_info() for mysql?
I guess not, so I've written my own basic one and appended it below for feedback.
Tim.
sub DBD::mysql::db::column_info {
my ($dbh, $catalog, $schema,
If you're using mysql try a 'DESCRIBE TABLE' query first.
If not mysql find a similar command in your database and use that first,
Once you have the name and position of the column names you can do what you want with
them
While associating them to the data in the subsequent select statement q
If it won't be exactly 8 characters every time you need to change it to VARCHAR(8)
That will allow up to 8 characters but doesn't have to be exactly 8.
Dan
>
> Hello all,
>
> I am having a problem with prepared sth that uses
> fetchrow_array with two parameters passed in.
>
> The problem is
What I've done before with mysql is do a 'DESCRIBE TABLE joemama' query and assign the
results to a hash withh the keys being a number starting with 0
0 => ID,
1 => name,
2 => etc,
Then I do my select and just do
@row = fetch_rowarray
print "%column_name{$num} is $row[$num] \n";
Or cre
Does defining $exp_string between single quotes (as opposed to the " you are
using in your example) help ?
---
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
"If at first you don't succeed, skydiving isn't for you"
> -Oorspronkelijk bericht-
On Thu, Feb 20, 2003 at 02:36:04PM -0800, Jeff Zucker wrote:
> Jeff Zucker wrote:
>
> > There is no database independent way to match a delimited identifier
> >to an undelimited identifier.
>
> That part of my previous post is correct, but my examples were bad.
> Here is a better explanation wi
Out of interest, why did you choose to use DBI::Proxy instead of
communicating directly with the SQL server via DBD::Sybase?
--
Simon Oliver