HELP, HELP, HELP

What am I doing WRONG




#!/usr/bin/perl -w
#
# Consilta.cgi
#

push(@INC,"/var/www/cgi-bin/");

require("cgi-lib.pl");

$|=1;
#use strict;
use DBI;
use CGI;

sub avisa_y_salte {
    my $error = "@_";
    print &PrintHeader;

    print "<h1>Error Inesperado</h1>";
    print "<p>$error</p>";
    print &HtmlBot;
    die $DBI::errstr;
    }

my $version="V.20.01";
my $registro="<CENTER><H5><I>Consulta Ciudadana $version 2001. <A
HREF=\"mailto:aoriza\@cancun.gob.mx\">Hayuntamiento Benito
Juarez.</A></I></H5></CENTER>";


if (&ReadParse) {
    my $query = new CGI;
    my $dat_nombre = $query->param('dat_nombre');
    my $dat_apater = $query->param('dat_apater');
    my $dat_amater = $query->param('dat_amater');
    my $dat_calle = $query->param('dat_calle');
    my $dat_sm = $query->param('dat_sm');
    my $dat_mz = $query->param('dat_mz');
    my $dat_lt = $query->param('dat_lt');
    my $dat_edif = $query->param('dat_edif');
    my $dat_nomint = $query->param('dat_nomint');
    my $dat_nomext = $query->param('dat_nomext');
    my $dat_colo = $query->param('dat_colo');
    my $dat_cp = $query->param('dat_cp');
    my $dat_mpio = $query->param('dat_mpio');
    my $dat_ciudad = $query->param('dat_ciud');
    my $dat_edo = $query->param('dat_edo');
    my $dat_pais = $query->param('dat_pais');
    my $dat_tel = $query->param('dat_tel');
    my $dat_fax = $query->param('dat_fax');
    my $dat_email = $query->param('dat_email');
    my $dat_edad = $query->param('dat_edad');
    my $dat_sexo = $query->param('dat_sexo');
    #$dat_nombre = $in{'dat_nombre'};
    #$dat_apater = $in{'dat_apater'};
    #$dat_amater = $in{'dat_amater'};
    #$dat_calle = $in{'dat_calle'};
    #$dat_sm = $in{'dat_sm'};
    #$dat_mz = $in{'dat_mz'};
    #$dat_lt = $in{'dat_lt'};
    #$dat_edif = $in{'dat_edif'};
    #$dat_nomint = $in{'dat_nomint'};
    #$dat_nomext = $in{'dat_nomext'};
    #$dat_colo = $in{'dat_colo'};
    #$dat_cp = $in{'dat_cp'};
    #$dat_mpio = $in{'dat_mpio'};
    #$dat_ciudad = $in{'dat_ciud'};
    #$dat_edo = $in{'dat_edo'};
    #$dat_pais = $in{'dat_pais'};
    #$dat_tel = $in{'dat_tel'};
    #$dat_fax = $in{'dat_fax'};
    #$dat_email = $in{'dat_email'};
    #$dat_edad = $in{'dat_edad'};
    #$dat_sexo = $in{'dat_sexo'};

if ($dat_nombre eq '')  {
        print &PrintHeader;

        print "<html>\n";
        print "<META HTTP-EQUIV=\"Refresh\"
CONTENT=\"0;URL=http://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\n";
        print "</html>\n";
}

# Par�metros para abrir la base de datos
my $dbmain = 'habj';
my $dbuser = 'xxxxx';
my $dbpass = 'xxxxxxxxxx';
my $data_source = 'DBI:Pg:dbname=$dbmain';
my ($dbh, $sql, $cursor, $resultado);
# Nos conectamos a la base de datos
$dbh = DBI->connect("DBI:Pg:dbname=$dbmain",$dbuser,$dbpass) ||
avisa_y_salte("No puedo Abrir la Base de Datos");

# Sentencia SQL para hacer la consulta.
$sql = qq|INSERT INTO general (nombre, apaterno, amaterno, calle, sm,
mz, lte, edif, noint, noext,
          col, cp, mpio, city, edo, pais, phone, fax, email, edad, sex)
          VALUES ('$dat_nombre', '$dat_apater', '$dat_amater',
'$dat_calle', '$dat_sm', '$dat_mz',
                  '$dat_lt', '$dat_edif', '$dat_nomint', '$dat_nomext',
'$dat_colo', '$dat_cp',
                  '$dat_mpio', '$dat_ciudad', '$dat_edo', '$dat_pais',
'$dat_tel', '$dat_fax',
                  '$dat_email', '$dat_edad')|;
# Hacemos la consulta, en $resultado vienen todos los datos que nos
interesan
$cursor = $dbh->prepare($sql) || avisa_y_salte("No puedo Preparar el
Comando para Grabar");
$resultado = $cursor->execute || avisa_y_salte("No puedo executar el
Comando Para Grabar");

$dbh->finish;
$dbh->disconnect;

print &PrintHeader;

print "<html>\n";
print "<META HTTP-EQUIV=\"Refresh\"
CONTENT=\"0;URL=http://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\n";
print "</html>\n";
} else {
  print &PrintHeader;

  print "<html>\n";
  print "<META HTTP-EQUIV=\"Refresh\"
CONTENT=\"0;URL=http://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\n";
  print "</html>\n";
  print &HtmlBot;
}

ERROR on error_log

Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/Pg.pm line 94.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/Pg.pm line 94.
DBD::Pg::st execute failed: ERROR:  general: Permission denied. at
/var/www/html/HABJ/consulta.cgi line 100.
ERROR:  general: Permission denied. at /var/www/html/HABJ/consulta.cgi
line 22.
Database handle destroyed without explicit disconnect.

0
aguztyn
6/19/2001 1:46:37 AM
perl.dbi.users 11085 articles. 1 followers. Follow

3 Replies
3034 Views

Similar Articles

[PageSpeed] 44

See comments below.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Aguztyn Garcia-Cruz" <aguztyn@cancun.com.mx>
To: <dbi-users@perl.org>
Sent: Monday, June 18, 2001 18:46
Subject: HELP, HELP, HELP


> What am I doing WRONG
>
>
>
>
> #!/usr/bin/perl -w
> #
> # Consilta.cgi
> #
>
> push(@INC,"/var/www/cgi-bin/");
>
> require("cgi-lib.pl");

If you have control over cgi-lib.pl, it should probably be a .pm file so you
can 'use' it.  If the reason you are using require() is because cgi-lib.pl
is in /var/www/cgi-bin, you can add that directory to @INC with 'use lib' or
get it added to the webserver's environment in environment variable PERL5LIB
(preferred).

If this is the old cgi-lib module, you shouldn't need it because CGI
provides the same functionality.

> $|=1;
> #use strict;

You should fix whatever is causing 'use strict' to raise errors.  I normally
don't invoke it until after 'use'ing all standard modules, though.

> use DBI;
> use CGI;
>
> sub avisa_y_salte {
>     my $error = "@_";
>     print &PrintHeader;
>
>     print "<h1>Error Inesperado</h1>";
>     print "<p>$error</p>";
>     print &HtmlBot;
>     die $DBI::errstr;

die() writes to STDERR which is going to your webserver's log, not the
webpage you are creating.

>     }
>
> my $version="V.20.01";
> my $registro="<CENTER><H5><I>Consulta Ciudadana $version 2001. <A
> HREF=\"mailto:aoriza\@cancun.gob.mx\">Hayuntamiento Benito
> Juarez.</A></I></H5></CENTER>";
>
>
> if (&ReadParse) {
>     my $query = new CGI;
>     my $dat_nombre = $query->param('dat_nombre');
>     my $dat_apater = $query->param('dat_apater');
>     my $dat_amater = $query->param('dat_amater');
>     my $dat_calle = $query->param('dat_calle');
>     my $dat_sm = $query->param('dat_sm');
>     my $dat_mz = $query->param('dat_mz');
>     my $dat_lt = $query->param('dat_lt');
>     my $dat_edif = $query->param('dat_edif');
>     my $dat_nomint = $query->param('dat_nomint');
>     my $dat_nomext = $query->param('dat_nomext');
>     my $dat_colo = $query->param('dat_colo');
>     my $dat_cp = $query->param('dat_cp');
>     my $dat_mpio = $query->param('dat_mpio');
>     my $dat_ciudad = $query->param('dat_ciud');
>     my $dat_edo = $query->param('dat_edo');
>     my $dat_pais = $query->param('dat_pais');
>     my $dat_tel = $query->param('dat_tel');
>     my $dat_fax = $query->param('dat_fax');
>     my $dat_email = $query->param('dat_email');
>     my $dat_edad = $query->param('dat_edad');
>     my $dat_sexo = $query->param('dat_sexo');
>     #$dat_nombre = $in{'dat_nombre'};
>     #$dat_apater = $in{'dat_apater'};
>     #$dat_amater = $in{'dat_amater'};
>     #$dat_calle = $in{'dat_calle'};
>     #$dat_sm = $in{'dat_sm'};
>     #$dat_mz = $in{'dat_mz'};
>     #$dat_lt = $in{'dat_lt'};
>     #$dat_edif = $in{'dat_edif'};
>     #$dat_nomint = $in{'dat_nomint'};
>     #$dat_nomext = $in{'dat_nomext'};
>     #$dat_colo = $in{'dat_colo'};
>     #$dat_cp = $in{'dat_cp'};
>     #$dat_mpio = $in{'dat_mpio'};
>     #$dat_ciudad = $in{'dat_ciud'};
>     #$dat_edo = $in{'dat_edo'};
>     #$dat_pais = $in{'dat_pais'};
>     #$dat_tel = $in{'dat_tel'};
>     #$dat_fax = $in{'dat_fax'};
>     #$dat_email = $in{'dat_email'};
>     #$dat_edad = $in{'dat_edad'};
>     #$dat_sexo = $in{'dat_sexo'};
>
> if ($dat_nombre eq '')  {
>         print &PrintHeader;
>
>         print "<html>\n";
>         print "<META HTTP-EQUIV=\"Refresh\"
> CONTENT=\"0;URL=http://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\n";
>         print "</html>\n";
> }
>
> # Par�metros para abrir la base de datos
> my $dbmain = 'habj';
> my $dbuser = 'xxxxx';
> my $dbpass = 'xxxxxxxxxx';
> my $data_source = 'DBI:Pg:dbname=$dbmain';
> my ($dbh, $sql, $cursor, $resultado);
> # Nos conectamos a la base de datos
> $dbh = DBI->connect("DBI:Pg:dbname=$dbmain",$dbuser,$dbpass) ||
> avisa_y_salte("No puedo Abrir la Base de Datos");
>
> # Sentencia SQL para hacer la consulta.
> $sql = qq|INSERT INTO general (nombre, apaterno, amaterno, calle, sm,
> mz, lte, edif, noint, noext,
>           col, cp, mpio, city, edo, pais, phone, fax, email, edad, sex)
>           VALUES ('$dat_nombre', '$dat_apater', '$dat_amater',
> '$dat_calle', '$dat_sm', '$dat_mz',
>                   '$dat_lt', '$dat_edif', '$dat_nomint', '$dat_nomext',
> '$dat_colo', '$dat_cp',
>                   '$dat_mpio', '$dat_ciudad', '$dat_edo', '$dat_pais',
> '$dat_tel', '$dat_fax',
>                   '$dat_email', '$dat_edad')|;
> # Hacemos la consulta, en $resultado vienen todos los datos que nos
> interesan
> $cursor = $dbh->prepare($sql) || avisa_y_salte("No puedo Preparar el
> Comando para Grabar");
> $resultado = $cursor->execute || avisa_y_salte("No puedo executar el
> Comando Para Grabar");

Considering how uncontrolled a source you are using, you should _really_ use
placeholders instead of having the user's input pasted directly into the
INSERT statement.

finish() servers no purpose for non-SELECT statements.

> $dbh->finish;
> $dbh->disconnect;
>
> print &PrintHeader;
>
> print "<html>\n";
> print "<META HTTP-EQUIV=\"Refresh\"
> CONTENT=\"0;URL=http://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\n";
> print "</html>\n";
> } else {
>   print &PrintHeader;
>
>   print "<html>\n";
>   print "<META HTTP-EQUIV=\"Refresh\"
> CONTENT=\"0;URL=http://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\n";
>   print "</html>\n";
>   print &HtmlBot;
> }
>
> ERROR on error_log
>
> Use of uninitialized value in subroutine entry at
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/Pg.pm line 94.
> Use of uninitialized value in subroutine entry at
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/Pg.pm line 94.
> DBD::Pg::st execute failed: ERROR:  general: Permission denied. at
> /var/www/html/HABJ/consulta.cgi line 100.
> ERROR:  general: Permission denied. at /var/www/html/HABJ/consulta.cgi
> line 22.
> Database handle destroyed without explicit disconnect.

I don't use Postgresql, so I can't comment directly on the errors you are
getting.  You can look in the source of Pg.pm to see what values might be
uninitialized.

0
mchase
6/19/2001 4:46:29 AM
Date sent:      	Mon, 18 Jun 2001 20:46:37 -0500
From:           	Aguztyn Garcia-Cruz <aguztyn@cancun.com.mx>
Organization:   	Internet Cancun
To:             	dbi-users@perl.org
Subject:        	HELP, HELP, HELP


Aguztyn,

> What am I doing WRONG

I do not know exactly, because I don't use DBD::Pg, but below you call
the finish() method on the  database handle $dbh, which is wrong for sure.=
 
In addition, I have written a tidied verison of your script, so error 
catching could be easier (see below)


> #!/usr/bin/perl -w
> #
> # Consilta.cgi
> #
> 
> push(@INC,"/var/www/cgi-bin/");
> 
> require("cgi-lib.pl");
> 
> $|=3D1;
> #use strict;
> use DBI;
> use CGI;
> 
> sub avisa_y_salte {
>     my $error =3D "@_";
>     print &PrintHeader;
> 
>     print "<h1>Error Inesperado</h1>";
>     print "<p>$error</p>";
>     print &HtmlBot;
>     die $DBI::errstr;
>     }
> 
> my $version=3D"V.20.01";
> my $registro=3D"<CENTER><H5><I>Consulta Ciudadana $version 2001. <A
> HREF=3D\"mailto:aoriza\@cancun.gob.mx\">Hayuntamiento Benito
> Juarez.</A></I></H5></CENTER>";
> 
> 
> if (&ReadParse) {
>     my $query =3D new CGI;
>     my $dat_nombre =3D $query->param('dat_nombre');
>     my $dat_apater =3D $query->param('dat_apater');
>     my $dat_amater =3D $query->param('dat_amater');
>     my $dat_calle =3D $query->param('dat_calle');
>     my $dat_sm =3D $query->param('dat_sm');
>     my $dat_mz =3D $query->param('dat_mz');
>     my $dat_lt =3D $query->param('dat_lt');
>     my $dat_edif =3D $query->param('dat_edif');
>     my $dat_nomint =3D $query->param('dat_nomint');
>     my $dat_nomext =3D $query->param('dat_nomext');
>     my $dat_colo =3D $query->param('dat_colo');
>     my $dat_cp =3D $query->param('dat_cp');
>     my $dat_mpio =3D $query->param('dat_mpio');
>     my $dat_ciudad =3D $query->param('dat_ciud');
>     my $dat_edo =3D $query->param('dat_edo');
>     my $dat_pais =3D $query->param('dat_pais');
>     my $dat_tel =3D $query->param('dat_tel');
>     my $dat_fax =3D $query->param('dat_fax');
>     my $dat_email =3D $query->param('dat_email');
>     my $dat_edad =3D $query->param('dat_edad');
>     my $dat_sexo =3D $query->param('dat_sexo');
>     #$dat_nombre =3D $in{'dat_nombre'};
>     #$dat_apater =3D $in{'dat_apater'};
>     #$dat_amater =3D $in{'dat_amater'};
>     #$dat_calle =3D $in{'dat_calle'};
>     #$dat_sm =3D $in{'dat_sm'};
>     #$dat_mz =3D $in{'dat_mz'};
>     #$dat_lt =3D $in{'dat_lt'};
>     #$dat_edif =3D $in{'dat_edif'};
>     #$dat_nomint =3D $in{'dat_nomint'};
>     #$dat_nomext =3D $in{'dat_nomext'};
>     #$dat_colo =3D $in{'dat_colo'};
>     #$dat_cp =3D $in{'dat_cp'};
>     #$dat_mpio =3D $in{'dat_mpio'};
>     #$dat_ciudad =3D $in{'dat_ciud'};
>     #$dat_edo =3D $in{'dat_edo'};
>     #$dat_pais =3D $in{'dat_pais'};
>     #$dat_tel =3D $in{'dat_tel'};
>     #$dat_fax =3D $in{'dat_fax'};
>     #$dat_email =3D $in{'dat_email'};
>     #$dat_edad =3D $in{'dat_edad'};
>     #$dat_sexo =3D $in{'dat_sexo'};
> 
> if ($dat_nombre eq '')  {
>         print &PrintHeader;
> 
>         print "<html>\n";
>         print "<META HTTP-EQUIV=3D\"Refresh\"
> CONTENT=3D\"0;URL=3Dhttp://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\=
n";
>         print "</html>\n";
> }
> 
> # Par=E1metros para abrir la base de datos
> my $dbmain =3D 'habj';
> my $dbuser =3D 'xxxxx';
> my $dbpass =3D 'xxxxxxxxxx';
> my $data_source =3D 'DBI:Pg:dbname=3D$dbmain';
> my ($dbh, $sql, $cursor, $resultado);
> # Nos conectamos a la base de datos
> $dbh =3D DBI->connect("DBI:Pg:dbname=3D$dbmain",$dbuser,$dbpass) ||
> avisa_y_salte("No puedo Abrir la Base de Datos");
> 
> # Sentencia SQL para hacer la consulta.
> $sql =3D qq|INSERT INTO general (nombre, apaterno, amaterno, calle, sm,
> mz, lte, edif, noint, noext,
>           col, cp, mpio, city, edo, pais, phone, fax, email, edad, sex)
>           VALUES ('$dat_nombre', '$dat_apater', '$dat_amater',
> '$dat_calle', '$dat_sm', '$dat_mz',
>                   '$dat_lt', '$dat_edif', '$dat_nomint', '$dat_nomext',
> '$dat_colo', '$dat_cp',
>                   '$dat_mpio', '$dat_ciudad', '$dat_edo', '$dat_pais',
> '$dat_tel', '$dat_fax',
>                   '$dat_email', '$dat_edad')|;
> # Hacemos la consulta, en $resultado vienen todos los datos que nos
> interesan
> $cursor =3D $dbh->prepare($sql) || avisa_y_salte("No puedo Preparar el
> Comando para Grabar");
> $resultado =3D $cursor->execute || avisa_y_salte("No puedo executar el
> Comando Para Grabar");
> 
> $dbh->finish;
> $dbh->disconnect;
> 
> print &PrintHeader;
> 
> print "<html>\n";
> print "<META HTTP-EQUIV=3D\"Refresh\"
> CONTENT=3D\"0;URL=3Dhttp://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\=
n";
> print "</html>\n";
> } else {
>   print &PrintHeader;
> 
>   print "<html>\n";
>   print "<META HTTP-EQUIV=3D\"Refresh\"
> CONTENT=3D\"0;URL=3Dhttp://agustin.cancun.com.mx/HABJ/f_servicio.htm\">\=
n";
>   print "</html>\n";
>   print &HtmlBot;
> }
> 
> ERROR on error_log
> 
> Use of uninitialized value in subroutine entry at
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/Pg.pm line 94.
> Use of uninitialized value in subroutine entry at
> /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/Pg.pm line 94.
> DBD::Pg::st execute failed: ERROR:  general: Permission denied. at
> /var/www/html/HABJ/consulta.cgi line 100.
> ERROR:  general: Permission denied. at /var/www/html/HABJ/consulta.cgi
> line 22.
> Database handle destroyed without explicit disconnect.

Here's a tidied version. I guess that you just want to insert the 
form data into the table general and promt the user the starting page 
afterwards.

<perl_code>

#!/usr/bin/perl

use warnings;
use strict;
use vars;
use DBI;
use CGI;
# the next line will redirect (most) errors from the server's log to 
the browser
use CGI::Carp qw(fatalsToBrowser);
|$ =3D 1;

my $query =3D new CGI;

### if the user provides a number...

if ($query->param('dat_nombre')) {
	
	### generate an array with your table's columns

	my @columns =3D qw(
                     dat_nombre
                     dat_apater
                     dat_amater
                     dat_calle
                     dat_sm
                     dat_mz
                     dat_lt
                     dat_edif
                     dat_nomint
                     dat_nomext
                     dat_colo
                     dat_cp
                     dat_mpio
                     dat_ciud
                     dat_edo
                     dat_pais
                     dat_tel
                     dat_fax
                     dat_email
                     dat_edad
                     dat_sexo);
	
	### stuff the form values into an array using
	### the columns array as argument source for
	### the query object's param() method. The values
	### array will hold the form values in the same order
	### as the respective fields appear in the columns array.
	
	my @values =3D map {$query->param($_)} @columns;

	### Generate your sql statement with placeholders

	my $sql =3D "INSERT INTO general (" . 
				join(', ', @columns) . 
				") VALUES (" . 
				join(', ',  map {'?'} @columns) . 
				")";
	
	### and now the DBI routine stuff
	
	my $dbmain =3D 'habj';
	my $dbuser =3D 'xxxxx';
	my $dbpass =3D 'xxxxxxxxxx';
	my $data_source =3D 'DBI:Pg:dbname=3D$dbmain';
	my $dbh =3D DBI->connect("DBI:Pg:dbname=3D$dbmain",$dbuser,$dbpass, {Rais=
eError =3D> 1}) or die "No puedo Abrir la Base de Datos: " . DBI::errstr;
	my $cursor =3D $dbh->prepare($sql);
	$cursor->execute(@values);
	$dbh->disconnect;
}

### redirect the user to you service page

print $query->redirect('http://agustin.cancun.com.mx/HABJ/f_servicio.htm')=
;


</perl_code>

Although I am not sure if this solves your problem, this version is 
compact enough for easy debugging. Being on windows, unfortunately i 
can not test this script, but it compiles at least...

HTH

Bodo
eingb@uni-muenster.de

0
eingb
6/19/2001 10:31:42 AM
From:           	"Bodo Eing" <eingb@uni-muenster.de>
To:             	dbi-users@perl.org, Aguztyn Garcia-Cruz <aguztyn@cancun.com.mx>
Date sent:      	Tue, 19 Jun 2001 12:31:42 +0200
Subject:        	Re: HELP, HELP, HELP
Priority:       	normal


 Aguztyn,
> 
> > What am I doing WRONG
> 
> I do not know exactly, because I don't use DBD::Pg, but below you call
> the finish() method on the  database handle $dbh, which is wrong for sure. 
> In addition, I have written a tidied verison of your script, so error 
> catching could be easier (see below)

found a typo in this version, sorry

....snip...
> 
> <perl_code>
> 
> #!/usr/bin/perl
> 
> use warnings;
> use strict;
> use vars;
> use DBI;
> use CGI;
> # the next line will redirect (most) errors from the server's log to 
> the browser
> use CGI::Carp qw(fatalsToBrowser);
> |$ = 1;
  ^^

this should read

$| = 1;

of course.


>... snip ...

Bodo
eingb@uni-muenster.de
 


Dr. med. Bodo Eing
Institut fuer Medizinische Mikrobiologie
Klinische Virologie
v.-Stauffenbergstr. 36
48151 Muenster
Germany

Phone: ++49 251 7793 111 Fax: ++49 251 7793-104
0
eingb
6/19/2001 10:45:27 AM
Reply:

Similar Artilces:

HELP!HELP!HELP!HELP!HELP!HELP!
I was using powerbuilder4.0 a month ago I decided that migrate it to PB7.0 When Im using 4.0, in datawindows I was using extra colums additional to stores procedure. I mean that for example; stored proc. returns 4 columns. I was using 2 extra columns to modify something from client. But I cant do the same thing in PB7.0. How can I do that??? please help. Gurcan yucel gyucel@infina.com.tr "I was using 2 extra columns to modify something from client." what does this mean that you added to the result set? If so then just goto the SQL and add a param. Then set the...

Help Help Help Help Help Help
------=_NextPart_000_0074_01C2960E.EBE13A30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Can someone please help me. I have installed mysql on Unix Solaris and it works fine I have Perl installed previously which is working and with which i have installed other perlmodules before and are working fine. I have also installed DBI and it works fine with the Sybase drivers which i have installed. When i tried to install the Msql-Mysql-modules-1.2219 drivers i get the following error. # make /usr/local/bin/perl -Iblib/arch -Iblib/lib -I/...

Help Help Help Help
i need to create a crosstab report using Crystal reprot for VS 2003 i face aproblem when i need to order my Fileds by their names my data must be like this Basic Cola Housing Gross Deduction1 Deduction2 Deduction3 Net but when i run my report it give my a not sorted data acutally i have acode field which can i order field using it. but i don't knwo how to do thisSo..................? Select Report tab | |-->Select Record Sort expert Choost the fields you want to sort --Select the corresponding sort direction f...

help help help help
Name: chef mario Email: chefusa_at_pacbell.net Product: Firefox Summary: help help help help Comments: Heard great reports about Firefox!!! Downloaded & installed Firefox !!!! Lost All my very very valuable BOOKMARKS!!! CAN ANYONE HELP!!!!! All bookmarks were in Internet Explorer Did bookmark transfer to Firefox. Seem the Fox eat all m,y bookmarks Need serious help anyone. chef mario Browser Details: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8) Gecko/20051025 Firefox/1.5 ...

help!help!help!
Sorry to re-post again, Hi, Dean : 1. Are you dialing an ISP or dialing modem pool in side the company? I am dailing an ISP. Because some of my client use this way. 2. Is the Jag server behind a firewall? No, there is no Firwall. 3. Do you have a proxy for the remote component? Yes. 4. What is the syntax of createinstance? ls_class = "p_packagename/n_cst_logon" if not isvalid(inv_logon) then ll_return = g_connect.CreateInstance(inv_logon,ls_class) if ll_return <> 0 then ls_return = ...

help help help
i wanna know the list of compite time errors related to code correction/programming errors in powerbuilder.thanks lot cenk That's a pretty big request. You want a list of everything it is possible to do wrong in PowerBuilder? What you might want to do is search the solved cases infobase on the Sybase web site. On Tue, 15 Jun 1999 11:50:32 +0300, in powersoft.public.powerbuilder.general cenk KIZILDAG <cenk1536@yahoo.com> wrote: >i wanna know the list of compite time errors related to code >correction/programming errors in powerbuilder.thanks lot > >c...

HELP!!!HELP!!!HELP!!!
I try set picture to database and import it to picture control. Why SetPicture funktio dosen�t work? blob b, tot_b integer li_FileNum, loops, i, ret long flen, bytes_read, new_pos string txtname, named string defext = "BMP", Filter = "bitmap Files (*.bmp), *.bmp" ret = GetFileOpenName("Open Bitmap", txtname, named, defext, filter) SetPointer(HourGlass!) flen = FileLength(txtname) li_FileNum = FileOpen(txtname, StreamMode!, Read!, LockRead!) IF flen > 32765 THEN IF Mod(flen, 32765) = 0 THEN loops = flen/32765 ELSE loops = (flen/32765...

Help, help help
This is a multipart message in MIME format. --=_alternative 005C87C886257037_= Content-Type: text/plain; charset="US-ASCII" I did a Mysqldump for backing up and how I got this error. Anyone know why? Software error: DBD::mysql::st execute failed: Unknown column 'mimetype' in 'field list' [for Statement " SELECT attach_id, DATE_FORMAT(creation_ts, '%Y.%m.%d %H:%i'), mimetype, description, ispatch, isobsolete, isprivate, submitter_id, LENGTH(thedata) FROM attachments WHERE bug_id = 41 OR...

HELP HELP HELP
Hi again: Just tested my first test and proceeded to test and install a second time. This time I let the server run the update after registering with Novell. However, upon reboot the server was dorked as it could not read my /usr and /var partitions (fstab was bad). Now here is what changed between my first the second build: I added a separate partition for /usr, that is all. I could really use a hand here. If I can't trust the update mechanism ...... Chris. Chris wrote: > Hi again: Just tested my first test and proceeded to test > and install a second...

HELP HELP HELP
I need EAS 3.0.1 mantainance as soon as possible or at least an updated datawindow.jar. I've already asked the mantainance CD to italian Sybase support but they know nothing about it. If someone from sybase could send me an updated datawindow.jar would be very very appreciated. Please email me to m.mazza@ads.it Thank you Mauro Mazza Research & Develop - Gruppo FINMATICA E-mail: m.mazza@ads.it http://www.ads.it ADS automated data systems - Data Processing S.p.A. Via Del Lavoro, 17 40127 Bologna - Italy tel. +39 051 6307 411 fax. +39 051 6307 498 We expect t...

Help! Help! Help
Help! I am using the HttWebRequest classrooms and HttWebResponse and when I execute my application for the second time of the this error: A potentially dangerous Request.Form value was detected from the client (TextBox1="<!DOCTYPE HTML PUBLI..."). this is my codes: Dim req As System.Net.HttpWebRequest Dim res As System.Net.HttpWebResponse Dim sr As System.IO.StreamReader Dim s As System.IO.Stream Dim b As Byte() req = System.Net.WebRequest.Create("http://www.page.com") b = ...

help help help
after i unload., theni install adaptaive server.......everythings running well but unluckily it cannot start the adaptive server when installing but backupserver and XP server can install and start it Building Adaptive Server "abc", unable to boot server "abc" server "abc" was not connected anyone can help me Was an errorlog created for this ASE in the ASE install directory? If so, what does it say? Zidane wrote: > after i unload., theni install adaptaive server.......everythings running > well > but unluckily it cannot st...

HELP, HELP, HELP!!!!
can't Install dbd for postgreSQL someboy can help, Me How about some code. Do you have the DBD::pg installed? Send in you code so we can help. Ilya Sterin -----Original Message----- From: aguztyn@cancun.com.mx [mailto:aguztyn@cancun.com.mx] Sent: Monday, April 02, 2001 4:45 PM To: dbi-users@perl.org Subject: HELP, HELP, HELP!!!! can't Install dbd for postgreSQL someboy can help, Me ...

help! help! help!
I got such errors while installing a new replication server,please help me !Thanks a lot. T. 2003/05/29 14:21:24. (-1): Hardware Exception: c0000005, EXCEPTION_ACCESS_VIOLATION T. 2003/05/29 14:21:24. (-1): Thread GLOBAL RS(GLOBAL RS) infected with signal -1073741819 T. 2003/05/29 14:21:24. (-1): ***************STACK TRACE*************** T. 2003/05/29 14:21:24. (-1): *****thread GLOBAL RS(GLOBAL RS)******* T. 2003/05/29 14:21:24. (-1): unknown function 0x0038c559 () T. 2003/05/29 14:21:24. (-1): unknown function 0x0038bb65 () T. 2003/05/29 14:21:24. (-1): pc: 0x00468934, err_h...

Help Help Help
How to send a form data to mail by onclick action of Submit button. By using vbscript (using ADODB) in ASP Try this page: http://www.systemnetmail.com/faq/3.4.1.aspx I have found a lot of help from it.Click on 'Mark as Answer' if this post is helpful.-- Randy...

Help!help!help!
Whether can I set a window to be unmoveable when the application is run,whatever the window is normal or max when it's running?If it may be set,how.... ...

Help Me,Help,Help ^^^^^^^^^^^
How to use Procedure in web matrix? Can somebody help me ? Thanks each's help Hi Kandy, You can try the Data Pages Template to use "Procedure" (I assume Procedure you mean is "Stored Procedure") Add New File | Template (Data Page) | Simple Stored Procedure Regards, Yes , I mean Stored Procedure, I found Add New File | Template (Data Page) | Simple Stored Procedure Thank you very much,Thanks a lot (I come from China, my English is poor , sorry~~~~)...

HELP HELP HELP
i need help, i use an dbmaker 3.0 server and now i want to use an client to go on it but i dont have an client(i have dbmaker 3.6 but it don't work) who can help me with the dbmaker 3.0 client (tools,files,drivers) email me kelly.kloen@siteways.nl ...

help... help... help....??????
I have this datatable , and i binded it to a datagrid with check box for delete ,but i have a problem with delete code for the datagrid : 'this is the datatable Sub cart() Dim objDT As DataTable Dim objDR As DataRow objDT = New System.Data.DataTable() objDT.Columns.Add("ProductID") objDT.Columns.Add("name") objDT.Columns.Add("cost") objDT.Columns.Add("quantity") ' objDT.Columns.Add("check") 'first row objDR = objDT.NewRow() ...

help help help
Name: bryon Email: bryonbattampabaydotrrdotcom Product: Thunderbird Summary: help help help Comments: why can't i go into the address book and create a new contact with all the information. the screen does not scroll down to the phone numbers section to allow me to enter it, this is with a few of the application that wont allow me to scroll down and finish inserting information needed. please help Browser Details: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9 ...

HELP HELP HELP
Hey all I ahve absolutely no idea where to start with DotNETNuke. I have downloaded and installed DNN3.2.2 and I now want to start creating my website with the help of DNN. I'm using .NET framework 1.1 and Visual Studio 2003. How do I go about starting a new webpage and using the DNN functionality to make manage my content?Thank you Have you installed DNN, yet? Either way, download the docs and go over the ones that you need help with. That's the best place to start. You can also find tutorials online that might be helpful.Michael Flanakin | Microsoft Consulting Serviceswww.michaelflanakin...

substr (help,help,help);
Hello, I am trying to pull a piece of text out of some html source. I am using the following, but the result is confusing me. open (SOURCE, "< $filename"); while (<SOURCE>){ if (m/\/nic\/login/){ substr ($_,28,4); print; } } The result is : <small>(<a href="/nic/login">Login</a>)</small></p> I would like to just get the word "Login" portion itself <snipped source> <tr><td> <p align="center">Not Logged In<br> ...

Help Help Help #2
I have created two transaction objects, one source and one destination, I have also created a pipeline object between the source and destination databases. Some of the fields in the source database contain blank spaces for values; after a successful pipeline the destination database fields that should contain spaces are now NULL. My PowerBuilder version is 7.0.3, my Sybase version is 6.0.4. Is this a simple setting change? Thank you in advance... I'm not sure if this is related or not, but, I've discovered what I think is a major bug in PB in that when a dw retrieves ...

Help! Help!!
Hi, Sybase adaptive IQ12 does not support multi-column primary key , It says we can create a stored procedure to check insertions into all primary key column, so that the combined columns would always produce a unique value. I am using LOAD TABLE statement to load a large number data from text format into a table with multi-column primary key. Could anyone help me how to write a procedure to enforce data integrity. Thanks ...

Web resources about - HELP, HELP, HELP - perl.dbi.users

Help - Wikipedia, the free encyclopedia
United States Senate Committee on Health, Education, Labor and Pensions , commonly abbreviated "H.E.L.P." Text is available under the Creative ...

Help:Contents - Wikipedia, the free encyclopedia
Templates are special pages that contain boilerplate text intended to be displayed on more than one page in Wikipedia. This Tip of the day box ...

'We have the same God': A priest helps Syrian refugees
In a Greek village at the heart of the refugee crisis, Father Schuff calls on priests and monasteries to do more.

Help Junior fight off the undead in Jr’s Mad Dash
... iOS 9 or later. You can buy the game for $0.99 on the App Store, without worrying about ads or in-app purchases. Jr's Mad Dash Help Junior ...

Feds to court: Apple must be forced to help us unlock seized iPhone
(credit: Kārlis Dambrāns ) On Friday, prosecutors asked a federal court in Riverside, California to force Apple to comply with a court order ...

Poll: Should Apple help the FBI unlock the San Bernardino iPhone?
The US courts say Apple should help the FBI access the contents of an iPhone belonging to one of the San Bernardino shooters, but Apple is refusing, ...

Alan Grayson is a Superdelegate. Help him decide — Clinton or Sanders? by @Gaius_Publius
Alan Grayson is a Superdelegate. Help him decide — Clinton or Sanders? by Gaius Publius It's coming from the feel That this ain't exactly real ...

A startup that wants to help big retailers battle coupon sites like RetailMeNot raises $875,000 from ...
... Justin Chapman think they've been building the solution for stores. Their startup, Thrive Ecommerce, has a suite of enterprise tools to help ...

"Please help me": 12-year-old shot while playing tag in Chicago
Police say boy was on the sidewalk near his home when a red SUV pulled up, and someone inside fired shots at him

Robert Downey Jr. helps make a boy’s superhero wish come true
I always wanted to believe that Robert Downey Jr. was a nice guy and now I have some concrete proof. The actor, soon to be reprising his role ...

Resources last updated: 2/20/2016 11:56:01 AM