1 Reply Latest reply on Jan 11, 2012 7:52 AM by Timothy Murphy

    WebSQL client-side database running server-side

    Timothy Murphy

      We have a local database running on an MC9190 WM6.5.  Trying to redirect the local client page to a server-side HTM page, produces the following error log entry:

       

      Engine ot match the number of ? placeholders...

      SYNTAX_ERR: DOM SQL Exception 5: Invalid or unauthorized statement; or the number of arguments did not match the number of ? placeholders

       

      The lines this is referring to is:

      var sql = 'select orderId, deliveryDate, statusCode, department, createDateTime, setDateTime from OrderHeader where orderid=' + orderId;

      results = readTransaction.executeSql(sql,[]);

       

      Running the same page client-side works as expected.

       

      Any thoughts?