encoding question

2004-02-23 Thread mmckenzie
I wrote a cold fusion script to migrate data from an access 2000 db to a mysql 4.0.18 db and when I display the data with cold fusion I see these little box characters in different spots. I'm assuming that it's an issue with the encoding. How do I correct this? Thanks. Mitchell S. McKenzi

Problem using EXISTS Keyword

2003-11-12 Thread mmckenzie
Using MySQL-4.0.15 For whatever reason I cannot use the following query in Cold Fusion or Inside the control center for MYSQL or from the command line mysql. Here is my query: SELECT * FROM dbwebmaster d2 WHERE (menuid <> 0 AND website='CMS_INFORMATION' AND parentref = 4 AND haschildren =1)