ODBC API call: 'statement executeDirect:' returned the following error message: '
{execDirect}[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (sqlState: 37000)
INSERT INTO UserAgent (Location, UserAgent)
VALUES
('EvalDir-testsearch','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')
WebBase ODBC (EwXx08.62@Windows NT 4.0) **
in file: e:\http\evaldir\files\testsearch.htf
;; following starts near line number 2 in your source form...
...
<html>
<head>
<title>Test Page</title>
</head>
<body>
{set %output% false}
{! Create record of browsers accessing the Directory; Location=EvalDir-testsearch !}
{set loctn 'EvalDir-testsearch'}
{sql source 'DirEval' user 'Admin' password '%passwd%'}
INSERT INTO UserAgent (Location, UserAgent)
<a class="gl" href = "http://wiki.eval.wmich.edu/wiki/Values"OnMouseOver="popup('<strong>Values</strong><br />Abstract qualities regarded as desirable, though not necessarily desired. For example, a judge values justice which may require setting free someone s/he would much prefer to see in jail.','#CBC1B0');" OnMouseOut="kill()">VALUES</a>
('{loctn sql=true}','{User-Agent sql=true}')
{/sql}
{set %output% true}
<a class="gl" href = "http://wiki.eval.wmich.edu/wiki/Test"OnMouseOver="popup('<strong>Test</strong><br />A device or procedure that is designed to elicit from a subject certain knowledge, skills, and/or attitudes (in the educational context) or other characteristics (e.g., in the medical or job-competency context) that are of interest to the test administrator or their employer, and possibly also to the subject.','#CBC1B0');" OnMouseOut="kill()">Test</a>
Search Page xyz
<br>
Inserts "EvalDir-testsearch" into the UserAgent table.
</body>
</html>
**