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
Tab
bubble Ltd
--
-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 ne
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 resu
et 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, September 11, 2000 11:00 AM
To: [EMAIL PROTECTED]
Subject: Ascii Date
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
this would put my date in the proper format.
This should be treated no different then if it was passed via a form. Now I
could parse the data out and put i
PM
To: [EMAIL PROTECTED]
Subject: RE: Importing a text file
Like this
#Replace("#f1_element#","Chr(34)"," ","ALL")#>
--K
-----Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:05 PM
To: [EMAIL PR
I have a file that I need to import that looks something like this.
"A3","BOOSTER_TANK_ASSY","1B89037","Serial
Number",#2000-09-09#,100,75,"Visual Good","No"
Now, I know how to import the, what I am having problems is that the data is
surrounded by "'s. This is my Replace statement
#R
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: ,
creates the file on the server. I need to create this file on the users
local HD.
Tha
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 what.
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: http://www.mail-archive.com/cf-talk@house
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: '[
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
-
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. Adv
t: RE: Query a Query
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 [
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
SELECT *
FROMDSTS.LLISTORAGE
WHERE (ENDITEMPN = '#FORM.ENDITEMPN#') AND (ENDITE
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
call
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 follow
Is there a way in a to force Upper Case while using a ?
Thank you.
Jim Ray
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=li
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.
SELECT ENDITEMPN, PRESSUREHIREQTS, PRESSURELOREQTS, PRESSURENAME
FROMDSTS.PRESSURE_REQTS
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 le
Thank you Ben,
Are you saying you can nested forms?
Example
Button
Button
Jim Ray
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 8:54 AM
To: [EMAIL PROTECTED]
Subject: RE: How to c
Excellent!!!
Thanks for the help. It really helped.
Jim Ray
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 8:54 AM
To: [EMAIL PROTECTED]
Subject: RE: How to call a javascript button
This will close the current window. However
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.
(Can this be a javascript
that closes the window?)
Thank you!
Jim Ray
--
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
Seems to be a bit slow. 60 secs on my T1 from Huntington Beach, Calif. Each
page seems to be the same. Can't read it though.
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
-Original Message---
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 Allre
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
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 Administr
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!
SELECT END_ITEM_ROOT_PN, END_ITEM_SN
FROM DSTS.B_V_DSTS_ASSEMBLY
ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN
#END_ITEM_ROOT_PN# #END_IT
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 PROTE
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 11:4
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/
--
Archives
34 matches
Mail list logo