>At the bottom of your error page it should show the generated SQL from >your query. >Can you include that? > Hmmm...I've tried do it but the entire paste doesn't show up here. I'll just paste the bottom to see if it shows up:
SQL select p.PROG_EMPH_ID, l.PROG_RL_DESCRIPTION, l.PROG_RL_LINK, l.PROG_REC_ID, l.PROG_LINK_LKUP_REC_ID, p.PROG_REC_ID from PROGRAMS p and PROG_RELATED_LINKS l where p.PROG_REC_ID = l.PROG_REC_ID and p.prog_emph_id = 1 and l.PROG_LINK_LKUP_REC_ID = 3 DATASOURCE csdevmaint VENDORERRORCODE 933 SQLSTATE HY000 Please try the following: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:15:506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
