Matthew, We need to see your SQL too. Can you please post it all? Also, can you paste it into notepad and then copy it from there again before you post it because the special characters are not coming through correctly.
Dave -----Original Message----- From: Matthew Lux [mailto:m...@chakracentral.com] Sent: Tuesday, December 16, 2008 10:03 AM To: cf-newbie Subject: Pull data from SQL DB... Here is what I haveââ¬Â¦. I have a page that is calling some text from a SQL database, and then put it on the page right now it is taking anything before a ââ¬Å-ââ¬Å and uses this as the title. I need to change this so it simply uses a separate table in the same db. The new table is named Section. Below is the code I am using, what should I change this to so it worksââ¬Â¦. Thanks everyoneââ¬Â¦ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4237 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
