Deleting rows using checkboxes and PostgreSQL

2001-07-08 Thread Daniel Falkenberg
List, I have come accross a slightly large hurdle in one of my perl scripts. Basically I have a list that prints out some *crud* from a PostgreSQL table. Each row has a checkbox located next to it. I want to be able to have the user select as many of these check boxes as they desire and then pre

Re: newbie question

2001-07-08 Thread nila devaraj
Hi Thank you for your mail. the code is #testcgi.cgi print "Content-type: text/html\n\n"; print "Hello World\n"; This is WinCGI. should i have to give the Shebang operator? Should i have Perl installed in the server where the Webserver is configured? If so, how will i give the shebang operat

Re: SQL problem...

2001-07-08 Thread Susanne
if you are trying to modify records that already exist you need to use UPDATE instead. insert is for adding new records, in which case the WHERE portion of the statement is not applicable. On Mon, 9 Jul 2001, Daniel Falkenberg wrote: > List, > > Below is my sub where I want to INSERT the follo

SQL problem...

2001-07-08 Thread Daniel Falkenberg
List, Below is my sub where I want to INSERT the following values into a PostgreSQL database that contatins a row that needs some entries updated. Can any one see a problem with the following code? sub complete_final{ my $status = 'COMPLETE'; my $sth = $dbh ->prepare( qq{ INSERT INTO

Re: Required Fields Module

2001-07-08 Thread Jason Purdy
Oops - found another little tweak - it should be $formHandle->param instead of $formHandle->keywords (unless your form is using an search). Sorry 'bout that... Jason - Original Message - From: "Jason Purdy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday

Re: Required Fields Module

2001-07-08 Thread Jason Purdy
Excellent points - Thanks for pointing them out! I'll check out your tutorial soon (took a quick glance earlier this afternoon and it looks very thorough, and a good read! Thanks! :)). I forgot the print $query->header part of the code. I also updated the code to accept '0' values by grepping

Re: Required Fields Module

2001-07-08 Thread fliptop
Jason Purdy wrote: > > > Example Hash: > %requiredFields = ( > 'upload_file' => 'Document Source', > 'doc_url||docfile'=> 'Specify either Document URL or Document File', > 'capture_date' => 'Capture Date'

Re: File name problem

2001-07-08 Thread Kamelia Popova
At 21:08 07.7.2001 'ã.' +0400, you wrote: >Hello from Russia > > >How can I set a name for some file? Here is some code from my script. > > >sub set_cyk3{ >my $name=join("",@_); >$name="date/$name"; >my $c_a="val1=$value1,val2=$value2"; >my $cookie=cookie(-name=>'something', >-value=>"$c_a", >-exp