RE: cfquery and mysql help

Do you have the query? -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 10:53 AM To: CF-Talk Subject: cfquery and mysql help Hi, im sure there must be a better way of doing the following code, and much quicker. i have a query which is

Re: cfquery and mysql help

hi andy query 1 has 2 columns firstName and lastName then i want to query the database to ensure that each firstName and lastName combination exists in the database, if not then i want it to return me a list of those that dont. i have achieved this through a loop but i am thinking there must

Re: cfquery and mysql help

You could try something like cfquery name=combined dbtype=query SELECT firstName, lastName FROM query1 WHERE NOT EXISTS ( SELECT firstName, lastName FROM query2 WHERE firstName = query1.firstName AND lastName = query1.lastName ) /cfquery No guarantees - this

Re: cfquery and mysql help

thanks Matt, i will see if this works in query on query You could try something like cfquery name=combined dbtype=query SELECT firstName, lastName FROM query1 WHERE NOT EXISTS ( SELECT firstName, lastName FROM query2 WHERE firstName = query1.firstName

Re: CFQuery and MySQL

This may help with the set up (but I'm assuming as it verifies it probably ok): http://www.oxalto.co.uk/index.cfm/2007/7/2/Setting-up-a-MySQL- database-with-Unicode--properly-in-Coldfusion-7 T On 2 Jul 2007, at 13:18, Mark Leder wrote: I have a new MySQL connection set up in CF7 - verifies

RE: CFQuery and MySQL

That worked, thanks for clearing that up for me. -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 8:40 AM To: CF-Talk Subject: Re: CFQuery and MySQL This may help with the set up (but I'm assuming as it verifies it probably ok): http

RE: cfquery crashes MySQL

Someone using my blog has reported that posting a comment crashes his MySQL server. You might suggest they update their JDBC drivers to the ones designed for MySQL 4. http://www.mysql.com/ has the gory. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company -

Re: Cfquery in mysql part 2

Remove the asterisk. ~Todd At 05:59 PM 1/17/2003 +, you wrote: Ok, so I got that, and a few others to work, now I have a bit of an issue with my delete statements cfquery DELETE * FROM PPD WHERE ID = #url.id# /cfquery Now I tried using cfqueryparam for the url.id but none worked!