[eluser]Unknown[/eluser]
Hi guys! Here I am again, I'm really going fond of codeigniter, and I hope you can help me again with this. I'm learning through your community, and Im very thankful to all of you.
So here's it. In my form, I have the deployment date field, which gets its value through a date picker beside it. I know it gets the value (for example, '12-31-2011') because it gives me this error:
Quote:A Database Error Occurred
Error Number:
Error Message:
SQL Message: INSERT INTO "PPLUS_PROJECTS" ("REFNO", "NAME", "DEPLOYMENT_DATE", "DESCRIPTION", "OWNER", "STATUS", "DEV_TYPE", "BUSINESS", "PROMO_FLAG", "PRIORITY", "PROJ_TYPE", "SYSTEM", "INVOLVEMENT", "REMARKS", "CREATED_BY") VALUES ('001', 'name', '12-31-2011', 'desc', 'ndsadona', '1', 'adhoc', 'comm', '1', '1', 'main', 'sys', 'inv', 'rem', 'ndsadona')
Filename: C:\wamp\www\projectplus\system\database\DB_driver.php
Line Number: 331
When I try to copy the sql message to an sql editor in TOAD, it gives me this error:
Quote:ORA-01843: not a valid month
In the sql editor, included this in line with the date value: ...TO_DATE('12-31-2011', 'MM-DD-YYYY')... and it worked. I just wonder how will I include that TO_DATE in my controller. :|
Any help or advice will be appreciated.
