Re: HELP insert still dosn't work

thx very much oracle statments don't need " but ' and it did exaktly what it should At 01:30 20.03.2001 +0100, you wrote:

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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net