Coding Help

[Guest]

I have a db with ~22,500 gene ID entries. I would like to be able to input
groups of IDs from a list and limit the records to only the IDs on my list
and be able to modify the records I've retreived. I've been hitting
roadblocks with my current attempts. Any suggestions?

Thanks!

 

[Bob Hairgrove]

I have a db with ~22,500 gene ID entries. I would like to be able to input
groups of IDs from a list and limit the records to only the IDs on my list
and be able to modify the records I've retreived. I've been hitting
roadblocks with my current attempts. Any suggestions?

Thanks!

Check out the SQL "IN" clause.

 

[Guest]

Tried that... it works pretty well; but, it limits your list to 73. I'd
like to be able to enter a list of 100 - 200. That's where I keep hitting
roadblocks.

Thanks for your response!

 

[Guest]

I got it!

I needed to use additional tables and cascades. With an additional table
containing the set I was interested in and this bit of code:

SELECT DISTINCTROW probeSetInfo.*
FROM ProbeSetInfo INNER JOIN FilterGroups ON
ProbeSetInfo.probeSet=FilterGroups.probeSetID WHERE
FilterGroups.group="MPD_110_ANOVA"

it works without a limit to the number of IDs in the list.

Thanks for your interest, help and response!
Christine