1 Reply Latest reply on May 15, 2009 9:16 AM by Sean hepburn

    Database Connection Error

    Sean hepburn

      Hi, can anyone tell me where I'm going wrong here please? I've set up a database and linked to it, but I'm having trouble navigating it using a dropdown box to select records. The drop down lists all the ID's for the records, but the refresh button, which should update all the other fields from the same record, gives the error message in the screen grab below. The code behind the refresh button is...

       

       

       

       

       

       

       

      if

       

       

      (Len(Ltrim(Rtrim(DropDownList16.rawValue))) > 0)

      then

       

      $sourceSet.DataConnection2.#command.query.commandType

      =

      "text"

       

      $sourceSet.DataConnection2.#command.query.select.nodes.item(0).value

      =Concat("Select * from Table1 Where CoureTitle = ",Ltrim(Rtrim(DropDownList16.rawValue)) ,

      "")

      $sourceSet.DataConnection2.open()

      endif

       

      Untitled picture.png

      Any help or pointers to tutorials would be very much appreciated.

       

      Sean