Categories
Mastering Development

my Message is not displayed in my chat app?error it show there is no setter fields [closed]

The messages are send to firebase database and the problem is created during the receiving the messages it is not error the application does not show the messages that is the problem : the code for my message activity : ref = FirebaseDatabase.getInstance().getReference("Myusers").child(userid); System.out.println("test1"); ref.addValueEventListener(new ValueEventListener() { @Override public void onDataChange(@NonNull DataSnapshot dataSnapshot) { Users […]

Categories
Mastering Development

Merge 2 SQL Server queries

We have to run every week a SQL Server query taking into accounts transactions starting from the latest Saturday at 00:01 until Saturday at 23:59 (Kuwait Time). The process takes into account thousands of rows and is there fore very heavy. I decided to do it in two steps, mostly because i could not manage […]

Categories
Mastering Development

SwiftUI @EnvironmentObject no ObservableObject of type error

I am getting the error Fatal error: No ObservableObject of type LoginResponse found. A View.environmentObject(_:) for LoginResponse may be missing as an ancestor of this view. I have passed the environment object to all the subviews of LoginView(), but the error still persists struct LoginView: View { @State var loginCredentials = Credentials() var loginResponse = […]

Categories
Mastering Development

Passing multiple arguments to api call

I have a function called saveChanges that dispatches a call to an api that takes user input from a bunch of different input fields. Each field uses v-model with an object called editFormData. I then use each property in this object to pass as the arguments for the function that dispatches the api call. When […]

Categories
Mastering Development

How to save specific values from JSON data with Python

I need to save specific values from a complex JSON object json = [ { "InvoiceNumberPrefix": "WH-", "InvoiceNumber": 44444, "OrderID": 9405944401, "CustomerID": 3233, "OrderDate": "2020-07-17T12:58:43", "OrderStatusID": 1, "LastUpdate": "2020-07-17T13:58:43", "UserID": "", "SalesPerson": "Dava", "ContinueURL": "http://", "AlternateOrderID": "", "OrderType": "Repeat", "PaymentTokenID": 0, "BillingFirstName": "John", "BillingLastName": "Doe", "BillingCompany": "3dcart", "BillingAddress": "1234 Test St.", "BillingAddress2": "", "BillingCity": "Tamarac", […]

Categories
Database Development

Is the following index is good?

What is the proper indexing plan for the below query? Query 1 : select id from room_participants where roomId=1 and userId=1 and status=1 and isMuted=0 Query 2 : select group_concat(b.phone) from room_participants as a left join users as b on b.id=a.userId where a.roomId = 1 and a.status = 1 Is it an advisable way to […]

Categories
Database Development

Is the following index is good?

What is the proper indexing plan for the below query? Query 1 : select id from room_participants where roomId=1 and userId=1 and status=1 and isMuted=0 Query 2 : select group_concat(b.phone) from room_participants as a left join users as b on b.id=a.userId where a.roomId = 1 and a.status = 1 Is it an advisable way to […]

Categories
Mastering Development

How to pass boolean values from Blade to Vue Component Laravel 7?

I’m trying to implement IF condition with true/false or 1/0 in Vue Component. I go through some earlier asked questions but not able to get it. Please help me out. Controller (I tried with two ways so that either I may got success with true/false or 1/0, In both methods on page I’m able to […]

Categories
Database Development

Insert into Stored Procedure Executes Twice and then gives Error

I have written following stored procedure for insert into a table. I want to insert data from my extract table to dm table only when no matching record exists in dm table. USE [US] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dm].[US_INSERT_UPDATE_v2] @ePK nvarchar(255), @userid nvarchar(255), @firstname nvarchar(255), @middlename nvarchar(255), @lastname […]

Categories
Database Development

MariaDB upgrade and database/table complications – not being able to add data

Yesterday my hosting updated to a new version of MariaDB (10.3.23-MariaDB-log-cll-lve – MariaDB Server) and after that i cannot add new data to my database. They cant help me so here i am. I have a dictionary website. Now the only data that is sent to db is taleshinorth,central and south. Nothing is being sent […]