Re: database execute status

2002-08-30 Thread Wiggins d'Anconia
From > perldoc DBI $rc = $h->err; $str = $h->errstr; $rv = $h->state; You should look at the docs for DBI, error handling is described in detail. That should get you started http://danconia.org aman cgiperl wrote: > Hi All > Is there a way to check the s

update.cgi

2002-08-30 Thread Jimmy George
Hello Steve I have lousy success with the $q cgi system as well. I will watch the replies for all the good ideas. Good luck mate JimmyG -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: encryption

2002-08-30 Thread Wiggins d'Anconia
zentara wrote: > On Fri, 30 Aug 2002 10:32:27 +1000, [EMAIL PROTECTED] (Jimmy > George) wrote: > > >>Is there any way of encrypting a credit card number etc. so that it can >>not be seen when being transmitted from desktop to server? The user >>needs to see what they type to make sure it is co

database execute status

2002-08-30 Thread aman cgiperl
Hi All Is there a way to check the status of $sth->execute; to check if it successfully executed. Also if I pass on a query to a mysql database using perl's DBI, and suppose it runs into error, how can I capture that error. Thank you Aman

Re: database connection problem

2002-08-30 Thread Felix Geerinckx
on Fri, 30 Aug 2002 16:46:08 GMT, Aman Cgiperl wrote: > 12 my $dth = DBI->connect("DBI:mysql:db_name","user","pass"); > 26 my $sth_check = dth->prepare("SELECT * FROM mytab WHERE ^ Try $dth->prepare(...); ^ -- felix -- To unsubscribe,

RE: database connection problem

2002-08-30 Thread Greg Smith
Try adding the hostname of the MySQL to your connect string. my $dth = DBI->connect("DBI:mysql:database=db_name;host=hostname","user","pass"); Greg > -Original Message- > From: aman cgiperl [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 10:46 AM > To: [EMAIL PROTECTED] > Su

database connection problem

2002-08-30 Thread aman cgiperl
Hello everyone I am doing the following - 1 #!/usr/bin/perl 2 3 use strict; 4 use CGI qw(:standard); 5 use CGI::Carp qw(fatalsToBrowser); 6 use DBI; 7 8 print header; 9 print start_html(); 10 $s = 'ama

RE: Redirect and cookies

2002-08-30 Thread Bob Showalter
> -Original Message- > From: Alex Agerholm [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 5:01 AM > To: [EMAIL PROTECTED] > Subject: Redirect and cookies > > > Hi all, > > I have a problem with redirect. > I have made a login system and when the user has logged in > correct

Re: Error: requires explicit package name

2002-08-30 Thread t
Felix Thanks! That was just what i needed:) thia --- Felix Geerinckx <[EMAIL PROTECTED]> wrote: > on Fri, 30 Aug 2002 13:58:47 GMT, [EMAIL PROTECTED] (T) wrote: > > > "Global symbol "$auto" requires explicit package name" > > [...] > > > if ($Country eq "Argentina") > > {my

Re: sorting arrays of arrays

2002-08-30 Thread Felix Geerinckx
on Fri, 30 Aug 2002 14:29:40 GMT, [EMAIL PROTECTED] (Alex B.) wrote: > 1. how do I assign new dynamic arrays, like @a25 if there is 25 > rows? or lets say there is 78 rows, then I don't really want to > type "my @a00 = ();" through "my @a77 = ();" using the strict > module... is there a way of so

sorting arrays of arrays

2002-08-30 Thread Alex B.
Hello pplz, I have this tiny project goin', where I scan a html-file, get all entries from out of the table and and every single - table row - into an array... well, I do have two problems: 1. how do I assign new dynamic arrays, like @a25 if there is 25 rows? or lets say there is 78 rows, the

Re: Error: requires explicit package name

2002-08-30 Thread Felix Geerinckx
on Fri, 30 Aug 2002 13:58:47 GMT, [EMAIL PROTECTED] (T) wrote: > "Global symbol "$auto" requires explicit package name" [...] > if ($Country eq "Argentina") > {my $auto = $q->param( '[EMAIL PROTECTED]' ); > } > and > if ($Country eq "Argentina") > {$auto = $q->pa

Error: requires explicit package name

2002-08-30 Thread t
Hello:) i am working on a script and have come across a problem. if i call a variable from the preceeding form, it works correctly, BUT, if i declare a variable within the script, then try to use it as the "To:" fiels in an e-mail, it tells me that "Global symbol "$auto" requires explicit

Re: Redirect and cookies

2002-08-30 Thread zentara
On Fri, 30 Aug 2002 11:01:08 +0200, [EMAIL PROTECTED] (Alex Agerholm) wrote: >Hi all, > >I have a problem with redirect. >I have made a login system and when the user has logged in correctly I set a >cookie and redirects the user to the first page. >But on all pages (including the first one) I ma

Re: encryption

2002-08-30 Thread zentara
On Fri, 30 Aug 2002 10:32:27 +1000, [EMAIL PROTECTED] (Jimmy George) wrote: >Is there any way of encrypting a credit card number etc. so that it can >not be seen when being transmitted from desktop to server? The user >needs to see what they type to make sure it is correct - so how do we >get cgi

Re: Application Design for User Authentication

2002-08-30 Thread doug
I don't believe these considerations represent actual risks of using web-server based authentication (.htaccess files). - Once a user is authenticated, the script can still tell who they are, and assume roles based on that information. - There are many scripts out there that can manage NCSA/Ap

Re: encryption

2002-08-30 Thread fliptop
On Fri, 30 Aug 2002 at 10:32, Jimmy George opined: JG:Is there any way of encrypting a credit card number etc. so that it can JG:not be seen when being transmitted from desktop to server? The user JG:needs to see what they type to make sure it is correct - so how do we JG:get cgi to encrypt that

Redirect and cookies

2002-08-30 Thread Alex Agerholm
Hi all, I have a problem with redirect. I have made a login system and when the user has logged in correctly I set a cookie and redirects the user to the first page. But on all pages (including the first one) I make a check to see if the user is logged in based on the cookie. When I redirect fro

Re: Application Design for User Authentication

2002-08-30 Thread Gfoo
> > you have ruled out using .htaccess for some reason? > > > ciao > drieux > > --- > > I don't want to use .htaccess, because: - there are scripts that their actions depend on the role of the user that executes them. For example there is a script all users can execute it, but its outpu

Re: SSI calls

2002-08-30 Thread Nitish Bezzala
Try escaping the double quotes with a backslash print DATAFILE ("The file was recorded at "); "Jimmy George" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello World > > Is the line > > print DATAFILE ("The file was recorded at "); > > a valid cgi line? Al

encryption

2002-08-30 Thread Jimmy George
Hello world Is there any way of encrypting a credit card number etc. so that it can not be seen when being transmitted from desktop to server? The user needs to see what they type to make sure it is correct - so how do we get cgi to encrypt that at the user end before transmission. I have read s

SSI calls

2002-08-30 Thread Jimmy George
Hello World Is the line print DATAFILE ("The file was recorded at "); a valid cgi line? All I want to do is record the time a cgi script is called that writes other form data to a file but the server objects to this line. The rest of the form goes into DATAFILE OK. Is it because of the use of