anewt-developers team mailing list archive
-
anewt-developers team
-
Mailing list archive
-
Message #00160
[Bug 502916] [NEW] AutoRecord crash when handling values like "boo ?bah? baa"
Public bug reported:
In anewt.cxs AutoRecord tries to take over the role of SqlTemplate and
fill column names and data values itself. Unfortunately the underlying
database layer doesn't handle this case, it requires proper
prepare()/execute() sequences.
AutoRecord currently can't handle any datavalue containing the string
?foo?. It feeds ?foo? to prepare() which tries to interpret foo as an
SQL data type.
I have created a simple (but IMHO wrong) patch which solves the problem
by creating an extra parameter to prepare() which disables all
preprocessing enabling you to execute raw queries through the database
layer.
A better fix would be to rewrite AutoRecord to build proper sql
templates which can be parsed by prepare().
** Affects: anewt
Importance: Critical
Status: New
** Tags: autorecord
--
AutoRecord crash when handling values like "boo ?bah? baa"
https://bugs.launchpad.net/bugs/502916
You received this bug notification because you are a member of Anewt
developers, which is subscribed to Anewt.
Follow ups
-
[Bug 502916] Re: AutoRecord incorrectly tries to escape values containing SQL template placeholders
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord incorrectly tries to escape values containing SQL template placeholders
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord incorrectly tries to escape values containing SQL template placeholders
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Wouter Bolsterlee (uws), 2010-01-05
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Sander van Schouwenburg (Sandworm), 2010-01-04
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Erik Hensema, 2010-01-04
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Erik Hensema, 2010-01-04
-
[Bug 502916] Re: AutoRecord crash when handling values like "boo ?bah? baa"
From: Erik Hensema, 2010-01-04
-
[Bug 502916] [NEW] AutoRecord crash when handling values like "boo ?bah? baa"
From: Erik Hensema, 2010-01-04
References