ColdFusion

help with coldfusion forms

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

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 with coldfusion forms

Feb 29th, 2008

i have a problem with this page and neither me or my lecutrer can spot it.
all i want it to do is display the details of the person who has just logged in.
can any one help??

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfquery name="GetStudent" datasource="2ndHandBooks"> 
SELECT * FROM students WHERE matno = #Form.MatNo# AND Password = #Form.password# </cfquery>
<cfif GetStudent.RecordCount gt 0>
<!--- Store the user id in session --->
<cfset Session.matno = GetStudent.>
 
<html>
<head>
<title>2ndHandBooks&reg</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
</head>
 
<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>#Session.username#</cfoutput>
      </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="home.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=".cfm"> </cfif>
<cfquery name="GetStudent" datasource="2ndHandBooks"> 
SELECT * FROM students WHERE matno = #Form.MatNo# AND Password = #Form.password# </cfquery>
<cfif GetStudent.RecordCount gt 0>
<!--- Store the user id in session --->
<cfset Session.matno = GetStudent.>

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

</head>

<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>#Session.username#</cfoutput>
      </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="home.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=".cfm"> </cfif>

•

Join Date: Jul 2005

Posts: 60

Reputation: hinde is an unknown quantity at this point

Solved Threads: 4

hinde

Offline

Junior Poster in Training

Re: help with coldfusion forms

Mar 1st, 2008

What type of issue are you experiencing? Are you getting a coldfusion error? If so post a cfdump of the error with a stacktrace (can be deprecated if you want, but leave the line numbers).