Hi,
When performing test's, I have some test that have the single quote character in them.
All tests are logged in ODBC using this query :
Insert into hmlog (eventtime, testname, status, reply, comment1, testmethode) VALUES ('%DateTime%', '%TestName%', '%Status%', '%Reply%', '%CommentLine1%', '%TestMethod%')
This is what I get in the systemlog of HM: (erased the password)
25/05/2004 13:30:36 ODBC log error. Error code: 4294967295 ([Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Connect to d'Light', 'Bad', '14', '[C:\Program Files\Cisco Systems\VPN Client\vpnclient.exe] connect d'light user icorda pass ****''.) Logging initiated by "Connect to d'Light" test.
Can I somehow change it so that the ' characters are preceded with a \ when putting into the SQL query ?
My guess is that this is a programmatic issue, and not a config issue.
regards
Pieter
PS: the default sql query string is missing ' around %datetime%
Using quote charactes in ODBC
- plambrecht
- Posts: 151
- Joined: Wed May 19, 2004 8:11 am
- Location: Belgium
- Contact:
Sorry, you cannot do that. We will try to improve this function in next version.Can I somehow change it so that the ' characters are preceded with a \ when putting into the SQL query ?
Probably you may use ` (character #96) instead of ' (character #39) in test name.
Thanks for the tip.PS: the default sql query string is missing ' around %datetime%
Regards
Alex