g returned is in the web pages"
SQLState: 08S01 Native Error Code: 1 Error while executing
the query; ERROR: cannot display a value of type record"
Kent Anderson
EZYield.com
407-629-0900
www.ezyield.com
This electronic message t
doesn't seem to read the "sort" variable.
Any help would be
appreciated.
Kent Anderson
;$2" at character 982)
yield_date = '' || '' || submissiondate || '' || '' (returns ERROR: column
"submissiondate" does not exist)
FOR result IN
EXECUTE ''SELECT
(. select all necessary fields ...)
FROM
( tables ...)
WHERE hm
Never mind, it requires '''''''' on each side of the variable.
Thanks
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Kent Anderson
Sent: Monday, October 18, 2004 1:32 PM
To: [EMAIL PROTECTED] Org
Subject: Re: [SQL]
suggestions?
Kent Anderson
EZYield.com
407-629-0900
www.ezyield.com
This electronic message transmission contains
information from the Company that may be proprietary, confidential and/or
privileged. The information is intended only for the use of the
second
table.
table
1
t1_fk_wm (FK)
t1_fk_hm (FK)
...
...
...
table
2
t2_fk_wm (FK)
t2_fk_hm (FK)
Table 2 doesn't have
the same number of records as the first table however it
should.
Any suggestions
would be appreciated as I am still very much a beginner at SQL.
Kent Anderson
