are encoded in
UTF8...
In the dump :
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `bar` ( [...] ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
Thanks in advance for any hint,
Alex
SMP Mon
Oct 16 14:54:20 EDT 2006 i686 i686 i386 GNU/Linux
Anyone has seen that before? What should I do to solve this?
Alex
Legal Disclaimer:
The information contained in this message may be privileged and confidential.
It is intended to be read only by the individual or entity to whom
Hello.
I create a table:
CREATE TABLE groups (
group_id serial PRIMARY KEY,
name varchar(64) UNIQUE NOT NULL,
guests integer[] DEFAULT '{}'
)
I add a new record to the table:
INSERT INTO groups (name) VALUES ('My friends');
Now the table contains 1 record:
| group_id |name|
completely wrong, and there isn't such a thing?
Scott Mohnkern
You're looking for SQLite:
http://www.sqlite.org/
and
http://search.cpan.org/~msergeant/DBD-SQLite-1.13/lib/DBD/SQLite.pm
Alex
have you looked into sqlldr
Robert Hicks [EMAIL PROTECTED] wrote: Garrett, Philip (MAN-Corporate) wrote:
Robert Hicks wrote:
Does anyone have such a beast for Oracle? I am trying to eliminate the
Perl/DBD::Oracle side of the equation for some problems in our app. I
did a looping select
.
Personally, just for speed alone I would only do this as a last resort. If
your DB can be migrated to SQLite you may have a much easier time of things
since SQLite runs on most platforms and is bundled in the DBD.
Alex
On Mon, 11 Jun 2007 09:34:38 -0400, Jordan Mueller wrote
Hello,
I have
Here are the results from Brian's script:
[root]/home/alex/DBI_testing# perl perl_dbi_nulls_test.pl
Using connect arguments, db version: 3.3.16
= Drop table 'dbi__null_test_tmp', if it already exists...
= Create table 'dbi__null_test_tmp'...
= Insert 4 rows into the table...
Inserting values
Hello,
Have somebody been lucky to utilize stored procedures that returns
multiple result sets? I was trying to it exactly as in the example and
it just returns 1 row... The sample code itself returns just 1 row.
ps. mysql_mutli_results=1 is specified in connection string.
Patrick Galbraith
Hello,
Have somebody been lucky to utilize stored procedures that returns
multiple result sets? I was trying to it exactly as in the example and
it just returns 1 row... The sample code itself returns just 1 row.
ps. mysql_mutli_results=1 is specified in connection string.
Patrick Galbraith
.
Alex
Tim.
On Fri, Aug 12, 2005 at 03:25:28PM -0400, Alex Deucher wrote:
I'm having problems using Class::DBI to access my database. I have a
postgres database with several tables and I've implemented Class::DBI
abstractions for each table. the problem is one of my tables does not
seem
at
/usr/lib/perl5/site_perl/5.8.5/Class/DBI.pm line 852.
I can't figure out what is going on. I have no problems accessing the
table via DBI directly. Any ideas?
Thanks,
Alex
message...
Regards,
Alex
___ALL-NEW Yahoo! Messenger -
so many all-new ways to express yourself http://uk.messenger.yahoo.com
for skipped ones...
If someone thinks I lack some optimization you are
welcome to comment.
Regards,
Alex
___ALL-NEW Yahoo! Messenger -
so many all-new ways to express yourself http
option mtune -pentiumpro
Of course I can delete lines in Makefile that carry
this option but it is said: don't edit this file...
And more: Makefile contains both perl 5.8.4 and 5.8.1
paths maybe I get rid of the old one?
Regards,
Alex
.
Cheers,
Alex
that was passed in.
Cheers,
Alex
: dbd_describe/SQLNumResultCols err=-1)
which sounds like an error from MSSQL saying it couldn't alter the table
(because the column was already added once and it's trying to do it
again). Perhaps I'm wrong though and this error is caught on prepare
instead of execute?
Cheers,
Alex
). This is with perl 5.6.1
(build 633), DBI 1.34 and DBD::ODBC 1.04.
Any ideas on workarounds?
Cheers,
Alex
; $dbh-disconnect;
errors out with:
Thanks for the email, but no difference. I was under the impression that
finish wasn't needed in the above case, and all cleanup would happen at
destruction.
Cheers,
Alex
I find a common operation is to execute a statement that you expect to return
at most one row and then fetch that row. I've found it convenient to combine
these two calls into one:
$res = $sth-executerow_foo(@bind);
equivalent to:
$sth-execute(@bind);
$res = $sth-fetchrow_foo();
make sure DBI is installed. use activeperl's ppm to do it for you
On Tue, 12 Sep 2000, Farhan wrote:
Can any one help me out from the error below.. i've been trying to use DBI module on
win 2000 with activeperl 5.6.4 and perl 5.8 and apache 2.0.. i dont know where i
went wrong.. do i have
hi
is there any way to do the same with ODBC?
out of CGI::Session::MySQL.pm...
my $lck_status = $dbh-selectrow_array(qq|SELECT GET_LOCK($sid, 10)|);
return $dbh-selectrow_array(qq|SELECT RELEASE_LOCK($sid)|);
Alex
Look into the dbi::proxy I think that is what you need
On Tue, 22 Jul 2003, stan wrote:
I need to be able to get some data out of a microsoft Access fatabase
intot a perl script that will run on a FreeBSD machine.
Can I do this using DBD::ODBC? If so what does the syntax of teh
try this ...
$commnd_string = qq!this is the .sql in a file!;
-Original Message-
From: steve hatfield [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Saturday, June 28, 2003 9:57 AM
Subject: General Perl Question
Hi everyone,
I am working in a Unix db2 environment and
-fetchrow_array;
$sth8-finish();
foreach (@ref8) {
my $var0=$ref8-[0];
my $var1=$ref8-[1];
my $var2=$ref8-[2];
my $sth9 = $dbh-prepare(UPDATE $dbtable2 SET TEST1=?,TEST2=? WHERE
TEST3=?);
my $rv9=$sth9-execute($var0,$var1,$var3);
$sth9-finish(); # not needed
}
}
Alex
- execute( @$row_array );
i will test this.
Alex
} ) {
my $var0 = $res8Item-[0];
.
my $rv9=$sth9-execute($var0,$var1,$var3);
}
$sth9-finish();
Alex
don't know whats wrong. if you have a working example i
will be happy :-)
Greetings
Alex
[DF_Test1_ProvLevel2] DEFAULT (0.) FOR [ProvLevel2],
CONSTRAINT [DF_Test1_Action] DEFAULT (0) FOR [Action]
GO
Alex
to change the n to 1 - but the SQL_VARCHAR will not go
away.
Alex
have moved to DBD-ODBC v1.04 today and DBI v1.34 - but the problem is
still here.
Alex
begin 666 money_test.cgi
M(R%C.B]PF]GF%M;64O5R;]B:6XO5R;YE[EMAIL PROTECTED]-@T*=7-E('-T
MFEC=#L)0D)(R!A8W1I=F%T92!F;W(@')O9W)A;6UI;FO95B=6=G:6YG
M(]N;'D-G5S92!W87)N:6YGSL)0D)(R!A8W1I=F%T92!F;W(@')O9W)A
M;6UI
ok - i have tested with mssql from remote - and the error is there.
Alex
,?),
Provlevel2=CONVERT(money,?)
WHERE Test1=?
);
my $rv9=$sth9-execute($level1,$level2,$name); # line 221
$sth9-finish();
}
$sth8-finish();
Alex
are you using Ms IIS (perlis.dll) ?
Alex
!?
Alex
use DBD-ODBC driver
Alex
/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.
What am I missing?
Thanks,
Alex
not
use ISNULL function...
Alex
SELECT * FROM table WHERE field IS NULL
thats not the problem... :-). one example - i hope this makes it clearer
what i mean...
SELECT ISNULL(ID,'') AS ID FROM $dbtableWith(nolock) WHERE
SUBSTRING(ID,7,6)=LEFT(?,6)
Alex
in future.
Alex
to program platform
independend.
Alex
a count of the selected/found rows (for e.g. i select users and
like to display how many users i have collected with this statement)
Alex
(my @row = $sth-fetchrow_array()) {
$i++;
}
very difficult in my code... i will have a look if i can change the code.
isn't it possible without a while ?
Alex
post a code fragment?
here is the old code... based ob a file
my @data=split(/\r?\n/,$part[2]);
if ($data[2] ne '') {
my @datas=split(';',$data[2]);
print Counted Items ;print $#datas+1;print ItemsBR\n;
print Inside: ;foreach (sort @datas) {print Item: $_ ;} print BR\n;
}
Alex
$html .= Item: $row ;
oh *g* - thats the idea :-) - a point for appending the $html string... i
will change this... sometimes if you look too long on a code you get
blockhead... :-)
thx
Alex
thx for your explaination :-)
Alex
a disconnect befor die'ing yet... is this bad? is there
something special to mod_perl, Apache Perl or PerlIS?
Alex
Same script with Apache 1.3.27, DBD-ODBC 1.03, DBI 1.32 and Perl 5.8.804
works without any problems! sounds like a PerlIS Bug...
Alex
Why not try DBD-ODBC 1.02 for 5.8? It is on the TheoryX site.
will not help
Alex
Why not try DBD-ODBC 1.02 for 5.8? It is on the TheoryX site.
a good tip... i haven't seen this yet... but tryed out in the last 5
minutes... DBI 1.32 and DBD-ODBC 1.03 will nox fix the problem too.
Alex
needed for MsSQL or bedder ODBC...
Alex
.
Alex
is it a good idea doing a count()? i need to test if a user is in the system
or not... if i count i get a row with 0 or 1... count is fast... but what is
the fastest way? speed is one of the highest prioritys for this script...
Alex
to
understand why the following will not work with a select.
my $rv4 = $sth4-execute('$ip','$http_user_agent');
if ($rv4 eq '0E0') {
Alex
my $rv4 = $sth4-execute('$ip','$http_user_agent');
if ($rv4 eq '0E0') {
a... removing the ' around the vars will fix it :-(. my fault... but the
' are needed on inserts... strange thing...
Alex
sorry Jeff... i found today this is my fault. i have done a type missmatch
on the dbtable var... after correcting this it works now and gives correct
results... i havent't tested with MyODBC 2.5... only with beta 3.51
Alex
Also note that some objects have stringifying methods which allow you
to use or qq() to convert the objects into a useful string. None
of that applies to normal DBI placeholders though.
Alex:
I hope you aren't depending on $rv4 to tell you whether a select
found any rows. The return
script with a Stresstester and it will run fine with
ActiveState Perl 5.6.1 and DBD-ODBC 1.02. This is a Win2k Server SP3 Box.
Alex
hi
i'd like to upgrade the DBD-ODBC driver but i get a force unlink of odbc.dll
failed. i have often seen this problem. it looks like PerlIS is caching the
DBI driver... i don't know how to unload the dll in production... any
idea???
This is Win2k, ActivePerl 5.6.1 633, DBD-ODBC 0.43
Alex
The obvious sanity test is that the $dbtable var is unset for some reason.
Perhaps a check of $dbtable value prior to the prepare would suffice?
no - the var is set... this isn't the fault.
try to set:
my $dbtable='test_db';
Alex
there is a Perl 5.8 compile bug with the driver version 1.00. use version
1.01!
Alex
' Stop.
Alex
:\Inetpub\test\test.cgi line 39.
my $sth = $dbh-prepare(SELECT COUNT(TEST) FROM $dbtable WHERE (TEST=?));
my $rv = $sth-execute($var1); # this is line 39
This select will fully work for e.g. with MySQL-Front 2.5 without any
problems...
Alex
/cgi-bin/showsess.cgi line 9.
I would know how i do to access catalog views with DBI.
Regards
Alex Marino
program to this e-mail to have a look at.
Kind Regards,
Alex
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 10:25 PM
To: Alex Cerantonio; [EMAIL PROTECTED]
Cc: Darren Edgerton; [EMAIL PROTECTED]
Subject: RE: Problems with using DBD-ODBC
Database: Redbrick v6.11
Server: AIX 4.3.3.0
If you require any additional information not in the attached files please
don't hesitate to ask.
Your assistance with our problem will be greatly appreciated.
Kind Regards,
Alex Cerantonio
output.zip
Description: Zip compressed data
Try delimiting each element of the in clause, i.e. ...in ('a','b')
-Original Message-
From: Agarwal, Ramakant [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 9:25 AM
To: '[EMAIL PROTECTED]'
Subject: RE: doubt
Hi,
I did not get any answer to my first question and asking
DBD::Pg currently does a 'begin' immediately after a 'commit' or
'rollback'. Unfortunately this can cause some minor problems for
PostgreSQL. It used to cause PostgreSQL 7.1 spits out lots of 'NOTICE:
InvalidateSharedInvalid: cache state reset' messages (in 7.2 this is just
a DEBUG message and
That's not the case for current things invocable via func() interface for
DBD::Pg driver...
-alex
On Thu, 13 Jun 2002, Tim Bunce wrote:
Don't forget that all driver-private attribute and functions should
start with the driver prefix. So backend_pid should be called pg_backend_pid
Tim
This is perl, v5.6.1 built for sun4-solaris
Thanks
- Alex
Is there anyway to build DBD so that it can be used with either various
version of Oralce 8 and Oracle 9i.
Thanks
AG
Message -
From: Gaul, Ken [EMAIL PROTECTED]
To: 'Alex Green' [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 10:31 AM
Subject: RE: DBD and Oracle 8 and 9i
If you build against 8i it should be able to access a 9i instance. Have
you
tried it?
Ken.
-Original Message-
From: Alex Green
are the same across all the
versions... but with oracle 9 the 8's in the library names were changed to
9's kinda obvious that one :).
- Original Message -
From: Gaul, Ken [EMAIL PROTECTED]
To: 'Alex Green' [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 12:03 PM
Subject: RE: DBD
Does anyone have a link of info on how to build DBD on HPUX 11i...
Thanks
That's correct behavior for postgresql. See the documentation for
explanation.
-alex
On Wed, 20 Mar 2002, Doug Silver wrote:
Hi All -
I'm just trying to confirm the perl DBI transaction/rollback feature,
which works as expected except for one thing, one field that is SERIAL
keeps
Hello Tim! My name is Alex and I'm from Russia.
I have some problems with DBD-Oracle-1.12 installation.
When I'm trying to install this module on Linux
Mandrake 7.1 I recive a message like this:
The ORACLE_HOME environment variable value
(/home/oracle/OraHome1) is not valid.
It must be set
Thank you a lot!!! But...
Where can I find the Oracle client and how to install
it on Linux Mandrake 7.1?
ãÉÔÉÒÕÀ Sterin, Ilya [EMAIL PROTECTED]:
Well, is your ORACLE_HOME set? You must have the
Oracle client
installed in order to compile.
Ilya
-Original Message-
From: Alex
=server_name;serv=service_name;pro=olsoctsp;database
=database_name;uid=id;pwd=password;';
#
# protocol name above is olsoctcp, other protocols will work as long as
supported by network
#
$dbh = DBI-connect(dbi:ODBC:$dsn, { RaiseError = 1, AutoCommit = 1});
DSN...Leave home without it!
Alex Mitsuda
utilities to connect to Informix. On a DBI connect I'm
getting a Informix ODBC Driver error : Unable to load translation DLL.
I'm sure it's probably some environment setting. If someone could just point
me in the right direction...thanks
Alex Mitsuda @ NEUBERGER BERMAN
* [EMAIL PROTECTED] * 646
Hi all,
I am having a problem installing the above module (Version 0.32). I have
succeeded in the past with a statically linked version but cannot get the
dynamic one going.
The driver I'm using is Redbrick (a data warehouse now provided by Informix
(IBM)). The only tweak that I have made is a
);
Using placeholders is a common practice. It makes code more readable and
helps you avoid errors.
For more information on using placeholders, read perldoc DBI.
Regards,
Alex.
Woops. Bad math on my side, you look correct. I'll submit it to Ed Mergl
later on.
(I'm to blame for this piece of code).
-alex
On Tue, 25 Dec 2001, KAWAI,Takanori wrote:
I've found that DBD::Pg not works with binary data.
It occurs Unterminated quoted string with long invisible-character
Need to be a bit careful though, if there are simultaneous inserts going
on @@identity is not guaranteed to give back the correct key...besides a
numeric primary key, it's always good practice to have an alternate primary
key with which you can check against...
-Original Message-
From:
Using DBI, you must be careful how you fetch the data.
There are methods for fetching entire result set as an array of arrays or
array of hashes, but doing row-by-row fetching as a reference of an array
is fastest. That was most likely the reason for disparity.
-alex
On Tue, 13 Nov 2001
You can do this using DBD::Sybase Library and DBI as long as the SQLServer7
has most uptodate patch, without having to use Merant/ODBC solution. Though
I'm not sure how the DBD::Sybase install will go without actually having
Sybase on the box...
-Original Message-
From: Meng Yoke
' performance is to put each statement in its
own transaction (default, AutoCommit=1).
If you post your source code, I might be able to help you out.
-alex
On Mon, 12 Nov 2001, Michael Wray wrote:
Thanks for the suggestions, but here's my 2 cents on DBI/DBD::Pg:.
I would LOVE to use DBD::Pg...I
Why are you using func()?
You should be using dbd-table_attributes(tablename)
But actually, yes, DEFAULT is not being set by DBD::Pg.
If you want to fix it, please edit table_attributes function in Pg.pm in
DBD::Pg source.
-alex
On 9 Nov 2001, Brad Hilton wrote:
Hello,
I am new to using
First thing that comes to mind:
a) do you have an index on tqosinsp_rwd?
b) did you vacuum the table in question?
6000 transactions per hour seems awfully slow.
It would also help if you provide structure of the tables. Version of
postgres, too. If there are awfully large rows, performance will
To: 'Mitsuda, Alex '; '[EMAIL PROTECTED] '
Subject: RE: = NULL vs. IS NULL
Then explain assigning NULL to values in the update query and not being able
to query based on NULL as for foo=NULL, but set foo=NULL is legal.
Ilya
-Original Message-
From: Mitsuda, Alex
To: [EMAIL PROTECTED]
Sent: 10/23
change their implementation of '=null' even between versions.
-alex
On Tue, 23 Oct 2001, Sterin, Ilya wrote:
So if NULL is not defined, what's the difference between is NULL and
=NULL. I guess my disagreement comes from not being able to ask for
undefined field by =undefined, but rather
Yes, and it rocks my socks. :)
-alex
On Fri, 12 Oct 2001, Mark Riehl wrote:
All - Just curious if anyone is successfully using DBI with PostgreSQL under
Linux? I don't see a lot of traffic about it and may need to use it in the
near future.
Thanks,
Mark
--
Mark Riehl
Agile
is that standard syntax? :-)
ANSI SQL3, maybe even SQL2.
-alex
On Wed, 10 Oct 2001, Jeff Zucker wrote:
Alex Pilosov wrote:
On Wed, 10 Oct 2001, Jeff Zucker wrote:
Steve Howard wrote:
The Standard SQL syntax for updating based on a join is this
UPDATE Table1
Set Column1 = r.Column1, Column2 = r.Column2
FROM
you run this program. If nothing helps, do a 'where' on
coredump, that should help.
(gdb perl core, then 'where')
-alex
On Thu, 4 Oct 2001, Matt Nelson wrote:
I have come up with a small perl script which consistently causes a
segmentation fault using DBD-Pg. I have included it below, along
You must use bytea type on postgres side to insert binary data, and bind
your variable as SQL_BINARY.
ALternatively, byte64 or hex encode your binary data.
On Wed, 3 Oct 2001, K Old wrote:
Hello,
I am trying to load encrypted data (a credit card number encrypted by the
Crypt::Twofish
,
DBI-1.20 installed just fine, with make test giving no errors.
Thanks,
Alex Kirk
handler you'll be able to pay attention
only to certain errors or print HTML messages to user's browser, for
example. Just be sure to handle WARN signals that are not caused by DBI
errors properly.
Regards,
Alex Gerasev
[EMAIL PROTECTED]
Jeff Zucker wrote:
Alex Schuilenburg wrote:
Hi
I have successfully been using DBD::CSV for the last year and recently upgraded
to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade, the ORDER
BY clause on an ISO date field (i.e -mm-dd,m e.g. 2001-09-10) no longer
. The same years are grouped
together but the comparison does not continue after the first '-').
I tried various 'locale's, but simply cannot. Switching back to 6.2 it all
works again.
Any ideas?
Thanks
-- Alex
Alex Schuilenburg wrote:
Hi
I have successfully been using DBD::CSV for the last year and recently
upgraded
to Red Hat 7.0 from 6.2. The problem is that ever since the upgrade,
the ORDER
BY clause on an ISO date field (i.e -mm-dd,m e.g. 2001-09-10) no longer
works. The sort
1 - 100 of 125 matches
Mail list logo