/    Sign up×
Community /Pin to ProfileBookmark

Query works in sqldeveloper but not PHP oci_parse

Copy linkTweet thisAlerts:
Apr 19.2018

Hi,

I have a query that works in SQL Developer but not in PHP/Quercus. It’s the second field is causing the error in the PHP code (the date one) because when I try with the first field (TITLE) only it works fine.

I’m wondering if PHP is not parsing the date calculation correctly? Are there characters I need to escape?

https://pastebin.com/6Dv5dRFm

Thanks!

to post a comment
PHP

1 Comments(s) ↴

Copy linkTweet thisAlerts:
@ginerjmApr 19.2018 — Gonna take two guesses.

1 - the words 'TIME zone' may be confusing as two separate words. I am not up on this syntax but perhaps it should be 'timezone'?

2 - you might also need a space in the string you are building for the 'Numtodsinterval' calculation.

You might also echo out the query you are producing before you prepare it. You may then see what is wrong.

good luck!
×

Success!

Help @RunningDude87 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.16,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...