Oracle database gives an missing comma message while saving file

[StephanieRice]

I am having oracle database when I save that file it gives me error message saying that "missing comma" and hence I would like to know if there is a way to rectify the error that pops up when we insert values into a particular table from v to oracle.

[machok]

One way would be to populate an empty recordset

String unitName="select UNITNAME from UNITMASTER WHERE UNITID=7"; //returns--> No's

then i want like this

"SELECT * FROM Table_1 WHERE FirstName &H3D'foo'"

[BlackSunReyes]

This issue is not in numbers, it is the actual Insert statement that does not separate the values by commas... or you may also use the SQL statement such as follows:

SQLInsrtBk = "INSERT INTO tbtext (" &_"tbtext_id, tbtext_publisher_txt, tbtext_author_txt, tbtext_title_txt,
" &_"tbtext_edition_num")

The text field would be as you may have in your table. or use the following query format.

Insert into ADM_LOCAL (AML_NO_ADM_LOC,PKAML) values (100 1000) ;

[Pauline]

If it runs fine in Toad, but not in ASP, try outputting the query string to the web page to be sure it is what you think it is.

VALUES ($exptid, ?, NULL, ?, NULL, NULL, NULL, ?, NULL, NULL, ?, ?, NULL, NULL, NULL, ?)");

$sth1 ->execute($spot, $CH1_TOTAL, $CH2_TOTAL, $SNR1, $SNR2, $NORMALIZE);

I have had issues in the past with PHP not executing my 'perfect' query, only to find out that I had somehow formatted it wrong for PHP's liking.