On Feb 21, 2007, at 8:05 PM, Mathieu Langlois wrote:
> Check theDB.Error and theDB.ErrorMessage. My guess: you have illegal
> characters in the path. Probably single quotes within the path
> that throw
> SQL off. Do something like that: rs = theDB.SQLSelect("SELECT *
> from paths
> where pathname = '" + thePath.ReplaceAll("'", "''") + "'"
Hi Math,
Already done. That's why I stated that the "thePath" variable is a
properly processed ShellPath. And, the oddity is that the same
select succeeds 3-5 times and then fails once for the same value of
thePath. Thanks for the reminder of the errormessage...
Tim
--
Tim Jones
[EMAIL PROTECTED]
Remember: Amateurs...built the ark.
Professionals...built the Titanic
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>