Joshua wrote:
I checked the table and found that none of my fields in the SELECT
statement contain NULLs.
Any other suggestions?
Why are you using such constructions in your query: ',' || ',' || ',' ?
May be this set of commas makes you think that some of your fields are
empty? Do you have empty fields in following query?
SELECT 'PV.LINEITEM:' || partnum || ',' || round(onhand) || ',' ||
round(qm5) || ',' || round(lsm4) || ',' || round(onorder) || ',' ||
binone || ',' || round(backorderqty) || ',' || round(onhold) || ',' ||
round(qtyperjob) || ',' || round(ordermax) AS gmrim FROM slparts WHERE
vendor LIKE 'CH%'
P.S. If you really need so many commas - use them in a single block....
',,,'
PFC wrote:
SELECT 'PV.LINEITEM:' || partnum || ',' || round(onhand) || ',' ||
round(qm5) || ',' || round(lsm4) || ',' || ',' || ',' ||
round(onorder) || ',' || ',' || ',' || binone || ',' || ',' ||
round(backorderqty) || ',' || ',' || round(onhold) || ',' || ',' ||
',' || ',' || ',' || ',' || ',' || round(qtyperjob) || ',' ||
round(ordermax) AS gmrim FROM slparts WHERE vendor LIKE 'CH%'
You could select columns and build the string in your application ?
The query does work and I am getting results from the database.
There are values for all 'partnum' in the database, however, the
query results include blank fields here and there in between the
returned records. Why am I receiving blank fields for 'gmrim'????
This absolutely defies logic
Because one of your fields is probably NULL, and NULL || anything
stays NULL.
You have probably been misled to believe they are "blanks"
because they don't display as "NULL" but as "".
I set psql to display NULL as NULL.
If these columns can, must, or should not contain NULLs depends
on your application... it's for you to chose.
Use COALESCE, add NOT NULL constraints, grab the columns and
build the string in your application, you chose.
--No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.8.1/822 - Release Date:
5/28/2007 11:40 AM
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
