I have the following query in my code:
<sql "select project_id searchingProject, search_field searchingField, filter_id searchingFilter, documentType searchingDocumentType from backgroundSearchFlag where isSearching = '1'"></sql>
The definition of backgroundSearchFlag is:
NAME TYPE SIZE
------------+------------+------------+
id counter 1
filter_id varchar 25
search_field varchar 25
project_id varchar 25
pid varchar 25
documentType varchar 4
category varchar 4
pEquivs varchar 4
cEquivs varchar 4
isSearching varchar 1
The problem is that if the table has zero rows, then the query hangs. The code never progresses beyond the <sql> statement and the texis process continues to grind on and on, as if in an infinite loop. I don't don't understand why it does this. What should I do differently?
The output of Texis -version is:
Texis Web Script (Vortex) Copyright (c) 1996-2013 Thunderstone - EPI, Inc.
Commercial Version 7.00.1376340754 20130812 (i686-intel-winnt-64-32)
However, I notice this same behavior on our version 6.x installations as well.
Thanks
<sql "select project_id searchingProject, search_field searchingField, filter_id searchingFilter, documentType searchingDocumentType from backgroundSearchFlag where isSearching = '1'"></sql>
The definition of backgroundSearchFlag is:
NAME TYPE SIZE
------------+------------+------------+
id counter 1
filter_id varchar 25
search_field varchar 25
project_id varchar 25
pid varchar 25
documentType varchar 4
category varchar 4
pEquivs varchar 4
cEquivs varchar 4
isSearching varchar 1
The problem is that if the table has zero rows, then the query hangs. The code never progresses beyond the <sql> statement and the texis process continues to grind on and on, as if in an infinite loop. I don't don't understand why it does this. What should I do differently?
The output of Texis -version is:
Texis Web Script (Vortex) Copyright (c) 1996-2013 Thunderstone - EPI, Inc.
Commercial Version 7.00.1376340754 20130812 (i686-intel-winnt-64-32)
However, I notice this same behavior on our version 6.x installations as well.
Thanks