I have two quick questions about this tutorial if you have a chance to placate my inquiry.
When executing an SQL query such as: "SELECT UserID FROM FormsData WHERE UserID = 'DDuck'" in a cloned node works fine if I have bound a field <TextField1> to the data connection I am using. Makes sense. You reopen the connection, the data connection re-queries the DB and the form remerges the data into the bound (from $record.dataconnectionname.User) object.
A problem I am having is if DDuck isn't a user in the DB. The query seems to break, the code quits, and I don't get any errors. In SQL, if you were to query the above I might get a return of something like this:
I was hoping for a null or something I could test against.
The second one is quicker I think. Executing the DB connection with the string above from the cloned node with the following command:
var dUser = "'DDuck'"
oDB.resolveNode("#command").query.select = "SELECT UserID FROM FormsData WHERE UserID = + dUser" <just an example>
How do I get the return value into a variable. Does it simply enter into oDB.rawValue? I don't think it's that simple right? I think I am a bit frazzled on the subject and could use a pointer.