Re: [PHP] FATAL: emalloc() error

2001-01-11 Thread Justin Smith 

I'm passing odbe_exec() an ODBC connection ID (returned from odbc_connect())
and a SQL command that pulls several fields from a query in an Access
database.

Playing with it, I've determined that removing certain fields from my SQL
command (not SELECT'ing them) will allow it to work.  These fields are
composed of other fields, joined together in the Access query
(e.g. [Location] & [Sublocation]).

I tried doing the join directly in my PHP SQL command ("SELECT [Location] &
[Sublocation] AS Local FROM [Test Query] "), but this fails with:

SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 2., SQL state 07001 in SQLExecDirect in...

I'm not sure what the problem is here.  Does the ODBC Access driver not
support "AS" or is the syntax differet?  Any tips on how to get it to join
these fields that will work, either in Access or my SQL SELECT command?

Justin

On Thu, 11 Jan 2001, Richard Lynch wrote:

> What arguments are you passing to odbc_exec()?
>
> - Original Message -
> From: Justin Smith <[EMAIL PROTECTED]>
> Newsgroups: php.general
> Sent: Tuesday, January 09, 2001 1:07 PM
> Subject: [PHP] FATAL: emalloc() error
>
>
> > I'm trying to query an MS Access database via ODBC, but the odbc_exec
> > command fails with this error:
> >
> > FATAL:  emalloc():  Unable to allocate 2147483599 bytes
> >
> > I don't know why it could possibly be trying to allocate 2GB, as the
> > database is only about 4MB.  Any suggestions would be appreciated.

Justin Smith
New Mexico Natural Heritage Program
University of New Mexico
Department of Biology
167 Castetter Hall
Albuquerque, New Mexico 87131
505-277-3822 x226
505-277-3844 (fax)
[EMAIL PROTECTED]




-- 
PHP General 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] String parsing problem

2001-03-15 Thread Justin Smith 

Hello, PHP-type folks.

I'm attempting to parse up search parameters from a user-inputted form into
something I can build a query with.  For example, given the string
"\"grizzly bear\" or tiger and carnivorous mammal", I'd like to split it
into an array like this:

array[0] = array("'grizzly bear'", "badger")
array[1] = "mammal"
array[2] = "carnivorous"

so that ANDed values (explicitely with "and" keyword or implicitely with
whitespace) are separate entries in the main array, with ORed values
together in sub-arrays, preserving double-quoted phrases without ANDing them
and replacing the double-quotes with single quotes.

Quite a mess, I know, and I'm getting knowwhere with my limited regular
expression experience.  Splitting up AND and OR blocks is easy enough with
simple strings "owl and screech or pygmy" but this preservation of quoted
phrases is killing me.  Any help would be appreciated.

Thanks,


Justin Smith
New Mexico Natural Heritage Program
University of New Mexico
Department of Biology
167 Castetter Hall
Albuquerque, New Mexico 87131
505-277-3822 x226
505-277-3844 (fax)
[EMAIL PROTECTED]


-- 
PHP General 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]