I have a very strange situation that me or may not be able to be solve
easly.
I have 4 tables that have various information in that link to one another.
Tables 1,2, and 3 have a one to one entries. Table 4 can have several
entries.
For example:
Table 1 PN = Table 2 PN
Table 1 PN = Table 3 PN
I have a complex query and need a little help in directions. I have 5 tables
that I need to grab various information from . Some of the tables will only
have have 1 record that will match, others can have several that do. The
problem comes from those tables that have more then one match. The
--
-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2000 15:51
To: CF-Talk
Subject: Query Question
I have a complex query and need a little help in directions. I have 5 tables
that I need to grab
After I have imported my Ascii file, I have a date which is displayed as
'9/9/2000'
Now, I though that if I use the format statement
cfset pDATEOFMAINT = #DateFormat(DATEOFMAINT, "dd-mmm-yy")#
this would put my date in the proper format.
This should be treated no different then if it was
WI 53151-0620
Phone: 262.814.2000
Fax: 262.814.2006
Amateurs practice until they get it right,
Experts practice until they can't get it wrong.
Any opinions expressed are mine and are not representative of USAV Group.
-Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Monday, S
I have create a program that will create a excel file. Cool, this works
great, but what I need to do next is not so clear. How do I allow the user
to create the file on their local computer?
Using this code: CFSET OUTFILE="E:\inetpub\wwwroot\vsts\ExcelExport.txt",
creates the file on the
I want to take the results of a query and insert the results into an Oracle
table. Looking into the books, it really doesn't cover anything like that.
Here are some of the basic elements I have so far.
This code works except for the fact it will only insert on 1 record. Do I
use CFLOOP or
Which is a better perference, using a Join or Union?
I need to link together several tables so I can build an excel spreadsheet
Thanks for the direction.
Jim Ray
--
Archives:
-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 1:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query
Here is some more background. Here is what I need to do.
You are record number 1
1. Grab like Fields 1 2 (this would include records 1 thru 3)
2. Advance
I thought about this one as a possible solutions. The problem is, I have 2
primary keys and I haven't been able to locate any examples of how to use
two keys.
Thanks for the information anyway.
Jim Ray
-Original Message-
From: Ed Toon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August
A, I'll try that.
Thanks
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 6:33 AM
To:
This is a wierd question, but I need to ask it.
Is there a way to query the results of a query? There is a really reason
whey I need to do this.
Example
CFQUERY name="getRecord" datasource="DSTS"
SELECT *
FROMDSTS.LLISTORAGE
WHERE
I don't know exactly what you are trying to do, but would a subquery work?
If you've got the Web Application Construction Book by Ben Forta (or any sql
book), it will explain subqueries.
Hope this helps,
Brad
-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent
I have question about using JS and CF. What I wanted the following to do is
build a list of parts in a SELECT command. ALlow the user to select the
part they want and then reload the page with the part number select.
The calling program is call "EndItemAddEdit.cfm" and of course I want to
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_000_01BFFD54.357D7D80
Content-Type: text/plain;
charset="iso-8859-1"
I have a problem with getting my code to run under Netscape. Any
I have an oracle table that is defined has a date field in it. When I allow
the user to enter information and they enter the date and save it,
everything goes great.
The problem is, when the user saves the record without entering the date. I
get an error. Before I save the data I do the
CAn anyone tell me if there is something wrong with this statement? I can
not find anything wrong with it, unless CF does not support multi parms
(which I doubt).
Thanks for the help.
cfquery name="getRecord" datasource="DSTS" maxrows=1
SELECT ENDITEMPN, PRESSUREHIREQTS,
Is it possible to do the following? I want to have a form that calls another
CFM or closes the current browser window.
That's it. Straight and to the point.
form action="Some.cfm" method="post"
input type="text"
input type="submit" value="save"
input type="submit"
Thank you Ben,
Are you saying you can nested forms?
Example
form
form
Button
/form
Button
/form
Jim Ray
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 8:54 AM
To: [EMAIL PROTECTED]
Ahhh, ok , the light comes on now.
Thanks Much!
Jim Ray
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 12:12 PM
To: [EMAIL PROTECTED]
Subject: RE: How to call a javascript button
Are you saying you can nested forms?
No, at
I have 2 tables:
Table 1 - Name, location
Table 2 - Location
What I want to be able to is, is use Table 2 as a lookup table to grad the
location when in a Edit or Add mode. I have read some of the docs, but it's
not so clear to me.
I want to populate a "select box" so I can select the correct
Oh Man, my teenage son has a better looking web site. Anyway, I frequently
subscribe and unsubscribe depending how long I am going to be away from the
office. I can tell you from experience, there is nothing wrong with the
House of Fusions lister.
Shakespeare said in Julius Caesar. "The fault
What is the URL for the PHP list?
Jim Ray
-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 30, 2000 6:54 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Great list WAS: Unsubscribe
I consider this list to be a great resource.
Regards,
John Allred
The problem I have is testing the code that uses cookies. The code is
suppose to work wheter I am using Netscape or IE. Is there different code
that is needed when using cookies for both Browers?
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
I have found also, that cookies set in IE will not work in Netscape. This
is wierd because , they are saved into 2 differnet locations. I have a user
name and password with cookies and it will work in IE and not Netscape.
Even though the expert says it should.
Jim Ray
Delta Program NT
How can I take the results of a Query and save it as an Excel file?
This is what I though would work.
Thanks all!
CFQUERY NAME="DIMS" DATASOURCE="DSTS"
SELECT END_ITEM_ROOT_PN, END_ITEM_SN
FROM DSTS.B_V_DSTS_ASSEMBLY
ORDER BY END_ITEM_ROOT_PN,
Does anyone have a nice Calendar program written in CF?
Thanks
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
--
I just download it and will let you know.
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
-Original Message-
From: Hassan Khawaja [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000
Very nice package. it's a keeper. To bad the tags only cover CF 3.0 and not
4.0.
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
-Original Message-
From: Hassan Khawaja [mailto:[EMAIL
29 matches
Mail list logo