logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Serveur with NWNX4 1.04 crash when a select retreive a NULL

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Technical support
View previous topic :: View next topic  
Author Message
yi



Joined: 17 May 2005
Posts: 12
Location: France

PostPosted: Sun Nov 19, 2006 18:31    Post subject: Serveur with NWNX4 1.04 crash when a select retreive a NULL Reply with quote

Papillon,

NWNXServeur crash when I retreive a NULL string with the version 1.04 (with MySQL database)

request : a simple
Quote:
SELECT toto FROM table


A will do some test to have more precision
_________________
http://www.arkalym.com
Back to top
View user's profile Send private message
amphiprion



Joined: 07 Nov 2006
Posts: 44
Location: Toulouse (France)

PostPosted: Sun Nov 19, 2006 18:34    Post subject: Reply with quote

Same bug here (field type independant - VARCHAR - INT- ....)
Back to top
View user's profile Send private message
yi



Joined: 17 May 2005
Posts: 12
Location: France

PostPosted: Sun Nov 19, 2006 18:53    Post subject: Reply with quote

more details

it crashs if the result of the request is NULL
it does not crahs if the result of the resquest is empty

I hope it helps
_________________
http://www.arkalym.com
Back to top
View user's profile Send private message
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Sun Nov 19, 2006 19:42    Post subject: Reply with quote

Fixed. Redownload the prototype4 archive to get the updated version.

I wonder what would be better: Should NWNX return "NULL" or "" (empty string) for NULL columns ? I think an empty string is more in line with how NWScript works and what users probably expect.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
yi



Joined: 17 May 2005
Posts: 12
Location: France

PostPosted: Sun Nov 19, 2006 19:57    Post subject: Reply with quote

I vote "empty string"
_________________
http://www.arkalym.com
Back to top
View user's profile Send private message
amphiprion



Joined: 07 Nov 2006
Posts: 44
Location: Toulouse (France)

PostPosted: Sun Nov 19, 2006 19:58    Post subject: Reply with quote

thanks papillon, and yes, it's better to return empty value for compliance and nwscript logic.
Back to top
View user's profile Send private message
Grinning Fool



Joined: 12 Feb 2005
Posts: 264

PostPosted: Mon Nov 20, 2006 4:52    Post subject: Reply with quote

Agreed, empty string makes the most sense and would be consistent with prior versions (and compatible with existing scripts).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Technical support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group