This is a really odd occurrence and I wonder if anyone has run into
themselves, or more importantly knows how to get around it.
I'm using ColdFusion 6.1 with mySQL 4.0. Here's my data structure:
eq_year - smallint(4)
mfr_name - varchar(60)
eq_model - varchar(12)
and the query:
SELECT CONCAT(' ', e.eq_year,' ', m.mfr_name,' ',e.eq_model) AS equipment
FROM equipment e
INNER JOIN manufacturer m
ON m.mfr_id = e.fk_mfr_id
The query itself runs just fine, but instead of returning a string for
"equipment", it returns a binary number. So I recall this sort of thing
happening before where the CAST function fixed it. So I try this query:
SELECT CONCAT(' ', CAST(e.eq_year AS CHAR),' ', m.mfr_name,' ',e.eq_model)
AS equipment
FROM equipment e
INNER JOIN manufacturer m
ON m.mfr_id = e.fk_mfr_id
And I get an error. Does anyone have any ideas about why this might be
happening? Just to point out that it also throws an error when running the
query straight in phpmyadmin. The easy solution would be to just convert the
eq_year field to a char field, but that seems stupid.
<!----------------//------
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--------------//--------->
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230267
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
