Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: insert on oracle db question

Re: insert on oracle db question

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 15 Mar 2006 09:11:45 +1100
Message-ID: <MPG.1e81eaacf07a65e498978d@news.readfreenews.net>


stephane.vollet_at_bluewin.ch says...

> $query="insert into vegetables (name) values ($veg)";

Try adding simple quote delimiters around strings.

$query="insert into vegetables (name) values ('$veg')"; or for readability
$query="insert into vegetables (name) values ('".$veg."')";

Also try redesigning your code to use bind variables.

GM Received on Tue Mar 14 2006 - 16:11:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US