| Hey Guys,
So I took over as web manager for a company. And I have a problem with a web objects site. I understand the problem but have no idea how to fix it. I also dont have any of the original xcode files.
So here are my questions: Is there a way to reconstruct a project from the files that are on the web server?
Does anyone know how to fix this problem? ================================================ com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:42000 -- error code: 0 -- msg: SQL ERROR - [position 525, near 'E' in ', -4.85208E+8, 'dj Dan')'] insert error: comma expected but not found in data. SQL: INSERT INTO NoRiskSubscriber(notes, zipCode, newsletterFid, customerName, formatFid, reference, state, country, suscribeDate, title, source, alert, fax, entityId, orgTypeFid, endDate, city, keyCode, phone, address, receivedWelcomeEmail, email, birthday, company) VALUES (NULL, '07719', 7, 'Daniel John Brateris', 2, NULL, 'NJ', 'United States', 197782355.515, 'Mr.', 'Health Resources Publishing', NULL, '908-692-7166', 1043, 1, NULL, 'South Belmar', NULL, '908-692-7166', '313 19th Ave.', 'no', 'email@hidden', -4.85208E+8, 'dj Dan') ================================================
-to me it seems that there should be ' ' around the -4.85208E+8 in the insert statement. -I tried making this change and executing the statement from an SQL terminal and it worked. so how do I get the EOAdapter to put ' ' around that value and why is it not doing it in the first place. -I also believe that -4.85208E+8 is not the correct value even if the ' ' were around it
I should also point out that this application was working and all of a sudden stopped, apparently for no reason
Any help would be greatly appreciated,
Thanks, Dan |