[farcry-dev] Re: Database Problem

[Brendan Sisson]

Nathan Mische wrote:

<cfquery name="updateClob" datasource="farcry_fbhc">
	UPDATE 
		FARCRY_FBHC.DMHTML
	SET
		BODY = <cfqueryparam value="#clobstring#"
cfsqltype="CF_SQL_LONGVARCHAR"/>
	WHERE
		OBJECTID = <cfqueryparam
value="B096EC8D-E0B8-16B3-5AB4A96D921C7031" cfsqltype="CF_SQL_VARCHAR"/>
</cfquery>


Nathan you were on the right track here. I had been working with Alex 
off list trying to resolve this issue and the above had worked for us 
also, so yesterday I re-wrote the fourq setData method to use 
cfqueryparam instead of building up a standard query string. Alex has 
just confirmed that this change works! So is this a driver issue? A 
known CFMX issue?

I have attached the file in question (fourq/_fourq/setData.cfm).

-Brendan
http://farcry.daemon.com.au




	// get table name for db schema
	tablename =  this.getTablename();
	// get extended properties for this instance
	aProps = this.getProperties();




	

	

	




	UPDATE #arguments.dbowner##tablename#
	SET
		
	
		
		
		
			
			
			
			
				
					
						#propertyName# = 
					
						#propertyName# = ''
					
						
					
				
				
				
					
					
					>
						
						
										
						
						
						 arr_sql = "DELETE FROM #arguments.dbowner##tablename#_#propertyname# WHERE objectid = '#objectid#'";
						 arrayAppend(stQueries,arr_sql);
						
									
						
						
							
							
							
							
								
									
								
								
									
									
									
									
										
											
										
										
											
										
										
											
										
																								
								
							
							
							
							arr_sql =  "
							INSERT INTO #arguments.dbowner##tablename#_#propertyname#
							(objectid,seq,data)
							Values
							('#objectid#',#j#,#preservesinglequotes(thisvalue)#)
							";
							arrayAppend(stQueries,arr_sql);
												
							
						
					 
				
				
				
					#propertyName# = 
				
				
				
					#propertyName# = 
				
				
				
					#propertyName# = 
				
				
				
					
					#propertyName# = 
				
				
			
			
			
			, 
		
	
	WHERE objectID = 

	



	
	
		
		
		
		
			#preservesinglequotes(thisSQL)#
		 
	



---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004