locked
Using variables as in SQL queries for Access RRS feed

  • Question

  • User904890884 posted

    Hello,

    I'm creating a site where someone logs in and can enter data that updates an Access database. I'm using formview for the data entry;

        <asp:AccessDataSource ID="Description" runat="server" 
            DataFile="~/App_Data/datanew.mdb" 
            
            SelectCommand="SELECT CDescription FROM [Conference Details] WHERE (CID = 42346)" 
            UpdateCommand="UPDATE [Conference Details] SET [Conference Details].CDescription=CDescriptionTextBox WHERE [Conference Details].CID=42346" SelectCommandType="Text">
            
        </asp:AccessDataSource>

     My problem is that CID will change depending on what user is logged in. I've tried setting CID to a variable eg: x    and using that in the query but I get an error.

    Is there an easier way to do this.

    Any help whatsoever appreciated,

    Thanks in advance.

    Wednesday, January 28, 2009 1:59 PM

Answers

All replies