[wsessomsParticipant]

Thanks for the prompt reply.
I figured it out. There was a problem in my query statement.

Thanks again

[wsessomsParticipant]

After thinking about the timezone issue it occurred to me that at most there would be an time offset of 3 hours coast to coast. The issue I am experiencing accounts for a whole 24 hour offset. It turns out that the problem did surround the date as a string object being passed in through the json response. I changed the expensedate type from date to string and the problem corrected itself.
Thanks again. Hope this help someone else that might run into the problem

[wsessomsParticipant]

Thanks Peter for the quick reply. I’m not sure how to apply this info to my project yet but I am going to take a look at the link you supplied. Thanks again.

[wsessomsParticipant]

I am using ColdFusion 10 and mySQL. The first screenshot is a table showing the values for the records by Category.
The chart show the amount spent by date. So the query totals the records by date.

Below is the query for the line chart,

<cfquery name=”chartQuery” datasource=”#datasource#”>
SELECT
expense_date.expenseDate,
expenses.cost,
expenses.name,
SUM(expenses.cost) as total
FROM expenses
INNER JOIN expense_date ON expenses.dateID = expense_date.dateID WHERE expenses.userID = ‘#userID#’ Group By expense_date.expenseDate order by expense_date.expenseDate
</cfquery>

<cfreturn #SerializeJSON(chartQuery,true)#>

[wsessomsParticipant]

I came up with a better solution. Instead of opening a popup with a button to print the popup, I changed the button on the grid so that it opens the print dialog with the contents of the row formatted in HTML ready to print.

This totally solved my problem.

Love your widgets!

[wsessomsParticipant]

I came up with a solution to the problem which is to reload the browser window when the x is clicked in the upper right corner of the popup window.
Below is the code that I added to accomplish the browser reload.
Not that happy with my solution as it refresh the browser window after every opening and closing of the popup window.
If anyone knows of a better solution please post it

Thanks

// refresh browser window.
	  $("div.jqx-window-close-button").click(function(){
		window.location.reload();
		});

[wsessomsParticipant]

Peter,
Thank you for the fast reply. There was a css styles conflict in one of css files. I made the adjustment and everything is working perfectly now.

Thanks

[wsessomsParticipant]

Hi Peter,
I want to congratulate you on great piece of software. I have just started using it and will be upgrading to a license version as soon as the application that I’m working on it completed.

I am working with Mira CMS and cold fusion on the server side to do database manipulation and I’m also using cold fusion pages: on the server instead of HTML. I ran into a problem that I saw you had replied to in reference to the sort / filter dialog window filter and clear buttons being cut off in the popup window.

as part of your answer to the solution you stated that the user is not initializing from invisible HTML element or the user is using an old version of the plugin.

Can you give me some insight into how to solve this problem. I’m using a container for the grid as follows
<div id=’jqgrid’></div>
and I have downloaded the version that is currently available on your website.

Your help will be greatly be appreciated.

[Author]

Posts