Cannot display correct value after database update via webpage

[Apache65]

I have an asp webpage that allows a user to view and update student demographic information that resides in an Access database. I have recently added a yes/no field (checkbox) in the demographics table and modified the webpage to reflect the change/new field.

I can make updates to the table via the webpage, however, when I leave the page then return back to it, the checkbox field is not checked and appears to be set to “no”. When I look at this field in the database, the value is set to “yes”. Anyone have any ideas as to why the field doesn’t display correctly on the webpage?

 

[traingamer]

This sounds like an ASP question and could probably be better answered here: forum333.

That being said, it sounds like you are simply not referencing the field correctly in your asp code.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[lebisol]

default value need to = record set field.
also, consider 1/0 vs. yes/no if you are going to use this field in search.

:-------------------------------------:
Do the DW »|MostarNetworks|