Anand, It works now. I’m using just text editor (KrViewer) for csv modification.
On Monday, March 26, 2012 9:05:22 PM UTC+4, Anand Doshi wrote:
Hi Anton,
I have made the sql syntax changes. Can you try again.
Quick question, are you using openoffice or libreoffice for saving the .csv file?
-Anand.
On Mon, Mar 26, 2012 at 10:17 PM, Anand Doshi <an…@iwebnotes.com> wrote: > Hi Anton, > > I think the issue is caused when using sql(“… ‘%s’ …” % > (something)) instead of sql(“… %s …”, (something)) > > Try changing the syntax here and let me know. I will also look into it. > > Thanks, > Anand. >
–
You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
there are still many those ‘%s’ things in other parts of project which can potentially lead to similar problem with variety of languages with non ascii symbols (russian, french etc). Ain’t be good to unify all queries and escape from apostrophes? Why apostrophes has been used at all if they must be added by mysqldb at runtime?
On Monday, March 26, 2012 10:20:37 PM UTC+4, Anand Doshi wrote:
Hi Anton,
Good to hear that its working now. Thanks for reporting the issues.
Cheers, Anand.
> Anand, > It works now. I’m using just text editor (KrViewer) for csv modification. > > > On Monday, March 26, 2012 9:05:22 PM UTC+4, Anand Doshi wrote: >> >> Hi Anton, >> >> I have made the sql syntax changes. Can you try again. >> >> Quick question, are you using openoffice or libreoffice for saving the >> .csv file? >> >> -Anand. >> > Hi Anton, >> > >> > I think the issue is caused when using sql(“… ‘%s’ …” % >> > (something)) instead of sql(“… %s …”, (something)) >> > >> > Try changing the syntax here and let me know. I will also look into it. >> > >> > Thanks, >> > Anand. >> > >> > –
–
You received this message because you are subscribed to the Google Groups “ERPNext Technical Forum” group.
I will be working on replacing such queries wherever it is possible to
do so. Should be done by end of this week.
Such queries are part of legacy code and they have remained till now
because they had never caused any issue till now. So, in the light of
these bugs, its time to change the syntax.
Thanks,
Anand.
On Tue, Mar 27, 2012 at 3:00 PM, AntonK an...@gmail.com wrote:
Anand,
there are still many those ‘%s’ things in other parts of project which can
potentially lead to similar problem with variety of languages with non ascii
symbols (russian, french etc). Ain’t be good to unify all queries and escape
from apostrophes? Why apostrophes has been used at all if they must be added
by mysqldb at runtime?
On Monday, March 26, 2012 10:20:37 PM UTC+4, Anand Doshi wrote:
Hi Anton,
Good to hear that its working now. Thanks for reporting the issues.
Cheers,
Anand.
Anand,
It works now. I’m using just text editor (KrViewer) for csv
modification.
On Monday, March 26, 2012 9:05:22 PM UTC+4, Anand Doshi wrote:
Hi Anton,
I have made the sql syntax changes. Can you try again.
Quick question, are you using openoffice or libreoffice for saving the
.csv file?
-Anand.
Hi Anton,
I think the issue is caused when using sql(“… ‘%s’ …” %
(something)) instead of sql(“… %s …”, (something))
Try changing the syntax here and let me know. I will also look into
it.