sql query that has 1 row result
Hello, Let sql_count_bucks be: SELECT count(*) as Number FROM MyBucks I know that this query will always have *one* row, and i want to use this value. Is there a better way of writing this than: <!--#var "sql_count_bucks()[0]['Number']"--> kinda unreadable, isn't it? Another example: suppose i want a document to display an article given the article id in a database. That is, i want to display the article whose id is 2 with http://mysite.com/document?id=2 As id is the primary key, i know there will always be one article that match the query. Is there another (better) way to write: <!--#with "sql_query_article(REQUEST)[0]"--> Article title: <!--#var title--><p> Article content: <!--#var content--><p> <!--#/with--> It's not very important, because this way of writting works, but i wonder, just in case i missed something in the FM. Regards, Jephte CLAIN Service Informatique
participants (1)
-
Service Informatique CHSR