Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!---Brandon Sullivan week 4 homework--->
- <cfparam name="url.searchArt" default="" />
- <cfparam name="url.searchArtist" default="" />
- <cfparam name="url.sold" default="" />
- <cfif NOT LEN(url.searchArt)>
- <cflocation url="index.cfm">
- </cfif>
- <cfquery name="qArt" datasource="CF8IntroArtGallery">
- SELECT artName, artistID, isSold
- FROM art
- WHERE
- <cfif url.searchArt IS NOT "">
- artName LIKE '%#url.searchArt#%'
- </cfif>
- <cfif url.searchArtist EQ 'artistID'>
- artistID
- </cfif>
- </cfquery>
- <html>
- <head>
- <title>Art List</title>
- </head>
- <body>
- <h2>Artwork by <cfoutput>#url.searchArtist#</cfoutput></h2>
- <table border="0">
- <thead>
- <tr>
- <th>Art Name</th>
- <!---<th>isSold</th>--->
- <!---<th>artistID</th>--->
- </tr>
- </thead>
- <cfoutput query="qArt">
- <!---Sets alternating table style--->
- <cfif currentRow MOD 2 IS 1>
- <cfset color="green">
- <cfelse>
- <cfset color="blue">
- </cfif>
- <tbody>
- <tr color="#color#">
- <td><cfif NOT LEN(artName)>
- <p>No Results to Show</p>
- <cfelse>
- #artName#
- </cfif>
- </td>
- <!---<td>#yesnoFormat(isSold)#</td>--->
- <!---<td>#url.searchArtist#</td>--->
- </tr>
- </tbody>
- </cfoutput>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement