Re: preprocess data returned from SELECT

2010-08-25 Thread Jon Bennett
> I need the value to be converted as the query returns results to the > model.  I cant convert after the fact > because an association query is run immediately after the initial > query. Hmm - is there a mysql function you can use as a field? If you can, you could use http://nuts-and-bolts-of-ca

Re: preprocess data returned from SELECT

2010-08-25 Thread milimber
I need the value to be converted as the query returns results to the model. I cant convert after the fact because an association query is run immediately after the initial query. On Aug 25, 9:06 am, Jon Bennett wrote: > > I have a column defined as a varbinary() field.  I need to convert the > >

Re: preprocess data returned from SELECT

2010-08-25 Thread Jon Bennett
> I have a column defined as a varbinary() field.  I need to convert the > data returned from the query to hex before its applied to the model. > The resulting data is being used in a second query to pull related > datasets. I have added a column type hex to the db_mysql.php columns > array and eac

preprocess data returned from SELECT

2010-08-25 Thread milimber
I have a column defined as a varbinary() field. I need to convert the data returned from the query to hex before its applied to the model. The resulting data is being used in a second query to pull related datasets. I have added a column type hex to the db_mysql.php columns array and each varbinar