1 Reply Latest reply on Jul 19, 2016 12:34 PM by JJGearhart

    Error Showing When Fetching And Inserting Data With Contact1 Table From Asp.Net Application

    ALahir Rookie

      When I login to the Goldmine system from my Asp.Net application, it is successful. However, when I try to fetch data from Contact1 table of GoldMine_New database, it gives an error. We are using the below query-

      <GMAPI call="DS_Query" SessionID="1">

      <data name="SQL">select contact, company, key1 from contact1 where contact=’Connie Correch’</data>

      <data name="Filter"/>

      </GMAPI>

      When the above query executes, it is giving me the below result-

      <GMAPI SessionID="2" call="DS_Query">

        <status code="0">Call did not succeed. select contact, company, key1 from contact1 where contact='Connie Correch'</status>

      </GMAPI>

       

      After logging in, when I try to insert the data with Session ID into the Contact1 table of GoldMine_New database, it gives another error. Could you please tell me if there’s anything that I am missing.

      I am giving below the XML data of my insertion:-

       

      <GMAPI call="WriteContact" SessionID="2">

        <data name="Contact">Sw test contact</data>

        <data name="Company">Sw test company</data>

        <data name="Phone1">3106548963</data>

        <data name="Email">[email protected]</data>

        <data name="WebSite">www.gmail.com</data>

      </GMAPI>

      Any help is greatly appreciated.