Posted By

jonniespratley on 10/27/08

Tagged

Versions (?)

Last Edited at 10/27/08 12:52am

Statistics

Viewed 899 times

Favorited by 1 user(s)

Related snippets

AS3 Import XML To SQLite

/ Published in: Other

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/**
  * This is for importing xml data to a SQLite table 
  * @param node xml node
  * @param user the user whos data this is
  * 
  */			 
 public function importPostXML( node:XMLNode, dUser:UserVO ):void
 {
	var query:String = "INSERT INTO posts (" + 
									"post_url," + 
									"post_title," + 
									"post_description," + 
									"post_tags," + 
									"post_shared," + 
									"post_timestamp," + 
									"post_replace," + 
									"delicious_user )" + 
							"VALUES ( " + 
									":post_url," + 
									":post_title," + 
									":post_description," + 
									":post_tags," + 
									":post_shared," + 
									":post_timestamp," + 
									":post_replace," +
									":delicious_user)";
 
	sqlImport = new SQLStatement();
 
	sqlImport.sqlConnection = dbconn;
	sqlImport.addEventListener( SQLEvent.RESULT, onSQLSave );
	sqlImport.addEventListener( SQLErrorEvent.ERROR, onSQLError );
	sqlImport.text = query;
 
	sqlImport.parameters[":post_url"] 				= node.attributes.href;
	sqlImport.parameters[":post_title"] 			= node.attributes.description;
	sqlImport.parameters[":post_description"] 		= node.attributes.extended;
	sqlImport.parameters[":post_tags"] 				= node.attributes.tag;
	sqlImport.parameters[":post_shared"]			= node.attributes.shared;
	sqlImport.parameters[":post_timestamp"] 		= node.attributes.time;
	sqlImport.parameters[":post_replace"]			= "no";
	sqlImport.parameters[":delicious_user"] 		= dUser.username;
 
	sqlImport.execute();
 
	trace( "Importing XML to SQLite Database" );				
}