Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - gencylegaspi

3
General Discussion / SQL Error
Hi,

Somebody please help me with this error.

I am trying to make a bar chart with this statement.

SELECT  COUNT(h.hhid) AS count_of_males FROM hhoccupants AS h WHERE  (h.gender  ="M" )

After pressing OK button, I got this error. Tried so many possibilities but no success at all.

"Cannot Parse The SQL Statement. Error: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"

Can't identify the source of error specially this is just a Gender field with varchar(1) either "M" or "F"

Thank you.
4
General Discussion / Global Variable
Hi,

Is there a storage for global variables that can be use in the PHP Statement Before and After Adding a record.

Thanks.
5
General Discussion / Re: Code Snippet not working
it is okay now.
I got a sample from Mr. Willvin

$('input[type=radio]').change(function () {
    if ($(this).val() == 'N') {
        $('#ctrl-fgno').hide();
        } else {
         $('#ctrl-fgno').show();
        }
});

Thanks again Mr. Willvin
6
General Discussion / Code Snippet not working
trying to hide this field when clicked.
but it won't work.
I just create a simple function to check whether it will work or not.

it is a radio selection, choosing 'Y' or 'N' only

$('#ctrl-hof').on('click', function(){
   $(this).hide();
});

Thanks.