Re: DBD::mysql::st execute failed: Out of memory

I am looking at using "mysql_use_result", but the result returned can be a
single row and will still get this error.

Software versions:

DBD-mysql-3.0002
DBI-1.50
MySQL 5.0.17

The query is coming from a CMS(webgui).  The query is ugly and the table
design is even worse for the amount of data that we have in it.  Here is an
example of the query that fails:

$query = "select users.userId, users.username, users.status,
users.dateCreated, users.lastUpdated, email.fieldData as email from users
left join userProfileData email on users.userId=email.userId and
email.fieldName='email' where status like '%'  and (users.username like
'dtenney%' or email.fieldData like 'dtenney%') and users.userId not in
('0')  order by users.username";





On 3/17/06, Dave Howorth <[email protected]> wrote:
>
> Boysenberry Payne wrote:
> > I'm not sure how to help you with this.  If you don't get a reply that's
> > satisfactory
> > try [email protected]
>
> > On Mar 16, 2006, at 4:30 PM, Dustin Tenney wrote:
> > ...
> >> I asked on the forums and got no replies.  Any help would be
> appreciated.
> >> Thank you.
>
> Perhaps you would get more replies if you showed some details? Such as
> the Perl code or the SQL query or the versions of Mysql and DBI etc.
>
> Dave
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/[email protected]
>
>