Topic: Select fields from query
author: Cristian G
created: 16-08-2011 12:26:40 PM
Hi guys, I'm trying to make a combo option to a user for select fields of a query as info we need, i.e I need two things: date and value, but I want the user can write his sql sentence with the aliases he want (i.e money instead of value).
For that, I plan to execute the query and fetch the fields to give the user the option, but when the query has parameters (template defined by user), I replace parameters with null values (it works on pgadmin and SQLDeveloper i.e)  but when I execute the query with ADO the variable $rs ($rs=$conn->Execute...) has false as value on 'fields' index. I want to know if there is a way of determine the fields even when there is no results for the query. Thanks in advance
 http ://i.imgur.com/WMIxC.png
Topic: Re:Select fields from query
created: 20-01-2012 02:01:03 AM