cfoutput to a htm file? html frames

19 New Member

Currently i have a DEFAULT.htm file that display 2 htm frames , FRAME1.htm and FRAME2.htm.

1.FRAME 1.htm present a form to fill up a sql query and pass info to a "MYQUERY.cfm"
2.MYQUERY.cfm performs query on sql and show results in table on FRAME1.

Is any way i can make that result table to show up on FRAME2.htm instead??

I tried everything and nothing works

Any help will be appreciated

This is the code :
MYQUERY.CFM

Expand|Select|Wrap|Line Numbers

  
<html>

<CFOUTPUT>
 
The item selected is #item#
 
</CFOUTPUT>
 
<h1> List of product selected with price </h1><hr>
 
<!--- Step 1: The SQL query to list a subset of columns from supplier table --->

<cfquery name="testing" Datasource="Northwind">

select productid,productname,unitprice,unitsonorder from products

</cfquery>
 
<cfif #testing.recordcount# EQ 0>

No products available. 

<cfelse>
 
<!--- Step 2-a): Print Column Headings --->
 
<table border="1" cellpadding="1">

<tr>

<td>Productid</td>

<td>ProductName</td>

<td>UnitPrice</td>

<td>UnitsOnOrder</td>

</tr>
 
<!--- Step 2-b): Code for outputting retrieved data in table format ---> 

<cfoutput query="testing">

<tr>

<td>#ProductID#</td>

<td>#ProductName#</td>

<td>#UnitPrice#</td>

<td>#UnitsOnOrder#</td>

</tr>

</cfoutput>

</table>

</cfif>

</body>
 
</html>

Jun 9 '08 #1

Subscribe Reply

3524

acoder

16,027

Recognized Expert Moderator MVP

Set the target of the form to frame2. An HTML solution rather than a Coldfusion one.

Jun 9 '08 #2

Similar topics

2750

Probelm with cfoutput / document.write JS function in Netscape 7

by: Yvan J. Gagnon | last post by:

I am encountering a strange problem in Netscape 7 with a CFM file I am trying to troubleshoot (the page is working fine in NS Communicator and IE). Below is a sample of the problematic line of...

Javascript

7656

Referencing a text/html file within another HTML file - WITHOUT Frames (e.g. Span, Div)

by: Go USA! Go Israel! | last post by:

I was wondering if the following was possible: Instead of using a frameset which references other individual HTML files, have the <SPAN> tag reference another HTML file, which is placed within...

HTML / CSS

2182

checking for what file loaded in a frame..

by: Frances Del Rio | last post by:

if (parent.frames.main.location == 'mediaselect.html') { I have a very simple frameset, name of frame where I'm checking is 'main'... why is this not working? I mean this is correct syntax,...

Javascript

2016

Opening a html file from a Command Button

by: ChrisR | last post by:

Hi folkes I have a simple html file with 2 frames, as my Help file to my DB. It consists of 3 parts: Help.htm = Is the main file with the 2 frames. Index.htm = Is the left frame as a index...

Microsoft Access / VBA

1306

Getting a Border in an XML File

by: fro5tie | last post by:

Please would anyone be able to help me, i have search google and tried my best to get this to work for hours and its really infuriating now. basically i have a site with frames 5 frames, one...

.NET Framework

3396

How can I "include" an HTML file from another server?

by: indessen | last post by:

Hi, got the following problem: I want to include some code in an HTML page so that at a particular place, it fetches another HTML file from another server and puts it in. Reason for this is that...

HTML / CSS

1382

Link to a frames based page links to wrong html file.

by: admyc | last post by:

Hi, I have a site I designed using frames.The document that sets up the frame structure is called index.html, and one of its frames contains the main document called main.html. The search...

HTML / CSS

2710

I simply can't figure this out - file uploads with iframes... please help!

by: pbd22 | last post by:

hi. i have been posting this here and elsewhere a lot and can't seem to get resolution on this problem. i have been trying to upload files using a hidden iframe to a asp.net/vb.net form. the...

ASP.NET

5576

load frameset file form php include?

by: Geoff Cox | last post by:

Hello I'm having a problem loading a frameset file using an include in a php file. Nothing is displayed and when I look at the source code I see that <html> <head> <title></title>

PHP

7202

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7278

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

6991

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7458

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4672

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3167

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3154

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1512

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

736

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP