Re^2: dbi retieve single col value

thats the output.... when I do the same query in mysql with all these ids: pulls out matching records : here the syntax I used on mysql: SELECT tax_id FROM gene2acc where genomic_ac_ver = 'CP000950.1'; here is what I used in the script: SELECT tax_id FROM gene2acc where genomic_ac_ver = '?'; nin foreach loop with CP000950.1 No records matched for CP000950.1 nin foreach loop with CP000950.1 No records matched for CP000950.1 please help me ....got lot of work!

Comment on Re^2: dbi retieve single col value

Replies are listed 'Best First'.
Re^3: dbi retieve single col value by Anonymous Monk on Aug 28, 2008 at 13:26 UTC
out put is here...sorry about that: nin foreach loop with CP000720.1 No records matched for CP000720.1 nin foreach loop with CP000950.1 No records matched for CP000950.1 nin foreach loop with CP000950.1	[reply]
Re^4: dbi retieve single col value by Tux (Canon) on Aug 28, 2008 at 15:00 UTC
Pasting output like this doesn't realy help. You should enclose it in `<code>` `</code>` tags Ever considered using `DBI->trace (8);` or something alike? We're not here to fix your database or guess it's content. We can however point at program errors or scripting mistakes, and we might be able to explain a database error. Enjoy, Have FUN! H.Merijn	[reply] [d/l] [select]