Re[4]: Re-direct/Refresh question

2002-05-02 Thread Jason Ostrom
Adam, Thanks for your help. This is exactly what I was looking for. I found the answer at this URL on how to refresh by modifying the header with the object-oriented interface: http://www.esec.com.au/sep/content/eps_support/demo/perlcgi/cgi_module.html All the best, -Jason Adam Morton> Actual

Re: Re[2]: Re-direct/Refresh question

2002-05-02 Thread Adam Morton
Actually, if that is what you want to do, then you don't want to use the redirect header (whi is what CGI::redirect generates). A redirect header will make the browser go to a different location from the requesed location without actually ever loading any html into the browser. If you just want

Re: Re-direct/Refresh question

2002-05-02 Thread Adam Morton
Perhaps you just want to use $q->redirect() ? - Original Message - From: "Jason Ostrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 5:02 PM Subject: Re-direct/Refresh question > Is there a more efficient way to do page re-directs / refreshes with > CGI.pm?

Re-direct/Refresh question

2002-05-02 Thread Jason Ostrom
Is there a more efficient way to do page re-directs / refreshes with CGI.pm? I've searched all over, and can't find the answer. Like if I'm trying to re-create this HTML: Blah BlahRefresh Test I use CGI.pm with the object-oriented interface, and I can't figure out how to put that re

This is what I am doing to connect toa database :

2002-05-02 Thread Kamali Muthukrishnan
This is what I am doing to connect toa database : #Windows-based Perl/DBI/MS Access access use DBI; #open connection to Access database $dbh = DBI->connect('dbi:ODBC:MSMuseum'); #prepare and execute SQL statement $sqlstatement="SELECT * FROM Product"; $sth = $dbh->prepare($sqlstatement);

Re: query about empty return value from SELECT

2002-05-02 Thread fliptop
drieux wrote: > > if you are trying to make sure that you have packed up the > message correctly before pushing it into the mess - then > you might want to do something like > > my $msg = "select distinct X from Y where P=\'$pVal\'"; > > so that we can verify that the SQL is 'kosher' and w

Re: query about empty return value from SELECT

2002-05-02 Thread drieux
On Thursday, May 2, 2002, at 11:29 , Aman Raheja wrote: > My code looks like following > > foreach (@abc) > { > $sth = $dbh->prepare("select distinct X from Y where P='$_'"); > $sth->execute; > $reference = $sth->fetchall_arrayref(); > > if(@$reference eq '') > { > print "$_ in em

OT: Cross-Posting (was: query about empty return value from SELECT)

2002-05-02 Thread Nikola Janceski
How is this a CGI related question? It's not. This is strictly a perl beginner question. I am sorry Aman for using your e-mail as an example. Cross-posting is annoying to many of us that are subscribed to several of these similar lists. If you absolutely feel it is necessary to cross-post for som

query about empty return value from SELECT

2002-05-02 Thread Aman Raheja
My code looks like following foreach (@abc) { $sth = $dbh->prepare("select distinct X from Y where P='$_'"); $sth->execute; $reference = $sth->fetchall_arrayref(); if(@$reference eq '') { print "$_ in empty"; } } For some values of $_ the $reference has some value and i

Re: $_ and while stmt

2002-05-02 Thread drieux
On Wednesday, May 1, 2002, at 04:35 , Teresa Raymond wrote: > I'm trying to test @inlocation to make sure it is not null or filled in > with a space but although I input via ckbox a value, the error msg is > returned. I am not comfortable using the while or the $_. > > while (length @inlocati