I checked the table and found that none of my fields in the SELECT
statement contain NULLs.
Any other suggestions?
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
