Dears,
We are using BASE since a couple of months and GeneSpring for mining data.
I have installed the connector in GeneSpring to access data in our BASE database via GeneSpring.
This works fine and I could even customize the query to select more that the standard information transferred as sample annotation into GeneSpring.
Unfortunately I didn't manage to include the sample annotations defined in BASE. Does any of you have some experience or any hint how I could
form a query (in MySQL 4.1.11) which delivers such a table having one sample per row and all available sample annotations as columns.
Example:
Sample ID Hybridization Array Design Array Barcode Donor Name Donor Age Agent Dose
smp_001 smp_001.h1 myDesignXY sd34ds2a xcs_d21 4 weeks Vehicle 0 mg/kg/d
smp_002 smp_002.h1 myDesignXY sd34ds2b xcs_d22 4 weeks AB 10 mg/kg/d
Where columns Donor Name, Donor Age, Agent and Dose come from user defined samples annotations.
Kind Regards and many thanks in advance!
Dani
_______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
