That's exactly it. When there are no services/billing it shows nothing because of this:
WHERE c.account_number = '$account_number' AND removed <> 'y'"; Can't we remove the 'AND removed <> 'y'? What happens if we do? I know it does show the client info then but will it show all cancelled services too? Phil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Yasi > Sent: Tuesday, March 28, 2006 4:05 PM > To: citrusdb-users@lists.sourceforge.net > Subject: Re: [Citrusdb-users] Print icon shows no customer data > > I bet it's trying to join them with their services and > billing, and when they don't have any services or billing the > query doesn't work. > > Paul > > On 3/28/06, Pagehit Talklists <[EMAIL PROTECTED]> wrote: > > Hmmmmm.... > > > > I just added a new client and then clicked print right away > and volia' > > nothing.... I am looking further. > > > > Paul here is the output: > > Customer Record > > > > Name: > > Company: > > Street: > > City: > > State: > > Zip: > > Country: > > Phone: > > Fax: > > Source: > > Contact Email: > > Billing Contact Email: > > > > Services > > ID Description Details Price > > > > Billing > > ID Type Status Next Billing Date > > > > > > ? > > > > Completed In 0.00693106651306 Seconds > > > > This is the url that was loaded.... > > http://www.blackcattech.com/citrusdb/index.php?load=print&type=base > > > > Regards, > > Phil > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > > Doug Poland > > > Sent: Tuesday, March 28, 2006 3:45 PM > > > To: citrusdb-users@lists.sourceforge.net > > > Subject: RE: [Citrusdb-users] Print icon shows no customer data > > > > > > > > > On Tue, March 28, 2006 14:37, Pagehit Talklists wrote: > > > > > > > The print button only shows the info for the currently selected > > > > customer. Did you search and select one of the new > > > companies you added > > > > and then click the print button once they are active? > > > > > > > > I just tried it with the newest CVS and it is working correctly > > > > for me. > > > > > > > Hi Phil, > > > > > > I've been playing with it since I posted that inquiry. > From what I > > > can tell, it's not a bug, it's data relationship issue. I just > > > added a new customer and clicked on the "Print" icon... nothing. > > > > > > -- > > > Regards, > > > Doug > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.Net email is sponsored by xPML, a groundbreaking > scripting > > > language that extends applications into web and mobile > media. Attend > > > the live webcast and join the prime developer group breaking into > > > this new coding territory! > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&; > > > dat=121642 > > > _______________________________________________ > > > Citrusdb-users mailing list > > > Citrusdb-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > > > > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by xPML, a groundbreaking scripting > > language that extends applications into web and mobile > media. Attend > > the live webcast and join the prime developer group > breaking into this new coding territory! > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=1216 > > 42 _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking > scripting language that extends applications into web and > mobile media. Attend the live webcast and join the prime > developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
