Thunderstone Support Forums

I'm checking for the existence of a record from 1 table inside another table. I know that the Url field is a different size in each table. Should that make a difference when comparing them?

Here's the code:

<sql row "select id,forumid,ThreadID,Url from testtable"
<sql "select count(*) tc from threads where (forumid=$forumid and ThreadID=$ThreadID) or (Url=$Url)">
</sql>
</sql>

Here's the error:

<!-- 005 mergethreads:33: Bad size 12151 for column Url before offset 0x2 in rec
id 0x0000000000000000 of (temp RAM DBF) in the function pbuftofld -->

The difference in size shouldn't make a difference. It sounds as if there is an issue with the Url index on the threads table. You might try rebuilding that index.