Databases :: General :: updating a oracle database table from cgi code written in c++; |
|||
By: FiatLink  |
Date: 20/09/2003 00:00:00  |
Points: 20 | Status: Answered Quality : Excellent |
|
Hi i have a strange problem. i am trying to update a table from cgi code. when i am saying update table set clumn name = 1 where ....blah blah , it's working but when i ma saying updtae table set column name = a where .. blah blah this a is a variable which has the value 1, this is not working it's giving me ora00911 error , i have checked the error but it's not making me any sense. Need help urgently thanks |
|||
| By: VGR | Date: 20/09/2003 04:48:00 | |
Type : Answer |
| use @a for a SQL user-defined variable use your database layer (front-end language's) specific syntax for passing one of its variables "a" to the SQL statement and don't forget the single quotes around casual string litterals |
|||
| By: noriegaa | Date: 03/06/2007 23:02:54 | |
Type : Comment |
| yOU may need to cover the character to numeric. It looks like a datatype issue. Use TO_CHAR or TO_NUMBER to match the column datatype. | |||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
