Handling Null Array Locations in a Loop

Hi,

I am writing an online reservation system. I have catagorys of rooms, then individual blocks of rooms in them. To show preferance, to sea front over other catered rooms, you would select a number for the catagory of room, then for the blocks assing a perferance (all down with drop down lists).

im creating a 2D array from this data, then running through it to write out a list of prefered accomodation.

The drop down lists have values that i use as the array index, but as not all catagorys and blocks need a preferance assinged i need a way of skiping over null values.

Is there a simple if(array[x][y].isNull) method? Any other ideas?

Thanks, GR.
LVL 1
googlyralphAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cheekycjCommented:
something like

<cfif LEN(TRIM(myArrayVariable[x][y])) EQ 0>
  <!--- handle null --->
<cfelse>
  <!--- handle not null --->
</cfif>

Assuming your data is strings.

CF has the nice capability of being typeless so everthing can be seen as a string.

CJ
0
googlyralphAuthor Commented:
Nope, that doesn work, still get an error. The code im using to "squash" the array out is:

  temp = ArrayNew(1);
  for(x = ArrayLen(accomOrder); x gt 1; x = x - 1){
    temp = accomOrder[x];
    if(len(trim(temp[1])) eq 0){
       ArrayDeleteAt(accomOrder, x);
       continue;
    }
    for(y = ArrayLen(temp); y gt 1; y = y - 1){
       if(len(temp[y]) lt 1){
          ArrayDeleteAt(accomOrder[x], y);
       }
    }
  }


What (i think) its doing:
geting a copy of a 1d array representing a single row in the "table" im making, if the first value is null, then delete the row and run the loop again.
if it gets to a row where the first location is not null, then move along it from right to left, deleting locations in the original 2d array that are null.

Anyone see anything wrong with this code? Any more sugestions?

Cheers, GR.
0
googlyralphAuthor Commented:
This is the error:

The element at position 1 in dimension 1 of object "temp" cannot be found. That dimension of the object is empty. Please, modify the index expression.


The error occurred while processing an element with a general identifier of (CFSCRIPT), occupying document position (1:1) to (1:10) in the template file e:\tempwebroot\current\test\hallselectconfirm\execute.cfm.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

cheekycjCommented:
Have you tried it without using a temp array?

for(x = ArrayLen(accomOrder); x gt 1; x = x - 1){
   if(len(trim(accomOrder[x])) eq 0){
      ArrayDeleteAt(accomOrder, x);
      continue;
   }
   for(y = ArrayLen(accomOrder[x]); y gt 1; y = y - 1){
      if(len(accomOrder[x][y]) lt 1){
         ArrayDeleteAt(accomOrder[x], y);
      }
   }
 }
0
cheekycjCommented:
any luck?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cyril_HCommented:
Just a question, could you Output the content of your Array with CF_OBJECTDUMP ? If yes, i think that cheekycj's solution should work... if not, maybe some part of your Array are not defined at all !! Then you have to resolve your problem when you create the Array, not when the Array is created !

Could you display the content of your Array ?

Cyril
0
googlyralphAuthor Commented:
I have found an alternative to using htis template now, so i am not overly concerned why this doesnt work. I will assign the points to Cheekyci for the time and effort.

Thanks, GR.
0
cheekycjCommented:
thanx for the pts.  Glad you got it working, would you care to post your solution for future reference?

Thanx,
CJ
0
googlyralphAuthor Commented:
Not really relevent, took an alternative route, and used client side validation instead.

Thanks for your help.

GR.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.