mysql - How can I determine the MySqlException.Number? -

-

i thinking of creating case statement mysqlexceptions, based on number property. there easy way determine if exception relates specific case? example, number "1062" always refer "duplicate entry"?

according mysql documentation answer question is, yes.

http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html

or 5.6

http://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html

when in doubt go dev.mysql...


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

c# - ItextSharp font color issue in ver 5.5.4+ -

-
Image
i have code creates red "stamp" using red font color: string stampdate = datetime.now.tostring("mm/dd/yyyy"); string fontpath = server.mappath("/assets/fonts"); string origfile = server.mappath("/test.pdf"); const int opacitypercent = 80; const float pdfpaidfontsize = 28; const float pdfcopyx = 170; const float pdfpaidx = 385; const float pdfy = 20; const float pdfdatexoffset = 7; const float pdfdateyoffset = 12; const float pdfdatefontsize = 10; const string paidstamptxt = "paid"; const string copystamptxt = "copy"; const string arialfilename = "arialbd.ttf"; pdfstamper stamper = null; pdfreader reader = null; pdfreader.unethicalreading = true; memorystream streampdf; try { reader = new pdfreader(origfile); streampdf = new memorystream(); stamper = new pdfstamper(reader, streampdf); (int = 1; <= r...
Read more

ios - retrievePeripherals deprecated in IOS7 how to substitude it with retrievePeripheralsWithIdentifiers -

-
i using "[self.manager retrieveperipherals:[nsarray arraywithobject:(id)aperipheral.uuid]];” works fine deprecated in ios7. found have use “ retrieveperipheralswithidentifiers ” instead. can not figure out right syntax new function. can please translate "[self.manager retrieveperipherals:[nsarray arraywithobject:(id)aperipheral.uuid]];” to new function “retrieveperipheralswithidentifiers”. // invoked when central discovers heart rate peripheral while scanning. - (void) centralmanager:(cbcentralmanager *)central diddiscoverperipheral:(cbperipheral *)aperipheral advertisementdata:(nsdictionary *)advertisementdata rssi:(nsnumber *)rssi { nsmutablearray *peripherals = [self mutablearrayvalueforkey:@"heartratemonitors"]; if(![self.heartratemonitors containsobject:aperipheral]) [peripherals addobject:aperipheral]; // retrieve known devices [self.manager retrieveperipherals:[nsarray arraywithobject:(id)aperipheral.uuid]]; } ...
Read more