Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Form field with SQL query data source View modes: 
User avatar
Member
Member
paul.truman-sunmed.co - 8/14/2012 10:59:45 AM
   
Form field with SQL query data source
Hey, I'm trying to do a form with a 'multiple choice' field and I want the values to be a list of the eCommerce product names that are currently sold on the site.

Has anyone got any examples on how to do this? I tried inserting a simple query to just list products as a first step, but it just kept telling me I had an invalid column value.

User avatar
Certified Developer 8
Certified Developer 8
Jiveabillion - 8/14/2012 1:49:42 PM
   
RE:Form field with SQL query data source
Can you post what you put in your SQL statement box for your dropdown list?

Make sure you selected the SQL Query radio button and you are returning two Columns from your query, the first column should represent the value and the second column should represent the Name.

Top