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,

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; $iscalar(@where); $i+=2){ #pour une entree a la table de hash avec en sortie

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 (?)};

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

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) {

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 : Have a good week-end. asma

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 : Have a good week-end

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 : Have a good week-end

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), ...

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

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

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);

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

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 :

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 not found parameters (in any sage doc) to type

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 have Perl installed in /opt/local/bin/... so make sure line 1 points to you perl

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 while

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

Re: CGI perl html urgent

2002-01-05 Thread mb
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 3:43 PM To: mb Cc: [EMAIL PROTECTED] Subject: Re: CGI perl html urgent So many things were wrong: Here is a cleanup version: (See attached file: VoirStock.cgi) I inserted line 21 for my purposes, so

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 find the pb. thanks for help. -