Forums

ASP

This topic is locked

Multiple Insert

Posted 21 Sep 2009 16:29:29
1
has voted
21 Sep 2009 16:29:29 Andrew Turner posted:
I am looking for a Dreamweaver extension that will allow me to upload images and insert multiple records into a datase at one time using ASP.

I have tried doing the multiple insert with a couple of non DMXzone extensions but as soon as I try to use Pure ASP Upload with them it fails.

Is there a DMXzone extension, or combination of extensions that will allow me to do this?

Replies

Replied 21 Sep 2009 17:44:33
21 Sep 2009 17:44:33 Patrick Julicher replied:
Hi Andrew,

Have a look at the Advanced Multi Uploader from DMXzone: www.dmxzone.com/go?15505.

Keep in mind that this extensions currently has problems on pages that have been protected by the "Restric Access To Page" behavior. However there are workarounds available.
Hope this is what you are looking for.

Kind regards, Patrick

Replied 21 Sep 2009 17:47:05
21 Sep 2009 17:47:05 Andrew Turner replied:
I looked at this but there was no indication that it would do a multiple record insert - will this do it on it's own, or will I need also to use an extension to do the insert?

Alos I have a restrict access on the page so where can I get info on the workarounds?
Replied 21 Sep 2009 18:11:01
21 Sep 2009 18:11:01 Patrick Julicher replied:
Hi Andrew,

What kind of records would you like to insert? Filenames can be inserted in a database without a problem. You might want to check this video: www.dmxzone.com/demo/multiupload/videos/20080525phpmultiuploadvid/phpmultiuploadvid.swf.
I will get back to you about the workaround.

Kind regards, Patrick
Replied 21 Sep 2009 19:18:07
21 Sep 2009 19:18:07 Andrew Turner replied:
OK, I bought the extension.

Does exactly what needed it to do, and so easy. Awesome!

Many thanks.
Replied 21 Sep 2009 19:27:34
21 Sep 2009 19:27:34 Andrew Turner replied:
Ah, spoke too soon. It is working, it does the insert and uploads the files but I shows an error when it is actually uploading the files.

I see the status as 'failed' and thr reason as '302 Found'

Is this the issue with the restrict access on the page - if so, where do I find information about the work around?
Replied 21 Sep 2009 19:40:01
21 Sep 2009 19:40:01 Patrick Julicher replied:
Hi Andrew,

Boy, your fast! Try this for the easiest solution:

* Remove the "Restrict access to page"-behavior and place the following If-statement arount the form code:

Before the form:

<% If Session("MM_Username") <> "" Then %>


After the form:

<% End If %>


The total should look somewhat like this:

<% If Session("MM_Username") <> "" Then %>
<form name="UploadQueue" id="UploadQueue" method="post">
  <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,63,0" width="550" height="350" id="upload1" align="middle">
    <param name="FlashVars" value="<%=pau.flashvars()%>&formName=UploadQueue" />
    <param name="movie" value="dmxMultiUploader.swf" />
    <param name="quality" value="best" />
    <param name="wmode" value="transparent" />
    <embed src="dmxMultiUploader.swf" name="upload1" quality="best" flashvars="<%=pau.flashvars()%>&formName=UploadQueue" wmode="transparent" type="application/x-shockwave-flash" width="550" height="350" pluginspage="http://www.macromedia.com/go/getflashplayer" />
  </object>
  <input type="hidden" name="Filedata" />
<script type="text/javascript">window.upload1 = document.forms["UploadQueue"].upload1;</script>
</form>
<% End If %>


This does load the page, but doesn't load the MultiUploader if a user did not login (using the standard DW Login).

Kind regards, Patrick
Replied 22 Sep 2009 09:45:29
22 Sep 2009 09:45:29 Andrew Turner replied:
OK, tried that, it still works but I still get the status failed and the 302 found error showing on the page.

Is this actually casued by the restrict access issue or is it something else?

What else can I look to to resolve this 302 found error message?
Replied 22 Sep 2009 10:03:33
22 Sep 2009 10:03:33 Patrick Julicher replied:
Hi Andrew,

Could you post a link to a test-page so I can see what is happening? Could you also post the source code for your page showing the error?

Kind regards, Patrick

Replied 22 Sep 2009 10:24:09
22 Sep 2009 10:24:09 Patrick Julicher replied:
Hi Andrew,

As a follow up to my previous post, could you please create a new topic in the Support Forum for the Advanced Multi Uploader and post a link and source code there:

www.dmxzone.com/forum/default.asp?NewsId=15505

This is to keep al the relevant information in the correct place.

Kind regards, Patrick

Reply to this topic