Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!---Brandon Sullivan week 4 homework--->
- <cfquery name="qArtist" datasource="CF8IntroArtGallery">
- SELECT firstName, lastName, artistID
- FROM artists
- ORDER BY lastName
- </cfquery>
- <html>
- <head>
- <title>Art Query</title>
- </head>
- <body>
- <h1>Art Search</h1>
- <form action="process.cfm" method="get">
- <label for="searchArt">Name of Art: </label>
- <input type="text" name="searchArt" id="searchArt" />
- <label for="searchArtist">Artist's Name:</label>
- <select name="searchArtist" id="searchArtist" />
- <option value=""></option>
- <cfoutput query="qArtist">
- <option value="#firstName# #lastName#">#lastName#, #firstName#</option>
- </cfoutput>
- </select>
- <br />
- <br />
- <fieldset>
- <legend>artSold</legend>
- <input type="checkbox" name="artSold" id="artSold" value="notSold" />
- <label for="artSold">Check to show only available pieces.</label>
- </fieldset>
- <br />
- <br />
- <input type="submit" name="btnSubmit" value="search" />
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement