Denis,
When you did the 'perl Makefile.PL', did it find Oracle and everything
correctly ?
Is there any particular reason you're using 'Makefile.aperl', rather than
simply 'make' ?
Which version of DBI are you using ?
Tim
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
A simple solution is:
Select column_name from my_table where column_name like 'jose'
or you can replace the accented e with the while card % ie 'jos%'
Cheers
Julio Santiago
From: webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Accented Characters.
Date: Thu, 24 May 2001 18:30:59
In typical Perl fashion (for me, anyway), I have no idea what the problem
was, but I got my script to work by using
foreach tablespace {
get list of datafiles
begin backup mode
call separate script to do fancy file copying with forks and children
end backup mode}
rather than putting all the
I was curious about IPC::Shareable, so I read the README and
found this (HTH):
3. Array operations on references
Generally, when a reference is assigned to a shared variable, the
referenced data is also supposed to be shared. However, this
currently is not the case for references
Oops, I see you already know you shouldn't 'push()' references
to a Shareable object. Instead of 'push' it should be something
like '$results[$i++] = ... '. Also are you sure you want to
store the results of ALL the queries in the same array?
-Original Message-
From: Mr. Sunray
If i use SELECT name FROM table WHERE name LIKE jos%
i'll receive jose, josé, josefa, joselene where i only need josé and jose.
There is in the MSSQL Server an option: Accent-Insensitive.
Do you think there is something written that could help me ?
Thanks.
Vivian.
- Original Message
webmaster writes:
If i use SELECT name FROM table WHERE name LIKE jos%
Use: like joe[_]
i'll receive jose, josé, josefa, joselene where i only need josé and jose.
There is in the MSSQL Server an option: Accent-Insensitive.
This is probably your best bet. DBI doesn't handle this
webmaster wrote:
If i use SELECT name FROM table WHERE name LIKE jos%
i'll receive jose, josé, josefa, joselene where i only need josé and jose.
Try the _ wildcard instead:
SELECT name FROM table WHERE name LIKE jos_
The _ matches only one character, not a sequence of characters like %
(Just an Idea ) You could try soundex encoding - if that works with
accented chars.
--MarkT
webmaster wrote:
If i use SELECT name FROM table WHERE name LIKE jos%
i'll receive jose, josé, josefa, joselene where i only need josé and jose.
There is in the MSSQL Server an option:
Hi, Michael, thanks for your help.
Below is the code i am using:
use DBI;
my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=DB3.mdb';
my $dbh = DBI-connect(dbi:ODBC:$DSN, '', '', {RaiseError =1})
or die Couldn't connect!;
$sql = SELECT * from tudo_ba where figura1 like '%josé%';
my
Oops, I see you already know you shouldn't 'push()' references
to a Shareable object. Instead of 'push' it should be something
like '$results[$i++] = ... '. Also are you sure you want to
store the results of ALL the queries in the same array?
Ok - tried making that change. Also put back
Actually, with Oracle I've found many times that dropping
the LIKE entirely and using Perl's regexp's to filter is much
much faster. So I'd second that.
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell:
Indeed, you are passing references ..Shouldn't your dereference when you push
onto @results like this:
$sth=$dbh-prepare($query);
$sth-execute();
while(my $hash_ref=$sth-fetchrow_hashref()){
push(@results,%$hash_ref);
}
Thus making an array of hashes instead of an array of hash_references?
Actually you'd also need to dereference the array of hashes all the way down to
a scalarsince the only way to pass hard data to another process is in a
scalar format since everything else uses a memory reference of some sort.
On 25 May 2001 12:01:39 CDT, STAFF said:
Indeed, you are
push(@results,%$hash_ref);
I do not think this does what you think it does.
It will push an array of values (key1, value1, key2, value2, ...)
onto the @results array.
And I don't think pushing onto the @results array was the problem,
it was just the allRecords array you needed to worry about.
I suppose another simple solution is:
Select column_name from my_table where column_name = 'jose' or column_name =
'jose'
though I think I'd recommend storing a separate column of accent-stripped
names in your table if you don't have full control over your search
parameter.
Somebody correct me
Has anyone built the DBI with DBD::ODBC on Mac OS X yet? If so would you be
willing to offer a little help on the compile? I'm doing the ODBC portion
right now and it wants the driver directory (I've installed Openlink's
drivers for OS X). Any help would be appreciated
Sorry for the lengthy email, but I wanted to include
relevant messages. Here's the scoop. The system
in question is a FreeBSD 4.1-RELEASE OS, with
perl5.00503 and MySQL 3.22.32. I'm attempting
to install DBD-mysql-2.0900.
I've also just previously installed DBI-1.15 w/o
any detectable
Downgrade to DBI 1.14, since this is a know bug.
Ilya Sterin
-Original Message-
From: Richard M Wesley
To: [EMAIL PROTECTED]
Sent: 05/25/2001 3:56 AM
Subject: DBD-Oracle 1_06 test error
-- Forwarded by Richard M Wesley/UK/CSC on
25/05/2001
10:55
Hey all,
Using a CGI script, I want to access a database from A DIFFERENT server than the mysql
database is
hosted. What is the proper syntax to access the mysql database on a different server?
They're 2 levels of secruity:
1. Log into Telnet shell
2. Log into database
This is what I have
Read 'perldoc DBD::Mysql' for different connect methods. Here is an exert
from the docs...
$dsn = DBI:$driver:database=$database;host=$hostname;port=$port;
$dbh = DBI-connect($dsn, $user, $password);
Ilya Sterin
-Original Message-
From: Simon Chan [mailto:[EMAIL PROTECTED]]
Sent:
21 matches
Mail list logo