	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.7

Deleting from tables using mysql

Asked by myselfrandhawa in ColdFusion Application Server, MySQL Server, Cold Fusion Markup Language

Tags: mysql, coldfusion

hi experts. i am using mysql query to fetch records. i am doing the right join to check that if the record i am retieving has any associated comments and testimonials attached to it:

the query runs oK but i want to delete once it gets confirmed that comments and testimonials do exists:

i am doing like this

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:

           
           
             <cfquery datasource="#request.dsn#" username="#request.dsn_user#" password="#request.dsn_password#" name="GetRecord">
SELECT DISTINCT(ID), gall.* 
testimonials.testID, comm.commID,   
from gall 
left outer JOIN testimonials ON Gall.ID = testimonials.ImageID  
left outer JOIN comm ON Gall.ID = comm.ImageID  
where ID = <cfqueryparam value="#URL.ID#" cfsqltype="cf_sql_integer"> 
</cfquery>
 
testimonials are stored in different testimonials table.
 
now i am doing something like this:
 
<cflock name="CreateLock" timeout="30">
    <cftransaction>
    <cfif Getrecord.commID IS NOT "">
    <cfquery  datasource="#request.dsn#">
    delete from Comm
    where 
    ImageID = <cfqueryparam cfsqltype="cf_sql_numeric" value="#trim(GetRecord.ID)#">
    </cfquery>
    </cfif>
    <cfif Getrecord.testID IS NOT "">
    <cfquery  datasource="#request.dsn#">
    delete from testimonials
    where 
    ImageID = <cfqueryparam cfsqltype="cf_sql_numeric" value="#trim(GetRecord.ID)#">
    </cfquery>
    </cfif>
    </cftransaction>
  </cflock>
 
ImageID  is the field related to gall table not directly but by programming code in the above query: while testimoniql table has testID as PK
 
my query getting failed, i also look if the comments do exists they should delete else it should skip the step.
 
same for the testimonials
           
         

Deleting from tables using mysql

Asked by myselfrandhawa in ColdFusion Application Server, MySQL Server, Cold Fusion Markup Language

Tags: mysql, coldfusion

About this solution