cfnewbie23
04-23-2004, 07:13 AM
Can someone help me on how to store the quantity information. I don't want to add a duplicate entry into the array but rather incrementing it. I've put some code but I get an error saying "Variable I is not defined". I can't find the error
Here is the code:
<head>
<title>Book Info</title>
<style type = "text/css">
table { border-collapse: collapse }
td { border: 2px solid lightgray; padding: 5px }
</style>
</head>
<body>
<!--- Make sure that an ISBN was submitted to this page --->
<cfif NOT isDefined( "form.ISBN" )>
<!--- CFML URL Forwarder --->
<cflocation url = "booklist.cfm" addtoken = "no">
<cfabort>
</cfif>
<!--- CFML Query using SQL on 'books' DSN --->
<!--- Dynamically insert form.ISBN variable --->
<cfquery name = "bookInfo" datasource = "books">
SELECT ISBN, Title, EditionNumber, Copyright, Description,
ImageFile, PublisherName
FROM Titles, Publishers
WHERE Titles.ISBN = '#form.ISBN#'
AND Titles.PublisherID = Publishers.PublisherID
</cfquery>
<!--- Using cfoutput with a query to loop result set --->
<cfoutput query = "bookInfo">
<!--- Based on ISBN, use SQL to retrieve authors --->
<cfquery name = "authorInfo" datasource = "books">
SELECT FirstName, LastName
FROM AuthorISBN, Authors
WHERE AuthorISBN.isbn = '#bookInfo.ISBN#'
AND AuthorISBN.AuthorID = Authors.AuthorID
</cfquery>
<h1>#bookInfo.Title#</h1>
<hr />
<!--- Display authors by using a CFML Loop --->
<cfloop query = "authorInfo">
#authorInfo.FirstName# #authorInfo.LastName# <br />
</cfloop>
<!---Output information from database about book --->
<table>
<tr>
<td>ISBN:</td>
<td>#bookInfo.ISBN#</td>
<td rowspan ="4">
<!--- Dynamically insert the filename into the tag --->
<img src = "images/#bookInfo.ImageFile#" alt = "Image File" />
</td>
</tr>
<tr>
<td>Edition:</td>
<td>#bookInfo.EditionNumber#</td>
</tr>
<tr>
<td>Copyright:</td>
<td>#bookInfo.Copyright#</td>
</tr>
<tr>
<td>Publisher:</td>
<td>#bookInfo.PublisherName#</td>
</tr>
</table>
#bookInfo.Description#
<!--- Used in Section 27.8 --->
<!--- Button to add book to shopping cart --->
<form action = "shoppingcart.cfm" method = "post">
<input type = "hidden" name = "ISBN" value = "#bookInfo.ISBN#" />
<input type = "hidden" name = "title" value = "#bookInfo.Title#" />
<input type = "hidden" name = "edition" value="#bookInfo.EditionNumber#" />
<input type = "submit" value = "Add To Cart"
!--disabled = "disabled" />
</form>
</cfoutput>
<!--- Button to go back to the book list --->
<form action = "booklist.cfm" method = "post">
<input type = "submit" value = "Book List" />
</form>
</body>
Thanks!
Here is the code:
<head>
<title>Book Info</title>
<style type = "text/css">
table { border-collapse: collapse }
td { border: 2px solid lightgray; padding: 5px }
</style>
</head>
<body>
<!--- Make sure that an ISBN was submitted to this page --->
<cfif NOT isDefined( "form.ISBN" )>
<!--- CFML URL Forwarder --->
<cflocation url = "booklist.cfm" addtoken = "no">
<cfabort>
</cfif>
<!--- CFML Query using SQL on 'books' DSN --->
<!--- Dynamically insert form.ISBN variable --->
<cfquery name = "bookInfo" datasource = "books">
SELECT ISBN, Title, EditionNumber, Copyright, Description,
ImageFile, PublisherName
FROM Titles, Publishers
WHERE Titles.ISBN = '#form.ISBN#'
AND Titles.PublisherID = Publishers.PublisherID
</cfquery>
<!--- Using cfoutput with a query to loop result set --->
<cfoutput query = "bookInfo">
<!--- Based on ISBN, use SQL to retrieve authors --->
<cfquery name = "authorInfo" datasource = "books">
SELECT FirstName, LastName
FROM AuthorISBN, Authors
WHERE AuthorISBN.isbn = '#bookInfo.ISBN#'
AND AuthorISBN.AuthorID = Authors.AuthorID
</cfquery>
<h1>#bookInfo.Title#</h1>
<hr />
<!--- Display authors by using a CFML Loop --->
<cfloop query = "authorInfo">
#authorInfo.FirstName# #authorInfo.LastName# <br />
</cfloop>
<!---Output information from database about book --->
<table>
<tr>
<td>ISBN:</td>
<td>#bookInfo.ISBN#</td>
<td rowspan ="4">
<!--- Dynamically insert the filename into the tag --->
<img src = "images/#bookInfo.ImageFile#" alt = "Image File" />
</td>
</tr>
<tr>
<td>Edition:</td>
<td>#bookInfo.EditionNumber#</td>
</tr>
<tr>
<td>Copyright:</td>
<td>#bookInfo.Copyright#</td>
</tr>
<tr>
<td>Publisher:</td>
<td>#bookInfo.PublisherName#</td>
</tr>
</table>
#bookInfo.Description#
<!--- Used in Section 27.8 --->
<!--- Button to add book to shopping cart --->
<form action = "shoppingcart.cfm" method = "post">
<input type = "hidden" name = "ISBN" value = "#bookInfo.ISBN#" />
<input type = "hidden" name = "title" value = "#bookInfo.Title#" />
<input type = "hidden" name = "edition" value="#bookInfo.EditionNumber#" />
<input type = "submit" value = "Add To Cart"
!--disabled = "disabled" />
</form>
</cfoutput>
<!--- Button to go back to the book list --->
<form action = "booklist.cfm" method = "post">
<input type = "submit" value = "Book List" />
</form>
</body>
Thanks!