Microsoft KB Archive/160749

= BUG: Errors Occur with the Admin.update Action =

PSS ID Number: 160749

Article Last Modified on 7/27/2001

-

The information in this article applies to:


 * Microsoft Merchant Server 1.0

-



This article was previously published under Q160749





SYMPTOMS
If you use the admin.update action without using the validation structure, and also without a value specified for the argument(s), you will receive an internal SQL formatting error.

For example, the following statements can cause such an error: [xform admin.update table="testtable" keys="name"]    [/xform] The following is the text of the error message:

  Error

dbi.program-error: Unable to perform update: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'se'. in EXEC sql: update testtable se wh parameters: [] (running with debug_all_stores set  to 0 will display a general message).



WORKAROUND
To work around this problem, specify a validation structure for the admin.update action, and make sure a value is specified for each argument.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Merchant Server version 1.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbBug KB160749

Technology: kbAudDeveloper kbMerchServ100 kbMerchServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.