Forums (Obsolete)

Portal Engine Questions on portal engine and web parts.

Version 4.x > Portal Engine > Field ->drop down list -> SQL =need help

View modes:


Member	eagleag - 8/24/2009 7:55:46 AM Field ->drop down list -> SQL =need help Hi, I created a custom table and wish to use the info in it to populate a drop down list in a document type I created. When I select FIELD TYPE: DROP DOWN LIST I need to: SQL Query (it must return value and text fields) How do I create sql that getts each fileds from customTable twice? value;text ???? THANKS :)


Kentico Developer	kentico_helenag - 8/25/2009 5:53:05 AM RE:Field ->drop down list -> SQL =need help Hi, you may use a SQL query like this: SELECT id, id FROM .... (you can repeat the column twice in the SELECT statement) Best regards, Helena Grulichová


Member	eagleag - 8/25/2009 10:27:16 AM RE:Field ->drop down list -> SQL =need help I tried this: SELECT filedName +';'+ filedName FROM customtable_tableName not working. when I go to create a document type which form has a dropdown list that is supposed to be populated by this query. tried a few variations of the code and still not working. any suggestions?


Member	Yehuda - 8/25/2009 8:18:16 PM RE:Field ->drop down list -> SQL =need help It should be like this: SELECT filedName, filedName FROM customtable_tableName


Member	eagleag - 8/26/2009 1:48:43 AM RE:Field ->drop down list -> SQL =need help thankk. I'm preety sure I tried that before but now it works so wahtever. many thanks :)

Top