Post reply

The multi-part identifier "" could not be bound

  • April 14, 2012 at 11:47 am

    #392025

    Hey guys , I am curently fallen in an adverse situation . I am at the end of my website and this situation occurs as follows:-

    I got 2 tables named "userdata" and "userresult" such that when user registers himself to the site , his information is inserted to both the tables . now , the login section of the website uses userdata page and then stores the "mail" column of userdata in session["mail"] .at the end of my exam website , i want to store the result of the exam undertaken by the user in "userresult" table and i m following this code --

    cmdd.CommandText = "update userresult set asp_beginner= " + final.ToString() + "where mail = " + Session["mail"].ToString()";

    here "final" stores the result

    and i m getting this error :

    The multi-part identifier "dean@gmail.com" could not be bound.

    here dean@gmail.com is the email id of the user stored in both the tables .

    please help friends as soon as possible .

  • April 14, 2012 at 12:12 pm

    #1473673

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1283659-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply