how dynamic column display and also sorting?

Hi,

I have one table
It contains username, and address.

I can display username and address and also sorting done both asc and desc order.

I want to add one more column in the display page and database/or file(Dyanmic fileds). for eg. i want to add emailid id.

My expected Output is both username and address and also dynamic field that is email id should be displayed. and also sorting also should be working.

and How to add Dynaic field values in DB/FILE?

Kindly send your suggestion.

Thanks
edward

Moving to the JDBC forum where the database gurus hang out.

excuse me any body know the above question. Please Reply

Thanks

What do you mean by "dynamic fields"? You can add additional columns, give them whatever name you like, and retrieve and sort by them.

How?

By "How?", do you mean how you can add columns to database tables? Any SQL reference will tell you how to do that (look for "ALTER TABLE").

But I don't know what you mean by "dynamic fields", so you might be looking for something completely different.

database fields are standard fields. in database i have customfields column also. if add new field. it will be stored into customfields like

<custom custom1="custom field name here" custom2="custom2 field name here" />

I hope you understood

thanks

<custom custom1="custom field name here" custom2="custom2 field name here" />

That's not SQL - where is this coming from, and what does it have to do with adding fields? Do you need to interpret this XML structure, and then adapt your DB schema dynamically? That would be more of an XML question (altering the schema would still be done by SQL DDL statements like "ALTER TABLE ADD COLUMN").
[ August 01, 2006: Message edited by: Ulf Dittmer ]