Sybase TEXT field updates..

; } } } /similar Thanks for any tips... amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Sybase TEXT field updates..

::Sybase : 1.05 Sybase : 11.9.2 PC OS : Windows XP Server OS : Windows 2000 Thanks! amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

confidence level is high. :-) Steffen Thanks again for all your great work with DBD::ADO, amonotod #!perl -w use strict; eval { use DBI; }; if ($@) { die This system does not have the DBI installed!\n; } eval { use DBD::ADO; }; if ($@) { die Database type ADO not supported!\n; } eval { use CGI

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

of next week. Either way, I appreciate your time and work investigating this, and will make sure I let you know how it goes... Steffen Thank you! amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

::ADO to retrieve the pics via CGI. Thanks for the pointer, Bart! As before, the pics I used are available at http://geocities.com/amonotod/picsDB_images.zip. Populate the database with perl myPics.pl load=1, then view the script via a browser and web server of choice And, again

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

, the pics I used are available at http://geocities.com/amonotod/picsDB_images.zip. Populate the database with perl myPics.pl load=1, then view the script via a browser and web server of choice And, again, thanks for DBI, DBI::ADO, DBI::ADO, DBI::Sybase, DBI::Oracle and all the other great

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

Steffen Goeldner [EMAIL PROTECTED] wrote: amonotod wrote: eval { use Win32::OLE; Win32::OLE-Option(CP = Win32::OLE::CP_UTF8); }; Looks like is has to do with UTF8. Commenting out (or moving it out of the eval{}) avoids (or hides?) the problem. Sorry, no further ideas

Re: Best authentication methods for CGI - PERL - DBI

passphrase. It's a bit of a classic, but it's a good classic, one the works... 1) http://www.modperl.com/ 2) http://ldap.perl.org/ HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

amonotod wrote: I'm trying to insert images into an Access database (they're small, and that's how the app was built, not my choice), but I'm running into errors. I'm using... Windows XP SP1 ActiveState Perl: This is perl, v5.8.3 built for MSWin32-x86-multi-thread DBI 1.43 DBD::ADO

DBD::ADO and Access IMAGE (OLE Object) fields...

\web\PicsDB\Yahoo_Logo.gif 4,The AOL Logo,image/gif,C:\development\web\PicsDB\AOL_Logo.gif EOF return($picList); } Thanks much! amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Re: large updates and deletes

out of the DB and through the DBI; this way the only process that has to work with the data is the oracle engine. Use DBI where appropriate... Right tool for the job, and all that... Mark v/r, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net

DBD::Oracle make test failure (Was: DBD::Oracle build failure)

, ORACLE_HOME and ORACLE_USER set, all with correct and valid parameters. What can I do te get all the tests to pass? (I think I got this last time I built it but installed anyway, and the DBD does work, but I'd like to get it to pass the tests...) Thank you, amonotod -- `\|||/ amonotod

Re: DBD::Oracle build failure...

, and even a flame or two, so feel free to suggest just about anything Thanks, amonotod From: amonotod [EMAIL PROTECTED] Date: 2005/12/20 Tue AM 08:20:26 CST No responses, maybe because I sent on Friday afternoon, so I'm resending... ;-) Hey all... I've previously built DBD

DBD::Oracle build failure...

it and hopefully spot the issue... AS Perl 5.8.0 DBI 1.45 MS VCC 6.0 SP5 w/SDK WinXP SP2+ Thank you, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo

DBD::Oracle build failure...

SP2+ Thank you, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_| C:\Perl\Installs\DBD-Oracle-1.16perl -v This is perl, v5.8.0 built

RE: Oracle and dbh - last_insert_id

insert. The query with the returning clause would be more reliable, from that standpoint... Hardy Merrill v/r, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Oracle 9i - Install problems on Win XP?

on this list... HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

RE: :Oracle PPDs for both 8.0 and 9.2 clients on Windows?

been able to get management to agree to OSS contributions, although I think they're close. So, at this point, the answer is no, but hopefully, that will change... Jeff HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a

had to teach me this just a few months ago (Thanks again, Michael) amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: RE: DBI.ppd

://your.local.proxy:80 HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Re: Dbi question?

this: http://poe.perl.org/ -sam Thanks for the new material, ;-) amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Newbie problem connecting to MS SQL Server

HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

RE: More on closing Oracle ref cursors

the cursor(s) via the clone()d connection, then call disconnect() at the end of the loop? Hmm... Well, sounds right, anyway Ron Reidy amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

RE: More on closing Oracle ref cursors

From: amonotod [EMAIL PROTECTED] Date: 2005/04/20 Wed PM 02:35:37 CDT Also, since the OP mentioned running the loop 1500(0?) times Boy, I don't know where I got that... He just said many times Doh! amonotod -- `\|||/ amonotod@| sun|perl|windows

Re: Accessing MS Access

://support.microsoft.com/default.aspx?scid=kb;en-us;Q207671 HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Accessing MS Access

way to connect to your Access database than with DBD::ODBC. If not better, at least different. http://www.nntp.perl.org/group/perl.dbi.users/26145 Regards, Javier Moreno HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba

RE: string help!

, then update the row to get the TEXT data in. Just like Michael told me to. Thanks, Michael... Michael amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

RE: :Pg for Windows

we're telling you what database to use, instead of answering your question... amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

RE: :Pg for Windows

this: http://www.issociate.de/board/post/149171/DBD-Pg_for_Perl_5.8.4_Build_810.html which was the 6th result in this: http://www.google.com/search?hl=enq=%22dbd%3A%3Apg%22+ppd Robert HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba

OT: Apology (WAS: RE: :Pg for Windows)

From: Moosmann, James [EMAIL PROTECTED] Date: 2005/04/01 Fri AM 09:41:25 CST But, I have to say, Amonotod's reply was implying to be rude to me. For that, I apologize... Sincerely. I'll try to refrain from being sarcastic from now on... v/r, amonotod - Please note the all-lower-case

Re: Re: Accessing MS Access through the DBI ODBC

the password to NULL for Access $retval .= :Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=. $arg_use_db .; } return $retval; } kevindot HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

RE: string help!

From: Anderson, James H \(Company IT\) [EMAIL PROTECTED] Date: 2005/03/31 Thu PM 01:59:26 CST Consequently, AFAIK, almost no one in the sybase world use them. How sad... I already figured out that I'm a nobody, but now I'm no one at all... *sigh*... amonotod

Re: last non-DBI attempt - reading MS Access .ldb (locked db file) with Perl

by the Jet database engine, and as far as I know, it's not too awful useful, outside of the engine. Plus, Jet is going to recreate it, every time you access the .mdb file, and that demotes its usefulness even further... amonotod -- `\|||/ amonotod@| sun|perl|windows

Re: Running stored procedures

'... http://www.db2mag.com/story/showArticle.jhtml?articleID=60400732 HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Re: DBD::CSV much slower on osX ?

reduced, it may indeed point to I/O issues... Best, Charles HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Does the DBD-Oracle-1.16 work with perl 5.6.0 version?

* BUILDING, TESTING AND INSTALLING DBD::Oracle: Build, test and install Perl 5 (at least 5.6.1) snip Thanks Junying Du HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: finding and inserting

[FK_EmpDistLkp_Employees] FOREIGN KEY ( [EmpID] ) REFERENCES [dbo].[Employees] ( [EmpID] ) GO v/r, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

Re: finding and inserting

would barf into my trashcan if you saw how the back-end is arranged. Okay, so let's see it. Might you have the SQL files that were used to create this database? If not, in SQL+, do a desc table for each table that is involved in the question... Robert amonotod -- `\|||/ amonotod

Re: finding and inserting

From: Robert [EMAIL PROTECTED] Date: 2005/02/11 Fri PM 12:55:03 CST Nope you got it. I am just mulling in my thick head. Say what? We're quite willing to help, we just need a little more data to do so... Robert amonotod -- `\|||/ amonotod@| sun|perl|windows

Re: Retrieve values from Oracle

()) { print Tr( td( $field1, $field2 ) ); # note - I can print both values here Well, where did you declare them? I don't see them in your snippet, except for there... } HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net

Re: DBI-1.46 issues

/bin/perl # module_version.pl # Stolen off the web... Thanks! use strict; foreach my $module ( @ARGV ) { eval require $module; printf( %-20s: %s\n, $module, $module-VERSION ) unless ( $@ ); } HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net

Re: Attachments on DBI mailing lists

. Ah, yes... Webmail strikes again... I'll make sure I get my scripts into the body of the email from now on... Tim. Thank you, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: DBD::Sybase $dbh-clone errors...

5.8.0 DBI 1.46 DBD::Sybase 1.05 Thanks, amonotod From: amonotod [EMAIL PROTECTED] Date: 2005/01/17 Mon AM 10:53:32 CST Hello all, Now, I'm not sure this is an error, since it does succeed, but the attached script will produce a warning about an unknown attribute. What I'm doing

Re: Re: DBD::Sybase $dbh-clone errors...

From: amonotod [EMAIL PROTECTED] Date: 2005/02/01 Tue PM 03:13:58 CST Hello all, I never got a response to this, so I'm sending it again... I've recieved an automated attachment stripped message, so here's the script... #! perl -w use strict; eval (use DBI); if ($@) { die This system

Re: Affected Rows

query and then fetch the row count from that. /snip Regards Hernan Dario Arredondo HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Searchable archive for the DBI mailing list?

with your search term... :-) regards, David HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Affected Rows

From: amonotod [EMAIL PROTECTED] Date: 2005/01/24 Mon PM 02:03:18 CST From: Hernan Arredondo [EMAIL PROTECTED] Date: 2005/01/24 Mon PM 12:41:56 CST anyone knows other easy method ? FROM THE DOCS! snip One alternative method to get a row count for a SELECT is to execute

Re: Affected Rows

it is. Myself, I never put a NULLable column in the first position of a query. You know, since that is usually a KEYed column... Well... Usually... For me... Jenda Point taken, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin

RE: Double quotes in select statement throw an error

that users don't have to worry about DSNs at all? $ConnStr= 'dbi:ODBC:driver={SQL Server};Server='.$Server'.;database='.$database.';'; $dbh = DBI-connect( $ConnStr, $user, $pwd, {RaiseError = 1, AutoCommit = 1} ); Thanks. James HTH, amonotod -- `\|||/ amonotod@| sun|perl

DBD::Sybase $dbh-clone errors...

if the message is from DBI or from the DBD, but it does show up... Environment: Windows XP Professional SP2 Sybase 11.9.2 client (With 11.9.2 server on Win2K AS sp4) ActivePerl 5.8.3 DBI 1.43 DBD::Sybase 1.04.6 Thanks for any recommendations... amonotod -- `\|||/ amonotod@| sun

Re: DBD Oracle DBI driver

? This was asked and answered just today... http://www.mail-archive.com/dbi-users@perl.org/msg23620.html Regards, Javier Moreno HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: connection from Perl 5.8.5 to Oracle 7.3.4 database

interface. Changes in DBD-Oracle 1.15 27th January 2004 NOTE: This is probably the last release that will support being built with the old Oracle 7 OCI interface. Yahui HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

Re: Apache::DBI usage

connection once, and have it available to all my subroutines and to the other two scripts that I require() in... Remember to make use of your 'our', 'my' and 'local' variable declarations... Thanks Angie HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows

Re: DBI for two database versions

it may indeed work against 10, but I really don't think the 8 client will... Sam Vilain HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: RE: Evaluated require $database not found.

' :-) Something like this works I believe: use strict; my $val = 'DBI'; eval require $val; Ripped straight from working code: eval (use DBI); if ($@) { die This system does not have the DBI installed\n; } HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows

execute_for_fetch() woes...

... Thanks for any pointers, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: execute_for_fetch() woes...

From: Tim Bunce [EMAIL PROTECTED] Date: 2004/10/04 Mon PM 09:39:49 GMT On Mon, Oct 04, 2004 at 08:59:33PM +, amonotod wrote: Howdy, So, I'm trying to use execute_for_fetch, and according to the POD (provided I'm reading it correctly), I need an array of arrays, each of which

execute_array and iterations....

handle, open a new statement handle, insert the remainder, and then commit that part? Boy, it seems like it should be easier... Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Re: execute_array and iterations....

execute_for_fetch failed: called with 101 bind variables when 5 are needed at D:\development\dbd_db.pl lin e 446, TEXT_DATA line 101. Ugh... Pointers? Thank you, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

execute_array() problem...

to the correct columns... :-( Oh, and before I switched to execute_array, I didn't have any errors like this... :-) So, any ideas? Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

Re: execute_array() problem...

From: amonotod [EMAIL PROTECTED] Date: 2004/09/28 Tue PM 07:13:23 GMT You ever have one of those days, where all you needed was to put on your headphones, tune everyone out, and make things work...? - $DataInsert-bind_param_array($temp_count, [EMAIL PROTECTED]); + $DataInsert

execute_array() - Use array of arrays?

Hey all, Before I spend half-an-hour making useless mods to my code, can I pass in an array of arrays to execute_array, or do I have to pass in each array separately? Thank you, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba

Re: RE: MySQL data matching error [OT perl]...

From: Dan Hopkins [EMAIL PROTECTED] Date: 2004/09/21 Tue AM 09:45:32 GMT -Original Message- From: amonotod [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 17:09 1) if you're using place-holders, assign undef() to the value, and the DBI *should* convert it to NULL

Re: MySQL data matching error...

...? ) ) { $myVal = NULL; } I'm sure you could build the second part of the compare with m//, perhaps like m/\A\s+\Z/ or something similar, but I pretty much suck at regex's, so I dunno... Scott Nipp HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net

DBD::CSV and large files...

? Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: DBD::CSV and large files...

routine. Is it as efficient? At this time, no. But I'll see what I can do... Jeff Thanks for the response, always appreciated... amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: multiple prepare calls

::ODBC does not like it. The scripts normally do fail unless I call $sth-finish before I call the next $dbh-prepare()... Michael amonotod P.S. Out of curiosity... Years ago, I worked with Sybase 10.0, and we had this Netscape 2.0 module that allowed us to write embedded Perl statements

Re: MySQL to MS SQL Server

a README.freetds file. I've seen mention of using the FreeTDS drivers wtih DBD::Sybase to connect to MS SQL from Unix/Linux. Perhaps someone with more knowledge in this area can help... I am still horribly lost. Well, good luck; sorry I'm not of more direct help... amonotod

Re: DBD::ADO connect error...

at http://www.perl.com/, the Perl Home Page. Anyway, getting past that... The errors went away. ;-) Hm... Steffen Thank you for the reply, I appreciate it, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_

Re: MySQL to MS SQL Server

From: Joel West [EMAIL PROTECTED] Date: 2004/08/18 Wed PM 05:33:54 GMT my $dsn = DBI:ODBC:databasename:ipaddress; (Assuming you're on Windows...) my $dsn = DBI:ODBC:driver={SQL Server};Server=ipaddress;database=databasename;; Joel (Yossel) West HTH, amonotod

RE: Trouble with bind variables

I suggest DBI:CSV? amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

DBD::ADO connect error...

/site/lib/DBI.pm line 595. DBD::ADO::dr connect warning: at C:/Perl/site/lib/DBI.pm line 595. I'd like to know how to get rid of the messages... Do I need an error_handler for DBD::ADO? Does it even support one? Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows

Re: DBD::ADO connect error...

From: amonotod [EMAIL PROTECTED] Date: 2004/08/17 Tue PM 08:25:11 GMT Use of uninitialized value in subroutine entry at C:/Perl/site/lib/DBI.pm line 595. DBD::ADO::dr connect warning: at C:/Perl/site/lib/DBI.pm line 595. Sorry, I didn't mean to forget: OS: Windows 2000, SP4 Perl

DBD::Sybase 1.04.6 -- Production quality?

1.02), or what, but it does happen. When I upgrade the DBD, I'm also going to upgrade to DBI 1.43. Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

OT: Just testing to see if the list is back...

Test... -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate 6 - request for testing

are below. Environment is Win2K SP4, AS Perl 5.8.3, MS VC 6.0 SP5. I would be happy to try again, if I am provided with possible fixes... Thank you, amonotod C:\Perl\installs\DBD_Oracle\DBD-Oracle-1.16perl Makefile.pl Using DBI 1.43 (for perl 5.008003 on MSWin32-x86-multi-thread) installed in C

Re: ANNOUNCE: DBD::Oracle 1.16 release candidate 6 - request for testing

From: amonotod [EMAIL PROTECTED] Date: 2004/08/13 Fri PM 04:01:54 GMT Results of a failed build are below. Or perhaps, not. Apparently, failed tests are not indicative of a failed build. 'nmake install' went just fine, and my DBI scripts work just fine against Oracle 8i and Oracle 9i

Re: DBD::Sybase 1.04.6 -- Production quality?

From: Michael Peppler [EMAIL PROTECTED] Date: 2004/08/13 Fri AM 07:50:56 GMT On Wed, 2004-08-11 at 19:39, amonotod wrote: I'm currently using 1.02, but am having problems with it hanging against an 11.9.2 server when doing massive non-bulk inserts (50,000+ space defined, or trunc. log

Re: SQL- Insert problem

From: Shah, Urmil [EMAIL PROTECTED] Date: 2004/08/13 Fri PM 04:42:54 GMT Need help in trying to insert an sql statement. As everyone else has been saying, you need to use placeholders. See my script below... Note that I tested with MSSQL, but Regards, Urmil Regards, amonotod #!perl

Re: SQL- Insert problem

From: amonotod [EMAIL PROTECTED] Date: 2004/08/13 Fri PM 07:29:35 GMT Note that I tested with MSSQL, but Well, yes, I did test with MSSQL, but as you can see from the DBI connection string, I also tested with Oracle 9i... :-) amonotod -- `\|||/ amonotod@| sun|perl

RE: SQL- Insert problem

' think that would work... HTH, and HINW, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_| Here is the code if it helps. I do

RE: SQL- Insert problem

, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: DBD::Sybase 1.04.6 -- Production quality?

From: amonotod [EMAIL PROTECTED] Date: 2004/08/13 Fri PM 05:33:16 GMT From: Michael Peppler [EMAIL PROTECTED] Date: 2004/08/13 Fri AM 07:50:56 GMT space defined, or trunc. log on checkpoint turned on? Might you know how to control how often the checkpoints happen? Okay, never

Re: DBD::ADO - Multiple unnamed columns clobber themselves.

From: Olivier Poulet [EMAIL PROTECTED] Date: 2004/08/07 Sat AM 09:39:59 GMT my $sql ='EOFSQL'; SELECT LOWER(field_one) as field_one , field_two, UPPER(field_three) as field_three FROM sample_table (NOLOCK) WHERE field_one = ? EOFSQL That should do it... HTH, amonotod

Re: DBD::Sybase and insert on TEXT column...

amonotod [EMAIL PROTECTED] wrote Okay, according to the Cheetah, DBD::Sybase does not support using placeholders on TEXT columns. Here's why you should search the archive *before* you post: http://www.mail-archive.com/[EMAIL PROTECTED]/msg21494.html ;-), sorry, amonotod

Re: Re: DBD::ADO and TEXT datatypes

is equivalent to Sql Server 7.0. It just doesn't come with the developer and administrative add-ons that Sql Server has... http://msdn.microsoft.com/data/downloads/updates/default.aspx 7th item down, they're now on Release A. HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows

Passing complete SQL scripts thru DBI...

... Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Passing complete SQL scripts thru DBI...

From: amonotod [EMAIL PROTECTED] Date: 2004/07/29 Thu PM 07:25:02 GMT So, I've got these heavy duty, complicated T|PL-sql scripts, that I have to pass through to my DB, After doing some more Googling, I've come up with a question: Is this what DBI::Shell is for? Thanks, amonotod

Re: DBD::ADO and TEXT datatypes

posts...)... Also, maybe someone might be able to give detail on using the FreeTDS libs and DBD::Sybase to make the connection and try the statements... Thank you very much! j. amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba

Re: DBD::ADO and TEXT datatypes

posts...)... Also, maybe someone might be able to give detail on using the FreeTDS libs and DBD::Sybase to make the connection and try the statements... Thank you very much! j. amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba

Re: DBD::Sybase message suppression....

From: amonotod [EMAIL PROTECTED] Date: 2004/07/21 Wed PM 10:12:45 GMT From: Chuck Fox [EMAIL PROTECTED] Date: 2004/07/21 Wed PM 09:35:55 GMT Install an error handler, ignore messages with a severity of 0 or 10 Okay, found that... Will try it out soonest... Basically, straight out

Re: DBD::Sybase message suppression....

From: amonotod [EMAIL PROTECTED] Date: 2004/07/22 Thu PM 02:10:13 GMT } print STDERR join(\n,@msg); return 0; ## CS_SUCCEED } } Actually, that's wrong. It should be this... } print STDERR join(\n,@msg); } return 0; ## CS_SUCCEED } Why? We need to return

DBD::Sybase message suppression....

... $sqlStatement..\n; } Now, if the answer is that I should change the RaiseError to 0, then I'll just live with the messages, as I prefer to know that the script execution went bad... Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba

Re: DBD::Sybase message suppression....

From: Henri Asseily [EMAIL PROTECTED] Date: 2004/07/21 Wed PM 09:22:07 GMT On Jul 21, 2004, at 2:06 PM, amonotod wrote: Now, if the answer is that I should change the RaiseError to 0, then Try to add PrintError = 0 Well, that sounded good, but had no effect on the messages... Thanks

Re: DBD::Sybase message suppression....

From: Chuck Fox [EMAIL PROTECTED] Date: 2004/07/21 Wed PM 09:35:55 GMT Install an error handler, ignore messages with a severity of 0 or 10 Okay, found that... Will try it out soonest... Chuck Thanks, amonotod -- `\|||/ amonotod@| sun|perl|windows

Re: How to insert CR/LF into Sql Server database?

$insertString = 'This is the mult-line '+ char(13) + char(10) +'string I want to enter'; Mark Bowen HTH, amonotod -- `\|||/ amonotod@| sun|perl|windows (@@) charter.net | sysadmin|dba ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: no DBD:MSSQL?

; } ### HTH, amonotod -- `\|||/ amonotod@| subject line: (@@) charter.net | no perl, no read... ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Truncation Issues with SQL Server Insert Statement

now. So, Thanks, Jeff and Jochen!... HTH, amonotod -- `\|||/ amonotod@| subject line: (@@) charter.net | no perl, no read... ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: Re: Truncation Issues with SQL Server Insert Statement

Merrill Thanks, amonotod (all lower case, btw... :-) -- `\|||/ amonotod@| subject line: (@@) charter.net | no perl, no read... ooO_(_)_Ooo _|_|_|_|_|_|_|_|

Re: no DBD:MSSQL?

, amonotod -- `\|||/ amonotod@| subject line: (@@) charter.net | no perl, no read... ooO_(_)_Ooo _|_|_|_|_|_|_|_|

  1   2   >