Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > PHP Forum

Vote on your favorite hash algorithm here!

PHP Forum Use this forum to discuss all aspects of PHP Development. PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-27-2006, 08:12 AM
NeedHelp NeedHelp is offline
Programming God
 
Join Date: May 2006
Posts: 527
Credits: 0
Rep Power: 12
NeedHelp is on a distinguished road
Default Oracle/PHP Error

I developed a program and it worked fine. Some guys changed the tables I was using a little and now I get this error:

Warning: Ora_Parse failed (ORA-00933: SQL command not properly ended -- while processing OCI function OPARSE) in <filename> on line 106
Oracle code - ORA-00933: SQL command not properly ended -- while processing OCI function OPARSE

Anyone know what this means? Why would a table change cause this error even though I've updated the SQL inside the PHP?
__________________
I Need Help
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 07-27-2006, 10:54 AM
TkTech TkTech is offline
 
Join Date: Jun 2006
Posts: 918
Last Blog:
Having trouble with yo...
Credits: 49
Rep Power: 20
TkTech is on a distinguished road
Send a message via MSN to TkTech
Default

Want to show us the query you have in php and the layout of your table?
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 07-27-2006, 12:11 PM
NeedHelp NeedHelp is offline
Programming God
 
Join Date: May 2006
Posts: 527
Credits: 0
Rep Power: 12
NeedHelp is on a distinguished road
Default

Sure

PHP Code:

$query 
"SELECT SUM(AMOUNT) "
."FROM table_inc_trp "
."WHERE ID_NUMBER='$id[$i]' "
."AND NAME='$account' "
."AND date >= '01-JAN-$tYear' "
."AND ACCOUNTING_DATE LIKE '$_mnt[$m]'"
__________________
I Need Help
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 07-30-2006, 10:21 AM
Lop's Avatar   
Lop Lop is offline
Speaks fluent binary
 
Join Date: May 2006
Posts: 1,149
Credits: 112
Rep Power: 16
Lop will become famous soon enough
Default

I bet one of the fields you have there has a character that needs to be escaped and it is causing your query to end.
__________________
Lop
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Php error handling Jaan PHP Tutorials 3 09-07-2008 12:19 PM
VB6.0:Tutorial, Error handling TcM VB Tutorials 9 06-06-2008 01:31 PM
Download problem, internal Server Error j3cubcapt ionFiles 1 07-02-2007 09:45 AM
Php - CGI Error thesquirrel16 General Programming 1 05-19-2007 05:09 PM
can someone help me with my c librarys? bobwrit C and C++ 4 04-27-2007 06:19 PM


All times are GMT -5. The time now is 10:25 PM.

Contest Stats

Xav ........ 1357.94
MeTh0Dz|Reb0rn ........ 1077.71
WingedPanther ........ 919.18
marwex89 ........ 906.86
morefood2001 ........ 900.18
John ........ 890.77
Brandon W ........ 770.65
chili5 ........ 312.39
Steve.L ........ 264.99
dcs ........ 232.34

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 83%

Ads