Re: Problem JOINing with Aliases

2002-10-31 Thread Bruce Hodo
No, I hadn't. So I did. IT WORKED! Thank you very much! Roger Baklund wrote: * [EMAIL PROTECTED] [...] In other words, any pix that has a bigpix defined is ok. But on any pix that does not have a bigpix defined, I "loose" the filename info from pix. And I don't understand why! Here is the

Problem JOINing with Aliases

2002-10-30 Thread Bruce Hodo
id=pix.id left join pix_section on pix_use.pixsectionid=pix_section.id left join pix_big on pix.id=pix_big.pixid left join pix as bigpix on pix_big.bigpixid=bigpix.id where pix.propertyid=202 order by pix_section.code,pix_use.typeseq Bruce Hodo - Webmaster, GetAwayNetwork, Inc.

ISP problems with 3.22.32

2001-12-18 Thread Bruce Hodo
ose (no, I DON'T have a backup! That's what I was trying to do when this happened. Any suggestions? -- Bruce Hodo - Webmaster, GetAwayNetwork, Inc. ==Providing unique vacation information on the World Wide Web== For Villas, Resorts, Hotels, Air/Hotel Packag