SQLite

[Admins]

Well for errors I gave the suggestion to write a wrapper function:

PHP Code:

function getsql(query) {
  temp.req = requestsql(query,true);
  if (!temp.req.completed && !waitfor(temp.req,"onReceiveData",60))
    return NULL;
  if (temp.req.error!="")
    echo(temp.req.error);
  return temp.req;
} 


For escaping use the string.escape() function.

[Inverness]

Originally Posted by Stefan

For escaping use the string.escape() function.

I don't believe that is the same thing as what I'm talking about. For example, if a have a graal string "It's alive!" and I want to stick it in as a string value in an SQL statement string then it needs to be changed to "'It''s alive!'". the SQL strings have the single quotes around them plus any single quotes inside the string need to have a second single quote after it to be escaped.

Also, I don't think you specified what the boolean value was for in requestsql() and requestsql2().

[napo_p2p]

Originally Posted by Inverness

Also, I don't think you specified what the boolean value was for in requestsql() and requestsql2().

It's in /scripthelp now:

requestsql(str, bool) - returns object - executes a sql query for the default database, parameters are the query string and if you expect a result (e.g. from a select-query); the result is an event object, call waitfor(requestobj,"onReceiveData",60) and then use requestobj.rows, error and lastinsertid

requestsql2(str, str, bool) - returns object - like requestSQL(), but allows you to select the database, parameters are database identifier, query, expect result (true/false)