SQL IN function problem in FP2003

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
 
R

Ronx

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top