RowCounter | An example on how to use SQLiteOpenHelper | Database library

I am a total newbie to programming and i have been following some tutorials on array related to housie ticket generator.The point where I am stuck is that, I have to check each rows and each rows of the 3x9 matrix should not have more the two empty cells or it cannot have more then two cells filled next to each other.I am putting random numbers on the arrays and trying to validate the rules but,the program crashes. Can someone please give me an idea.?

This is what i've tried.

So I'm making a simple program that will compare two text files and print out if there is a mismatch, and on what row the mismatch is in. But there is a problem, it seems to count wrong after a while, it's probably a simple explanation but I can't figure it out.

Below is the code:

I am able to create Pivot Table and Pivot Chart using apache POI individually. But I am trying to create column chart form pivot table rather than directly from sheet data. I've tried look for guidance here but could not find any. If it is possible, Can you please guide me in the right direction? Thank you.

Update

Below is the sample code i had earlier that populates data in one sheet and then create pivot table and pivot chart in another sheet using the data populated in the first sheet.

But I would like to have the pivot table as source for pivot chart rather than the original data from other sheet. This way i can dynamically hide certain records. For example if I need to show only Asia countries in the chart, i can filter them in pivot table which would show only those countries in the chart. I am not sure how I can accomplish that.

In a T-SQL code block, I am populating a temp table and doing a WHILE loop. In the WHILE loop, when I do a SELECT TOP 1 for a varchar value, it returns only the first character.

Here is the code

So, I've been trying to provide a user interface in an html page whereby the user can type a number in an input field and hit apply (using addRowsForm), to see rows of various input fields being appended to another separate form (named createRecordForm) and later submit this form (including all those appended inputs and two other hidden fields) via ajax.

My problem is that I cannot find a way to group the data and post it due to the unpredictable number of input fields that would be added, depending on the user's interaction with the page. Your help is greatly appreciated.

Here are my codes:

addRowsForm

I'm working on one issue and I need some help. I'm working on HTML code that fills in special machine labels. It is a kind of web page on where people fill in the number of lines and text size, then enter the text of the lines they want the resulting table to contain in each line.

I need advice on how to put ajax array to coldfusion variable.

Here is a small sample of the problem where I sequentially retrieving text from the fields:

I'm currently working on one issue and I need some help. I'm working on HTML code that fills in special machine labels. It is a kind of web page on where people fill in the number of lines and text size, then enter the text of the lines they want the resulting table to contain in each line.

I need advice on how to save JavaScript variable to cf variable. We use ColdFusion to link the code to DB.

Here is a small sample of the problem.

The basic mission of this code is to use a list as the source of data for my a listbox control...with a catch. I only want the rows that have black cell in column 14 of the list.

To accomplish this, I attempted to assign an the cells to an array and assign the array using the list property.

I feel like I have read every refence document available and adhered to all the references, but I continually get this 'subscript out of range' error when 'redimming' the array in a preserved fashion after a for...next loop.

Before I use a temporary list to store my data construct, I really want to nail this dynamic array...but if it is too much work, then I'll have to settle for the easier option. Also, this is a learning process. Also, please forgive my sloppy indentations and everything else.

How to make the Buttons appear in one line

This is my Code behind