Pure ASP.NET Upload 2 Support Product Page
This topic was archived
Insert ignores filename C#
Reported 14 Jul 2006 15:00:59
1
has this problem
14 Jul 2006 15:00:59 Johan Van Dyk posted:
HiI have a page where I use the ASP.NET upload ext. Everything works as it should (Record gets added to the database and the file is uploaded) but the filename is not recorded in the database. All other fields are populated except the filename.
My code is as follows: Any help appreciated....rather urgent!!
___________________________________________________________
<%@ Page Language="C#" %>
<%@ Register TagPrefix="webxelauthentication" Namespace="WebXelAuthentication" Assembly="WebXelAuthentication" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<%@ Register TagPrefix="DMXzone" NameSpace="PureUpload" Assembly="PureUpload" %>
<DMXzone<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ureFileUpload runat="server" id="pfu" ThePath="../../GenResources" Redirect="" StoreType="file" TimeOut="600" SizeLimit="" Extensions="doc,xls,ppt,pps,pdf,zip" NameConflict="uniq" MaxHeight="" MinHeight="" RequireUpload="true" MinWidth="" MaxWidth="" SaveWidth="" SaveHeight="" FormName="form1" ProgressBar="" ProgressWidth="300" ProgressHeight="100" TheVersion="2.0.2" /><MM<img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>nsert
runat="server"
CommandText='<%# "INSERT INTO dbo.tblResources (R_Title, R_Resource, R_MemberID, R_Private, R_ClientID) VALUES (?, ?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_conn"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_conn"] %>'
Expression='<%# Request.Form["MM_insert"] == "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "ViewModifyResource.aspx" %>'
>
<Parameters>
<Parameter Name="@R_Title" Value='<%# ((Request.Form["R_Title"] != null) && (Request.Form["R_Title"].Length > 0)) ? Request.Form["R_Title"] : "" %>' Type="VarChar" />
<Parameter Name="@R_Resource" Value='<%# ((Request.Form["R_Resource"] != null) && (Request.Form["R_Resource"].Length > 0)) ? Request.Form["R_Resource"] : "" %>' Type="VarChar" />
<Parameter Name="@R_MemberID" Value='<%# ((Request.Form["R_MemberID"] != null) && (Request.Form["R_MemberID"].Length > 0)) ? Request.Form["R_MemberID"] : "" %>' Type="Integer" />
<Parameter Name="@R_Private" Value='<%# ((Request.Form["R_Private"] != null) && (Request.Form["R_Private"].Length > 0)) ? Request.Form["R_Private"] : "" %>' Type="WChar" />
<Parameter Name="@R_ClientID" Value='<%# ((Request.Form["R_ClientID"] != null) && (Request.Form["R_ClientID"].Length > 0)) ? Request.Form["R_ClientID"] : "" %>' Type="Integer" />
</Parameters>
</MM<img src=../images/dmxzone/forum/icon_smile_blush.gif border=0 align=middle>nsert>
<MM<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ageBind runat="server" PostBackBind="true" />
<HTML>
<HEAD>
<%
Response.Expires=-1000;
Response.CacheControl="no-cache";
%>
<TITLE>Peer Educator</TITLE>
<link href="../../Assets/Css/<%= Session["CSS"] %>" rel="stylesheet" type="text/css">
<script src="../../Assets/Scripts/Rightclick.js"></script>
<script runat="server">
protected void Page_Load(Object Src, EventArgs E)
{
if (!IsPostBack)
{
R_MemberID.Value = CheckLoginStatus1.CurrentUser["MemberID"];
R_ClientID.Value = Session["ClientID"].ToString();
}
}
</script>
<script language='javascript' src='../../ScriptLibrary/incPureUpload.js'></script>
</HEAD>
<BODY>
<img name='awmMenuPathImg-Admin_sub' id='awmMenuPathImg-Admin_sub' src='../../Assets/Scripts/awmmenupath.gif' alt=''>
<script type='text/javascript'>var MenuLinkedBy='AllWebMenus [2]', awmBN='DW'; awmAltUrl='';</script>
<script src='../../Assets/Scripts/Admin_sub.js' language='JavaScript1.2' type='text/javascript'></script>
<script type='text/javascript'>awmBuildMenu();</script>
<WebXelAuthentication:CheckLoginStatus UserNotLoggedInURL="../../Errors/SessionExpired.aspx" AccessDeniedURL="../../Errors/SessionExpired.aspx" AccessLevel="1" CompareType="Equals" ID="CheckLoginStatus1" RestrictByAccessLevel="true" Runat="server"></WebXelAuthentication:CheckLoginStatus>
<h3>Add Resources</h3>
<P><SPAN class="note">Please Note:</SPAN></P>
<UL>
<LI>If you add a resource which already exist, it will be renamed (filename will be appended with a _X where X is a numeric value) </LI>
<LI>Only MS Office documents (<STRONG>.doc</STRONG>, <STRONG>.ppt</STRONG>, <STRONG>.pps</STRONG>, <STRONG>.xls</STRONG><img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>, Portable Document Format (<STRONG>.pdf</STRONG><img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>, and WinZip (<STRONG>.zip</STRONG><img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle> files will be uploaded. Selecting any other document types will cancell the submission od this resource.</LI>
</UL>
<form method='post' enctype="multipart/form-data" name='form1' id="form1" runat='server' onSubmit="checkFileUpload(this,'doc,xls,ppt,pps,pdf,zip',true,'','','','','','','');return document.MM_returnValue">
<table border="0" cellspacing="1" cellpadding="0">
<tr>
<th>Title</th>
<td colspan="2"><asp:TextBox ID="R_Title" Columns="80" MaxLength="200" runat="server" />
<asp:RequiredFieldValidator ControlToValidate="R_Title" CssClass="errormessage" Display="Dynamic" ErrorMessage="<br>Please supply a <b>Title</b>!" ID="RequiredFieldValidator1" runat="server"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<th>Resource
<input name="R_MemberID" type="hidden" id="R_MemberID" runat="server">
<input name="R_ClientID" type="hidden" id="R_ClientID" runat="server">
<input id="R_Private" name="R_Private" runat="server" type="hidden" value="No"></th>
<td colspan="2"><input name="R_Resource" type="file" id="R_Resource" onChange="checkOneFileUpload(this,'doc,xls,ppt,pps,pdf,zip',true,'','','','','','','')" size="80" runat="server"></td>
</tr>
<tr>
<td> </td>
<td colspan="2"><asp:Button ID="Submit" runat="server" Text="Add Resource" /></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
</BODY>
</HTML>
___________________________________________________________
Johan Van Dyk
Replies
Replied 14 Jul 2006 16:51:06
14 Jul 2006 16:51:06 Robbie Laliberte replied:
Johan,
try this as the value of your parameter R_Resource (that is the file input field, yes); no guarantees, because I really don't do C#.
((R_Resource.Value != null) && (R_Resource.Value.Length > 0)) ? R_Resource.Value.Substring(R_Resource.Value.LastIndexof("\"
+ 1) : ""
Original tales of Dark Fantasy and Horror. www.theHarrow.com
try this as the value of your parameter R_Resource (that is the file input field, yes); no guarantees, because I really don't do C#.
((R_Resource.Value != null) && (R_Resource.Value.Length > 0)) ? R_Resource.Value.Substring(R_Resource.Value.LastIndexof("\"
+ 1) : ""Original tales of Dark Fantasy and Horror. www.theHarrow.com
Replied 27 Jul 2006 14:36:19
27 Jul 2006 14:36:19 Robbie Laliberte replied: