10 : SELECT Courses.id, Name, City, phone, Address, Courses.State, Courses.Zip, Courses.courselogo, Courses.largeimage, largeimage, IFNULL(membership,'') as membership
11 : FROM Courses
12 : WHERE Courses.ID = <cfqueryparam value="#url.Id#" cfsqltype="cf_sql_integer" />
13 : </cfquery>
14 :
|