Procedure 'sp03_Delete_Usuario' expects parameter '@AN001_CDUSUARIO', which was not supplied.

I´m having problem to delete/update using stored procedure with gridview. Actually I made an update and delete work but just by itself not togheter. I made update ONLY works If I dont pass any fields from gridview to datakeynames and the delete show the following error:

Procedure 'sp03_Delete_Usuario' expects parameter '@AN001_CDUSUARIO', which was not supplied.

But the delete ONLY works if I pass all the fields form gridview to datakeynames. So the update stops to work. The code is:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Usuario.aspx.vb" Inherits="Usuario" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Size="X-Large" Text="Cadastro de Usuários"></asp:Label><br />
        <br />
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AllowSorting="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999"
            BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSourceUsuarios" 
            GridLines="Vertical">
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <Columns>
                <asp:CommandField CancelText="Cancelar" DeleteText="Deletar" EditText="Editar" ShowDeleteButton="True"
                    ShowEditButton="True" />
                <asp:BoundField DataField="AS001_NOME" HeaderText="Nome" SortExpression="AS001_NOME" />
                <asp:BoundField DataField="AS001_RAMAL" HeaderText="Ramal" SortExpression="AS001_RAMAL" />
                <asp:BoundField DataField="AS001_EMAIL" HeaderText="E-mail" SortExpression="AS001_EMAIL" />
                <asp:BoundField DataField="AS001_LOGIN" HeaderText="Login" SortExpression="AS001_LOGIN" />
                <asp:BoundField DataField="AS001_SENHA" HeaderText="Senha" SortExpression="AS001_SENHA" />
                <asp:BoundField DataField="AD001_DTNASCIMENTO" HeaderText="Data Nascimento" SortExpression="AD001_DTNASCIMENTO" />
                <asp:BoundField DataField="AS001_ADMINISTRADOR" HeaderText="Administrador" SortExpression="AS001_ADMINISTRADOR" />
                <asp:BoundField DataField="AN001_CDUSUARIO" HeaderText="AN001_CDUSUARIO" InsertVisible="False"
                    SortExpression="AN001_CDUSUARIO" />
                <asp:BoundField DataField="AS003_CARGO" HeaderText="Cargo" SortExpression="AS003_CARGO" />
                <asp:TemplateField HeaderText="Setor" SortExpression="AS004_NOME">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSourceSetor"
                            DataTextField="AS004_NOME" DataValueField="AN005_CDSETOR" SelectedValue='<%# Bind("AN005_CDSETOR") %>'
                            Width="152px">
                        </asp:DropDownList><asp:SqlDataSource ID="SqlDataSourceSetor" runat="server" ConnectionString="<%$ ConnectionStrings:BdAtConnectionString %>"
                            SelectCommand="SELECT [AN005_CDSETOR], [AS004_NOME] FROM [T005_SETOR]"></asp:SqlDataSource>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("AS004_NOME") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
            <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="Gainsboro" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceUsuarios" runat="server" ConnectionString="<%$ ConnectionStrings:BdAtConnectionString %>" 
            SelectCommand="SELECT T001_USUARIO.AN001_CDUSUARIO, T001_USUARIO.AS001_NOME, T001_USUARIO.AS001_RAMAL, T001_USUARIO.AS001_EMAIL, T001_USUARIO.AS001_LOGIN, T001_USUARIO.AS001_SENHA, T001_USUARIO.AD001_DTCADASTRO, T001_USUARIO.AD001_DTEXCLUSAO, T001_USUARIO.AD001_DTNASCIMENTO, T001_USUARIO.AS001_ADMINISTRADOR, T003_FUNCIONARIO.AS003_CARGO, T005_SETOR.AN005_CDSETOR, T005_SETOR.AS004_NOME FROM T001_USUARIO INNER JOIN T003_FUNCIONARIO ON T001_USUARIO.AN001_CDUSUARIO = T003_FUNCIONARIO.AN001_CDUSUARIO INNER JOIN T005_SETOR ON T003_FUNCIONARIO.AN005_CDSETOR = T005_SETOR.AN005_CDSETOR AND T001_USUARIO.AD001_DTEXCLUSAO IS NULL"
            UpdateCommand="sp02_Update_Usuario" UpdateCommandType="StoredProcedure" InsertCommand="sp01_Insert_Usuario" InsertCommandType="StoredProcedure" DeleteCommand="sp03_Delete_Usuario" DeleteCommandType="StoredProcedure"> 
            <InsertParameters>
                <asp:Parameter Name="AS001_NOME" Type="String" />
                <asp:Parameter Name="AS001_RAMAL" Type="String" />
                <asp:Parameter Name="AS001_EMAIL" Type="String" />
                <asp:Parameter Name="AS001_LOGIN" Type="String" />
                <asp:Parameter Name="AS001_SENHA" Type="String" />
                <asp:Parameter Name="AD001_DTCADASTRO" Type="DateTime" />
                <asp:Parameter Name="AD001_DTEXCLUSAO" Type="DateTime" />
                <asp:Parameter Name="AD001_DTNASCIMENTO" Type="DateTime" />
                <asp:Parameter Name="AS001_ADMINISTRADOR" Type="String" />
                <asp:Parameter Name="AS003_CARGO" Type="String" />
                <asp:Parameter Name="AN005_CDSETOR" Type="Int32" />
            </InsertParameters>
            <DeleteParameters>
            <%--
                <asp:ControlParameter ControlID="GridView1" Name="AN001_CDUSUARIO"  PropertyName ="SelectedValue" />
                <asp:ControlParameter ControlID="GridView1" Name="AS001_NOME" PropertyName="SelectedValue" />
                <asp:ControlParameter ControlID="GridView1" Name="AS001_RAMAL" PropertyName="SelectedValue" />
                <asp:ControlParameter ControlID="GridView1" Name="AS001_EMAIL" PropertyName="SelectedValue"  />
                <asp:ControlParameter ControlID="GridView1" Name="AS001_LOGIN" PropertyName="SelectedValue"  />
                <asp:ControlParameter ControlID="GridView1" Name="AS001_SENHA" PropertyName="SelectedValue"  />
                <asp:ControlParameter ControlID="GridView1" Name="AD001_DTNASCIMENTO" PropertyName="SelectedValue"  />
                <asp:ControlParameter ControlID="GridView1" Name="AS001_ADMINISTRADOR" PropertyName="SelectedValue"  />
                <asp:ControlParameter ControlID="GridView1" Name="AS003_CARGO" PropertyName="SelectedValue"  />
                <asp:ControlParameter ControlID="GridView1" Name="AN005_CDSETOR" PropertyName="SelectedValue" />
              --%>             
                <asp:Parameter Name="AN001_CDUSUARIO" Type="Int32" />
                <asp:Parameter Name="AS001_NOME" Type="String" />
                <asp:Parameter Name="AS001_RAMAL" Type="String" />
                <asp:Parameter Name="AS001_EMAIL" Type="String" />
                <asp:Parameter Name="AS001_LOGIN" Type="String" />
                <asp:Parameter Name="AS001_SENHA" Type="String" />
                <asp:Parameter Name="AD001_DTNASCIMENTO" Type="DateTime" />
                <asp:Parameter Name="AS001_ADMINISTRADOR" Type="String" />
                <asp:Parameter Name="AS003_CARGO" Type="String" />
                <asp:Parameter Name="AN005_CDSETOR" Type="Int32" />
               
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="AN001_CDUSUARIO" Type="Int32" />
                <asp:Parameter Name="AS001_NOME" Type="String" />
                <asp:Parameter Name="AS001_RAMAL" Type="String" />
                <asp:Parameter Name="AS001_EMAIL" Type="String" />
                <asp:Parameter Name="AS001_LOGIN" Type="String" />
                <asp:Parameter Name="AS001_SENHA" Type="String" />
                <asp:Parameter Name="AD001_DTNASCIMENTO" Type="DateTime" />
                <asp:Parameter Name="AS001_ADMINISTRADOR" Type="String" />
                <asp:Parameter Name="AS003_CARGO" Type="String" />
                <asp:Parameter Name="AN005_CDSETOR" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" BackColor="White"
            BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSourceUsuarios"
            ForeColor="Black" GridLines="Vertical" Height="50px" Width="125px" DefaultMode="Insert" DataKeyNames="AN001_CDUSUARIO,AS001_NOME,AS001_RAMAL,AS001_EMAIL,AS001_LOGIN,AS001_SENHA,AD001_DTCADASTRO,AD001_DTEXCLUSAO,AD001_DTNASCIMENTO,AS001_ADMINISTRADOR,AS003_CARGO,AN005_CDSETOR,AS004_NOME">
            <FooterStyle BackColor="#CCCCCC" />
            <EditRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <Fields>
                <asp:BoundField DataField="AS001_NOME" HeaderText="Nome" SortExpression="AS001_NOME" />
                <asp:BoundField DataField="AS001_RAMAL" HeaderText="Ramal" SortExpression="AS001_RAMAL" />
                <asp:BoundField DataField="AS001_EMAIL" HeaderText="E-mail" SortExpression="AS001_EMAIL" />
                <asp:BoundField DataField="AS001_LOGIN" HeaderText="Login" SortExpression="AS001_LOGIN" />
                <asp:BoundField DataField="AS001_SENHA" HeaderText="Senha" SortExpression="AS001_SENHA" />
                <asp:BoundField DataField="AD001_DTNASCIMENTO" HeaderText="Data Nascimento" SortExpression="AD001_DTNASCIMENTO" />
                <asp:BoundField DataField="AS001_ADMINISTRADOR" HeaderText="Administrador"
                    SortExpression="AS001_ADMINISTRADOR" />
                <asp:BoundField DataField="AS003_CARGO" HeaderText="Cargo" SortExpression="AS003_CARGO" />
                <asp:TemplateField HeaderText="Setor" SortExpression="AS004_NOME">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("AS004_NOME") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSourceSetorInsert"
                            DataTextField="AS004_NOME" DataValueField="AN005_CDSETOR" SelectedValue='<%# Bind("AN005_CDSETOR") %>'
                            Width="208px">
                        </asp:DropDownList><asp:SqlDataSource ID="SqlDataSourceSetorInsert" runat="server"
                            ConnectionString="<%$ ConnectionStrings:BdAtConnectionString %>" SelectCommand="SELECT [AN005_CDSETOR], [AS004_NOME] FROM [T005_SETOR]">
                        </asp:SqlDataSource>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("AS004_NOME") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:CommandField ShowInsertButton="True" />
            </Fields>
            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="#CCCCCC" />
        </asp:DetailsView>
         
        <br />
        <br />
        <asp:Button ID="Button2" runat="server" Text="Voltar" Width="120px" /> <asp:Button
            ID="Button1" runat="server" Text="Button" /> <asp:Button ID="Button3" runat="server"
                Text="Button" /></div>
    </form>
</body>
</html>

   

Procedures:

CREATE PROCEDURE dbo.sp02_Update_Usuario
(@AN001_CDUSUARIO INTEGER,
@AS001_NOME VARCHAR(50),
@AS001_RAMAL VARCHAR(5),
@AS001_EMAIL VARCHAR(50),
@AS001_LOGIN VARCHAR(20),
@AS001_SENHA VARCHAR(20),
@AD001_DTNASCIMENTO DATETIME,
@AS001_ADMINISTRADOR VARCHAR(1),
@AS003_CARGO VARCHAR(50),
@AN005_CDSETOR INTEGER )

AS

BEGIN
 UPDATE T001_USUARIO SET AS001_NOME = @AS001_NOME, AS001_RAMAL = @AS001_RAMAL, AS001_EMAIL = @AS001_EMAIL, AS001_LOGIN = @AS001_LOGIN,
                                        AS001_SENHA = @AS001_SENHA, AD001_DTNASCIMENTO = @AD001_DTNASCIMENTO,
               AS001_ADMINISTRADOR = @AS001_ADMINISTRADOR WHERE AN001_CDUSUARIO = @AN001_CDUSUARIO;
 UPDATE T003_FUNCIONARIO SET AS003_CARGO = @AS003_CARGO, AN005_CDSETOR = @AN005_CDSETOR WHERE AN001_CDUSUARIO = @AN001_CDUSUARIO;
END
GO

 

CREATE PROCEDURE dbo.sp03_Delete_Usuario
(@AN001_CDUSUARIO INTEGER,
@AS001_NOME VARCHAR(50),
@AS001_RAMAL VARCHAR(5),
@AS001_EMAIL VARCHAR(50),
@AS001_LOGIN VARCHAR(20),
@AS001_SENHA VARCHAR(20),
@AD001_DTNASCIMENTO DATETIME,
@AS001_ADMINISTRADOR VARCHAR(1),
@AS003_CARGO VARCHAR(50),
@AN005_CDSETOR INTEGER )

AS

BEGIN
 UPDATE T001_USUARIO SET AD001_DTEXCLUSAO = GETDATE() WHERE AN001_CDUSUARIO = @AN001_CDUSUARIO;
END
GO

0
eduarno
9/30/2008 1:45:03 PM
asp.net.presentation-controls 72751 articles. 3 followers. Follow

1 Replies
681 Views

Similar Articles

[PageSpeed] 30

O solved.. I had to dynamically pass the parameters for delete and for update like this:

 

Protected Sub LinkButton1_Click(ByVal sender As Object, ByVal e As System.EventArgs)Dim parametros As String() = {"AN001_CDUSUARIO", "AS001_NOME", "AS001_RAMAL", "AS001_EMAIL", "AS001_LOGIN", "AS001_SENHA", "AD001_DTNASCIMENTO", "AS001_ADMINISTRADOR", "AS003_CARGO", "AN005_CDSETOR"}

GridView1.DataKeyNames = parametros

End Sub

Protected Sub LinkButton1_Click1(ByVal sender As Object, ByVal e As System.EventArgs)Dim parametros As String() = {}

GridView1.DataKeyNames = parametros

End Sub

 

thanks

0
eduarno
10/1/2008 12:45:33 PM
Reply:

Similar Artilces:

''''''''''''''''''''
Name: haznen Email: haznenatyahoodotcom Product: Gran Paradiso Alpha 8 Summary: '''''''''''''''''''' Comments: '''''''''''''''''''''''''''''''''''' Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061204 UGES/1.7.2.0 GranParadiso/3.0a1 From URL: http://www.mozilla.org/projects/granparadiso/ Note to readers: Hendrix gives...

'''''
Name: mario Email: ramar17atfastwebnetdotit Product: Gran Paradiso Alpha 2 Summary: ''''' Comments: K: Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2) Gecko/20070206 GranParadiso/3.0a2 ...

Procedure 'CRMC_ProductDetails' expects parameter '@Color', which was not supplied
I keep getting this error when I browse the productsdetail.aspx page... I am using the C# SDK version of the Commerce kit... I have added a new col in th eDB called "Color", and *thought* that I had fixed the strored proc, and the product.cs file... I can get the color from the db to display on the productslist.aspx page fine... Any ideas? Did you modify the ProductDetails GetProductDetails function in productsdb.cs?...

Procedure 'x' expects parameter '@y' which was not supplied.
I'm trying to update a member's record via stored procedure. The procedure is thus: ********************************* CREATE PROCEDURE upd_MemberProfile( @MemberID VarChar(10), @FirstName VarChar(20), @LastName VarChar(20), @Address VarChar(50), @City VarChar(40), @StateID Char(2), @ZipCode Char(5), @Email VarChar(30), @PayPalSubscrID VarChar(22) ) AS UPDATE Members SET FirstName = @FirstName, LastName = @LastName, Address = @Address, City = @City, StateID = @StateID, ZipCode = @ZipCode, Email = @Email, PayPalSubscrID = @PayPalSubscrID WHERE Me...

Procedure 'JaiDeleteUser' expects parameter '@user_name', which was not supplied
<html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"><title>Untitled Page</title> </head> <body>   <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager>   <div>   <br /> <asp:Label ID="lblUserInfo" runat="server" Text="Label"></asp:Label><asp:SqlDataSource ID="SqlDataSource1" runat="server"...

Procedure 'Create_User' expects parameter '@Password', which was not supplied.
Hi AllGetting Procedure 'Create_User' expects parameter '@Password', which was not supplied errorI can't register new user in role based system app, the following code is from register.aspx: private void Submit_Click(object sender, System.EventArgs e) { User user; if (Context.User.Identity.IsAuthenticated) user = new User(((SiteIdentity)User.Identity).UserID); else user = new User(); user.FullName = FullName.Text; user.Email = Email.Text; user.Password = Password.Text; user.Biography = Biography.Text; if (Context.User.Identity.IsAuthenticated) { user.Update(); Response.Redirec...

Procedure 'sp_GetEEByDept' expects parameter '@tkdept', which was not supplied.
I have a basic vb.net form with a few text fields and dropdown boxes.  In one of the dropdown boxes, I ask the user to select a department.  After the user selects the department, I want to fill another dropdown box with employees that belong to the selected dept.  I keep getting an error for my procedure that is to get the employees, because I can't figure out how to pass in the department selected in the first drop down box.  ARGH... Also, do I need to set the employee dropdown box visible to false until the first dropdown selection is made, otherwise, it'd be b...

Procedure or Function 'SubscribeToNewsletters' expects parameter '@emailAddress', which was not supplied.
Hi i have been trying to insert some values selected in a checkbox list into the database, however it is giving me the following error "Procedure or Function 'SubscribeToNewsletters' expects parameter '@emailAddress', which was not supplied. "public void Page_Load(object sender, EventArgs e) -- on page load the checkbox list is populated through stored procedure (stream_NewsletterTypes) { try {SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["streamConnectionString"].ConnectionString); SqlCommand command = new SqlCommand(...

Procedure or Function 'retrieve_product' expects parameter '@productPrice', which was not supplied.
Hi i am getting this error whenever i try to execute a stored procedure, below is my stored procedure;  ALTER PROCEDURE [dbo].[retrieve_product] -- Add the parameters for the stored procedure here @productPrice decimal (10,2), @productInfoURL varchar (255), @categoryName varchar (255),@companyName varchar (255), @subCategoryName varchar (255), @companyWebsiteURL varchar (255) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT Categories.categoryName, SubC...

Procedure or function 'selectFromView' expects parameter '@Year', which was not supplied. ???
 hay all, i'm trying to pass parameters to a stored procedure ..and i keep getting this error "Procedure or function 'selectFromView' expects parameter '@Year', which was not supplied." this is the procedure implementation : ALTER PROCEDURE dbo.selectFromView @Year as varchar(10), @Country as varchar(10), @Family as varchar(10), @Manu as varchar(10), @Status as varchar(10), @Type as varchar(10), @Operator as varchar(10) AS SELECT * FROM ViewofAll WHERE ProductionYear = @Year...

Procedure or Function 'UpdateContactInfoProc' expects parameter '@SUBURB', which was not supplied.
I tried to use this update stored procedure from a objectdatasource which calls the method "UpdateCompanyInfo", however, once I leave an item to be empty I got the error as title.My stored procedure:ALTER PROCEDURE dbo.UpdateContactInfoProc@Contact_ID int,@Contact_Type_ID int,@Name nvarchar(100),@TEL nvarchar(50),@EMAIL nvarchar(50),@ADDRESS nvarchar(200),@SUBURB nvarchar(50),@FAX nvarchar(50),@STATE nvarchar(50),@POSTCODE nvarchar(50),@COUNTRY nvarchar(50),@Description textASUpdate Contactset Contact_Type_ID = @Contact_Type_ID, [Name] = @Name, TEL = @TEL, EMAIL = @EMAIL, ADDRESS=@...

Error--Procedure 'SP_Insert_NewPipeLine' expects parameter '@CompanyId', which was not supplied.
Can any body help me in solving this problem. First I use to get Error which reads "Object Must Implement Iconvertible" After using the overloaded Sp.paramerers.add() function It started giving this problem. I am giving the sample code. ConObject = new SqlConnection(ConString); ConObject.Open(); string SpString ="dbo.SP_Insert_NewPipeLine"; SqlCommand CmdObject = new SqlCommand(SpString,ConObject); CmdObject.CommandType = CommandType.StoredProcedure; CmdObject.Parameters.Add("@RequestTypeId",SqlDbType.Int,4,"0"); //CmdObject.Parameters["@RequestTypeId"].Value= 0; CmdObject.Parame...

SQL_Error Procedure 'DelectHostName' expects parameter '@Host', which was not supplied.
How do I supply the parameter @Host?  Below is the part of my code that has the call to the stored procedure  public void DeleteHostName() { // start of the method using (SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))            {                 cn.Open();                SqlCommand cmd = new SqlCommand("hnDeleteHost&...

Procedure or Function 'syl_EmailQueueInsert' expects parameter '@EmailCC', which was not supplied.
We have a email table in the database (SQL Server 2005). When we try to execute the Insert Stored Proc in the database to add a record and leave the EmailCC and EmailBCC fields blank we are getting the following error: Msg 201, Level 16, State 4, Procedure syl_EmailQueueInsert, Line 0Procedure or Function 'syl_EmailQueueInsert' expects parameter '@EmailCC', which was not supplied. The EmailCC and EmailBCC are set to allow nulls. Shouldn’t the system automatically insert nulls into those colums if no value is supplied??? What am I doing wrong? Newbie I a...

Web resources about - Procedure 'sp03_Delete_Usuario' expects parameter '@AN001_CDUSUARIO', which was not supplied. - asp.net.presentation-controls

Resources last updated: 12/4/2015 6:54:00 AM