[thelist] Disappearing values when updating db [Access/Vbs/ASP]

Chris W. Parker cparker at swatgear.com
Thu May 2 19:37:01 CDT 2002


i'm am having a very weird problem.

i'll try to be brief.

a statement is called thusly...

rsUpdate.Fields("custCompany") = sCompany

this statement inside a SUB. this SUB gets values passed to it. one of
them is the sCompany value.

even though the statement executes without error, the value does not get
written to the database. i can response.write(scompany) and see that the
variable actually contains the value i gave it in a form. but it doesn't
get written.

i can bypass the variable like this...

rsUpdate.Fields("custCompany") = "hello"
rsUpdate.Fields("custCompany") = 3

and the value will be written to the database like it should. i can also
do this...

sCompany = "hello"
sCompany = 3

rsUpdate.Fields("custCompany") = sCompany

and even in THAT situation the value is written to the database
properly. it seems that even though the variable is getting passed
correctly to the SUB for some reason it won't go into the database. it
just ends up being blank in the db fields.

what could possibly be happening?


More information about the thelist mailing list