CFUPDATE and CFINSERT have historically been less than stellar
performers....
If you pass the fields in the wrong order it will crap out (and the error is
vague). The vagueness is my big beef...it's supposed to be more of a set of
tags for beginners....but the error messages are worse than the usua; SQL
errors...so it makes being a beginner frustrating. There are other issues
as well...so I tell my students to avoid at all costs ;-)
<cfquery name="MyQuery" datasource="MyDataSourceName">
INSERT INTO MyTable
(
Name
)
VALUES
(
<cfqueryparam value="#MyNameVariable#"
cfsqltype="cf_sql_varchar" maxlength="maxLengthofField">
)
</cfquery>
There ya go...SQL 101...simple insert with cfqueryparam ;-)
If you want o add multiple fields just put a comma after each field name and
field value (except the last pair of course).
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:192687
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
