baffled by Access 2002 - Any ideas

[% =joe %]

I have this simple shopping cart that I am working with with two
databases

- products & orders

-orders has two tables: orders & itemsOrdered
-products has a products table

When a customer orders somethign the data gets written to the
itemsOrderd table. There is a field that is giving me a lot of
trouble (property of that field is text). The field name is
synaroCode

Here's the strange thing...

In my form I have these hidden values:

<input type="hidden" name="intProdID" value="2">
<input type="hidden" name="strProdName" value="product X">
<input type="hidden" name="strProdPrice" value="89.95">
<input type="hidden" name="synaroCode" value="CAL-150P KIT:">

The synaroCode field is the stinker. WE can all see that the value of
the synaroCode hidden field in my form is

CAL-150P KIT:

It can only be that cause that field is getting it's value from my
products database/products table.

The hidden fields values gets written to an itemsOrderd table

The crazy thign is that when I am displaying the contents of the
itemsOrdered table, the synaroCode field - rs("synaroCOde") is getting
displayed as


CAL-150 BP KIT:

Where did the 'B' come from? At an earlier rev of my products table
did have that value, but it aint there no more.

Some how Access is remembering that value and it is showing up and I
cannot get the 'real' value of my origional hidden field to show up.

I even verified that the 'new' data that gets written to the
itemsOrdered table is in fact the correct hidden value.

I know this may sound a bit crazy, but Access i sremembering my
previous value and I'm stuck

[Jeff Cochran]

On 4 Jun 2004 14:06:31 -0700, [email]jweiss@lanelabs.com[/email] (% =joe %) wrote:

>I have this simple shopping cart that I am working with with two
>databases

Why two databases? These should all be tables in the same database.

>- products & orders
>
>-orders has two tables: orders & itemsOrdered
>-products has a products table
>
>When a customer orders somethign the data gets written to the
>itemsOrderd table. There is a field that is giving me a lot of
>trouble (property of that field is text). The field name is
>synaroCode
>
>Here's the strange thing...
>
>In my form I have these hidden values:
>
><input type="hidden" name="intProdID" value="2">
><input type="hidden" name="strProdName" value="product X">
><input type="hidden" name="strProdPrice" value="89.95">
><input type="hidden" name="synaroCode" value="CAL-150P KIT:">
>
>The synaroCode field is the stinker. WE can all see that the value of
>the synaroCode hidden field in my form is
>
>CAL-150P KIT:
>
>It can only be that cause that field is getting it's value from my
>products database/products table.
>
>The hidden fields values gets written to an itemsOrderd table
>
>The crazy thign is that when I am displaying the contents of the
>itemsOrdered table, the synaroCode field - rs("synaroCOde") is getting
>displayed as
>
>
>CAL-150 BP KIT:
>
>Where did the 'B' come from? At an earlier rev of my products table
>did have that value, but it aint there no more.
>
>Some how Access is remembering that value and it is showing up and I
>cannot get the 'real' value of my origional hidden field to show up.
>
>I even verified that the 'new' data that gets written to the
>itemsOrdered table is in fact the correct hidden value.
>
>I know this may sound a bit crazy, but Access i sremembering my
>previous value and I'm stuck

It *is* crazy. Access doesn't remember a value, each update to a
record is finished when the record is updated. You may be oulling
from the wrong table, the wrong record or even have the value in your
code somewhere, but we can't tell that since we don't have your
database or code to look at.

Search your database(s) and code for that value.

Jeff