working with table that name containing space characters

[eluser]Unknown[/eluser]
Hi, all

I am working with the trunk version of CodeIgniter. It seems that it can not work with tables that containing space characters. Anybody tried that?

I have filed a issure https://github.com/EllisLab/CodeIgniter/issues/1452 there.

[eluser]jmadsen[/eluser]
what sort of table are you using that you have a space in the name?

Any normal database will treat that as <name> <table_alias>

I think you have issues with your understanding of databases? Please at least tell us the details of what database you are using, and a sample query

[eluser]Unknown[/eluser]
i.e. If My table name is "Test Table",

Code:

$this->db->count_all("Test Table");

the last query will be

Code:

SELECT COUNT(*) AS `numrows` FROM `Test` `Table`

But it should be

Code:

SELECT COUNT(*) AS `numrows` FROM `Test Table`

Thanks for your help

[eluser]jmadsen[/eluser]
sorry, I understand what you are saying now.

you should follow up on narfbg's fix, or push a bug fix of your own since you had a proposed solution

[eluser]InsiteFX[/eluser]

Code: