I don't understand your exact problem but I think you have:
user_name | user_password | some_value --------------------------------------- FOO | FOO | FOO --------------------------------------- FOO2 | FOO2 | FOO2 And you want Username | Password | Some Value --------------------------------------- FOO | FOO | FOO --------------------------------------- FOO2 | FOO2 | FOO2 You can do that by use the column attribute as: "lblusername:user_name, lblpassword:user_password, lblsomevalue:some_value" and than place the lbl.. in your properties file, so its good for internationalization too. Jasper -----Original Message----- From: Peter Dawn [mailto:[EMAIL PROTECTED] Sent: donderdag 31 augustus 2006 4:13 To: tapestry-user@jakarta.apache.org Subject: Retrieving table column names guys, i am running into this problem within my web app. please help me. i am using tap3. now i am retrieving column name information from my tables and displaying to the user in drop down menus. i retrieve the data using List columns = new ArrayList(); int columnSize = columns.; while (rsColumns.next()) { columns.add(rsColumns.getString("COLUMN_NAME")); } String s = columns.toString(); setColumnList(columns); rsColumns.close(); so now s contains information like user_username, user_password etc this being my column names within a particular table. and this information is visible to the user in drop down menus within my web app. within my html i have something like, <select jwcid="[EMAIL PROTECTED]" style="width:180"> <span jwcid="@Foreach" source="ognl:columnList" value="ognl:column"> <option jwcid="@Option" label="ognl:column" selected="ognl:true"/> </span> </select> now my problem is that i can retrieve data properly, but i want to display user friendly information to the user. so instead of they viewing user_username i want to display Username etc. but at the same time when the select this particular option i want to maintain the information passed on back to my java code as the original column name (user_username). so essentially all i want to do is display user friendly labels but not change the underlying content. can some genius help me out. i also need to worry about multi-lingual stuff so somehow this info needs to be stored in properties files, which i can change on the fly. please help me. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]