SQL QUERY
there are 26 errors
24 are undefined symbol "INT" line 291-314 1 is undefined symbol "ClientName" line 290 1 is invalid string <possibly non-terminated string> line290 Code:
Queries = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS TRMOD_DB ( |
Re: SQL QUERY
I've seen others have problems with string that are too long, I believe they had to format the whole query into a buffer.
|
Re: SQL QUERY
solved thx
but another error occurs.. here's the code Code:
new bool:IsUserHaveNickname[33][51]Code:
if(SQL_NumResults(Query) < 1) |
Re: SQL QUERY
IsUserHaveNickname holds booleans, and I'm guessing SQL_ReadResult is an integer.
You can't assign integers to a boolean without having a tag mismatch error. |
Re: SQL QUERY
Code:
`CN_BOOL_IsUserHaveNickname_0`//SQL_ReadResult(Query, i+31)Code:
CN_BOOL_IsUserHaveNickname_0 varchar(6)//not interger |
Re: SQL QUERY
Read what the function does before you try to understand anything:
http://www.amxmodx.org/funcwiki.php?...sult&go=search And I quote: Quote:
|
Re: SQL QUERY
read it before
forgot.. thx anyway btw after edited: Code:
new TempString[32] |
Re: SQL QUERY
Code:
for(new i; i < 51; i++) |
Re: SQL QUERY
Well, TempString is just that, a string, it's not a bool or integer. What is the contents of TempString when you retrieve it?
|
Re: SQL QUERY
In i+31, i insert "false" / "true"(the thing i retrieve)
a little part of the code: Code:
len += formatex(TempQuery[len], charsmax(TempQuery)-len, "'true',") |
| All times are GMT -4. The time now is 03:31. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.