Zquery Select * Form table ROWS 0 TO 100 ERROR

[sfxcc]

If i do :

Zquery Select * Form table ROWS 0 TO 100
ERROR : .... blabla have to be >= 0 ...

But is = 0 so ...

if i do ROWS 1 to 100 it works fine ...

( I need only the Field header Title) SO i NEED only ROWS 0 to 0


Does any one know how to get Title only without any lines.

[seawolf]

Sorry, I don't understand ..
Do you need the first record of a select? In this case you can use First method.
Do you need the column names? Method Fields.GetFieldNames

[exdatis]

If you want LIMIT(mysql, postgresql), then:
SELECT FIRST 20 SKIP 40 FIELD_ONE,FIELD_TWO from TABLE1
also, for all :
SELECT FIRST 100 * FROM TABLE_NAME.

[mdaems]

sfxcc,

If I understand correctly you want to see zero lines from your query but get the right column headers from the query.

The easy way : Select * Form table where 1=2

This selects an empty dataset, but the column headers are incuded in the result.

Mark