thiazi
Posts: 6
|
| Posted: 08/08/2007, 8:16 AM |
|
Hi all,
I'm evaluating CodeCharge Studio and have to say I'm very impressed with the functionality this software provides. I'm really looking to create a few applications - but my main interest is in creating a functional, but small project management application with ASP and Access.
Using the provided examples in the Example Pack 1 (I have not purchased the software yet, so I cannot download Example Pack 2), I have taken the pre-built Task Manager application and modified the task maintenance page to include a File Upload box. What I did is this: I added another row to the form, clicked on File Upload in HTML options, specified ASP/VBScript with ADODB.Stream (as I don't have any of the other components installed), specified the FileFolder and Temp Folder, and then saved/published the project.
When I specified the project parameters, I clicked the option to use the Intranet example database, if it matters.
I didn't think it would be this easy to get a published application online - but it did publish all the files, and all the other functions of the task management application work without a problem. However, the file upload component is a different story. On the task maintenance page (add/edit tasks), when I browse for a file, then hit Submit, it does upload the file into the directory specified in File Folder. It renames the file with 2007 and (what look like) random numbers before the file name. So it uploads fine, and then takes me back to the screen that lists all the tasks. When I select the specific task that I uploaded the file for, I'm not given a list of files that were uploaded.
What I'd like is a separate row to display the files associated with a particular task/record, and offer those as a hyperlink for downloading. Is there a step I'm missing? I see the {FileName} and Delete (with a checkbox) options on the actual form itself inside CodeCharge, but when the page displays in the browser, neither are there - it's just simply the browse button with the file text box.
So I guess what i'm asking is - what step am I missing to display what files have been uploaded in association with specific record/task ID? Thank you!
|
 |
 |
thiazi
Posts: 6
|
| Posted: 08/08/2007, 6:46 PM |
|
I hope I'm not trying to make this software do something it's not designed for?
|
|
|
|
ReneS
Posts: 225
|
| Posted: 08/09/2007, 3:21 AM |
|
Hi Thiazi,
You cannot (i think) just add a row and insert upload component. You could add a text field to the database, let's say its called "uploadedfile". In design view of your form, add a row, add the upload component, link the component to your database field "uploaded".
Now you can use that field to also display etc. the uploaded files
This is as far as I can go.....
Good luck
Rene
|
|
|
|
thiazi
Posts: 6
|
| Posted: 08/09/2007, 9:43 AM |
|
Hi there! Thank you for your quick reply! How do you link the component to your database field?
|
|
|
|
thiazi
Posts: 6
|
| Posted: 08/09/2007, 12:37 PM |
|
I figured the upload part out. How do I rename the file back to its original filename? Previous posts on here suggest modifying Classes.asp and specifically this line:
NewFileName = GetValidFileName(f.FileName) & f.FileName
Does anyone know what it needs to be modified to?
|
|
|
|
thiazi
Posts: 6
|
| Posted: 08/13/2007, 5:20 AM |
|
anyone?
|
|
|
|
thiazi
Posts: 6
|
| Posted: 08/19/2007, 1:25 PM |
|
Last effort here  Trial is about to expire and the upload component is still not performing as documented.
|
|
|
|
Waspman
Posts: 948
|
| Posted: 08/20/2007, 9:12 AM |
|
The way I do this is have a link that is populated by the contents of the field in the before show event.
This either points to a file which will show in the same window or if you know javascript show it in a popup.
Let me know if you want more.
Tony
_________________
http://www.waspmedia.co.uk |
|
|
|
Waspman
Posts: 948
|
| Posted: 08/20/2007, 9:22 AM |
|
Read your post some more...
When the task is selected the users is sent to another page along with all relevant variables.
This is the used to filter the tasks and any associated uploaded files in 2 seperate tables.
So you have the main task details table, an associated files table and maybe a status log table, all filtering the data using the variables passed in the url or set by the page.
Hope this helps
Tony
CCS can eat this sort of thing
_________________
http://www.waspmedia.co.uk |
|
|
|
popularanky
Posts: 53
|
| Posted: 08/31/2007, 6:12 AM |
|
Hi, the issue with CCS is that when u upload a file or image . the save name go to the database while the image go to it direction, so to view that image from the database, what i do is that i run a little query from the database for that page. in the query if the field with image is picture1, i add "'images/' + '' +" to the front of the picture1 like this ('images/' + '' +picture1 AS picture) and add other field. the 'image' is the name of the folder where the image is in the server. i hope this will help you.
_________________
EKERE UBONG UBONG
IT Officer
CognitiveDrive |
|
|
|
|
