On Feb 21, 2007, at 8:21 PM, Tim Jones wrote:
> 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...
Found it - there is a Null that has gotten embedded into one of the
test imports (a flat text file). There are 5 test files with
(supposedly) the same data that I was running through my parser and I
was apparently choosing the wrong one every 3 to 5 tests - DOH!
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>
