Viewing posts by scoopseven

MySQL “Explain”

Posted by: scoopseven in MediaPost 17 years, 3 months ago

This command would have saved me a couple of hours today should I have known about it. While running a query that returned 48k rows, I needed to run a subquery to check against another table to exclude certain other rows. (Querying a list of people to send a promotional email to while trying to make sure the email didn't go to any people who were already registered for a show [show registrants stored in that separate table]). I attempted to do this using several different techniques:

• and m_email not in (select email from attendees where shw_id = 19)
• and NOT EXISTS (SELECT * FROM attendees WHERE m_email = email AND shw_id='19')
• left outer join attendees on email = m_email where email IS NULL

read more / 0 comments

Updating CFMX 6.1

Posted by: scoopseven in ColdFusion IIS 17 years, 3 months ago

Hotfixes since 6.1 Updater http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=b3a939ce Newest supported JVM 1.4.2_05 http://java.sun.com/products/archive/j2se/1.4.2_05/index.html

for those having troubles installing a new JRE (like I did): With MX 6.1 you have to install the whole SDK, not only JRE, because ColdFusion needs a 'Hot-Spot JVM' which is not included in the JRE. If you only install the JRE and change the path in jvm.config to the new location, ColdFusion will start with an 'error 2' and you'll get an errormessage in {CFMX root}/runtime/logs/default-err.log like 'Error: no `server' JVM at c:/Program Files...' -Posted By Juerg Anderegg | 5/15/04 7:35 AM on Forta.com

STEPS: 1) Install Java SDK 2) Update the java.home path in jvm.config (rather than cfadmin) to point to new JRE 3) Apply ColdFusion 6.1 Updater 4) Apply Hotfixes

• Hot fix available for null, null errors ( Article b3c51ba1 )
• Hot fix available for cfchart output not displaying with IIS 6 ( Article 38824ea2 )
• Hot fix for client variables ( Article 19590 )
• Hot Fix to upgrade web server connectors ( Article 238944b1 )
• Hot fix to resolve slow memory leak when enabling Debug Logging ( Article 1ea55f4a )
• Hot fix to upgrade DataDirect Sequelink ODBC Server to version 5.4 ( Article e917887 )
• Hot fix for cfdump throwing unknown type error for cfcatch structure ( Article 1a9c83c )
• Hot fix for ColdFusion not responding to requests ( Article 19536 )
• Hot fix for ColdFusion Administrator navigation frame on an SSL site ( Article 19597 )

read more / 0 comments

SQL Fun

Posted by: scoopseven in Database MySQL 17 years, 6 months ago

select a.*, ba.column1, bb.column1

read more / 0 comments

Incorrect key file for table

Posted by: scoopseven in MySQL 17 years, 6 months ago

Incorrect key file for table '/tmp/#sql_18ed_O.MYI' ; try to repair it.

read more / 0 comments

Connecting MySQL ODBC 3.51 to CFMX

Posted by: scoopseven in ColdFusion MySQL 17 years, 6 months ago

The MySQL ODBC 3.51 driver doesn't like CFMX because CFMX uses the odl MySQL password convention. So, to setup a datasource in CFMX that uses the MySQL 3.51 driver you have to setup a user in MySQL for ColdFusion, then run the following commands (I do it in MySQL Front).

read more / 0 comments