Skip Menu |

This queue is for tickets about the DBD-ASAny CPAN distribution.

Report information
The Basics
Id: 5067
Status: new
Worked: 5 min
Priority: 0/
Queue: DBD-ASAny
People
Owner: Nobody in particular
Requestors: paulg [...] singlestep.com
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Tue Jan 27 19:46:48 2004 Guest - Ticket created
Subject: placeholder parsing assumes single-quote field delims
DBD::ASAny 1.13 ActivePerl 5.8.1 (build 807) WinXP Pro, SP1 SQL Anywhere 9.0 (EBF 1252) For our current use, we need to delimit field values using double-quotes, not single-quotes, so I have set the Quoted_identifier database option to "Off". Now when preparsing my insert statements, I receive the error "Cannot handle unordered ':numeric' placeholders" when certain text fields contain time values. Minimal database and statement to reproduce: create database egbug ( egtext varchar(50) not null ) insert into egbug ( egtext ) values ( "2004-01-27 14:35:22 - log this" ) I have locally modified dbdimp.sqc line 350 from if( *src == '\'' ) { to if( *src == '\'' || *src == '\"' ) { in order to get up and running, but I doubt it's a good general solution; I just happen to know that we don't plan to use placeholders in this product. Thanks, Paul Goracke
  Thu Jan 29 16:25:46 2004 smirnios [...] sybase.com - Correspondence added 5 min
You're right. I think that parsing code even predates the Quoted_identifier option's existence. I have made a change to dbdimp.sqc that I will include in DBD::ASAny 1.14. Let me know if you have any problems with it. Thanks, -john. [guest - Tue Jan 27 19:46:48 2004]: Show quoted text
> DBD::ASAny 1.13 > ActivePerl 5.8.1 (build 807) > WinXP Pro, SP1 > SQL Anywhere 9.0 (EBF 1252) > > For our current use, we need to delimit field values using double- > quotes, not single-quotes, so I have set the Quoted_identifier > database option to "Off". Now when preparsing my insert
statements, Show quoted text
> I receive the error "Cannot handle unordered ':numeric' > placeholders" when certain text fields contain time values. > > Minimal database and statement to reproduce: > > create database egbug ( egtext varchar(50) not null ) > > insert into egbug ( egtext ) values ( "2004-01-27 14:35:22 - log > this" ) > > I have locally modified dbdimp.sqc line 350 from > > if( *src == '\'' ) { > > to > > if( *src == '\'' || *src == '\"' ) { > > in order to get up and running, but I doubt it's a good general > solution; I just happen to know that we don't plan to use > placeholders in this product. > > Thanks, > Paul Goracke

Message body is not shown because it is too large.