Hi Denis,
try this one:
$r=odbc_exec($x,"select 'a' as a_leter from some_table");
or
$r=odbc_exec($x,"select \"a\" as a_leter from some_table");
which you prefer, but you have to escape the "" within a ""-String !!
Hope this solves your problem.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: Denis Eltsov [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 8:00 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] FATAL: emalloc(): Unable to allocate
> 2147483599 bytes
>
>
> I use IIS5 - php4 (as CGI) - odbc connection to Access 2000
>
> Everything was fine until I install MS SQL 2000 to the same machine.
>
> After this I receive such a message
>
>
>
> FATAL: emalloc(): Unable to allocate 2147483599 bytes
>
>
>
> every time I try to execute such a program
>
> <?
>
> $x=odbc_connect("oh","","");
>
> $r=odbc_exec($x,"select "a" as a_leter from some_table");
>
> ?>
>
> or
>
> <?
>
> $x=odbc_connect("oh","","");
>
> $r=odbc_exec($x,"select format("dd.mm.yyyy",date_field) from
> some_table");
>
> ?>
>
>
>
> Best regards Denis Eltsov
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]