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>

Reply via email to