Re: SQL Server "Invalid Cursor State"

2006-01-24 Thread itrabado
Does your sp manage cursors? Ignacio Trabado Castillo Dpto. Informática Desarrollo tlf: 93 500 (9255)___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: filtering the output of fetchrow

2005-06-22 Thread itrabado
The thing is that that wrapper is being used by many different programmers. The data containing the # is not under my control, so i can't backslash it before i get it. The problem is that in certain scripts (I don't know how many, cause here there's thousands...) the # is being interpreted as a co

filtering the output of fetchrow

2005-06-21 Thread itrabado
Hi perlies... I've got a function wraping DBI::fetchrow() like this: sub fetchrow_sql() {         my $sth=$_[0];         $sth->fetchrow() } That i use in this two fashions: A) Assigning result to an array $dbh=DBI->connect(...); sql = "select a,b from table"; $sth=$dbh->prepare($sql) or m

Re: uninstall/delete running app

2005-05-04 Thread itrabado
If you're in linux you can use cron... Ignacio Trabado Castillo Dpto. Informática Desarrollo tlf: 93 484 (8391) Ted Yu <[EMAIL PROTECTED]> Enviado por: [EMAIL PROTECTED] 04/05/2005 01:06                 Para:        perl-win32-users@listserv.ActiveState.com         cc:                 Asu

Re: Store hash in SQL

2005-05-02 Thread itrabado
Why should you use that instead of using SQL like it's meant to be? store each property in a field, then use the key to index... I can't think why you should prefer storing the hash in any other way... "Chris" <[EMAIL PROTECTED]> Enviado por: [EMAIL PROTECTED] 02/05/2005 16:30          

Re: SELECT substring of column into a variable

2005-04-30 Thread itrabado
I would do something like this: SELECT                 substring(ContractTerms, 0, 1000),2field,3field FROM                 ContractsTest WHERE                  refnum = '1' Then  you can perfectly do the while with the fetchrow, and asign the alias at the same time. That would be something lik

Re: Problems with win32 and shebang

2005-04-05 Thread itrabado
thanks for your quick reply: >> But Apache still ignores the thing and keep complaining about the wrong >> shebangs -> couldn't spawn child process: x:/xxx/xxx/hola.cgi >Is that from the error log ?  If not, there may be further info there. > Yes, is the only line i get from the error Log. >>

Problems with win32 and shebang

2005-04-05 Thread itrabado
Hi guys, I know that this is not exactly the matter of this list but i'm kind of desperate so i would appreciate some help. I'm trying to setup the Apache 1.3 with activestate perl on a windows 2003 server. It works fine with the shebang on the scripts, but i'm trying to migrate from a IIS. So