Re: ORA-00928: missing SELECT keyword

Thanks for the replies, I noticed on Friday that I was using date as the
name of my field.  I had looked for everything, but this escaped me.  I
wouldn't normally use date as my field name, but I'm converting an old
Paradox table, and just used the same fieldnames!



==============================
Tom Skillman
Programmer/Analyst I
City of St. Louis Water Division

[email protected]
(314) 771-4806  ext 184




[email protected] wrote:
> 
> 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.unsub%%.

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