Forums

This topic is locked

Dynamic files how do you do it?

Posted 31 Aug 2001 10:03:22
1
has voted
31 Aug 2001 10:03:22 camille seaman posted:
<font face='Verdana'>I need to include a complete file, ie:text bulletin, to read and or download but its too big to include in the data base is there anyway to reference it in the database and include it in a recordset? How can I possibly make this work? or what are the principles to how it could work so I know why I am not able to make it work...hmmm?</font id='Verdana'>

Replies

Replied 31 Aug 2001 15:30:28
31 Aug 2001 15:30:28 Joel Martinez replied:
the easiest way to work with big files dynamically, is to throw the file on the server, and just store the URL in the database.

Then that way, you can make a dynamic link list or something of that nature, and just use the URL to send the user to the file <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
Replied 03 Sep 2001 06:50:39
03 Sep 2001 06:50:39 camille seaman replied:
<font face='Trebuchet MS'>By throwing them on the server do you mean with the other pages of my website or can they be contained in subfolders? do they also need to be .htm files?</font id='Trebuchet MS'>

Replied 03 Sep 2001 11:42:59
03 Sep 2001 11:42:59 Sam aaa replied:
They can go wherever you like in your site structure, just so long as you give the correct URL for them in the database. In this case, I would say relative paths are probably a bad idea, so give the full URL.

They shouldn't need to be in HTML format. If you rename a txt file to html and put:
<pre id=code><font face=courier size=2 id=code>&lt;PRE&gt;
ALLYOURTEXTHERE
&lt;/PRE&gt;
</font id=code></pre id=code>
, IE seems to open it without complaint. If you want to use more exotic formats like PDF, then obviously your user will need the browser plugin.

Reply to this topic