nuBuilder Forum

HI

I have a number of select object using an attribute table
SELECT attribute_id, att_value
FROM attribute
WHERE att_type = 'Staff_Member'

The Select come back blank.

When I run the above in MYSQL returns
attribute_id;"att_value"
6002d17eb160d46;"Lauren"
6002d18ed4f3f3f;"Joanna"
6002d1a10e113c0;"Debbie"
6002d1b10e0c7f0;"Glenda"
6002d1bdab39015;"Paul"
6002d1c68d783d7;"Annie"
6002d1cc0ead332;"Tara"
6002d1d2d4cec0c;"Stuart"

The form has 9 Tabs and 103 objects

Release 4.5 on Windows

Any ideas where to look

Thanks

Release 4.5 on Windows
Any ideas where to look

Test result your request in NU: and you see errors.

It means that there's somewhere an SQL Syntax error. Check the nuDebug Results as miasoft has suggested.

Thanks

Was an orphan subform that had not been finished.


P