Losing Data

[Longhorngator]

I'm using coldfusion MX6.1 and usign MS Access 2003 as a database program.

We run web survey for class every semester and we had problem reported from
student about missing data in database file.

We are making three files to run survey, i.e., HTML, CFM, MDB.

One of our student reported that the one specific column in her mdb file was
empty. it all coded as zero.

What we found was she used several similar variable name in that data base
such as brand, brand1, brand2, brand 3, brand4.
The problem is all the data in variable name "brand" was either coded as zero
or missing.

So we changed variable name to totally different, one for example, brand post
brand prebrand then the problem was solved.

My question is is it possible CF can confuse those variable name with same
characters except numbers at the end and code notihng or code zero on database?

Becuase we had another student who coded same way but she does not have any
problem with her dataset.

Please help.

[Ian Skinner]

No, I don't think so, but I suspect programmers can get easily confused.

Longhorngator wrote:

> I'm using coldfusion MX6.1 and usign MS Access 2003 as a database program.
>
> We run web survey for class every semester and we had problem reported from
> student about missing data in database file.
>
> We are making three files to run survey, i.e., HTML, CFM, MDB.
>
> One of our student reported that the one specific column in her mdb file was
> empty. it all coded as zero.
>
> What we found was she used several similar variable name in that data base
> such as brand, brand1, brand2, brand 3, brand4.
> The problem is all the data in variable name "brand" was either coded as zero
> or missing.
>
> So we changed variable name to totally different, one for example, brand post
> brand prebrand then the problem was solved.
>
> My question is is it possible CF can confuse those variable name with same
> characters except numbers at the end and code notihng or code zero on database?
>
> Becuase we had another student who coded same way but she does not have any
> problem with her dataset.
>
> Please help.
>
>