sqlite table method:columname... exists or not?

new BookmarkLockedFalling
davos1
Guest

Guest Avatar

Post by davos1 on May 4, 2009 12:05:43 GMT -5

Hi,
first I cheched in SQLite Doc, localhost.../docs/sqlite.html
there it says:
The following methods are for rendering the result of a query to a web page as a TABLE
#handle COLUMNNAMES(expr$) - Set the column names using a comma delimited string expression

but if I go to the main page or to the wikipage it does not exist:

The following methods are for rendering the result of a query to a web page as a TABLE
#handle CAPTION(expr$) - Set the caption using expr$
#handle CSSCLASS(expr$) - Set the CSS class tag to expr$
#handle TRCLASS(expr$) - Set the CSS class tag for table rows to expr$
#handle TDCLASS(expr$) - Set the CSS class tag for data items to expr$
#handle THCLASS(expr$) - Set the CSS class tag for header row items to expr$
#handle CAPTIONCLASS(expr$) - Set the CSS class tag for the caption to expr$
#handle ALLCLASS(expr$) - Set the CSS class tag for all of the properties to expr$
#handle LINK(columnNameExpr,ドル handler) - Make the items in a column into links using handler when the user clicks


So, I would like to know if it was a typo error, or if it is really possible to set the columnnames of a table when getting the data directly from sqlite.


if my #handle is the #sqldb data from an SQlite, how to call that method to render a table?
for example, if I set

sqliteconnect #records, "asesproductos.db"
query$ = "select * from productos"
#sqldb execute(query$)
cssclass "table", "{ width: 600px; border: 8px ridge #CCF ; border-spacing: 3px }"
cssclass "tr", "{ background: #CCF }"
cssclass "columnname", "one,two,tree,four,five,six,seven"
#sqldb columnnames("one,two,tree,four,five,six,seven")
render #sqldb
#sqldb disconnect()

there is a Runtime Error in program 'untitled': #sqldb columnnames("one,two,tree,four,five,six,seven")
Unrecognized command for SQLite connection: columnnames()

thanks a lot
;D
mikeukmid
Guest

Guest Avatar

davos1
Guest

Guest Avatar

Alyce
Administrator
*****

Alyce Avatar

Posts: 519Female

-Alyce