OLE DB

2002-02-18 Thread mb
Hello all, I have seached for learning OLE DB syntax for accessing database,and all informations converge to this statement for join use but it does not work. require "connexion.pl"; my $Statement = "SELECT F_FAMILLE.FA_Intitule, F_ARTICLE.AR_UniteVen, F_ARTICLE.AR_SuiviStock, F_FAMIL

urgent gettting '$var' as a String 'value of $var'

2002-02-16 Thread mb
Hi all, Sure i m the only one doing perl in the week-end, the mailinglist is deserted. I' m tryig to generate dynamic SQL statements. I have a problem on getting a WHERE over 'varchar' type fields. for ($i =0; $i I want to get 'mars'. "select DE_Intitule, @select from F_Depot $stringW" -

ADO syntax

2002-02-13 Thread mb
Hi all, can some one tells me what is wrong with that : $Conn->Execute("create procedure textproc \@val varchar(25) as select AR_Ref ,AR_Design from F_Article where AR_design like \@val"); $cmd->{ActiveConnection} = $Conn; $cmd->{CommandText} = "{call textproc (?)}"; $cmd->Paramete

DATABASE query

2002-02-02 Thread mb
Hi, I'm trying to execute a SQL statement asking three tables on a DBI database connection. The database is a commertiale one (diff from MySQL) I think that my SQL statement is right : my($stmt) = "select AS_QteSto from art F_ARTICLE,dep F_DEPOT,sto F_ARTSTOCK where art.AR_Ref='

generate variable names

2002-02-01 Thread mb
Hi all, I 'm asking if there a dynamic way to generate variable names. $id; foreach(@_){ my($var1 > in the second time my($var2 -> my($varn Thanks a lot in advance, asma

Tr: soft reference sorry I think that there is a pb of transmit

2002-02-01 Thread mb
Hi, I need help about soft referencing or extract value of array var. Can some one get a look to code bellow : Have a good week-end. asma. foreach(@articles) { ##($code,$article,$codeFamil,$uniteVent,$idDepot,$quantite) my @row1; push(@row1, $q -> td({align => 'center'},$article), ...

Tr: soft reference

2002-02-01 Thread mb
-Message d'origine- De : mb <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : vendredi 1 février 2002 19:01 Objet : soft reference Hi, I need help about soft referencing or extract value of array var. Can some one get a look to code bellow : Hav

Tr: soft reference

2002-02-01 Thread mb
-Message d'origine- De : mb <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : vendredi 1 février 2002 19:01 Objet : soft reference Hi, I need help about soft referencing or extract value of array var. Can some one get a look to code bellow : Hav

Tr: soft reference

2002-02-01 Thread mb
-Message d'origine- De : mb <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : vendredi 1 février 2002 19:13 Objet : soft reference Hi, I need help about soft referencing or extract value of array var. Can some one get a look to code bellow : Hav

soft reference

2002-02-01 Thread mb
Hi, I need help about soft referencing or extract value of array var. Can some one get a look to code bellow : Have a good week-end. asma. foreach(@articles) { ##($code,$article,$codeFamil,$uniteVent,$idDepot

call a cgi script

2002-01-30 Thread mb
Hi all, Is there a way to call a cgi script from another one(diff using html header and forms). So that this script get params and return values ... a kind of sub. Thanks in advance

acces to a data base on reading

2002-01-29 Thread mb
Hi, I'm working on a database witch had her own ODBC driver(it is declared that the database organized in files, one for each tables, accessible on read, write and update ~~) So there is no problem for writing tuples and there is no way to read any thing from any tables(I tryed with ODBC module a

unknown error

2002-01-25 Thread mb
Hi, I had correctly created a system DSN (OS windows 98), this DSN does not require usr and so password, if (!($db = new Win32::ODBC("Gestion100"))){ print "Error connecting to $DSN\n"; print "Error: " . Win32::ODBC::Error() . "\n"; exit; } I'm perplexed about the error signposted

please Help ! Database connection

2002-01-25 Thread mb
Hi, I just need when does this kind of error is raised : [Fri Jan 25 15:16:29 2002] [error] [client 127.0.0.1] malformed header from script. Bad header=Error connecting to gestion100: c:/phpweb/cgi-bin/majbd.cgi Kind Regards, asma

accessing to a DSN system

2002-01-25 Thread mb
hi, I'm asking to connect to a DSN system (on windows98) ... I ceated a DSN file so to get connection on it. and when excecuting the small lignes bellow . #!/perl/bin/perl use Win32::ODBC; my($db) = new Win32::ODBC("ConnectGestion100;UID=mouna;PWD=mennou;"); $db->Sql("SELECT * FROM F_ARTICLE")

Tr: creating DSN system

2002-01-16 Thread mb
-Message d'origine- De : mb <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : mercredi 16 janvier 2002 09:47 Objet : créating DSN system Hi, I'm trying to drive "gestion commerial 100" data bases using "ODBC 100" and do n

Tr: not perl, but need some help with Linux...

2002-01-06 Thread mb
-Message d'origine- De : maximilian sichart <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : dimanche 6 janvier 2002 11:44 Objet : Re: not perl, but need some help with Linux... >Frank McCollum wrote: > >> Does anyone know where to get help if you destroy a computer

Re: CGI perl html urgent

2002-01-06 Thread mb
>-Message d'origine- >De : [EMAIL PROTECTED] <[EMAIL PROTECTED]> >À : mb <[EMAIL PROTECTED]> >Cc : [EMAIL PROTECTED] <[EMAIL PROTECTED]> >Date : dimanche 6 janvier 2002 03:50 >Objet : Re: CGI perl html urgent > > >> >>Also, I ha

Re: CGI perl html urgent

2002-01-05 Thread mb
int qq~ ~; for instance? What >are the advantages of using this other method? > I' m new on perl world but I found the <R.A. Howard > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Friday, January 04, 2002 3:43 PM >To: mb >C

call a windows application (.exe) via perl

2002-01-05 Thread mb
Hi, I asking if there is any module to make some directives like : runing a window appli, waiting it finish and get the result of runing. Thanks , asma

CGI perl html urgent

2002-01-04 Thread mb
  -Message d'origine-De : mb <[EMAIL PROTECTED]>À : [EMAIL PROTECTED] <[EMAIL PROTECTED]>Date : vendredi 4 janvier 2002 21:46 Hi,   When compiling the perl cgi code joined to this mail, I had "Internal Server Error" on my apache server. I did not f