RE: AW: [sqlite] sqlite3_column_tablename

2005-01-23 Thread mike cariotoglou
What do you want if the user types "SELECT (t0.x || t1.x) FROM table0, table1 ."? I would like to second that request. Ok, sure, there are cases where the info is meaningless (like above), and should be blank. But in most cases, it IS meaningful, and extremely useful for tools (not so much pe

Re: AW: [sqlite] sqlite3_column_tablename

2005-01-22 Thread Dan Kennedy
--- "Plenert, Joerg" <[EMAIL PROTECTED]> wrote: > Yes that function points into the right direction ! > But I need something like that: > > SELECT t0.x as col0, t1.x as col1 from table0 as t0, table1 as t1 where t0.y > = t1.y; > > Now I want the following information about the colums: > >

Re: AW: [sqlite] sqlite3_column_tablename

2005-01-22 Thread Ulrik Petersen
Hi Joerg, Plenert, Joerg wrote: Hi Ulrik, picture this: A user types a query with output of fields from two ore more tables. Now, before you output the data, you'll check if the user has the right to see the data in the fields. So I check if the columns name is in my "allowed" list. Because two