• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

how dynamic column display and also sorting?

 
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moving to the JDBC forum where the database gurus hang out.
 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
excuse me any body know the above question. Please Reply

Thanks
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What do you mean by "dynamic fields"? You can add additional columns, give them whatever name you like, and retrieve and sort by them.
 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How?
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

<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 ]
 
Ruth Stout was famous for gardening naked. Just like this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic