when doing query of query it assumes field is numeric

CJ wrote:
> I have a query that has 30 some records in it from an AS400 file. Now when I do

you create the original query yourself? if so, create the AND define the data types:

newQ=QueryNew("user,lastLogin,manager", "varChar,time,bit");

> a query on the query, it thinks one of the columns is a numeric field, even
> though it is not. Now I do the same thing with another query (with same file
> and fields, just different data) and it works fine.
>
> This is the error that I am getting: The value "73D" cannot be converted to a
> number
>
> That column looks like this for example
> 75

cf will construct the result query based on the first row of data (if you're not
defining the datatypes in the original query), which looks like numeric data.

> 73D

so when it hits this row it will fail.

if you're not using that column's data, then don't return it. otherwise use the
CAST method as dan suggested.