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) [1] 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
[1] http ://i.imgur.com/WMIxC.png |
