SQL IN function problem in FP2003

  • Thread starter Thread starter jhmosow
  • Start date Start date
J

jhmosow

I have an ASP that worked fine when I used FP2003. Now the IN SQL
function is rejected. Here is my query string:

fp_sQry="SELECT * FROM ""Objects for HTML Query"" WHERE (""Database
Release"" = ::Database Release:: AND ProdVersion = ::ProdVersion::
AND Object LIKE '%::Object::%' AND HostSystem IN (::HostSystem::))
ORDER BY Object ASC"

With the IN function, I get the following error:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

Any help is greatly appreciated.

TIA
 
Try
fp_sQry="SELECT * FROM [Objects for HTML Query] WHERE ([Database
Release] = ::Database_Release:: AND ProdVersion = ::ProdVersion::
AND Object LIKE '%::Object::%' AND HostSystem IN (::HostSystem::))
ORDER BY Object ASC"

Note that field names must NOT contain spaces (invalid HTML), and table and
column names should be renamed to remove spaces, then the square brackets
can be dispensed with.
 
Back
Top