I'm using MySQL and PHP.

I used the Sever Behavior to create a Repeating Region.

If I tell the behavior to show all records it works fine, but if I tell it to limit it to 10 I get an error telling me to: "check the SQL syntax 'LIMIT 0, 10' at line 1".

questions:
how can view the SQL, and, what the heck is wrong?

thanks a lot!

ted

Got it!

I was using WHERE to get all my records instead of an INNER JOIN!
works fine now... plus my orginal INNER JOIN was written wrong so the xtra confusion!

ted