> From: Martin Hesse [mailto:[EMAIL PROTECTED]]
> 
> When I prepare an INSERT-Statement that contains :0 in it 
> (e.g. INSERT 
> INTO MYTABLE (FOO LONG) VALUES ('xxx:0') ) I get an error that says 
> Placeholder :0 invalid, Placeholder must be >= 1. I tried to prefix 
> every :<decimal> with '\' and this doesn't seem to work 
> either because I 
> get the same error message as without the '\'.

Did you try:
$dbh->prepare("INSERT INTO MYTABLE (FOO LONG) VALUES (?)");
$dbh->execute("xxx:0");

HTH,
Douglas Wilson

Reply via email to