procedures - How to get previous row data by using SQL? -

-

here table example

main_cd code
1 aa

1 bb

1 cc

2 1231

2 1232

.

that table have lots of data. use main_cd "1" (other data other pages cannot delete it)

my question if got value of "cc". want sent pre_data ("aa") , next data ("cc")

also if got value of "cc", pre_data "bb" , next_data "aa"


Comments

Post a Comment

Popular posts from this blog

javascript - IndexedDB error: Uncaught DataCloneError: Failed to execute 'put' on 'IDBObjectStore': An object could not be cloned -

-
i using google maps api along html 5 geolocation api display position marker on map. once marker displayed have simple on marker double click function saves new marker current position using indexeddb. goes until object stored, recieve message " uncaught datacloneerror: failed execute 'put' on 'idbobjectstore': object not cloned. " in console. code follows: function initialize() { var mapproperties = { // set maps properties center:new google.maps.latlng(55.8580,-4.2590), zoom:8, maptypeid:google.maps.maptypeid.roadmap }; var map=new google.maps.map(document.getelementbyid("map-overview"),mapproperties); //display map in map-overview div function nogeolocation(e) { //a function handle users not have geolocation if (e) { var content = 'error: unfortunately geolocation service failed.'; } else { ...
Read more

amazon web services - When using Cognito credentials with AWS in a browser (javascript), keep getting "missing credentials" error -

-
Image
i'm attempting upload file s3 bucket of mine web browser using aws' javascript sdk. code looks this: aws.config.credentials = new aws.cognitoidentitycredentials({ accountid: 'dfhgdh', identitypoolid: 'fdagsd', rolearn: 'fdafds' }); var bucket = new aws.s3({params: {bucket: 'test-bucket'}}); var pdfupload = document.getelementbyid('pdf-uploads').files[0]; var params = {key: pdfupload.name, contenttype: pdfupload.type, body: pdfupload}; bucket.putobject(params, function (error, data) { if (error) { console.log(error); } else { console.log(data); } }); however, whenever reaches putobject command, keep getting error aws: "error: missing credentials in config {message: "missing credentials in config", code: "credentialserror"..." i'm sure i'm missing simple , stupid here, can't figure out life of me. (i different error when try hardcode bogus secret...
Read more

ember.js - ember-cli / ember-data model unit tests using http-mocks -

-
i using ember-cli / ember-cli-mocha testing. have generated http-mock work when run app via ember serve . however, when run tests -- (e.g. see below...), error: sheet calculates exported fields ✘ assertion failed: unable find fixtures model type (subclass of ds.model). if you're defining fixtures using `model.fixtures = ...`, please change `model.reopenclass({ fixtures: ... })`. i presume unit test setup must set store use fixtures. there configuration somewhere use http-mocks instead? start of test ... 'calculates exported fields', -> # now, exported fields fields , variables expected = `new set()` sheet = null store = @store() ember.run -> store.find('sheet', '1').then( (sheet_)-> sheet = sheet_ promise.all([ sheet.get('fields'), sheet.get('formulas')]) ).then((args)-> [fields, formulas] = args fields.foreach (f)->expected.add(f) ... ...
Read more