help meeee??

Reply

•
•
Join Date: Feb 2007
Posts: 20
Reputation: muddpigeon is an unknown quantity at this point 
Solved Threads: 0
muddpigeon muddpigeon is offline Offline
Newbie Poster

help meeee??

 
0
  #1
Mar 5th, 2008
theres problem with this page and its annoying me sooo much
basically because of the cfml code in the page its knocked the html and style of the page away.
the web site is due this friday and im really stuggling
any help would be appreciated


ColdFusion Syntax (Toggle Plain Text) 
  1. <cfquery name="GetUser" datasource="2ndhandbooks">
  2. SELECT * FROM students
  3. WHERE lastname = '#Form.lastname#'
  4. AND firstname= '#Form.firstname#'
  5. AND password= '#Form.password#'
  6. </cfquery>
  7.  
  8. <cfif GetUser.RecordCount gt 0>
  9. 	<cfset Session.firstname = getUser.firstname>
  10.  
  11. <cfquery name="list" datasource="2ndhandbooks">
  12. SELECT * FROM books
  13. </cfquery>
  14.  
  15. <html>
  16. <head>
  17. <title>2ndHandBooks&reg</title>
  18. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  19.  
  20. </head>
  21.  
  22. <cfif isDefined ("url.matno")>
  23. <cfquery name="reservations" datasource="2ndhandbooks">	
  24. SELECT * FROM (reservations INNER JOIN students on reservations.matno = students.matno) INNER JOIN BOOKS on books.bookid = reservations.bookid WHERE students.matno=#matno#;
  25. </cfquery>
  26.  
  27. <body bgcolor="#666666" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
  28. <div id="Layer1" style="position:absolute; left:23px; top:63px; width:1000px; height:600px; z-index:1; background-color: #000000; layer-background-color: #000000; border: 1px none #000000; "> 
  29.   <div id="Layer6" style="position:absolute; left:283px; top:47px; width:300px; height:1252px; z-index:7"><font size="1" face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode">
  30.   <strong><font size="2"> </font></strong></font>
  31.   <font face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode"> 
  32.  
  33.     </font> 
  34.  
  35.    <p><font size="2"><strong><font face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode"><br>
  36.  
  37.    <h1>Welcome to your account!</h1>
  38.  
  39. <p><cfoutput query="GetUser">
  40. <p>Welcome back <cfoutput>#Session.firstname#</cfoutput></p>
  41. </cfoutput>
  42.  
  43.  
  44. <p> Here are the books you have currently reserved. </p>
  45. 	<tr bgcolor="#">	
  46. 		<td>Book ID</td>
  47. 		<td>Book Title</td>
  48.  
  49. 	</tr>
  50. 	<cfoutput query="reservations">
  51. 	<tr>
  52. 		<td>#bookid#</td>
  53. 		<td>#title#</td>
  54.  
  55. 	</cfoutput>
  56. 	</tr>
  57. 	<br>
  58.  
  59. </cfif>
  60.  
  61.  
  62.       </font></strong></font> </p>
  63.   </div>
  64. </div>
  65. <div id="Layer2" style="position:absolute; left:124px; top:24px; width:189px; height:30px; z-index:2; background-color: #000000; layer-background-color: #006699; border: 1px none #000000;"></div>
  66. <div id="Layer3" style="position:absolute; left:142px; top:28px; width:160px; height:21px; z-index:3"><strong><font color="#FFFFFF" face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode">2ndhandbooks&reg; </font></strong></div>
  67. <div id="Layer5" style="position:absolute; left:764px; top:100px; width:100px; height:169px; z-index:4"> <font color="#FFFFFF" face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode">
  68.       <div id="nav_m">
  69. 			 <ul>
  70.  
  71. 							<li><a href="homepage.cfm" class="active">Home</a></li>
  72.  
  73. 							<li><a href="AboutUs.cfm">About us</a></li>
  74.  
  75. 							<li><a href="Registration.cfm">Register</a></li>
  76.  
  77. 							<li><a href="news.cfm">News</a></li>
  78.  
  79. 							<li><a href="Books.cfm">Books</a></li>
  80.  
  81. 							<li><a href="contact.cfm">Contact</a></li>
  82. 					</ul>
  83.                     </div>
  84.  
  85.   </form>
  86.  
  87.  
  88. </div>
  89. <div id="Layer7" style="position:absolute; left:623px; top:39px; width:600px; height:16px; z-index:6"><font color="#006699" size="1" face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode"><strong>
  90.   </strong></font></div>
  91. <div id="Layer4" style="position:absolute; left:51px; top:90px; width:215px; height:401px; z-index:5"><img src="images/rowofbooks.jpg" alt="BOOKS" width="209" height="398" border="2"></a></div>
  92. </body>
  93. </html>
  94. <cfelse>
  95. <!--- User does not exist --->
  96. <cflocation url="loginerror.cfm"> </cfif>
Last edited by peter_budo; Mar 6th, 2008 at 7:04 am. Reason: ICODE is for one line codes, CODE is for multiple
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ColdFusion Forum
Thread Tools Search this Thread



Tag cloud for ColdFusion
adobe adobelivecyclees alfresco amazon cfquery checkbox coldfusion contentmanagement dreamweaver ebooks insert kindle multiple opensource openstandards pdf select sony sonyreader
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC