Categories
Database Development

How to add “You are Friends” button instead, if user is not in the addfriends table?

How to add “You are Friends” button instead, if user is not in the addfriends table? Hi all, I have assigned a column called “friendshipstatus” as a DEFAULT Constraint =0 in “addfriends” table. Here the table :- CREATE TABLE addfriends( id INT AUTO_INCREMENT, fname varchar(255), lname varchar(255), email varchar(255), reg_date date, friendshipstatus int(11) DEFAULT 0, […]

Categories
Database Development

How to add “You are Friends” button instead, if user is not in the addfriends table?

How to add “You are Friends” button instead, if user is not in the addfriends table? Hi all, I have assigned a column called “friendshipstatus” as a DEFAULT Constraint =0 in “addfriends” table. Here the table :- CREATE TABLE addfriends( id INT AUTO_INCREMENT, fname varchar(255), lname varchar(255), email varchar(255), reg_date date, friendshipstatus int(11) DEFAULT 0, […]

Categories
Development

Object not found! Error when i try to sumbit a form it was not going to that addresss

I downloaded the SB Admin template from the internet and edited it. After editing, I tried to run a server file which has this code: var express = require(‘express’) var sql = require(‘mysql’) var bodyParser = require(‘body-parser’) //initializing express into App var app = express() //using bodyparser to get the details from a page app.use(bodyParser()); […]

Categories
Development

How to Count How Many Zeros are within a column from the Right in Oracle SQL

I am currently going through a process of validating a column that holds reference numbers for each customer but they have to be a specific format to be counted as a genuine number. I initially received around 80 csv files and uploaded this into a single master table after going through a process of making […]