sql server - Stopping an SQL Cursor with one of two conditions -

-

i have cursor want stop running based on 1 of 2 conditions.
1 based on data of table, , other based on fetch status.
right cursor ignores both , keeps running.

this part of have:

open demandcur fetch next demandcur     @....,     @++++   while @index  > 0 or  @@fetch_status = 0   begin  select  ....,  ++++ from......  --after doing stuff here---  fetch next demandcur      @....,     @++++  end close demandcur deallocate demandcur

should not and, , not or? if of conditions true, query keep running. , in case @@fetch_status true, until end


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

c# - How to set the datatextfield value instead of the value on a drop down list? -

-
i have list of countries, returns id , name. have string. drop down sets value id, @ point don't have id's. want able set selectedvalue text field. there way this? or there way compare string against list work out id? string country = "australia"; ddlcountry.datasource = listofcountries; ddlcountry.datatextfield = "value"; ddlcountry.datavaluefield = "key"; ddlcountry.databind(); ddlcounty.selectedvalue = ??? thanks ddlcountry.items.findbytext(country).selected = true
Read more