Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

coldfusion - What's wrong with my simple insert? -


i'm using coldfusion insert contents of struct (key-value pairs) database table. code:

<cfloop collection="#results#" item="id" >     <cfquery name="insertstuff" datasource="mydatasource">         insert web..stuff (id, name)         values (#id#, #results[id]#)     </cfquery> </cfloop> 

this seems simple enough... i'm getting following error:

incorrect syntax near 'va'.  

any ideas?

you ought think parameterising data too.

<cfloop collection="#results#" item="id" >     <cfquery name="insertstuff" datasource="mydatasource">         insert web..stuff (id, name)         values (             <cfqueryparam cfsqltype="cf_sql_varchar" value="#id#">,              <cfqueryparam cfsqltype="cf_sql_varchar" value="#results[id]#">)     </cfquery> </cfloop> 

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -