Forums

This topic is locked

Pure Upload Saving images sizes in database

Posted 27 Jun 2007 04:01:16
1
has voted
27 Jun 2007 04:01:16 Christian Nankervis posted:
<font face='Arial'>Hi,
I have followed the tutorial for saving the width and height of your picture in the database for the Pure Upload ASP.NET component and th javascript doesn't put the width and height in the hidden feilds after you have selected the file. Could someone please let me know why it's not going in?
Please find my code below.</font id='Arial'>
<pre id=code><font face=courier size=2 id=code>
&lt;%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %&gt;
&lt;%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %&gt;
&lt;%@ Register TagPrefix="DMXzone" NameSpace="PureUpload" Assembly="PureUpload" %&gt;
&lt;DMXzone<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>ureFileUpload runat="server" id="pfu" ThePath="" Redirect="" StoreType="file" TimeOut="1200" SizeLimit="" Extensions="GIF,JPG,JPEG,BMP,PNG" NameConflict="uniq" MaxHeight="" MinHeight="" RequireUpload="true" MinWidth="" MaxWidth="" SaveWidth="PImgWidth" SaveHeight="PImgHeight" FormName="createProduct" ProgressBar="" ProgressWidth="300" ProgressHeight="100" TheVersion="2.0.2" /&gt;&lt;MM:Update
runat="server"
CommandText='&lt;%# "UPDATE cn12012065.products SET PImgWidth=?, PImgHeight=?, PImg=? WHERE PID=?" %&gt;'
ConnectionString='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_aConn" %&gt;'
DatabaseType='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_aConn" %&gt;'
Expression='&lt;%# Request.Form("MM_update" = "createProduct" %&gt;'
CreateDataSet="false"
SuccessURL='&lt;%# "result_product.asp" %&gt;'
Debug="true"
&gt;&lt;Parameters&gt;
&lt;Parameter Name="@PImgWidth" Value='&lt;%# IIf((Request.Form("PImgWidth" &lt;&gt; Nothing), Request.Form("PImgWidth", "" %&gt;' Type="VarChar" /&gt;
&lt;Parameter Name="@PImgHeight" Value='&lt;%# IIf((Request.Form("PImgHeight" &lt;&gt; Nothing), Request.Form("PImgHeight", "" %&gt;' Type="VarChar" /&gt;
&lt;Parameter Name="@PImg" Value='&lt;%# IIf((pfu.getFileName("PImg" &lt;&gt; Nothing), pfu.getFileName("PImg", "" %&gt;' Type="VarChar" /&gt;
&lt;Parameter Name="@PID" Value='&lt;%# IIf((Request.Form("PID" &lt;&gt; Nothing), Request.Form("PID", "" %&gt;' Type="Integer" /&gt;
&lt;/Parameters&gt;
&lt;/MM:Update&gt;
&lt;MMataSet
id="dsPID"
runat="Server"
IsStoredProcedure="false"
ConnectionString='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_aConn" %&gt;'
DatabaseType='&lt;%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_aConn" %&gt;'
CommandText='&lt;%# "SELECT * FROM cn12012065.products WHERE PID = ?" %&gt;'
Debug="true"
&gt;
&lt;Parameters&gt;
&lt;Parameter Name="@PID" Value='&lt;%# IIf((Request.QueryString("PID" &lt;&gt; Nothing), Request.QueryString("PID", "" %&gt;' Type="Integer" /&gt;
&lt;/Parameters&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;script runat="server"&gt;
Private Sub Page_Load(sender As Object, e As System.EventArgs)
'Response.Write("Shared Session Variable Names/Values between Classic ASP and ASP.NET:&lt;BR&gt;"
Dim i As Integer
For i = 0 To Session.Contents.Count - 1
'Response.Write(("Assigned to """ + Session.Keys(i).ToString() + """")
'Response.Write((" Value: " + Session(i).ToString() + "&lt;BR&gt;")
Next i
'Response.Write(Session.Contents.Count)
If Session.Contents.Count = 0 Then
Response.Redirect("/siteadmin/menu.asp"
End If
If Session("logged" &lt;&gt; "true" AND Session("UserAccess" &lt;&gt; "admin" Then
Response.Redirect("/siteadmin/menu.asp"
End If
'Response.Write(Session("logged")
End Sub 'Page_Load
&lt;/script&gt;&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
&lt;html xmlns="www.w3.org/1999/xhtml"&gt;
&lt;head&gt;
&lt;title&gt;Edit Product Image - CraftBrewer&lt;/title&gt;
&lt;link rel="stylesheet" type="text/css" href="/common/admin.css" /&gt;
&lt;script language='javascript' src='../../ScriptLibrary/incPureUpload.js'&gt;&lt;/script&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;!-- Begin Wrapper --&gt;
&lt;div id="wrapper"&gt;
&lt;div id="header"&gt;
&lt;!--#include virtual="/siteadmin/includes/inc_header.asp" --&gt;
&lt;/div&gt;
&lt;!-- Begin Left Column - Menu --&gt;
&lt;div id="leftcolumn"&gt;
&lt;!--#include virtual="/siteadmin/includes/inc_admin_menu.asp" --&gt;
&lt;/div&gt;
&lt;!-- End Left Column - Menu --&gt;
&lt;!-- Begin Right Column - Content --&gt;
&lt;div align="left" id="rightcolumn"&gt;
&lt;h5&gt;Upload Product Image&lt;/h5&gt;
&lt;div id="content"&gt;
&lt;table border="0" cellspacing="10" cellpadding="0" class="textError"&gt;
&lt;tr&gt;
&lt;td&gt;&raquo; To upload your product image please fill out the form located below and click the &lt;strong&gt;Upload Product Image &raquo;&lt;/strong&gt; button located at the bottom of the form. &lt;br /&gt;
&raquo; All fields that are marked with an asterix * are required fields. &lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;div id="content"&gt;
&lt;table width="100%" border="0" cellspacing="5" cellpadding="0"&gt;
&lt;tr&gt;
&lt;td&gt;&lt;table width="100%" border="0" cellpadding="0" cellspacing="0"&gt;
&lt;form method='post' enctype="multipart/form-data" name='createProduct' id='createProduct' runat='server' onsubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,'','','','','','PImgWidth','PImgHeight');return document.MM_returnValue"&gt;
&lt;tr&gt;
&lt;td align="left" valign="top"&gt;&lt;h5&gt;Product Details&lt;/h5&gt;
&lt;table width="100%" border="0" cellpadding="3" cellspacing="0" class="textBlack"&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Code:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PCode", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Name:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PName", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="top" class="borderBottomAdmin"&gt;&lt;strong&gt; Description:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" valign="top" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PDesc", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="top" class="borderBottomAdmin"&gt;&lt;strong&gt; Display Order:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" valign="top" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("POrder", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Weight:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PWeight", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Price:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PPrice", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Tax Included: &lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PTaxIsInclusive", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Tax Code: &lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PTaxCode", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;In Stock: &lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PStock", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Stock Alert: &lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PStockAlert", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Online:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("POnline", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr valign="baseline"&gt;
&lt;td align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Latest Release: &lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;%# dsPID.FieldValue("PLatestRelease", Container) %&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;h5&gt;Image Upload&lt;/h5&gt;
&lt;table width="100%" border="0" cellpadding="3" cellspacing="0" class="textBlack"&gt;
&lt;tr valign="baseline"&gt;
&lt;td width="15%" align="left" valign="middle" class="borderBottomAdmin"&gt;&lt;strong&gt;Image:&lt;/strong&gt;&lt;/td&gt;
&lt;td colspan="3" class="borderBottomAdmin"&gt;&lt;input name="PImg" type="file" class="formField" id="PImg" onchange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,'','','','','','PImgWidth','PImgHeight')" value='&lt;%# dsPID.FieldValue("PImg", Container) %&gt;' size="50" /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;br&gt;
&lt;input name="PID" type="hidden" id="PID"&gt;
&lt;input type="hidden" name="PImgWidth" id="PImgWidth" value=""&gt;
&lt;input type="hidden" name="PImgHeight" id="PImgHeight" value=""&gt;
&lt;input type="submit" name="createProduct" value="Upload Product Image &raquo;" class="formButton" onMouseOver="this.className='formButtonOver'" onMouseOut="this.className='formButton'" /&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;input type="hidden" name="MM_update" value="createProduct"&gt;
&lt;/form&gt;
&lt;/table&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;!-- End Right Column - Content --&gt;
&lt;!-- Begin Footer --&gt;
&lt;div id="footer"&gt;
&lt;!--#include virtual="/siteadmin/includes/inc_footer.asp" --&gt;
&lt;/div&gt;
&lt;!-- End Footer --&gt;
&lt;/div&gt;
&lt;!-- End Wrapper --&gt;
&lt;/body&gt;
&lt;/html&gt;
</font id=code></pre id=code>

Reply to this topic