I have duplicated your upload and insert record tutorial using my database. I'm also using Smart Image Processor to generate a thumbnail. When I execute the upload, I get the upload and I get a record in my database, but the filename ("LargeFileName" doesn't get inserted into its field - just a null value. I know the database and and the insertion sql statements are correct because I'm able to insert records without Pure ASP.net Upload/SIP. Any idea why it's ignoring my filename? Code below:

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="DMXzone" NameSpace="PureUpload" Assembly="PureUpload" %>
<%@ Register TagPrefix="Image" Namespace="PUImageProcessor" Assembly="PUImageProcessor" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
&lt;MM<img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>nsert
runat="server"
CommandText='&lt;%# "Insert Into babies (ID,DateOfBirth,LargeFileName) Values (@BID,@DOB,@LF)" %&gt;'
ConnectionString='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING" %&gt;'
DatabaseType='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE" %&gt;'
Expression='&lt;%# Request.Form("MM_insert" = "form1" %&gt;'
CreateDataSet="false"
SuccessURL='&lt;%# "default.aspx" %&gt;'
Debug="true"
&gt;
&lt;Parameters&gt;
&lt;Parameter Name="@BID" Value='&lt;%# IIf((Request.Form("BID" &lt;&gt; Nothing), Request.Form("BID", "" %&gt;' Type="VarChar" /&gt;
&lt;Parameter Name="@DOB" Value='&lt;%# IIf((Request.Form("DOB" &lt;&gt; Nothing), Request.Form("DOB", "" %&gt;' Type="DateTime" /&gt;
&lt;Parameter Name="@LF" Value='&lt;%# IIf((pfu.getFileName("LargeFileName" &lt;&gt; Nothing), pfu.getFileName("LargeFileName", "" %&gt;' Type="VarChar" /&gt;
&lt;/Parameters&gt;
&lt;/MM<img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>nsert&gt;
&lt;MMataSet
id="DSBabies"
runat="Server"
IsStoredProcedure="false"
ConnectionString='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING" %&gt;'
DatabaseType='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE" %&gt;'
CommandText='&lt;%# "Select * FROM Babies" %&gt;'
Debug="true"
&gt; &lt;/MMataSet&gt;
&lt;MM<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ageBind runat="server" PostBackBind="true" /&gt;
&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Administrators&lt;/title&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;
&lt;link href="../css/styles.css" rel="stylesheet" type="text/css"&gt;
&lt;script language='javascript' src='../../ScriptLibrary/incPureUpload.js'&gt;&lt;/script&gt;
&lt;/head&gt;
&lt;body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"&gt;
&lt;form action="" method="post" enctype="multipart/form-data" name="form1" runat="server" onSubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,2000,'','','','','','');showProgressWindow('blueFlashProgress.htm',300,50);return document.MM_returnValue"&gt;
&lt;div id="content"&gt;
&lt;table width="100%"&gt;
&lt;tr&gt;
&lt;td valign="top" class="formtext1"&gt;&nbsp;&lt;/td&gt;
&lt;td valign="top"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td width="20%" valign="top" class="formtext1"&gt;&lt;div align="right"&gt;&lt;b&gt;ID:&nbsp;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td valign="top"&gt;&lt;input class="formtext2" type="text" id="DOB" name="BID" size="10" maxlength="15"&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" class="formtext1"&gt;&nbsp;&lt;/td&gt;
&lt;td valign="top"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" class="formtext1"&gt;&lt;div align="right"&gt;&lt;b&gt;Date Of Birth:&nbsp;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td valign="top" class="formtext2"&gt;&lt;input class="formtext2" type="text" id="DOB" name="DOB" size="10" maxlength="10"&gt; - ex. 12/31/2004&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" class="formtext1"&gt;&nbsp;&lt;/td&gt;
&lt;td valign="top"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"class="formtext1"&gt;&lt;div align="right"&gt;&lt;b&gt;Picture:&nbsp;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;
&lt;td valign="top"&gt;&lt;input id="LargeFileName" name="LargeFileName" type="file" class="formtext2" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,2000,'','','','','','')" size="32" runat="server"&gt;
&lt;Image:SmartImageProcessor runat="server" Component="ASP.NET" ResizeImage="true" ResizeWidth='267' ResizeHeight='400' ResizeQuality='80' ResizeAspect="true" MakeThumbnail="true" ThumbPath="/gallery/album1" ThumbWidth='93' ThumbHeight='140' ThumbQuality='70' ThumbAspect="true" PrePost="suffix" FixValue='_small' RedirectUrl="" TheVersion="1.0.1" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;&nbsp;&lt;/td&gt;
&lt;td valign="top"&gt;&nbsp;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;&nbsp;&lt;/td&gt;
&lt;td valign="top"&gt;&lt;input name="MM_insert" type="hidden" value="form1"&gt;
&lt;asp:button ID="submit1" runat="server" Text="Add Baby" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td colspan="2" align="left"&gt; &lt;DMXzone<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ureFileUpload runat="server" id="pfu" ThePath="../../gallery/album1" Redirect="" StoreType="file" TimeOut="1800" SizeLimit="2000" Extensions="GIF,JPG,JPEG,BMP,PNG" NameConflict="over" MaxHeight="" MinHeight="" RequireUpload="true" MinWidth="" MaxWidth="" SaveWidth="" SaveHeight="" FormName="form1" ProgressBar="blueFlashProgress.htm" ProgressWidth="300" ProgressHeight="50" TheVersion="2.0.2" /&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;

Thanks

Um.... hello?!?

Anyone going to address this question? Fundamental flaw here.

Extension usefulness easily cut in half without the ability to save the information to the database.



Original tales of Dark Fantasy and Horror. www.theHarrow.com

Edited by - chariot on 03 Jul 2006 19:01:45

Edited by - chariot on 03 Jul 2006 19:11:41

Edited by - chariot on 03 Jul 2006 19:11:59

No answer yet.

I'll give it until next week for answer, then I email George directly as that seems to be the best way to get answers around here.

Original tales of Dark Fantasy and Horror. www.theHarrow.com

here's a way around the issue for the moment (requires .Net Framework 1.1.4X or higher, not sure why)

First, be sure and make the file input box a server control by inserting runat="server"

input type="file" name="filename" id="filename" runat="server"

Then manually update the DW Insert code parameter

Parameter Name="@filename" Value='&lt;%# IIf(filename.Value &lt;&gt; Nothing, filename.Value.Substring(filename.Value.LastIndexof("\" + 1), "" %&gt;' type="Nchar"


You want to make sure and insert the name of your file field for "filename" as it is listed above, and be sure and use your own type for the Parameter insert. As I stated above this works on .Net framework 1.1.4x and above, and most definetly not on 1.0.X -- and no on I now has been able to determine why that is.

I have had to adjust the above code slightly because the code options on the forum seem to either not work in preview or to be disable completely.

Original tales of Dark Fantasy and Horror. www.theHarrow.com

BAH!!!!

Ignore my RANTS. I feel like a flaming jackass.

I do think there is something wrong with the upload progress bars, but other than that... extension works fine IF you remember to upload all the necessary files! Upload your bin folder and your Script Library, most problems solved!



Original tales of Dark Fantasy and Horror. www.theHarrow.com

Ok... we're back to this again.

Why does this sometimes work and sometimes not work? Any ideas? Because this was working before I had my SIP problems; now that's fixed, and this is not working again!

What's the deal? Can we figure out what is going on here?

Original tales of Dark Fantasy and Horror. www.theHarrow.com

Riddle me this:

2 machines, sa OS, same version of DW, same version of Asp.Net Upload: build a page on one machine and everything works flawleslly; but build it on the other machine and the file name fails to insert into the database.

Now that's a good one.

Original tales of Dark Fantasy and Horror. www.theHarrow.com

A way I have found to get the filename is to use pfu.getFileName("yourFileFieldName" instead of Request.Form("yourFileFieldName"