479568 - I am writing a adon accessing mozilla database but i could not connect a table from addon.I post my code please where is the error

Status: RESOLVED INCOMPLETE

(Firefox :: General, defect)

Description

[bhaskar]

User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322)
Build Identifier: not selecting data 

function SQLite() {

var file = Components.classes["@mozilla.org/file/directory_service;1"]
                     .getService(Components.interfaces.nsIProperties)
                     .get("ProfD", Components.interfaces.nsIFile);
file.append("bhaskar.sqlite");
var storageService = Components.classes["@mozilla.org/storage/service;1"]
                        .getService(Components.interfaces.mozIStorageService);
var mDBConn = storageService.openDatabase(file);
alert ("mDBConn:" +mDBConn);

//var sQuery = " SELECT dateAdded FROM  moz_bookmarks" ;
   //alert ("SQL:" +sQuery);
//var statement = mDBConn.executeSimpleSQL("SELECT dateAdded FROM  moz_bookmarks");
 //alert ("statement:" +statement);
 		// mozIStorageStatement
			//var stmt = mDBConn.createStatement(sQuery);
					//alert ("stmt:" +stmt);


var statement = mDBConn.createStatement(" SELECT name FROM  bhaskar" );
alert("statement" +statement);


					 					
//var sql = "INSERT INTO bhaskar (name, rollno) VALUES (hello, hello)"
//alert ("stmt:" +sql);
//var statement = mDBConn.createStatement(sql);
//alert ("stmt:" +statement);
    //statement.bindUTF8StringParameter(1, name);
    //statement.bindUTF8StringParameter(2, rollno);
    statement.execute();
    statement.reset();
    
//var rowid = mDBConn.lastInsertRowID;
	 
			 
			 
			 
    //statement.bindUTF8StringParameter(0, firstname);
    //statement.bindUTF8StringParameter(1, lastName);
    
   
//var rowid = mDBConn.lastInsertRowID;


}

Reproducible: Always

Comment 1

[Matthias Versen [:Matti]]

An Addon is not a plugin...

Bugzilla is not for helping with developing addons. Did you ask in the addons/extension newsgroup, on IRC ?

Comment 2

[Tyler Downer [He/Him]]

This is a mass search for bugs which are in the Firefox General component, are
UNCO, have not been changed for 500 days and have an unspecified version. 

Reporter, can you please update to Firefox 3.6.10 or later, create a fresh profile, http://support.mozilla.com/en-US/kb/managing+profiles, and test again. If you still see the issue, please update this bug. If the issue is gone, please set the status to RESOLVED > WORKSFORME.

Comment 3

[Tyler Downer [He/Him]]

No reply from reporter, INCOMPLETE. Please retest with Firefox 3.6.12 or later and a new profile (http://support.mozilla.com/kb/Managing+profiles). If you continue to see this issue with the newest firefox and a new profile, then please comment on this bug.