Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
Subject: Re: Perl code Solved - renaming a file for upload

Subject: Re: Perl code Solved - renaming a file for upload

2007-09-28       - By Greg Meckes

 Back
Ah, next time include all the code!


--- Douglas Brantz <brantzdr@(protected)> wrote:

> Got it worked out - thanks - it was in another part of the code -
>
> $CGI::POST_MAX = 1024 * 2;
> Get_Names();
> sub Get_Names{
> my $counter=0;
> my $full_name;
> my $file_name;
> foreach $full_name (@(protected)){
> my $rec={};
> if ($full_name ne ""){
> $file_name = Get_File_Name($full_name);
> $file_name = "$p$file_name"; <-- ---- ------ Added this line and it
> works now
> $rec->{file_name} = $file_name;
> $rec->{full_name} = $full_name;
> $rec->{description} = $Descriptions[$counter];
> push @(protected), $rec;
> Store_File($full_name, $file_name);
> }
> $counter++;
> }
> }
>
>
> Greg Meckes wrote:
> > You certainly could use rename. You would have to use it after because the
file would have to
> > exist first to be able to rename it.
> >
> > Greg
> > --- Douglas Brantz <brantzdr@(protected)> wrote:
> >
> >  
> >> Should I use the rename function before the file is uploaded or after? -
> >>  I'm not sure if I can change the name of the file before its uploaded -
> >> it seems I might have to change it on the server after the upload?
> >> Modified script below -
> >>
> >> Thanks in advance -
> >>
> >>
> >>
> >> Douglas Brantz wrote:
> >>    
> >>> That didn't seem to work - still uploads file with original name. In
> >>> the example I upload 1 file and form# 405 is added to the beginning of
> >>> the file name for Mysql -
> >>> below the list you see the File that is getting uploaded.
> >>>
> >>> current: 405File1faapage.pdf
> >>> proposed:
> >>> syll1:
> >>> syll2:
> >>> csheet:
> >>> psheet:
> >>>
> >>> File being uploaded: File1faapage.pdf
> >>>
> >>> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
-- ---- ------
> >>>
> >>>
> >>> Greg Meckes wrote:
> >>>      
> >>>> Couldn't you just say?:
> >>>>
> >>>> open (STORAGE, ">$dir/$p$file_name")
> >>>>
> >>>>
> >>>>
> >>>> --- Douglas Brantz <brantzdr@(protected)> wrote:
> >>>>
> >>>>  
> >>>>        
> >>>>> I need to upload a file to the server and I have that working, but I
> >>>>> want to add the form# to the front of the file:
> >>>>> I can do this to the filename stored in Mysql but how do I change
> >>>>> the name of the file being uploaded to the server?
> >>>>> -
> >>>>> The variable for form number is $p
> >>>>>
> >>>>> I thought I could do this somewhere in this part of the code?
> >>>>>
> >>>>> sub Get_File_Name{
> >>>>> if ($ENV{HTTP_USER_AGENT}=~/win/i){
> >>>>> fileparse_set_fstype("MSDOS");
> >>>>> }
> >>>>> elsif($ENV{HTTP_USER_AGENT}=~/mac/i){
> >>>>> fileparse_set_fstype("MacOS");
> >>>>> }
> >>>>> my $full_name = shift;
> >>>>> $full_name = basename($full_name);
> >>>>>          
> >>>>> $full_name = "$p$full_name";  ##>> Added this so I can get the file
> >>>>> name with form# for Mysql
> >>>>>     $full_name =~ s!\s!\_!g;
> >>>>> return($full_name);
> >>>>> }
> >>>>> sub Store_File{
> >>>>> my $file_handle = shift;
> >>>>> my $file_name = shift;
> >>>>> my $data;
> >>>>> #my $mime = uploadInfo($File_handle)->{'Content-Type'};
> >>>>> open (STORAGE, ">$dir/$file_name")  ##  Tried
> >>>>> "..>$dir/$p$file_name");  but it didnt' work.
> >>>>> or die "Error: $!\n";
> >>>>> #if($mime !~ /text/){
> >>>>> binmode ($file_handle);
> >>>>> binmode (STORAGE);
> >>>>> #}
> >>>>> while( read($file_handle, $data, 1024) ){
> >>>>> print STORAGE $data;
> >>>>> }
> >>>>> close STORAGE;
> >>>>> }
> >>>>>
> >>>>> --
> >>>>> Douglas Brantz
> >>>>> Computer consultant
> >>>>> College of Fine & Applied Arts
> >>>>> Appalachian State University
> >>>>> Boone, NC 28608
> >>>>>
> >>>>> 828-262-6549 ? office
> >>>>> 828-262-6312 - fax
> >>>>>
> >>>>>
> >>>>> --
> >>>>> MySQL Perl Mailing List
> >>>>> For list archives: http://lists.mysql.com/perl
> >>>>> To unsubscribe:    
> >>>>> http://lists.mysql.com/perl?unsub=gregmeckes@(protected)
> >>>>>
> >>>>>
> >>>>>    
> >>>>>          
> >>>>  
> >>>>        
> >> --
> >> Douglas Brantz
> >> Computer consultant
> >> College of Fine & Applied Arts
> >> Appalachian State University
> >> Boone, NC 28608
> >>
> >> 828-262-6549 ? office
> >> 828-262-6312 - fax
> >>
> >>
> >> --
> >> MySQL Perl Mailing List
> >> For list archives: http://lists.mysql.com/perl
> >> To unsubscribe:    http://lists.mysql.com/perl?unsub=gregmeckes@(protected)
> >>
> >>
> >>    
> >
> >
> >  
>
> --
> Douglas Brantz
> Computer consultant
> College of Fine & Applied Arts
> Appalachian State University
> Boone, NC 28608
>
> 828-262-6549 ? office
> 828-262-6312 - fax
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/perl?unsub=gregmeckes@(protected)
>
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=mysql@(protected)