Re: Strange error when doing insert into DB

On Tue, Feb 21, 2006 at 10:17:44AM +0530, Hemlata Lalwani wrote:
Hi,
Which code do you want?Like the error says abt this path..

/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Oracle.pm
So shall i give you the code of this?If not which code we want
..please tell me..

Can't mix placeholder styles (:foo/:1) at

Well you can't, I would need to see the $statemnet in order to help.

It's the SQL statement you are passing to prepare() that has the problem,
not a perl statement. Please post the SQL statement.

Tim.
.

Relevant Pages

  • Re: Combo Box Row Source Code
    ... The first thing I noticed about your SQL statement is that you have quotes ... If you are passing a new RowSource to a second combo box using VBA, ... "BillyS" wrote in message ...
    (microsoft.public.access.formscoding)
  • Re: Parameters
    ... The example in this link shows how to build a SQL statement by passing in: ... "Luis" wrote in message ... > I use a recordset to do this action. ...
    (microsoft.public.access.formscoding)
  • Re: pass-through-queries
    ... Ezekiël wrote: ... > Hello Douglas, ... How about passing the variable to a stored ... You create the SQL statement that would constitute a ...
    (microsoft.public.access.modulesdaovba)
  • Re: Regex Help on SQL Parse
    ... Passing the complete SQL statement is the difference. ... you will see an empty match for each letter before the ... letter after the where clause. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Response.write strsql does not yield desired sql statement
    ... > I am trying to check for the final sql statement before passing it to a ... > database. ... I want to build the statement using user input in three text ... the sql statement does not give me the right statement. ...
    (microsoft.public.inetserver.asp.general)