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 Douglas Brantz

 Back
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=mysql@(protected)