OK, hindsight is 20/20.
Well the problem was nothing to do with how the parameter was passed. I found that "User" is a MS Access reserved word. It cannot be used as a column header. It let me name the colmun "User" but when keeping all parameters in the SQL string except "User" the UPDATED...
As of now all variables are either String types or .Text from a control, which I guess is String, from a VB.Net form. I am not using any boolean or numeric (Integer, Byte, Short) types any longer. But in any case, the String type didn't solve the problem.
The Output portion is a Javascript...
Not sure what language you use to do the code. But I think I had a similar problem with ASP.Net with VB. I initialized some controls on a form and if they were updated and a button clicked to post them to the server and onto a DB the code would only get the original initialized values.
I...
I have a web form that accesses a MS Access (.mdb) file. The has on one table with a dozen columns and records. All columns are text. From the VB.Net page I issue an SQl UPDATE string that uses valuse from various controls on the page. The string is as follows:
(VB.Net):
Return "UPDATE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.