mysql joins not always working in c#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm making a mysql call from c# to a mysql database for a windows
application. when i try to use the join command it works fine until the
column being joined gets to a null character and then the rest of that column
becomes null. my statement is:

"select customers.name, customers.firstname, customers.customerid,
customers.contact, customers.memorec, extinfo.info, memos.memo from customers
left join extinfo on customers.rec=extinfo.rec left join memos ON
customers.memorec=memos.rec where customers.rec=extinfo.linkrec and
extinfo.identifier=1 and extinfo.primarytype=2 and customers.inactive=0 order
by customers.name asc"

the info column from extinfo never has a problem, but as soon as a memos.rec
= null or 0 then the rest of the memo field becomes null. i have tried this
same call in mysql and it works fine, but when i transfer it over to C# it
doesn't work right. any body know why? if i do a right join all the memos
show up with their customers, but i need to be able to get all the customers
and memos for the ones that have them.

thanx in advance
 
oscar said:
i'm making a mysql call from c# to a mysql database for a windows

And this has what to do with C++ programming?

You should post this on a general SQL programming newsgroup or something
specific to MySQL.

-cd
 
my bad, didn't realize i was in the .vc forum. i'm posting it in the
language because it is not a mysql issue. it's an issue with the way c#
seems to read the info.
 
Back
Top