.net and mysql join

From: oscar (oscar_at_discussions.microsoft.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 11:23:02 -0800

i'm curious if there are any known issues with the 2. i've tried it in vc#
and vb and i get the same results with both.

every time i run a join and it gets to a 0 or null it makes everything
following it in that column null. the mysql 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 memorec points to the coresponding rec in the memo file. the problem is
that if a customer has a 0 memorec (no memo) then the dataset makes it null
and all the memos following it. is this a known bug or am i doing something
wrong? is there a better way to do this?

Relevant Pages

  • mysql joins in c#
    ... i'm making a mysql call from c# to a mysql database for a windows ... left join extinfo on customers.rec=extinfo.rec left join memos ON ... show up with their customers, but i need to be able to get all the customers ...
    (microsoft.public.dotnet.framework.windowsforms)
  • mysql joins not always working in c#
    ... i'm making a mysql call from c# to a mysql database for a windows ... left join extinfo on customers.rec=extinfo.rec left join memos ON ... show up with their customers, but i need to be able to get all the customers ...
    (microsoft.public.dotnet.languages.vc)
Loading