EZ Results

I have a simple DB table structure of 'Month' 'Week' 'Price'. If, for example I have 4 rows for Month 'January', and I want to output the following table structure from EZ Results:

[table]
[tr][td colspan=2]January[/td][/tr]
[tr][td]Week1[/td][td]Price[/td][/tr]
[tr][td]Week2[/td][td]Price[/td][/tr]
[tr][td]Week3[/td][td]Price[/td][/tr]
[tr][td]Week4[/td][td]Price[/td][/tr]
[/table]

I can see how simple it is to output the Week rows, but can't fathom out how to only display the Month row ONCE ONLY..?

Any help appreciated.

Does anyone have experience with ezResults and MS SQL? How would mssql_query look like is the main question? Anyone?

Hi All.

I am using Ezresults to send me a table of information. Currently, the last column is a "Select" link that has the item id tied to it, so if i click select next to any of the table items, I can go to another screen and edit or view that item.

I now want to replace that with a checkbox. In this way (I am hoping), a user could check off 10 or 20 items, clikc submit, and I somehow would be able to cycle thru the page and grab all the items that were selected. But I am having no luck at all adding a checkbox with the itemid attached to it (it is pulled from a MySQL Db, and COL1 has the item id).

Has anyone modified ez_results to work with images for the navigation links?

Hi All,

I understand the principal behind the way to manipulate data before it's output. However, once I've made my function where do I put it!? I'm using one of JV's output templates BTW. Anyway I made a fuction and I tried placing it in my script which calls ezr and I tried popping it into the template itself but no luck, I can't get anything to show up (no errors, just not showing up). Would someone be kind enough to illustrate an example of where to put the function and a sample call etc.

Sarah

I have a EZ Results list display where I have placed my own edit link on each row display to allow me to edit the content of any row. However after I click on my link the list returns to page 1 when my edit for is displayed. How can I persist the current page so that the list display stays on the current page while I display the edit form and save any updates?

Jim

Fatal error: Call to a member function get_var() on a non-object in E:\www\work\actionstrategy\lib\ez_results.php on line 622

I keep getting this error, someone told me to try to use
Comment out the global ${$this->ez_sql_object};
Replace it with: $db = $this->ez_sql_object;

it worked the first time but then I have overwritten some files and keep getting this error.

Can plz someone help me.

Hi, I love using EZ results but I was wondering if any one could help me. I have a few drop down fields that I want to filter my results by. The value of the drop down selections is the ID of the field that I want to filter by. For instance, I want to be able to filter by Company and then maybe by Open POs and then by Date, etc.

My question is how do I make it so that I can build a query from these items and have the filterd results display in EZR? I think it would be easy if it were just one field but I have multiple fields to query by and some may not be used in each query. Can some one people point me in the right direction?

Hi,

in line 315 is the following code:

. '?BRSR=0'.$this->qs.'"'


wich runs on an (silent) error: the SID would not be added because there is no blank.

switch this to:

. '?BRSR=0'.$this->qs.'" '

and you are done.

Regards

carnalito