This (http://www.pcreview.co.uk/forums/thread-1138891.php) seems to suggest that UNION ALL might be your answer.
-----Original Message----- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 July 2005 6:58 a.m. To: CF-Talk Subject: RE: "or" operator in WHERE statement On 07/19/2005 10:12 PM Mathew Walker wrote: >I'd go with a UNION. The reason a union is useful is that you want B.content >and C.content to appear as the same column in your record set, which is what >a union does well. Thanks for your answer. I tried the UNION and it did what I wanted (it pulled the "content" field from either the B table or the C table based on the value of the 'status" field in the A table). However, when I output the "content" field with: CFOUTPUT #QueryName.content# /CFOUTPUT ......the output shows only the first 255 characters of the "content" field (the maximum length for an Access text field), although the field is set to "memo" in both tables B and C. Can this be fixed, or is it a limitation of UNION? Thanks, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212353 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
