On Tue, 20 Mar 2001, David Robley wrote:
> On Tue, 20 Mar 2001 03:32, Rudolf Frint wrote:
>
> > > I want to insert the Values into my Database like this
> >
> > $handle = ora_logon("iusr@test","kiwi1");
> > $cursor1 = ora_open($handle);
> > $query = "insert into internet_tmp select
> > rv_ret($FF),$FF,$sesid,(sysdate+0.0021) from dual";
> > ora_parse($cursor1,$query) or die;
> > ora_exec($cursor1);
> > ora_close($cursor1);
> >
> > tring the insert query on sql-plus works fine what do I do wrong??
> >
> > oh yea error msg is like this
> > Warning: Ora_Parse failed (ORA-00923: FROM keyword not found where
> > expected -- while processing OCI function OPARSE) in test2.php on line
> > 40
> >
> > line40 is parse line
> >
> > plaese help is very urgent
> > rudi
>
> I'm not an Oracle person, but it sounds like you may have a syntax error
> in your SQL. Try echo-ing $query and see how it looks.
>
> --
> David Robley | WEBMASTER & Mail List Admin
> RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
> AusEinet | http://auseinet.flinders.edu.au/
> Flinders University, ADELAIDE, SOUTH AUSTRALIA
>
I've had a few troubles with PHP/MySQL with requests like that... Maybe
you could try that (it worked for me) :
$query = "insert into internet_tmp select
rv_ret(\"$FF\"),\"$FF\",$sesid,(sysdate+0.0021) from dual";
the \"$var\" are important : ".$var." won't do, even if with an echo
$query, you _seem_ to get the same results...
--
Ben
As well look for a needle in a bottle of hay.
Miguel de Cervantes
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
