I changed the selection of the file to be id based in version 0.1.1 and
that is the current state of the CVS. I did that for the reason you
mentioned. That is, we may want multiple files with one name (definately
when we introduce directories :) ) so by selecting by the file_id (found
in the new db schemea in 0.1.1) we can have multiple files by the same
name.
I suggest you do one of two things. First, get the latest version out of
CVS, or secondly change file_id=$file to file_name=$file for doing the
testing.
Regards,
Abdul-Wahid
On Wed, 7 Jun 2000, Tony Kirk wrote:
> Hey there Abdul-Wahid,
>
> Here is the line of code in question.
>
> $sql = "select file, mime, size from files where file_id='$file'";
>
> Found on line 13 of the new get_file.php3 you sent out today to be tested.
> Does this line of code work for you on your system? The original
> get_file.php3 had a different line.
>
> $sql = "select file, mime, size from files where file_name='$file'";
>
> The first sql statement makes sense to me being used as there may be
> multiple files with the same name. Changing file_id=$file to file_name=$file
> in the new get_file.php3 works of course. But did you want to recode that to
> use the files ID instead?
>
> Regards,
> Tony Kirk
>
>
> _______________________________________________
> Vfs-devel mailing list
> Vfs...@li...
> http://lists.sourceforge.net/mailman/listinfo/vfs-devel
>
|