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'

Re: Is there anyway to return an array?

ut a comma at the end of format for CSV format */ for(int i=0;i David Godsey wrote: > >>> >>> I know, I know, sounds like something that should be done in the >>> presentation layer, howerver if possible, I would like to provide >>> common >>>

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 >&g

Is there anyway to return an array?

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]

Re: UDF help, convert BLOB to BIGINT

hanks. 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: >> >>

UDF help, convert BLOB to BIGINT

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 Swaping (Re Post)

ks for any help. 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

alas 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 >>

Byte Swapping

be appreciated. 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: 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 >

RE: Lost connection to MySQL server during query

atus" from 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 usi

Lost connection to MySQL server during query

nd_of,"INTO @fdata_converted"); PREPARE st1 FROM @string_query; EXECUTE st1; DEALLOCATE PREPARE st1; SELECT @fdata_converted INTO fdata_converted; END $$ CREATE PROCEDURE enumConv(IN fdata INT UNSIGNED,m

Error 2016 and 2013

INTO fdata_converted; END Are there some error cases I'm failing to catch and that is the cause of the apparent database connection loss? BTW: these are the first procedures I've writting so I'm a novice with stored procedures. 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: 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. > > Yo

BLOB to UNSIGNED, can you do it?

r 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: [SPAM] - convert help - Bayesian Filter detected spam

t; mysql> call test20(); >> Query OK, 0 rows affected (0.00 sec) >> >> mysql> >> mysql> select @fdata, hex(@fdata) >> -> >> -> ; >> ++-+ >> | @fdata | hex(@fdata) | >> ++-+ >> | ═∩☺

convert help

END The last two 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 mea