User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 374,007 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,917 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser:
Views: 616 | Replies: 0
Reply
Join Date: Feb 2007
Posts: 20
Reputation: muddpigeon is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
muddpigeon muddpigeon is offline Offline
Newbie Poster

help meeee??

  #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


<cfquery name="GetUser" datasource="2ndhandbooks">
SELECT * FROM students
WHERE lastname = '#Form.lastname#'
AND firstname= '#Form.firstname#'
AND password= '#Form.password#'
</cfquery>

<cfif GetUser.RecordCount gt 0>
	<cfset Session.firstname = getUser.firstname>
	
<cfquery name="list" datasource="2ndhandbooks">
SELECT * FROM books
</cfquery>

<html>
<head>
<title>2ndHandBooks&reg</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<cfif isDefined ("url.matno")>
<cfquery name="reservations" datasource="2ndhandbooks">	
SELECT * FROM (reservations INNER JOIN students on reservations.matno = students.matno) INNER JOIN BOOKS on books.bookid = reservations.bookid WHERE students.matno=#matno#;
</cfquery>

<body bgcolor="#666666" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<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; "> 
  <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">
  <strong><font size="2"> </font></strong></font>
  <font face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode"> 
    
    </font> 
    
   <p><font size="2"><strong><font face="Tahoma, Courier, Courier New, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode"><br>
 
   <h1>Welcome to your account!</h1>
   
<p><cfoutput query="GetUser">
<p>Welcome back <cfoutput>#Session.firstname#</cfoutput></p>
</cfoutput>


<p> Here are the books you have currently reserved. </p>
	<tr bgcolor="#">	
		<td>Book ID</td>
		<td>Book Title</td>
		
	</tr>
	<cfoutput query="reservations">
	<tr>
		<td>#bookid#</td>
		<td>#title#</td>
		
	</cfoutput>
	</tr>
	<br>

</cfif>


      </font></strong></font> </p>
  </div>
</div>
<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>
<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>
<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">
      <div id="nav_m">
			 <ul>
						
							<li><a href="homepage.cfm" class="active">Home</a></li>
							
							<li><a href="AboutUs.cfm">About us</a></li>
								
							<li><a href="Registration.cfm">Register</a></li>
							
							<li><a href="news.cfm">News</a></li>
								
							<li><a href="Books.cfm">Books</a></li>
								
							<li><a href="contact.cfm">Contact</a></li>
					</ul>
                    </div>

  </form>
  	

</div>
<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>
  </strong></font></div>
<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>
</body>
</html>
<cfelse>
<!--- User does not exist --->
<cflocation url="loginerror.cfm"> </cfif>
Last edited by peter_budo : Mar 6th, 2008 at 6:04 am. Reason: ICODE is for one line codes, CODE is for multiple
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb ColdFusion Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the ColdFusion Forum

All times are GMT -4. The time now is 10:42 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC