help with coldfusion forms

•

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,176 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 3,439 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.

Join our community!

Please support our ColdFusion advertiser:

Thread Tools Display Modes

Views: 824 | Replies: 1

•

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 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

(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

Location: Downingtown

Posts: 45

Reputation: hinde is an unknown quantity at this point

Rep Power: 4

Solved Threads: 2

hinde

Offline

Light Poster

Re: help with coldfusion forms

Feb 29th, 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).