want to verify the data coming from a form with the data in database

2003-06-09 Thread Annie
i have a perl file which is receiving the data from a form...and i want to verify the two fields $a2 and $a1 i m receiving from form to be checked in a table in database( using mysql)...and then if the data is verified in any of the row of the tablethe corresponding whole row data should be

Re: Inserting data into MySql using perl script

2003-06-09 Thread Roberto Ruiz
Hi, On Mon, Jun 09, 2003 at 04:49:41PM -0700, Nazary, David wrote: > > I am unable to insert data into MySql with following script: > > #!/usr/bin/perl > use DBI; > use Mysql; Not needed, you may comment it out. > $infile = "/cadfs8/sys/dnazary/mysql_test_data1"; > $dbh = DBI ->connect('DBI:m

Re: function/module to check if visitors have their cookies enabled

2003-06-09 Thread Octavian Rasnita
You need to set the cookie in a page, then refresh the page to display another one and in the second page you can check if that cookie was set or not. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: "Ahrent" <[EMAIL PROTECTED]> To: <[EMAIL P

Inserting data into MySql using perl script

2003-06-09 Thread Nazary, David
Hi, I am unable to insert data into MySql with following script: #!/usr/bin/perl use DBI; use Mysql; $infile = "/cadfs8/sys/dnazary/mysql_test_data1"; $dbh = DBI ->connect('DBI:mysql:dnazary_test:localhost', 'root', 'mysql'); open (IFH, $infile) or die ("Could not open input file."); foreach ()

Re: Simple character replace problem

2003-06-09 Thread drieux
On Monday, Jun 9, 2003, at 13:05 US/Pacific, steve ryan wrote: [..] So... i do my hex to ascii translation first, and the character replace second. so simple. AARRRGH! :) Huzzah! Welcome on the BigBus!!! Those who have headBashed in public that DuhMoment There is always this ungainly probl

Re: Simple character replace problem

2003-06-09 Thread steve ryan
Thanks everyone for your help. I actually figured it out myself - spaces get sent as "+" in a CGI form commas get sent in their hex equivalent in a CGI form so... i needed to convert my commas from their hex to their ascii equiv first, and then do a character replace on both the plus and comma s

Re: Strategies for Internationalizing - Re: Targeting two frames from one CGI - Spoke too Soon!

2003-06-09 Thread Greenhalgh David
[1] For fun, you may wish to get into the LWP::UserAgent and build a small 'browser' to 'fetch web pages' since that may help understand the 'advantages' and disadvantages of page fetching... I see prospects for sleep disappearing into fluffy pink sunsets...must check the difference betwee

Re: Simple character replace problem

2003-06-09 Thread Kristofer Hoch
Also, Maybe you may want to try using CGI.pm to get query strings. == use strict; use CGI; my $cgiObject = new CGI; my @params = $cgiObject->params(); foreach my $paramKey (@params){ print "Param: $paramKey = " . $cgiObject->param($paramKey); } == That may h

Re: Simple character replace problem

2003-06-09 Thread drieux
On Sunday, Jun 8, 2003, at 15:38 US/Pacific, steve ryan wrote: [..] The problem is - 1. My "+" symbols are not being replaced (i.e. the spaces in the form) 2. My HEX/Ascii conversion isn't working (i.e. i am getting things like %2C) [..] steve, First off, I do so try to avoid using "\n" and "\

Strategies for Internationalizing - Re: Targeting two frames from one CGI - Spoke too Soon!

2003-06-09 Thread drieux
On Sunday, Jun 8, 2003, at 11:16 US/Pacific, Greenhalgh David wrote: [..] This isn't foolproof, unfortunately. A large part of the target audience is English (or other) speakers in Japan. Unless they've manually set the preferences in their browsers, they will show up as asking for the Japanese