[u3003-04-23]

In case it helps anyone else, I found a simple workaround, which fixed the problem.

e.g.

update v_board_all_notices

set site = 'n/a'

where

length(site) = 0 or

length(site) = 1 or

length(site) = 2 or

site = '' or

site is null;

jim

[u3003-04-23]

Hi Nero,

thanks for the help.

It turned out to be due to the parentheses being in the wrong place.

This works now:

SELECT v_all.*, v_teacher_main.*, v_def_instruments.*, v_county.*

FROM v_all, v_teacher_main, v_def_instruments, v_county

WHERE v_all.pid = v_teacher_main.pid

AND v_teacher_main.instrumentkey = v_def_instruments.instrumentkey

AND v_all.pCounty = v_county.countyid

AND v_all.pCounty = 133

AND ((v_teacher_main.InstrumentKey= 6) OR (v_all.pCounty = 133 AND v_teacher_main.InstrumentKey= 1))

ORDER BY pName, countyName limit 0,25

Thanks

Jim

—

http://www.jimpix.co.uk

[u3003-04-23]

I worked it out. code below in case it helps anyone else out:

v1 from http://forums.devshed.com/showthread.php?s…=&postid=269096

SELECT v_pdf_info.*, v_pdf_cat.pdfCatTitle, v_pdf_diff.fldDesc

FROM v_pdf_diff

INNER JOIN v_pdf_info

ON v_pdf_diff.fldID = v_pdf_info.pdfdiff

INNER JOIN v_pdf_Cat

ON v_pdf_info.pdfCatID = v_pdf_Cat.pdfCatID

AND pdfID>0;

v2 from me:

SELECT v_pdf_info.*, v_pdf_cat.pdfCatTitle, v_pdf_diff.fldDesc

FROM v_pdf_diff, v_pdf_cat, v_pdf_info

where

v_pdf_cat.pdfCatID = v_pdf_info.pdfCatID

and

v_pdf_diff.fldID = v_pdf_info.pdfdiff

and

pdfID>0;

jim

[u3003-04-23]

Thanks Ritesh, that's great.

Jim

[u3003-04-23]

Hi Ritesh – thanks for the reply. I think I'm not using v 4.0 – I'll download v4.0 and see if that works.

Thanks

Jim

[Author]

Posts