Problem retieving using 'Order' as a column name

[dimitriqueso3]

I have the following problem: I have a database with a big list of animals and their taxonomy. but one column is named 'Order' and i have problems getting it into the sql query.

It looks like this so far. the results should vary depending on the value in the url like .../display.asp?order=ordername

s-criteria="{Order} EQ {Order} +" s-sql="SELECT * FROM Taxonomy WHERE Order = '::Order::' ORDER BY Genus ASC"

this works prefectly well when using 'Kingdom' instead of 'Order'. I am using FrontPage 2003 to do this, until now i never had any problems.

Any ideas of what i am doing wrong?

[shrimant]

where ever you are using Order except for "Order by"enclose it with square braces like below:
[Order]

ORDER is a SQL KEYword...and that is where you are having problem

I have the following problem: I have a database with a big list of animals and their taxonomy. but one column is named 'Order' and i have problems getting it into the sql query.

It looks like this so far. the results should vary depending on the value in the url like .../display.asp?order=ordername

s-criteria="{Order} EQ {Order} +" s-sql="SELECT * FROM Taxonomy WHERE Order = '::Order::' ORDER BY Genus ASC"

this works prefectly well when using 'Kingdom' instead of 'Order'. I am using FrontPage 2003 to do this, until now i never had any problems.

Any ideas of what i am doing wrong?

[dimitriqueso3]

works perfectly now!! thanks a lot!!

[jdk]

Refer following url for taxonomy trees
http://www.shigen.nig.ac.jp/taxonomyviewer/