|
From: D S. <dsi...@sq...> - 2000-12-19 00:35:38
|
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
>
>
|