I'm using Batch edit mode. My insert command is very simple:
InsertCommand="INSERT INTO "WFM_CAT_RECURRENCE_DT" VALUES (:DIVISION, :DISTRICT, :LOCATION, :FROM_YEAR, :FROM_WEEK, :TO_YEAR, :TO_WEEK, :USERID, :USERNAME, SYSDATE)" but it gives me an error:ORA-01036: illegal variable name/number. Can anyone help?
My aspx is as follow:
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Copy_To_Maintenance.aspx.vb"
Inherits="Copy_To_Maintenance" %>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server">
<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
<Scripts>
<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
</Scripts>
</telerik:RadScriptManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True"
CellSpacing="0" DataSourceID="OracleDatabase1" GridLines="None"
AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
AllowAutomaticUpdates="True" AutoGenerateColumns="False"
AllowFilteringByColumn="True" Width="1250px">
<mastertableview
datakeynames="USERID,USERNAME,CREATE_DATE"
datasourceid="OracleDatabase1" commanditemdisplay="TopAndBottom"
EditMode="Batch" BatchEditingSettings-EditType="Cell"
autogeneratecolumns="False" >
<RowIndicatorColumn Visible="False">
</RowIndicatorColumn>
<ExpandCollapseColumn Created="True">
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="DIVISION"
FilterControlAltText="Filter DIVISION column" HeaderText="DIVISION"
ReadOnly="False" SortExpression="DIVISION" UniqueName="DIVISION" AllowFiltering="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="DISTRICT"
FilterControlAltText="Filter DISTRICT column" HeaderText="DISTRICT"
SortExpression="DISTRICT" UniqueName="DISTRICT" ReadOnly="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="LOCATION"
FilterControlAltText="Filter LOCATION column" HeaderText="LOCATION"
SortExpression="LOCATION" UniqueName="LOCATION" ReadOnly="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FROM_YEAR" DataType="System.Decimal"
FilterControlAltText="Filter FROM_YEAR column" HeaderText="FROM_YEAR"
SortExpression="FROM_YEAR" UniqueName="FROM_YEAR">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FROM_WEEK" DataType="System.Decimal"
FilterControlAltText="Filter FROM_WEEK column" HeaderText="FROM_WEEK"
SortExpression="FROM_WEEK" UniqueName="FROM_WEEK">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TO_YEAR" DataType="System.Decimal"
FilterControlAltText="Filter TO_YEAR column" HeaderText="TO_YEAR"
SortExpression="TO_YEAR" UniqueName="TO_YEAR">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TO_WEEK" DataType="System.Decimal"
FilterControlAltText="Filter TO_WEEK column" HeaderText="TO_WEEK"
SortExpression="TO_WEEK" UniqueName="TO_WEEK">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="USERID"
FilterControlAltText="Filter USERID column" HeaderText="USERID"
SortExpression="USERID" UniqueName="USERID" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="USERNAME"
FilterControlAltText="Filter USERNAME column" HeaderText="USERNAME"
SortExpression="USERNAME" UniqueName="USERNAME" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CREATE_DATE" DataType="System.DateTime"
FilterControlAltText="Filter CREATE_DATE column" HeaderText="CREATE_DATE"
SortExpression="CREATE_DATE" UniqueName="CREATE_DATE" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridButtonColumn Text="Delete" CommandName="Delete" ButtonType="ImageButton" />
</Columns>
</mastertableview>
</telerik:RadGrid>
<telerik:RadWindowManager ID="RadWindowManager1" runat="server">
</telerik:RadWindowManager>
<asp:SqlDataSource ID="OracleDatabase1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM "WFM_CAT_RECURRENCE_DT" WHERE "DIVISION" = :DIVISION AND "DISTRICT" = :DISTRICT AND "LOCATION" = :LOCATION AND "FROM_YEAR" = :FROM_YEAR AND "FROM_WEEK" = :FROM_WEEK AND "TO_YEAR" = :TO_YEAR AND "TO_WEEK" = :TO_WEEK AND "USERID" = :USERID AND "USERNAME" = :USERNAME AND "CREATE_DATE" = :CREATE_DATE"
InsertCommand="INSERT INTO "WFM_CAT_RECURRENCE_DT" VALUES (:DIVISION, :DISTRICT, :LOCATION, :FROM_YEAR, :FROM_WEEK, :TO_YEAR, :TO_WEEK, :USERID, :USERNAME, SYSDATE)"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT "DIVISION", "DISTRICT", "LOCATION", "FROM_YEAR", "FROM_WEEK", "TO_YEAR", "TO_WEEK", "USERID", "USERNAME", "CREATE_DATE" FROM "WFM_CAT_RECURRENCE_DT""
UpdateCommand="UPDATE "WFM_CAT_RECURRENCE_DT" SET "LOCATION" = :LOCATION, "FROM_YEAR" = :FROM_YEAR, "FROM_WEEK" = :FROM_WEEK, "TO_YEAR" = :TO_YEAR, "TO_WEEK" = :TO_WEEK, "USERID" = 'ID', "USERNAME" = 'NAME', "CREATE_DATE" = SYSDATE WHERE "DIVISION" = :DIVISION AND "DISTRICT" = :DISTRICT AND "LOCATION" = :LOCATION AND "USERID" = :USERID AND "USERNAME" = :USERNAME AND "CREATE_DATE" = :CREATE_DATE">

We have customized the physical location as well as file download behavior by using the sample code files 'CustomFileSystemProvider.cs' and 'FileSystemHandler.ashx'. The implementation works fine on developer machine, but getting 404 error on production server.
=========================================================================================================
The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
--------------------------------------------------------------------------------
Please try the following:
•Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.
•If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.
•Click the Back button to try another link.
HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)
--------------------------------------------------------------------------------
Technical Information (for support personnel)
•Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.
•Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages.
=========================================================================================================
Is that some configuration related to .ashx is missing on the server or what could be the issue. Please suggest.
Thanks,
Suresh.C
