no value after timport

[pkoppel]

I have a server posting XML to texis and texis returning xml back to my server. Timport is causing me to have some issues.

Here is some code:
<loadSchema>
<timport ROW $schema $xml></timport>
<getCaseDB case_id=$case_id>
<db = $ret>
<prepTerms>
$custodian_id
<$searchTerms = $ret>
<strfmt "SELECT count(*) cnt FROM file
WHERE
custodian_id = $$custodian_id AND
device_id = $$device_id AND
folder_id = $$folder_id AND
assigned_user_id = $$assigned_user_id AND
review_level_id = $$review_level_id AND
category_id = $$category_id AND
last_reviewer_id = $$last_reviewer_id AND
extension = $$extension AND
deleted = $$deleted AND
viewable = 1 AND
( date_last_reviewed BETWEEN $$dlrStart AND $$dlrStop ) AND
( date_created BETWEEN $$dcStart AND $$dcStop ) AND
( date_modified BETWEEN $$dmStart AND $$dcStop ) AND
( date_accessed BETWEEN $$daStart AND $$daStop ) AND
( date_deleted BETWEEN $$ddStart AND $$ddStop ) AND
%s %s $$searchTerms" $searchfield "LIKE">
<$queryCount = $ret>
<$null = "">
<SQL ROW $queryCount>
$cnt
</SQL>

When the sql executes the $custodian_id from timport should be used in the following query but it is being treaded as null.

If I use $custodian_id prior to the sql executing every thing works perfect but this breaks my XML.

Suggestions?

[John]

You can use $custodian_id anywhere in the script, even in a dummy function. You also don't need to generate the SQL query that way, which is causing the problem as the $custodian_id variable is not explicitly referenced. It would be a lot easier to do:

<SQL ROW "SELECT count(*) cnt FROM file
WHERE
custodian_id = $custodian_id AND
device_id = $device_id AND
folder_id = $folder_id AND
assigned_user_id = $assigned_user_id AND
review_level_id = $review_level_id AND
category_id = $category_id AND
last_reviewer_id = $last_reviewer_id AND
extension = $extension AND
deleted = $deleted AND
viewable = 1 AND
( date_last_reviewed BETWEEN $dlrStart AND $dlrStop ) AND
( date_created BETWEEN $dcStart AND $dcStop ) AND
( date_modified BETWEEN $dmStart AND $dcStop ) AND
( date_accessed BETWEEN $daStart AND $daStop ) AND
( date_deleted BETWEEN $ddStart AND $ddStop ) AND " $searchfield " LIKE $searchTerms">