Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert record (GRAPHIC)? Can it be done?

Status
Not open for further replies.

Ladyborg

Programmer
Joined
May 11, 2002
Messages
208
Location
US
I'm using the server behavior "insert record" to allow people to upload their graphic to a database.

Can this be done? If so, what should the "submit as" for the field "logo" be?

In the form online "logo" is an include file field (browse button to find logo in one's computer). Ladyborg
"Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark"
 
Hey there,

Yes and no.

yes - you can upload a file or picture or whatever for that matter - you just need to specify what type of file to be uploaded - lest you get some nifty individual who uploads something nasty.

I'm a bit confused to the references of "submit to"

Let me tell you what I've done, perhaps it'll help clarify or answer your questions.

I have a form where my online pilots can upload missions. In this case I've specified .zip only. I have the form contents (mission name, bombing points, etc) go into the database - and the actual zip file itself going into one directory.

Now, on another page I have a place for pilots to download missions. The recordset here will reference the filename (which is the exact same as the Mission Name plus the .zip)

Mission = Magop1
Filename = Magop1.zip
Bomb Points = 0

in the download section I'll have a href=&quot;../downloads/<%Recordset1.Fields.Item(&quot;MissionName&quot;).Value %>.zip&quot;

Then some handy alt tags, maybe an image or something.

If this is similiar - you need to decide how you are going to use the recordset later on and mark it accordingly.

&quot;Insert witty remark here&quot;

Stuart
 
%-) I appreciate the help, I guess it's just a little over my head - or I can't really visualize it.

I'd be happy to just get a form that will allow a client to &quot;browse&quot; his files and send the necessary graphic in an e-mail, but I haven't been able to get anything to work that way yet.

Thanks for your help. %-) Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;
 
did you get that ASPupload?

Its really a slick program &quot;Insert witty remark here&quot;

Stuart
 
Had to take a really roundabout way to the link you gave in the other post didn't work. There I found aspupload 2 but not 1. Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;
 
Really roundabout? I noticed a extra space between .com and the / oops.

Here it is:
click the download link below the big NOTE

the tutorial link is right there on the same page. If you methodically follow the steps you shouldn't have any problem.

&quot;Insert witty remark here&quot;

Stuart
 
OK, thanks for the new link. I downloaded it and tried it. Seems to try to work but get error:

An error has occured saving uploaded file!

Filename: /Uploadlogo/flower_girl.jpg
Maybe the destination directory does not exist, or you don't have write permission.
Please correct and try again

&quot;uploadlogo&quot; is the directory I chose to upload to.
Also, do you know if there is a way to get an e-mail verification that a file was uploaded? So I can know which new uploaded file belongs to whom? Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;
 
Few things to check offhand.

1) is the path correct. You are /Uploadlogo not ../uploadlogo or anything like that.

2) That you have not tried to upload the file before - if you have, it will error.

3) That the directory is write-able. Most likely is.

On the Email verification - yes you can, it's not difficult, but lets get the uploading working first. Also - do you have people logging in to get to this upload point?

If you have - then just do a hiddin input field - and pull a session variable for the users name into it. I'd then include a field in your table for like fldAuthor. That way it'll always be there - in case you need it later on. AND it will help you when you do the email.

&quot;Insert witty remark here&quot;

Stuart
 
I really appreciate your help. Thanks.

1) path is correct, I made sure and even tried with entire URL ( Same error.

2) Tried a different file each time, so that's not it.

3) Directory is write-able

Your thoughts and help are highly appreciated. Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;
 
What version of ADO do you have?

&quot;Insert witty remark here&quot;

Stuart
 
How do I check? Ladyborg
&quot;Don't be afraid to try new things,
Remember: professionals built the Titanic, amateurs built the Ark&quot;
 

Look for the MDAC 2.5 SP2

I had thought about something to check, grrrr forgot it.

Anyhow, open up Internet Explorer, click Tools, Internet Options, Advanced, and make sure under &quot;Show HTTP Friendly messages&quot; is unchecked.

Then see if you get a different, more specific error message when you try to upload. &quot;Insert witty remark here&quot;

Stuart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top