Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why won't my page show up? 1

Status
Not open for further replies.
monoone

monoone

Programmer
May 24, 2002
219
US
I cannot see my dynamic content.

What am I doing wrong?


Here is my SQL
----------------
<cfquery name=&quot;GetTrans&quot; datasource=&quot;Loaner&quot; dbtype=&quot;ODBC&quot;>
SELECT
LN.LoanerID, LN.LoanerPO, LN.ManID,
TR.TransID, TR.LoanerID, TR.TimeStamp2,
MN.ManID, MN.ManName

FROM Loaner LN,
Transaction TR,
Manager MN

WHERE LN.LoanerID = #URL.TransID# AND
TR.LoanerID = LN.LoanerID AND
MN.ManID = LN.ManID

</cfquery>
------------------------------


Here is my output:

-----------------------------
<body BGCOLOR=&quot;White&quot; leftmargin=&quot;0&quot; topmargin=&quot;0&quot; marginwidth=&quot;0&quot; marginheight=&quot;0&quot;>
<TABLE ALIGN=&quot;center&quot; WIDTH=&quot;100%&quot; CELLSPACING=&quot;0&quot; CELLPADDING=&quot;0&quot; BORDER=&quot;0&quot;>
<TR>
<TD BGCOLOR=&quot;Gold&quot; HEIGHT=&quot;25&quot; WIDTH=&quot;100%&quot;>
<DIV ALIGN=&quot;center&quot;><FONT SIZE=&quot;2&quot; COLOR=&quot;Black&quot;>:: LOANER LIST ::</FONT></DIV>
</TD>
</TR>
<TABLE ALIGN=&quot;center&quot; WIDTH=&quot;550&quot; CELLSPACING=&quot;7&quot; CELLPADDING=&quot;7&quot; BORDER=&quot;0&quot;>
<TR>
<TD>
<TABLE CELLSPACING=&quot;5&quot; CELLPADDING=&quot;5&quot; BORDER=&quot;0&quot; ALIGN=&quot;center&quot;>
<TR>
<TD VALIGN=&quot;top&quot;>
<!--- <CFIF GetTrans.recordcount IS 1> --->
<FONT FACE=&quot;Arial,Helvetica,sans-serif&quot; COLOR=&quot;Red&quot; size=&quot;2&quot;>
<br>
<br>
<br>
<DIV ALIGN=&quot;center&quot;>This Loan only has One Transaction So You Must Delete The Initial Loan.<br>
<br>
<cfoutput query=&quot;GetTrans&quot;><a href=&quot;Edit_Loaner.cfm?LoanerID=#LoanerID#&quot;>Go Back and Delete Loan</a></CFOUTPUT>
</FONT>
</DIV>
<!--- <CFELSEIF GetTrans.recordcount GT 1> --->
<div align=&quot;center&quot;>
<font color=&quot;Red&quot;>
You Are About To Delete This Transaction From The Database.<br>
This CANNOT be UNDONE!!!
</font>
</div>
<br>
<br>
<br>
<cfoutput query=&quot;GetTrans&quot;>#ManName# - PO NO. #LoanerPO# - #DateFormat (GetTrans.TimeStamp2, 'mm/dd/yyyy')#&nbsp; - &nbsp;#TimeFormat (GetTrans.TimeStamp2, 'h:m:ss tt')#
<br>
<form action=&quot;DeleteTrans_Done.cfm&quot; method=&quot;post&quot; name=&quot;DeleteTrans&quot; id=&quot;DeleteTrans&quot; onSubmit=&quot;return confirm ('Did you really think this out? No going back, ARE YOU SURE?')&quot;>
<input type=&quot;hidden&quot; name=&quot;TransID&quot; value=&quot;#TransID#&quot;><input type=&quot;submit&quot; value=&quot;Delete&quot;>
</form>
</cfoutput>
<!--- </CFIF> --->
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</body>
</html>

What is wrong?

Thanks,

monoone
 
Sort by date Sort by votes
A lot of times a page may not display due simiply to html formatting issues within your tables. I would try closing your first table, as I don't see a </table> tag for that one and see if your page is displayed. Hope that helps.
Jami
 
Upvote 0 Downvote
Yup,

you were right - lesson 1 - Code neatly or it can get confusing.

Thanks,

Eric
 
Upvote 0 Downvote

One reason to always check your pages in Netscape. IE is much more forgiving of miscoded HTML and unclosed tags. Netscape ain't. If your page displays in IE, but not in Netscape, 999 times out of 1000 it means you have an unclosed tag or forgot to close the quote on a tag parameter.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cohan123
  • Locked
  • Question
page layout-&gt;page size, optimal for web
Replies
0
Views
189
cohan123
cohan123
LyndonOHRC
  • Locked
  • Question
CFpdf Tag Locking up my server 1
2
Replies
21
Views
483
jdhilljr
jdhilljr
oshinwa
  • Locked
  • Question
Which Call collector should I use and which one is compatible with my Ericsson BP250?
Replies
0
Views
177
oshinwa
oshinwa
LyndonOHRC
  • Locked
  • Question
Javascript code will not execute if a cfdocument tag is in my document
Replies
1
Views
117
LyndonOHRC
LyndonOHRC
ElizaShteto
  • Locked
  • Question
Split One Page in two separate Pages in Framemaker 11
Replies
0
Views
75
ElizaShteto
ElizaShteto

Part and Inventory Search

Sponsor

Back
Top