Oops! Sorry -- typo... that should be value="..." instead of
name="..."
> <cfparam name="form.categoryid" type="string" default="">
> <cfloop index="x" list="#form.categoryid#">
> <cfset altcatname = form["altcategoryname_#x#"]>
> <cfquery name="InsertForms" datasource="PhysicianForms">
> insert into tFormCategory
> (formid,categoryid,altcategoryname)
> values ('#session.formid#','#x#', <cfqueryparam
> name="#altcatname#"
> null="#yesnoformat(not altcatmodified)#">)
> </cfquery>
> </cfloop>
> This reurns errors below:
> Attribute validation error for tag CFQUERYPARAM.
> The tag does not allow the attribute(s) NAME. The valid
> attribute(s)
> are CFSQLTYPE,LIST,MAXLENGTH,NULL,SCALE,SEPARATOR,VALUE.
> The Error Occurred in
> D:\Inetpub\wwwroot\PhysiciansOrdersForm\TestDynamicInsertI
> nsert.cfm:
> line 12
> 10 : insert into tFormCategory
> 11 : (formid,categoryid,altcategoryname)
> 12 : values ('#session.formid#','#x#', <cfqueryparam
> name="#altcatname#" null="#yesnoformat(not
> altcatmodified)#">)
> 13 : </cfquery>
> 14 : </cfloop>
> Am I missing something?
> tia
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/author/?id=4806
http://www.fusiontap.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202373
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
