Re: postgres SSL

2005-05-20 Thread xaver biton
, May 20, 2005 at 04:47:52PM +0200, xaver biton wrote: HI, I'd like to build a secure connection to PostgreSQL, but I can't imagine how to do it, its the same like building a connection with the insecure protocol? How does that work? could someone make eventually an example. Man Thanks in advance. Xaver Biton

postgres SSL

2005-05-20 Thread xaver biton
HI, I'd like to build a secure connection to PostgreSQL, but I can't imagine how to do it, its the same like building a connection with the insecure protocol? How does that work? could someone make eventually an example. Man Thanks in advance. Xaver Biton

Re: return parameter value if query does't match

2005-04-12 Thread xaver biton
I think that was the second possibility I mentioned. If the inner query doesn't find any rows, you want to do something else. many thks. It works like I wished. cheers. Xaver

Re: return parameter value if query does't match

2005-04-07 Thread xaver biton
Hi Tim, while(my @row = $sql->fetchrow_array){ $sql1->execute("$row[3]"); What DBD module are you using? If Oracle, are any of the fields CHAR? is MySql, the fields are char Xaver

Re: return parameter value if query does't match

2005-04-07 Thread xaver biton
Hi, Perhaps if you list what you want to happen and what is happening in more detail we can help. Ok my $sql = $dbh->prepare(q{select col1, col2, col3 from test}); the second: my $sql1 = $dbh->prepare(q{select row1, row2, row3 from test1 where test1.row = ?}) $sql->execute(); while(my @col = $s

return parameter value if query does't match

2005-04-07 Thread xaver biton
Hi, i've 2 select query. the first one is like my $sql = $dbh->prepare(q{select * from test}); the second: my $sql1 = $dbh->prepare(q{select * from test1 where test1.row = ?}) $sql->execute(); while(my @row = $sql->fetchrow_array){ $sql1->execute("$row[3]"); while(m

Re: DBI tand subroutine

2005-02-20 Thread xaver biton
Michael A Chase tech wrote: I don't think you are showing us the running code. Hi Michael, you are right sorry, yesterday I was to tired. Any way thanks for the useful tips. The wrong part was the the missing brachets around "$para" I modified it in: sub area{ my ($para) = @_;... and now work

DBI tand subroutine

2005-02-19 Thread xaver biton
Hi, wht's wrong with the following code, I should recieve '49201','49203', '49','49203', '49203','49203' and if I don't use the sub I do that, but if I use the sub I recieve only '491' Thks. Xaver ##snip## my $zone_area_code = $dbh->prepare(q{ SELECT zone_area_code.area_code_from, zone_area_cod

DBI like

2004-12-19 Thread xaver biton
Hi, how do I use like as bind variables, eg: select * from users where user.tel like '49755%'. could xou make an example? thks. xaver

batch update

2004-09-10 Thread xaver biton
#x27;WHERE vo_nr = 012345 AND orders_id =12012345' at line 2 at proe-balance.pl line 388. Process perl exited with code 2 Please help I'm disperate Thks Xaver Biton

Update query :: Use of uninitialized value in concatenation

2004-09-09 Thread xaver biton
AND orders_id = $orders_id EOT $dbh->do($sql); } ######## thks. Xaver Biton

inserting into mysql single element from an array

2004-09-01 Thread xaver biton
Hi, I've elimminated the columns which contains commas, bu noe I'm recieving this error: inserting into mysql single element from an array what does that mean? Xaver Biton

Re: inserting into mysql single element from an array

2004-09-01 Thread xaver biton
Hi, there's the possibility to change the field separator in "values", so I could add a # instead, e.g. push @{ $array[1] }, $qualification ."#"; mybe is a stupid supposition, I don't know how can i test this. Xaver Biton

Re: inserting into mysql single element from an array

2004-09-01 Thread xaver biton
Ondrej Koala Vacha wrote: On Wed, 1 Sep 2004, xaver biton wrote: Hi, I've an Array like this: @array( ["Xaver", "Biton", "myStrasse", "1", "0725120155"], ["Xx", "Xy", "deineStrasse", "2", ], ["

inserting into mysql single element from an array

2004-09-01 Thread xaver biton
Hi, I've an Array like this: @array( ["Xaver", "Biton", "myStrasse", "1", "0725120155"], ["Xx", "Xy", "deineStrasse", "2", ], ["Robert", "sky", "seineStrasse", "2

Re: Core in connecting to Oracle using DBD

2004-08-31 Thread xaver biton
Sean Owens wrote: Version of Perl 5.005_03 Version of AIX is 4.2! Version of Oracle is 8.1.5 DBD-Oracle-1.03 DBI-1.13 The problem is that the script below bombs out only the 2nd and subsequent times I run it. What I have tried I have tried recompiling the DBD and the DBI using xlr_c instead of cc t