SQLite help

#1 Any particular message in the log file when this happens?

#2 Noting. I put an echo statement before and after. The one before hits, the one after does not. Even put echo just before the actual query and it hits and crashes.

#3 Which resource are you using? I used the ODBC resource and found that there were a number of returned types that it didn't handle properly. It would also return garbage instead of nulls. After mucking about with the source I was able to add the missing types but didn't have time to deal with the null issue.

Since then I've moved all the sql code out of my game and just make web service calls, leaving the sql on the server side which is also more secure.

#4 I've run into this same problem with MySQL. In MySQL when the value you are searching isn't in the table it returns nothing. I suspect SQLite does the same thing. It appears this is the problem.

I was able to get around this as follows:

// Verify username exists in database, returning an empty result set will crash the engine
	%mysql.Query ("SELECT IFNULL(count(usrname), 0) as Result FROM player WHERE usrname='"@%username@"'");
	%result= %mysql.StoreResult();

	%mysql.FetchRow (%result);
	%usrcnt = %mysql.GetRowCell(%result, "Result");
	%mysql.FreeResult (%result);
   
   // Now look up password
   if(%usrcnt)
   {
      %mysql.Query ("SELECT password FROM player WHERE usrname='"@%username@"'");

idea is to check to see if the name is present and if so go get the username.

#5 I keep getting SQLite Query Error: near "IFNULL": syntax error
This is what I have:
"SELECT * IFNULL(Name, 0) as Result FROM PlayerTable WHERE Name = '"@ $pref::player::name @"'" ;