Raised This Month: $ Target: $400
 0% 

[HELP] sql code doesnt working


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
quark
Veteran Member
Join Date: Oct 2011
Location: Your mind.
Old 08-21-2013 , 08:32   [HELP] sql code doesnt working
Reply With Quote #1

PHP Code:
public UpdateValues()
{
    new 
szTemp512 ]
    
formatexszTempcharsmaxszTemp ),
    
"UPDATE %s SET value1 = '%d', value2 = '%d' WHERE id = '%d'",
    
TABLEvalue1value2ID )
    
    
SQL_ThreadQueryg_SqlTuple"IgnoreHandle"szTemp )
}

public 
IgnoreHandleFailStateHandle:QueryError[ ], ErrcodeData[ ], DataSize )
{
    
SQL_FreeHandleQuery )

So , i'm trying to put in table 2 values, but it's not working.
No output errors or log errors.
__________________

Check out My Plugins:
qServerInfo ; ASKTAG

Last edited by quark; 08-21-2013 at 08:38.
quark is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 08-21-2013 , 09:51   Re: [HELP] sql code doesnt working
Reply With Quote #2

Try to see if show a error in sql

PHP Code:
public IgnoreHandleFailStateHandle:QueryError[ ], ErrcodeData[ ], DataSize )
{
    if(
FailState)
    {
        
server_print(Error);
    }

    
SQL_FreeHandleQuery )


but, ID in formatex function is a string or a integer value?
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
quark
Veteran Member
Join Date: Oct 2011
Location: Your mind.
Old 08-21-2013 , 10:04   Re: [HELP] sql code doesnt working
Reply With Quote #3

it's a number.
__________________

Check out My Plugins:
qServerInfo ; ASKTAG
quark is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 08-21-2013 , 10:08   Re: [HELP] sql code doesnt working
Reply With Quote #4

Quote:
Originally Posted by quark View Post
it's a number.
You tried to see a error?
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
Old 08-21-2013, 10:15
quark
This message has been deleted by quark.
quark
Veteran Member
Join Date: Oct 2011
Location: Your mind.
Old 08-21-2013 , 10:23   Re: [HELP] sql code doesnt working
Reply With Quote #6

No errors on logs , and i dont have acess to server console.
__________________

Check out My Plugins:
qServerInfo ; ASKTAG
quark is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 08-21-2013 , 10:33   Re: [HELP] sql code doesnt working
Reply With Quote #7

Quote:
Originally Posted by quark View Post
No errors on logs , and i dont have acess to server console.
It is a error in sql syntax for me, but if you not get errors or not acess server console, we not able to help you only using this informations.

For last trie,

PHP Code:
public IgnoreHandleFailStateHandle:QueryError[ ], ErrcodeData[ ], DataSize )
{
    if(
FailState)
    {
        
log_amx(szError);
    }

    
SQL_FreeHandleQuery )

__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 

Last edited by ^SmileY; 08-21-2013 at 10:33.
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
quark
Veteran Member
Join Date: Oct 2011
Location: Your mind.
Old 08-21-2013 , 10:56   Re: [HELP] sql code doesnt working
Reply With Quote #8

Quote:
Originally Posted by ^SmileY View Post
It is a error in sql syntax for me, but if you not get errors or not acess server console, we not able to help you only using this informations.

For last trie,

PHP Code:
public IgnoreHandleFailStateHandle:QueryError[ ], ErrcodeData[ ], DataSize )
{
    if(
FailState)
    {
        
log_amx(szError);
    }

    
SQL_FreeHandleQuery )

You we're right, it was a syntax error. It's fully working now
__________________

Check out My Plugins:
qServerInfo ; ASKTAG
quark is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 15:52.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode