BackEnd new page without linking a mysql Table

[synergie]

Hello,

I understood the creation of page on BackEnd (linked with the internal ORM, 1:1 relation to a mysql table), that very simple.

Now I want to create a new page that are NOT linked to a table. I try to make it but the ORM automatically make a "Select * from NamePage" in the database (and crash because there no table with this name).

What must I do to stop this automatic Select (for this page only)? Overriding a method?

[ramjet]

Sorry, What is ORM synergie?

[synergie]

Sorry, What is ORM synergie?

Object-relational mapping http://en.wikipedia.org/wiki/Object-relational_mapping
Typolight have an internal ORM that make a generation 1 mysql.Table = 1 php.Class.

[synergie]

did somebody have an idea?

[ga.n]

What do you want to do exactly?

I can not understand what "create a new page that are NOT linked to a table" means ...

TYPOlight relies on DataContainer for creating record; the built-in DataContainer are

DC_Table for managing record that are stored in a database table (like pages, articles, news, layouts etc.)
DC_Folder for managing files (like files and templates)
DC_File for managing the file settings configuration

you can find the above classes into the system/drivers/ directory of your TYPOlight installation

maybe you want to create your own DataContainer

[synergie]

hum... I found I let "Table" in the DCA and not "File". So it was an automatique "SELECT * from ..." and the name of the php file as name of the table.
Now it is ok with "File".

Thanks, ticket closed ;-)

[thyon]

You can look at the settings or Maintenance BE apps, they do not directly use any tables, but perform custom controls to the user and do not follow the standard guidelines of using a DC_xxx driver.... You can with this approach edit anything, be it a web service updated, or an RSS feed, or something else that is retrieved from the internet... But this will require you to write ALL the code for every little bit - edit, copy, paste, delete, etc... its all in your hands.

Another module that is custom, although it is using a table is the Task Manager... but its interface doesn't use a DC_xxx driver as well, it uses its own methods for edit and copy and paste... This just shows you how flexible TL really is.

[jwalter]

Hi synergie,
I am glad that you have found to solution to your problem. I am not quite sure about what you were trying to do, I was just thinking about it but couldn't stop myself from asking you about what you were trying to achieve as you didn't want any SQL query to be called on that page.