2. ASPRunnerPro General questions
  3. Inserting A File
This topic is locked

Inserting A File

 		3/5/2004 10:26:47 PM
ASPRunnerPro General questions
author

Is there a way to insert files so that when someone click on the it, it will open up a new page which shows the content of the file. For example, Inserting a file named

Lolo.pdf. when someone click on view file Lolo, it will open up Lolo.pdf file.
I thought the Pro has this option
Thanks
Sergey Kornilov admin 3/10/2004

Check this version of ASPRunnerPro that can upload files to the database:

http://www.asprunner.com/files/asprunnerpro30a.exe
You can use new Edit as and View as type Database file. Do not forget to set a field that stores uploaded file name also.
501031 3/10/2004

Do you mean to create a column with name of pdf files.
I have not successful getting this one to work correctly.
Sergey Kornilov admin 3/10/2004

Yes,
besides having a binary field that holds PDF file contens you also need a text field that holds upload file name ( "something.pdf" ). This file name is required when you download files from the database.
501032 3/10/2004

Thanks,
but how do you upload or store the pdf files in the database.

like in access, how do you upload or insert those pdf files.
Sergey Kornilov admin 3/11/2004

To upload files just set Edit as type of binary field to Database file. After that you can go to the edit page and upload files.
swat 1/12/2006

admin-

I am using asprunner3.2 and I can not upload pdf file to server- do you have any running sample thanks
Sergey Kornilov admin 1/12/2006

What exactly is the error message you getting uploading files to the Web server?
swat 1/15/2006

I do not see any link , or file name on the web browser. I am trying to upload pdf format file-

thanks
It looks like it works for excel-word-txt form of files, however pdf files does not show up-
Sergey Kornilov admin 1/16/2006

Send me a URL where I can see this problem.
swat 1/17/2006

I can not send you the link- internal server- any one using this function with pdf file ?
A
 		a_melchiore 1/17/2006

I'm using 3.2 and 4.0Beta and uploading a file and viewing works perfectly. Make sure:

  1. you set the field in the database to the correct data type (MS Access would be OLE object)
  2. under formatting for the table set "view as" and "edit as" to database file
  3. it should ask you for the field that will hold the filename...gotta have it
    Abel Melchiore
swat 1/18/2006

I'm using 3.2 and 4.0Beta and uploading a file and viewing works perfectly. Make sure:


  1. you set the field in the database to the correct data type (MS Access would be OLE object)
  2. under formatting for the table set "view as" and "edit as" to database file
  3. it should ask you for the field that will hold the filename...gotta have it
    Abel Melchiore


Abel-

Did you tested with pdf file format, I have done all the list that you mentioned, it works on word, excel but it does not work on txt-pdf file formats.

thank you
A
 		a_melchiore 1/18/2006



Abel-

Did you tested with pdf file format, I have done all the list that you mentioned, it works on word, excel but it does not work on txt-pdf file formats.

thank you


Swat-

Yes, I tested at two different locations with different hardware and I had no issue what so ever. I just retested it with both PDF and TXT. No problem. Are you sure you don't have a corrupted pdf or txt file? Are you sure it's not the database having issues?
Abel
C
 		clig 1/18/2006



Abel-

Did you tested with pdf file format, I have done all the list that you mentioned, it works on word, excel but it does not work on txt-pdf file formats.

thank you


  • here is a capture for a field of "image" type in SQL Server 2000
  • It doesn't matter what file type is but the "size" is actually determined by your IIS configuration - The default as about 200K on IIS6
swat 1/18/2006

Abel-
You are right, it works just fine now. The problem was the pdf file it self. Another question is the where do we save this files on the server.
thx