convert int field to a string

[shaffer]

can anyone tell me how to convert a int field into a string ... i've
had a look at the mysql site but unable to look for the right function
.... thank you ..

[Chris Hope]

shaffer wrote:

can anyone tell me how to convert a int field into a string ... i've
had a look at the mysql site but unable to look for the right function

Are you wanting to change the column type in the table structure to a
string, or are you wanting to cast the data from the resultset into a
string?

Also, what language are you using to get the data, as you may want to cast
the data in the language code instead. In PHP, for example, you can cast a
variable as a type in the script eg

$foo = 1;
$bar = (string)$foo;

In this example $bar is an explicitly cast string version of $foo

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/

[Chris Hope]

shaffer wrote:

can anyone tell me how to convert a int field into a string ... i've
had a look at the mysql site but unable to look for the right function

Are you wanting to change the column type in the table structure to a
string, or are you wanting to cast the data from the resultset into a
string?

Also, what language are you using to get the data, as you may want to cast
the data in the language code instead. In PHP, for example, you can cast a
variable as a type in the script eg

$foo = 1;
$bar = (string)$foo;

In this example $bar is an explicitly cast string version of $foo

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/

[shaffer]

I'm wanting to cast the data from the resultset into a
string.

I'm using coldfusion mx 6

#On Sun, 04 Apr 2004 22:46:51 +1200, Chris Hope
<bl*******@electrictoolbox.com> wrote:

[shaffer]

I'm wanting to cast the data from the resultset into a
string.

I'm using coldfusion mx 6

#On Sun, 04 Apr 2004 22:46:51 +1200, Chris Hope
<bl*******@electrictoolbox.com> wrote:

[Chris Hope]

shaffer wrote:

I'm wanting to cast the data from the resultset into a
string.

I'm using coldfusion mx 6

I quickly searched the MySQL manual using Google and found this:

http://www.mysql.com/doc/en/Cast_Functions.html

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/

[Chris Hope]

shaffer wrote:

I'm wanting to cast the data from the resultset into a
string.

I'm using coldfusion mx 6

I quickly searched the MySQL manual using Google and found this:

http://www.mysql.com/doc/en/Cast_Functions.html

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/