Re: [BioMart Users] Problems with boolean fields in Mart Configurator (release-0_8-candidate_7)

[Syed Haider]

Hi Gert,

i am afraid i cannot say much on the fix time line. Arek et al, should 
know more on this.

Best,
Syed

On 09/02/2012 00:29, Gert Hulselmans wrote:
Hi Syed,

Thanks for the answer.
Can you let me know, when it is properly fixed?

Greetings,
Gert

________________________________________
From: Syed Haider [sa...@cam.ac.uk]
Sent: Thursday, February 09, 2012 1:18 AM
To: Gert Hulselmans
Cc: users@biomart.org
Subject: Re: [BioMart Users] Problems with boolean fields in Mart Configurator 
(release-0_8-candidate_7)

Hi Gert,

Clearly the only combination that seemed to be working is singleSelect.
I was hoping that logs would have the SQL statement itself logged in -
but thats not the case. In short, the query compilation is perhaps the
one which needs to be fixed for this case. I guess safest route for you
right now is to use singleSelect.

Best,
Syed

On 08/02/2012 09:44, Gert Hulselmans wrote:
Hi Syed,

Order of the queries:

1. Simplerepeat: type boolean ==>  select 'Only'
- Dropdown values are set to "false" and "true" (filled in by update
button)
- "Error has occurred"
2. Simplerepeat: type boolean ==>  select 'Excluded'
- Dropdown values are set to "false" and "true" (filled in by update
button)
- "Error has occurred"
3. Microsatellite: type boolean ==>  select 'Only'
- Dropdown values are set to "0" and "1" (changed manually)
- "Error has occurred"
4. Microsatellite: type boolean ==>  select 'Excluded'
- Dropdown values are set to "0" and "1" (changed manually)
- "Error has occurred"
5. Segmentational duplication : type SingleSelect ==>  select '1'
- Dropdown values are set to "0" and "1" (changed manually)
- Correct results
6. Segmentational duplication : type SingleSelect ==>  select '0'
- Dropdown values are set to "0" and "1" (changed manually)
- Correct results
7. Segmentational duplication : type SingleSelect ==>  select 'true'
- Dropdown values are set to "false" and "true" (filled in by update
button)
- Wrong results (only results with Segmental duplication = 0 are shown)
8. Segmentational duplication : type SingleSelect ==>  select 'true'
- Dropdown values are set to "false" and "true" (filled in by update
button)
- "Correct" results (only results with Segmental duplication = 0 are shown)


Here is the relevant part of the log:

2012-02-03T09:27:09+0100 INFO [445882584@qtp-1468206791-3:Log.java:165]:
Incoming XML query:<!DOCTYPE Query><Query client="biomartclient"
processor="TSVX" limit="1000" header="1"><Dataset name="cancerlcbmut"
config="snvs_config"><Filter name="snvs__simplerepeat_101"
value="only"/><Attribute name="snvs__chr_101"/><Attribute
name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:27:09+0100 INFO [445882584@qtp-1468206791-3:Log.java:165]:
Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__simplerepeat_101:
only"]}
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ''NOT NULL'' at
line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795)
at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757)
at
org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171)

at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73)
at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)
2012-02-03T09:27:09+0100 INFO [445882584@qtp-1468206791-3:Log.java:165]:
Total query time is 226 ms
2012-02-03T09:30:56+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__simplerepeat_101" value="excluded"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:30:56+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__simplerepeat_101:
excluded"]}
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ''NULL'' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795)
at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757)
at
org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171)

at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73)
at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)
2012-02-03T09:30:56+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 12 ms


2012-02-03T09:32:41+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__microsat_101" value="only"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:32:41+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__microsat_101:
only"]}
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ''NOT NULL'' at
line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795)
at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757)
at
org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171)

at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73)
at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)
2012-02-03T09:32:41+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 12 ms
2012-02-03T09:36:30+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__microsat_101" value="excluded"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:36:30+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__microsat_101:
excluded"]}
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ''NULL'' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.biomart.queryEngine.SubQuery.executeDatabaseQuery(SubQuery.java:795)
at org.biomart.queryEngine.SubQuery.executeQuery(SubQuery.java:757)
at
org.biomart.queryEngine.QueryRunnerThread.recurseSubQueries(QueryRunnerThread.java:171)

at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:73)
at
org.biomart.queryEngine.QueryRunnerThread.call(QueryRunnerThread.java:37)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)
2012-02-03T09:36:30+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 12 ms


2012-02-03T09:36:51+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__segdup_101" value="1"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:36:51+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101:
1"]}
2012-02-03T09:36:51+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 235 ms
2012-02-03T09:37:10+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__segdup_101" value="0"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:37:10+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101:
0"]}
2012-02-03T09:37:10+0100 INFO
[1870285440@qtp-1468206791-4:Log.java:165]: Total query time is 237 ms


2012-02-03T09:54:14+0100 INFO
[1478626955@qtp-1468206791-8:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__segdup_101" value="true"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:54:14+0100 INFO
[1478626955@qtp-1468206791-8:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101:
true"]}
2012-02-03T09:54:14+0100 INFO
[1478626955@qtp-1468206791-8:Log.java:165]: Total query time is 662 ms
2012-02-03T09:55:32+0100 INFO
[1478626955@qtp-1468206791-8:Log.java:165]: Incoming XML query:<!DOCTYPE
Query><Query client="biomartclient" processor="TSVX" limit="1000"
header="1"><Dataset name="cancerlcbmut" config="snvs_config"><Filter
name="snvs__segdup_101" value="false"/><Attribute
name="snvs__chr_101"/><Attribute name="snvs__startpos_101"/><Attribute
name="snvs__simplerepeat_101"/><Attribute
name="snvs__microsat_101"/><Attribute
name="snvs__segdup_101"/></Dataset></Query>
2012-02-03T09:55:32+0100 INFO
[1478626955@qtp-1468206791-8:Log.java:165]: Query =
{"dataset":"cancerlcbmut","attributes":["snvs__chr_101","snvs__startpos_101","snvs__simplerepeat_101","snvs__microsat_101","snvs__segdup_101"],"filters":["snvs__segdup_101:
false"]}
2012-02-03T09:55:32+0100 INFO
[1478626955@qtp-1468206791-8:Log.java:165]: Total query time is 239 ms


On 02/01/2012 10:06 PM, Syed Haider wrote:
Gert,

For the settings whereby you get the incorrect results from the
webinterface, what do the logs suggest
(biomart-java/dist/logs/stdouterr*) ?

You can see the query in the logs and please post here.

thanks
Syed


On 01/02/2012 16:35, Arek Kasprzyk wrote:
Hi Gert,
have you tried 'rc6'? (this is the last version officially released).
Are
you experiencing the same problem there?

a


On Wed, Feb 1, 2012 at 11:17 AM, Gert Hulselmans<
gert.hulselm...@med.kuleuven.be>  wrote:

Hi,

I am trying to use Mart Configurator of BioMart
(release-0_8-candidate_7)
with my custom table.

I have some fields with boolean data (stored as TINYINT(1)):
- false is stored as 0
- true is stored as 1

When I give such a field a boolean type in Mart Configurator, I get:

"Error has occurred"

when I select one of the options (Only or Excluded) and press "Go" in
the webinterface.

When looking at the "Dropdown list" in Mart Configurator, I see:
- false
- true

Changing those values to 0 and 1 respectively, doesn't help (same
error).

If I change the fileds with the boolean data to singleSelect or
multiSelect type in Mart Configurator
and select 'true' or 'false', both return only columns with '0' for
that
field.

When changing 'false' ->  '0' and 'true' ->  '1' in the "Dropdown list",
selecting '0' or '1' return
the right columns.


Is this a bug or am I doing something wrong?


Another question.
Where can I find documentation about all property fields in Mart
Configurator?
The PDF manual doesn't cover them all.

Is it possible to specify in Mart Configurator which checkboxes for the
attributes section
of the webinterface should be checked by default in the webinterface?


Greetings,
Gert Hulselmans
______________________________**_________________
Users mailing list
Users@biomart.org
https://lists.biomart.org/**mailman/listinfo/users<https://lists.biomart.org/mailman/listinfo/users>




_______________________________________________
Users mailing list
Users@biomart.org
https://lists.biomart.org/mailman/listinfo/users

_______________________________________________
Users mailing list
Users@biomart.org
https://lists.biomart.org/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@biomart.org
https://lists.biomart.org/mailman/listinfo/users