Re: [SQL-Ledger-users] MySQL and SQL Ledger

[D S. <dsi...@sq...>]

The only other items I am aware of which differ is a case insensitive
substring search in the form of 
"SELECT * FROM parts WHERE description ~* '$form->{description}'"

This can be fixed with
$substr = lc $form->{description};
SELECT * FROM parts WHERE lower(description) LIKE '%$substr%'

affected modules include:
ap, ar, ct, gl, ic, is

and missing (as) table identifiers.
such as
  $query = qq|SELECT ap.id, ap.invnumber, ap.transdate, ap.duedate,
              ap.amount, ap.paid, ap.ordnumber, vendor.name, ap.invoice
              FROM ap,vendor
              WHERE ap.vendor = vendor.id|;


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 18 Dec 2000, Sean Roe wrote:

> Hello all,
> 
> We just installed SQL-ledger in a MySQL enviroment, I read all the caveats so I am aware of the potential 
> problems with this setup.  I was wondering if anybody else has attempted this before and if so do they have any 
> insights into any modifications or tweeks to make it run, we are still in the debug mode right now.  We will 
> eventually be setting up transactions on MySQL (After the holidays)  but I wanted to get this up and running.
> 
> Again any insights into the MySQL conversion would be great.
> 
> Thanks,
> 
> Sean Roe
> 
>