Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trouble with inserting a string containing a single quote

404759Sep 24 2003 — edited Oct 8 2003
Using php with Oracle

If I do the following two lines before sending my $Query string through the parse function

$name = "Dominick's";
$Query = "INSERT INTO customers (name) values ('$name')";

it gives me the following error:

Warning: Ora_Parse failed (ORA-00917: missing comma -- while processing OCI function OPARSE)

If I try and force the single quote to be surrounded by double quotes and therefore not be confused:

$name = "Dominick's";
Query = "INSERT INTO customers (name) values (\"$name\")";

Trying that yields the following error:

Warning: Ora_Parse failed (ORA-01741: illegal zero-length identifier -- while processing OCI function OPARSE)

Help

Jeff

Comments

MiPa
Answer
Have you tried it this way? 
scene.getStylesheets().add(FXMLSample1.class.getResource("/layouttests/fxml/sample1/FXMLSample1RootPane.css").toExternalForm());
Marked as Answer by 661933 · Sep 27 2020
661933
Nope, hadn't tried that. Worked like a charm! Thank you very much!
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 5 2003
Added on Sep 24 2003
#php
6 comments
1,860 views