Problem with select

Joseph Morgan joseph at checkos.com
Sun Oct 28 09:57:01 CDT 2007


Hello,

I am trying the following select and it returns nothing.

select * from customers where accountName = 'testAccountName'

I know there is a row where accountname = test but valentina
returns 0 rows.


The ContactName field works:
select * from customers where contactName = 'testContact'

I can't tell why one field works and the other doesn't.

I know that some of the accountnames where imported from mysql and  
some look like this:
U.S. Tae Academy
Fly-Boy Electronics

Does '.' or '-' cause problems?

Joseph




More information about the Valentina mailing list