Reply to topic  [ 38 posts ]  Go to page Previous  1, 2, 3, 4  Next
JeF's Toolbox v0.9 (beta) (discontinued) 
Author Message
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1093
Location: France
Post Re: JeF's Toolbox v0.812 (beta)
TerribleFloater wrote:
OK. But you try to find the other way please! There are 55 *.nls in "C:\WINDOWS\system32", JeF's interface will lose it's convenience (out of the box, you know) :(
Sure, the 'custom folder' idea was just to keep plugin preview working for you in any case until a global solution is found... You can leave the file where it is and redo the patch if you reinstall JeF's interface before fix is released.
I think i will find a global solution using utf-8 encoding, so this will work for all charsets (without 55* specific behaviours).


Sat Nov 27, 2010 11:18 am
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1093
Location: France
Post Re: JeF's Toolbox v0.813 (beta)
v0.813 : bug fixes in Extra Queries Module
- Fix move up/down query
- Fix import (from examples on forum)
- Fix preview : cyrillic characters should now be correctly displayed
- Added message when sql command is invalid (just a fail status, not a syntax analyzer/helper)
- one new string in language file
JeF


Sat Nov 27, 2010 11:48 pm
Profile
Superstar

Joined: Thu Feb 28, 2008 4:20 pm
Posts: 1179
Post Re: JeF's Toolbox v0.813 (beta)
It doesn't know how to output result with aliases, right? I mean, when query is:
Code:
SELECT m.code as "Number", m.title_sort as "Movie", m.year as "Release date" FROM movies m where m.in_collection=1 order by m.title_sort, m.year asc

the result is:


Attachments:
Безымянный.PNG
Безымянный.PNG [ 5.96 KiB | Viewed 2847 times ]

_________________
Тестер, помни: багрепорт «ничего не работает!» оскорбляет чувства программирующих. (с) баш
Sun Nov 28, 2010 6:20 am
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1093
Location: France
Post Re: JeF's Toolbox v0.814 (beta)
TerribleFloater wrote:
It doesn't know how to output result with aliases, right?
Yes, it did a very basic syntax analysis of the string before 'from' clause.
v0.814 now suports aliases.
Are cyrillic characters now ok in preview without patching 'List.html' ?
JeF


Sun Nov 28, 2010 11:49 am
Profile
Superstar

Joined: Thu Feb 28, 2008 4:20 pm
Posts: 1179
Post Re: JeF's Toolbox v0.814 (beta)
JeF wrote:
Are cyrillic characters now ok in preview without patching 'List.html' ?
JeF

Oh, yes. It's OK now. Thanks. But there is a new strange problem :-)
I added the new query:
Code:
SELECT t1.name AS name, t1.code AS code1, t1.birth_date AS birth_date1, t1.original_name AS original_name1, t2.code AS code2, t2.birth_date AS birth_date2, t2.original_name AS original_name2 FROM persons t1, persons t2 WHERE (t1.name = t2.name AND t1.code<t2.code) order by t1.name, t1.code asc

It works great (BTW, try this... very useful for search of double persons). And when I press "Close" button, error window says:
Code:
A name contained an invalid character.
Line: 13
<Query><CategoryCode>2</CategoryCode><Na

That's all, the window is too small to fit entire message.
So I can't save my favorite query.
I've tried all categories, all names. Nothing helps :-(

_________________
Тестер, помни: багрепорт «ничего не работает!» оскорбляет чувства программирующих. (с) баш


Sun Nov 28, 2010 1:15 pm
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1093
Location: France
Post Re: JeF's Toolbox v0.814 (beta)
TerribleFloater wrote:
JeF wrote:
Are cyrillic characters now ok in preview without patching 'List.html' ?
JeF

Oh, yes. It's OK now.
Thanks for testing.
Quote:
But there is a new strange problem :-)
error window says: A name contained an invalid character.
Ok, this is due to '<' character which was wrongly interpreted as xml begin tag (sql command wasn't protected/encoded)...
v0.815 fixes this. You can now save your prefered query :)
Thanks for the query, added to 'Extra Queries' topic :)
JeF


Sun Nov 28, 2010 4:19 pm
Profile
Superstar

Joined: Thu Feb 28, 2008 4:20 pm
Posts: 1179
Post Re: JeF's Toolbox v0.814 (beta)
JeF wrote:
v0.815 fixes this. You can now save your prefered query :)

Thanks again :)
JeF wrote:
Thanks for the query, added to 'Extra Queries' topic :)

Wow, Hall of Fame :D
BTW, this query is only useful with this plugin: you can save the result, compare it with previous one, mark good persons green, bad ones red and so on...

_________________
Тестер, помни: багрепорт «ничего не работает!» оскорбляет чувства программирующих. (с) баш


Sun Nov 28, 2010 5:25 pm
Profile
Superstar

Joined: Thu Feb 28, 2008 4:20 pm
Posts: 1179
Post Re: JeF's Toolbox v0.815 (beta)
Bad news, good news...
Bad news: 0.815 crashes the program :-(
Good news: that's all.

_________________
Тестер, помни: багрепорт «ничего не работает!» оскорбляет чувства программирующих. (с) баш


Mon Nov 29, 2010 7:11 am
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1093
Location: France
Post Re: JeF's Toolbox v0.815 (beta)
TerribleFloater wrote:
Bad news, good news...
Bad news: 0.815 crashes the program :-(
Good news: that's all.
Ok, v0.816 has 'crash feature' disabled :)
JeF


Mon Nov 29, 2010 1:06 pm
Profile
Superstar

Joined: Thu Feb 28, 2008 4:20 pm
Posts: 1179
Post Re: JeF's Toolbox v0.815 (beta)
JeF wrote:
Ok, v0.816 has 'crash feature' disabled :)

Yeah, the "Limited Edition" works fine, thanks :D

_________________
Тестер, помни: багрепорт «ничего не работает!» оскорбляет чувства программирующих. (с) баш


Tue Nov 30, 2010 8:27 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 38 posts ]  Go to page Previous  1, 2, 3, 4  Next

Who is online

Users browsing this forum: No registered users and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.