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

RESOLVED INCOMPLETE

Status

()

RESOLVED INCOMPLETE
10 years ago
8 years ago

People

(Reporter: b_bprimal, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [CLOSEME 2010-11-01])

(Reporter)

Description

10 years ago
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
An Addon is not a plugin...

Bugzilla is not for helping with developing addons. Did you ask in the addons/extension newsgroup, on IRC ?
Summary: I am writing a plugin accessing mozilla database but i could not connect a table from addon.I post my code please where is the error → 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
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.
Whiteboard: [CLOSEME 2010-11-01]
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.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.