Quick Question about Memo

I am developing in coldfusion. When I query the database and retrieve records that are type text, I have no problem.
But if the type is memo...I get all sorts of errors when I try to manipulate that string. I am guessing that this is because it is not returned
as a string.

So my question is...what does an Access Memo field return?

Thanks.
Shawn

You might want to post the errors. I'm not an Access developer and can't help you out, but it's always good to post the actual error messages.

Error message is usually

Expected ')'

Sometimes if I screw around with it a little, it will be

Expected ';'


Shawn.

Just out of curiosity, what's your query look like? That looks more like a code parse error than a database error.

I think I figured out the problem with the two expected errors.

I am pulling information out of the database, but if it throws an error, it kills the script immediately. The script is then looking for the rest of its statement, the ';' or the ')'

I could be wrong on that though.

The query(named query2) looks like this...

SELECT tablename.field1,
tablename.field2,
FROM tablename
WHERE tablename.field1 LIKE '#query1.field1#%'
ORDER BY tablename.field1


I'm guessing it's just a tricky parse error when creating the option. I ended up just attempting to insert the option, and if it doesn't work with single quotes, then
try it again with double quotes. Long and time-consuming, but it works. It still throws the errors, but they are 'fixed' somewhat.

Thanks again for your help...if I am wrong though or you see something else...post back.

Shawn

Might be less klugey to escape single quotes. Not sure how to do this in ColdFusion, but it's a standard operation, so there must surely be a way.