phpLens
 home  products examples manual  faq support forum  contact news  login store

Forums: phplens   adodb
Forums:   PHPLens Technical Support:   Replies 
New ReplySearch
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) [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
Topic: Re:Select fields from query
author: Machael   created: 20-01-2012 02:01:03 AM
[url=http ://www.golfshopclubs.com/Golf-68-Ping-G20-Irons.html]Ping G20 Irons[/url]
[url=http ://www.golfshopclubs.com/Golf-76-Ping-Anser-Irons.html]Ping Anser Irons[/url]
[url=http ://www.golfshopclubs.com/Golf-94-Mizuno-JPX-800-Irons.html]Mizuno JPX-800 irons[/url]
Page 1
New ReplySearch

View Source

email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800