Re: Is there anyway to return an array?

values in a string format (ascii representation). Like I said, I'm new to UDF's so it is likely I'm not aware of conventions to follow that are well known to others. Any help would be great. David Godsey David Godsey wrote: I know, I know, sounds like something that should be done

Re: Is there anyway to return an array?

Never mind, I was being dumb. I wasn't using the args-lengths array for binary data, so it was dying on a strlen(args-args[0]) which makes sense. Thanks anyway. David Godsey So, in theory this should be pretty straight forward to do right? Well I'm new to UDF's, so how mysql is passing

Re: Is there anyway to return an array?

Well, I'm doing something stupid because that is what the bosses want. I appreciate the suggestions, I think the CSV string format is the way to go. David Godsey David Godsey wrote: I know, I know, sounds like something that should be done in the presentation layer, howerver if possible

Is there anyway to return an array?

an array in mysql? Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UDF help, convert BLOB to BIGINT

that the boss will add it to your regular duties. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UDF help, convert BLOB to BIGINT

. David Godsey David Godsey [EMAIL PROTECTED] wrote on 03/22/2006 01:21:07 PM: I'm in the process of writing my first UDF and would appreciate some help. I am pulling data from a table like: SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1

Byte Swaping (Re Post)

. Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Byte Swapping

. Thanks. Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Byte Swapping

it is not. David Godsey Hi David, This might be an unusual question because mysql always stores in little endian for all platforms (if I'm not mistaken). However, I am receiving data from several different platforms (custom boards with various processors) in raw form. I will have stored

Re: Error 2016 and 2013

George Law gave me the answer: http://bugs.mysql.com/bug.php?id=14993 I had read the link you suggested, however it didn't really explain why I was getting the error. Thanks. David Godsey Hello. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html David Godsey wrote: nativecode

Error 2016 and 2013

duties. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lost connection to MySQL server during query

)) BEGIN SELECT name FROM EnumLiterals WHERE major_frame_desc_id=mfid AND value=fdata INTO fdata_converted; END Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey -- MySQL General

RE: Lost connection to MySQL server during query

PHP or in the procedure? From the procedure it wouldn't do any good right? From PHP it would be after I didn't get the data, so I would have to reconnect and rerun the query. That won't really work for me either. David Godsey David, Are you using persistent connections? Sounds like perhaps

BLOB to UNSIGNED, can you do it?

. David Godsey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: convert help

Thank you. I tried this outside of the procedure and it works. However In MYSQL 5 I get: ERROR 1314 (0A000): PREPARE is not allowed in stored procedures Is there a way without needing to use prepare? Any idea why CAST(fdata AS UNSIGNED) doesn't work? David Godsey Hello. You can use

convert help

selects are added to show what I would like to do, but have not been able to get it to work. Any help would be great. Thanks in advance. Accomplishing the impossible means only that the boss will add it to your regular duties. David Godsey Accomplishing the impossible means only that the boss

Re: [SPAM] - convert help - Bayesian Filter detected spam

| hex(@fdata) | ++-+ | ═∩☺#E | CDEF012345 | ++-+ 1 row in set (0.00 sec) -Original Message- From: David Godsey [mailto:[EMAIL PROTECTED] Sent: Thursday, January 19, 2006 3:33 PM To: mysql@lists.mysql.com Subject: [SPAM] - convert help