You shouldn't have to change it to a string. The problem is more than likely
your SQL statement itself.
To insert a string in a database you need to do the following:
$strSQL = "INSERT INTO {TABLE} VALUES('$myVar', '$myothervar')";
Notice the ' marks surrounding the variables, this tells MySQL that you want to
use these as strings. You can also use " if you would like.
--
Scott Carr
OpenOffice.org
Documentation Maintainer
http://documentation.openoffice.org/
Quoting Brian McGarvie <[EMAIL PROTECTED]>:
> you can use the following:
>
> $myVar = (string) $myVar;
>
> Also look up...
>
> http://www.php.net/manual/en/function.settype.php
>
> "R.S. Herhuth" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
> >
> > In order to please MSSQL I have a situation where I must turn a result
> > into string before SQL will accept it. Is there a command I can use to
> > convert a numeric into a string that SQL will accept?
> >
> > RON
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
