What the heck?
I've got a very simple form with a simple radio button:
<input name="safety_required" type="radio" value="Yes"> Yes
<input name="safety_required" type="radio" value="No" checked> No
Typical Insert code (SQL Server) on the form that I've used 1000 times
before and I know it's correct. The "Yes/No" is going into a "char(3)"
field.
<cfquery datasource="myDATE" username="myUSER" password="myPASS">
INSERT INTO dbo.myTABLE
(safety_required)
VALUES
('#FORM.safety_required#')
</cfquery>
(Simplified Version)
Works as expected locally and inserts in the database (RDS) just fine.
No problems.
Put it out on the server, and I get:
"Form Entries Incomplete or Invalid
One or more problems exist with the data you have entered.
* Yes"
This is a shared server, so that's all I'm going to get for error codes.
Since it's working perfectly locally I've got no freaking idea.
What the hell could cause this? I'm not 100% sure what version of
Coldfusion they're using, but the code being used should work on anything.
Now, maybe I've been awake too long with no coffee refills, but, uhh,
huh? I'm not *that* stupid - I don't think...
--
-----------
Les Mizzell
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206595
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
