Re: ORA-00928: missing SELECT keyword

if you can change the "date" column to have a different name
it looks like you could be in for a whole world of pain if you keep with
this.



Regards
Chris Farmer



                                                                                                                                       
                      "Robert                                                                                                          
                      Rainville"               To:       "Oracle" <[email protected]>                                                
                      <rrainville@geoco        cc:                                                                                     
                      mtms.com>                Subject:  [oracle] Re: ORA-00928: missing SELECT keyword                                
                                                                                                                                       
                      20/02/2003 13:10                                                                                                 
                      Please respond to                                                                                                
                      "Oracle"                                                                                                         
                                                                                                                                       
                                                                                                                                       




Put flasher (date) in CAPS ie.  Flasher("DATE")
Unless you created the column with double quotes and in lowercase
The default case for all column names is UPPERCASE unless created with
double quotes

-----Original Message-----
From: Tom Skillman [mailto:[email protected]]
Sent: Tuesday, February 18, 2003 11:28 AM
To: Oracle
Subject: [oracle] Re: ORA-00928: missing SELECT keyword

Ok fixed that problem, I have one more though.  Everything works fine,
but if I use my PHP script to insert values into the database, I get the
following error:

ORA-01009: missing mandatory parameter -- while processing OCI function
OPARSE


I am using the exact same query between SQL Plus and my PHP script, so
I'm suspecting something with the PHP, but if you have any ideas, help
would be greatly appreciated.


                                                             Tom



[email protected] wrote:
>
> youre going to have to put flasher(date) in double quotes
> like this
>
>       insert into flasher("date") values ( '12-dec-20')
>
> Regards
> Chris Farmer
>
>

---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.






---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].