In Visual InterDev, I'm attempting to assign a new value to an update query using [request.form("var")]. VInterDev accepts the variable, but when the ASP form handler is executed, I receive a syntax error. The criteria can contain a variable name, but what is the proper syntax for entering a variable into the 'new value' field in query designer?
My SQL statement:
SET comments = [request.form("comments")]
WHERE (id = [id])
Also, I'm using the DCC/DTC component.
Thanks in advance.