Victoria, you solved my problem!!! (after we spent way too much time trying to figure out what was wrong with our SQL syntax) Where should we ship the beer to? Thanks from all of us at BCA!
----------------------------------------------------- Jerry Jackson Director of Software Development BCA Technologies, Inc. (407) 659-0653 ext. 320 [EMAIL PROTECTED] ----------------------------------------------------- -----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: Re: query returns a BLOB for no reason Jerry, Friday, April 26, 2002, 5:12:57 PM, you wrote: JJ> I am hoping someone can shed light on this for me. We have a fairly simple JJ> query that is pulling data from varchar(255) and integer(11) fields and JJ> concatenating the field contents into a single results column. The problem JJ> is the resulting data is reported to be BLOB instead of the expected JJ> concatenated string....which in turn is causing our application to complain JJ> about an unsupported data type (our application is expecting a string value JJ> to be returned). It seems like an error in MySQL to us. JJ> If anyone is feeling adventurous, I can provide access to a data server to JJ> see the actual data and play with the query. JJ> this query returns BLOB's: JJ> SELECT CONCAT(tblSystemType_1.strDescription, '/', JJ> tblSystemType_2.strDescription, '/', tblSystemType_3.strDescription, '_', JJ> tblSystemType_1.intSystemTypeID, '/',tblSystemType_2.intSystemTypeID, JJ> '/',tblSystemType_3.intSystemTypeID) FROM tblSystemType AS tblSystemType_1, JJ> tblSystemType AS tblSystemType_2, tblSystemType AS tblSystemType_3 INNER JJ> JOIN tblLineItems ON tblSystemType_1.intSystemTypeID = JJ> tblLineItems.intSystemTypeID1 AND tblSystemType_2.intSystemTypeID = JJ> tblLineItems.intSystemTypeID2 AND tblSystemType_3.intSystemTypeID = JJ> tblLineItems.intSystemTypeID3 WHERE (((tblLineItems.varProjectID)=1) AND JJ> (tblLineItems.intLineItemTypeID = 5) AND booActive <> 0) ORDER BY JJ> tblSystemType_1.intSystemTypeID AND tblSystemType_2.intSystemTypeID AND JJ> tblSystemType_3.intSystemTypeID What is the length of your result string? BLOB is the same as VARCHAR BINARY column that can be as big as you like. So, if the length of your result query is bigger that 255 your result string becomes BLOB. JJ> Jerry Jackson -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.350 / Virus Database: 196 - Release Date: 4/17/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.350 / Virus Database: 196 - Release Date: 4/17/2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
