Hi everyone and happy neww year!
I have come across a very strange problem where I am trying to select
from an sqlite table with
db.babel.definition.upper().like("'%"+me.word.upper()+"%'") ) which
yields nothing.
The same happens if I try using sqlite's upper function
db.babel.definition.upper
Hi
Thanks for the quick reply. I was rather surprised to read on the
supplied link, I always assumed that sqlite would handle utf-8 upper /
lower case. What version is the sqlite bundled with web2py 1.54
windows?
Cheers
Petros Diveris
On Jan 2, 1:27 pm, mdipierro wrote:
> This
>
thon 2.5.
>
> Massimo
>
> On Jan 2, 9:35 am, Petros Diveris wrote:
>
> > Hi
>
> > Thanks for the quick reply. I was rather surprised to read on the
> > supplied link, I always assumed that sqlite would handle utf-8 upper /
> > lower case. What version
gt;
> On Jan 9, 7:36 am, Petros Diveris wrote:
>
> > Ok,
>
> > It seems that the version of sqlite shipped with Python versions 2.5
> > to 3.0 for Windows has been compiled in a way as to not include what
> > the sqlite guys call the ICU extension. The ICU is a litt
Hi,
Following my previous posts with regards to upper and lower case
problems I had with the sqlite3 version included in the python 2.5
(and therefore web2py) distribution, and my promise to resove this,
I'd like to announce that I have finally managed to compile
sqlite3.dll and the necessary ICU
e:
> This is great, thank you. Could you comment on licensing issues?
>
> Massimo
>
> On Jan 13, 1:31 pm, Petros Diveris wrote:
>
> > Hi,
>
> > Following my previous posts with regards to upper and lower case
> > problems I had with the sqlite3 version includ
Hi
First, I have observed that orderby.something doesn't seem to work in
itemize. No matter if I set it to mytable.id or mytable.word, I am
getting the same. The version of web2py I am using is 1.55.2, but I am
not sure as to which version of T2 I am using...
Second, if I wanted to order by in a
problem.
>
> you can do
>
> select(orderby=db.table.field.upper())
>
> On Jan 14, 2:14 am, Petros Diveris wrote:
>
> > Hi
>
> > First, I have observed that orderby.something doesn't seem to work in
> > itemize. No matter if I set it to mytable.id or
Hi,
While I am open to looking at ways of removing the MSVCR90.DLL (and
also recompiling using sqlite 3.6.9), I **suspect** at the same time
that more people are interested in multi-lingual support than
performance? What I mean is, if people really want performance then, I
would imagine, they wou
Hi,
I have done in the not so far past. What is it that you are after?
Petros
On Jan 14, 11:13 am, David Marko wrote:
> Hello,
> is there anyone using web2py with FirebirdSQL database? My question
> leads to some internationalisation issues, correct collations etc.
>
> David
--~--~-~--
s, so ordering the select
> statements doesnt work properly later.
>
> David
>
> On 14 Led, 12:41, Petros Diveris wrote:
>
> > Hi,
>
> > I have done in the not so far past. What is it that you are after?
>
> > Petros
>
> > On Jan 14, 11:13 am, David Marko
(ordering) working properly one have to specify
> > 'COLLATE' clause, when creating tables manualy.
> > e.g. NAME VARCHAR(100) CHARACTER SET UTF8 COLLATE UNICODE);
>
> > But its not how web2py generates tables, so ordering the select
> > statements doesnt work properly
ng SQL
>
> > SET NAMES UTF8;
>
> > it is no longer necessary to specify a collate for every column. Is
> > this wrong?
> > On your system this produces an error. Why is that? Can you issue the
> > statement to firebird manually outside web2py?
>
> > Massi
> > > On your system this produces an error. Why is that? Can you issue the
> > > statement tofirebirdmanually outside web2py?
>
> > > Massimo
>
> > > On Jan 14, 7:06 am, Petros Diveris wrote:
>
> > > > I am not sure as to why you are getting this. Btw,
Hi,
Can you paste in a message the relevant lines from your httpd.conf?
Also, what is the location of your web2py installation?
Finally, what version of Apache?
Cheers
On Jan 21, 10:35 am, voltron wrote:
> Hi Massimo!
>
> thanks for your help. Sadly, that did not work either , another idea?
>
Vut why not use the tracker of this very site? I mean, code.google.com
does provide issue tracking linked with the SVN
On Feb 25, 2:51 pm, Paul Eden wrote:
> +1 on a centralized place for documentation.
>
> I'm undecided on if we should use trac or web2py for this though.
> - Trac is a great
16 matches
Mail list logo
