1,079 Recommended Topics
Remove Filter  | |
| | [B]Mysql - How to use UPDATE with SELECT???[/B] I have two tables: [B]1) products_category[/B] -cat_id -cat_name [B]2) related_category[/B] -rel_cat_id (exaclty same as products_category.cat_id==related_category.rel_cat_id) -rel_cat_name [B]products_category table[/B] [IMG]http://www.ephpsolutions.com/scud/rrr/product_category.gif[/IMG] [B]related_category table[/B] [IMG]http://www.ephpsolutions.com/scud/rrr/related_category.gif[/IMG] I want to get cat_name from products_category and want to store in rel_cat_name in related_category tabel. and the query should … Databases mysql |
| | Imports System.Data.OleDb Public Class Form1 Dim pro As String Dim connstring As String Dim myconnection As OleDbConnection = New OleDbConnection Dim command As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click pro = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sinthu\Documents\Database1.accdb" connstring = pro myconnection.ConnectionString = connstring myconnection.Open() If myconnection.State = … Databases vb.net  |
 | I Have **"user_chat"** table name his 4 columns "msg_id" Auto Increament "chat_from_id" "chat_to_id" "chat_msgs" SELECT `chat_msgs` from `user_chat` where chat_from_id='2'AND chat_to_id='10' LIMIT 0,10 Also I have used **DESC** using above queary but not worked I want to fetch last **5 recent records** from **"chat_msgs" columns** Suggest me. Thank you Databases sql |
| | I have the following two tables: TABLE 1: +-----------------------------+--------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+--------------------------------------+------+-----+---------+-------+ | patient_id | bigint(20) | NO | PRI | NULL | | | patient_wpid | int(11) | NO | PRI | NULL | | | age_at_visit | … |
| | can you please help me to answer that problem? This is a question, I have an employee salary table, How do I find the second highest from it.? A big thanks to those who will help. I appreciate it a lot. Databases mysql |
 | Hi helpful people. Its been a while since Ive been here, ever since I employed someone who knew about IT to look after it for me. I'm back on my own again, and looking for a bit of guidance please? I run a small sales company and receive daily sales … |
 | Hi, I am new with sql server. I want my date formate like dd-mm-yyyy.. but i could not able to do so. please help me and give me proper syntex fro the same Databases sql |
| | Hello all. I have a funtion in MYSQL to substruct days from a date. This function seamsto work but some dates it times out. This is my function CREATE DEFINER=`root`@`localhost` FUNCTION `Calculater`(intrval int, req date) RETURNS date DETERMINISTIC BEGIN declare calculated date; declare added int default 0; Lbl_Loop: Loop IF … Databases mysql |
| | Hey! I am really stressed out about my TURBO CPP project. I wrote a program on periodic table using file handling. when i compiled it crashed and not the project is unusable. I want to submit it at the earliest. I was hoping some one might drop their out projects. … Databases  |
| | I'm using phpMyAdmin to manage my databases, I have 2 projects that use 2 different database the first one uses 'root'@'localhost' and the 2nd is 'root'@'127.0.0.1' I don't know how i ended up using 2 different server but it was working fine until i tried to edit codes with the … Databases client-server mysql |
| | Hello guys, i've the following table in database : IdCity int CityName nvarchar(20) it has the data like this in it : IdCity CityName 1 Абакан 2 Азов 3 Александров 4 Алексин 5 Альметьевск 6 Анапа when i try to run the following view SELECT IdCity, CityName FROM dbo.City WHERE …  |
 | I come across this problem every so often and end up having to do work arounds when I would prefer to keep it in the database. I have a query where the data in the query updates frequently so the query won't stay in the cache but I don't need … |
 | Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key … |
| | Hi everyone, right now I am looking for a database b2c (consumers) from the UK and SPAIN with more than 200k leads. This is to buy, someone interested? Databases |
| | Spent a day trying to gen any info on this but didn't find anything so maybe someone here could help me out . here's the html code and a css style. Maybe it's not that difficult in the end but I have never done this and php is not my … Databases html-css |
| | Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm … |
| | Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would … Databases microsoft-access vb.net  |
| | I am looking to create a database to record when students' work has been handed in to the office. I have created the form but it needs to be able to record who signed in the work. There are several people working in the office and will use the database. … Databases microsoft-access |
| | I am using bootstrap modals, when i query to populate a dropdown to fill in to my form, my query is show all but the first record and i can't figure out why. My form looks like this <div class="form-group"> <label for="deptcode">Department</label> <select class="form-control" id="deptcode" name="deptcode" value="<?php echo $mem['deptcode'];?>" <?php … Databases mysql |
 | All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu Databases sql  |
 | Hello. I have a quick question. I am making a database as a personal project (I am using Microsoft SQL Server therefore I am using its SQL syntax). All it does is that it keeps track of singing groups and bands, the members in these groups, albums they made, songs … |
 | Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, … |
| | here is the normal rows coming  i want to show the group by product name with the count of store as the below picture  here are mysql query SELECT i.barcode, i.name, u.company_name, COUNT(i.id) AS IQTY, COUNT(U.id) AS UQTY FROM inventory i, USER u |
| | How do I echo selected option? <?php session_start(); if(isset($_SESSION['cherianne'])){ }else{ header("Location:login.php"); } include("../includes/header.php"); // Retrieve our critical page setter variable. $char_id = $_GET['id']; //echo "<h1>$char_id</h1>"; // set this as a default value if (!isset($char_id)) { $result = mysqli_query($con, "SELECT bid FROM cde_blog LIMIT 1"); while ($row = mysqli_fetch_array($result)) { $char_id … |
 | CREATE TABLE Peaje ( id_no_pk CHAR(2) NOT NULL, nombre VARCHAR(30) NOT NULL, localizacion VARCHAR(30) NOT NULL, dirrecion VARCHAR(50) NOT NULL, tipo CHAR(1) NOT NULL, municipio_fk CHAR(2), CONSTRAINT Peaje_id_no_pk PRIMARY KEY(id_no_pk) CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)); CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)) * ERROR at line 9: ORA-00907: … Databases sql |
| | So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect …  |
| | Hi All, I am going to write a small inventory tracking app for a small company. What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. [LIST=1] … Databases seo web-design |
| | I do not have a clue as to what the problem is with this code. I am running php 7.0. This was an old form I used long ago, decided to upgrade it for random use. It works on php 5.0 but not in 7. I have run it through …  |
| | Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel … Databases asp.net microsoft-access vb.net  |
 | Hi all, I have a new project with vb.net. I need to always connect with older program that run in foxpro, i need to get dbf table and convert it to mysql table. Can anyone help me ? |
| | Hi, I'm creating a project using VB.Net Windows Form and I want to create a Log-In form that can **Add New User (Limited to 5 User Accounts), Delete User Account, and Change Password**. I want to use Microsoft Access with it. What are the codes I should use to create … Databases microsoft-access vb.net |
| | So, I created a program in VB.Net with Windows Form and I want the user to be able to create a new user, limited to 5 user accounts only. I also want to know if it's possible to change password and delete user accounts. Can I make it so that … Databases microsoft-access vb.net  |
| | Hello, I'm a beginner and I created a log-in form in VB.net using Windows Form and configuring the Settings of the project. I need help on how can I prevent the user from accessing the other parts of the program if they haven't registered yet, as well as deleting the … Databases vb.net  |
| | Greetings. I am making some Point of Sales system but I have a little problem with the database design. You see, there is this list of products that will be added to a cart. What I need is when these items are added in the cart and then sold, it … Databases |
 | This is the process I want to attain: 1. I have 4 buttons 2. Each 4 buttons have categories under it 3. When those categories is selected it shows list of datas 4. The datas are like powerpoint empty slides Can Someone give me some idea how to create relational …  |
| | > Last month, Facebook admitted to storing million of Facebook passwords in plaintext. The Verge Apr 18, 2019 We see students being taught login systems here and a recurring mistake is passwords being stored in databases. It appears that CompSci courses teach bad practices early and as we know it's … Databases cybersecurity social-media  |
| | Hello! I have a question and I don’t know whether the title is actually descriptive. For some background on the matter, we use Sage 50 as our merchandise information system and for our reporting and controlling tools we run Access queries. Since our database had been reset at some point … Databases microsoft-access sql |
| | This was a query raised by one of a forum members at another site, where he had a worksheet filled with random numbers, and I have already answered that query [at my post here](https://vbacoder1962.wordpress.com/2019/07/15/extracting-cell-phone-numbers-from-random-strings-of-variable-length/). You may go through that post and read the logic behind the code.  Databases microsoft-access vb.net |
| | Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of …  |
| | In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and … |
| | in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] … Databases sql |
| | TITLE: Connect to Server ------------------------------ Cannot connect to (LocalDb)\MSSQLLocalDB. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote … Databases sql |
| | |
 | Hello i am getting an error on a CASE WHEN THEN syntax on my mySql SELECT DISTINCT u.uid,c.c_id,u.name,u.profile_pic,u.username,u.email,c.time FROM conversation c, users u, conversation_reply r CASE WHEN c.user_one = '99' THEN c.user_two = u.uid WHEN c.user_two = '99' THEN c.user_one= u.uid END AND ( c.user_one ='99' OR c.user_two ='99' ) … |
| | I'm currently working on my project. I use Vertrigo as my virtual server. However recently i always see this message when i use it.... MySQL database server does not work correctly. Check whether other applications use the important port (3306)... i'd no clue at all but then i reconfigure my … Databases mysql  |
| | hey, i am trying to insert multiple checkbox data in my database but having a littlt bit problem. When i am trying to insert checkbox data it inserts only id and nothing else. Here is my full code:- <?php include("config.php"); if(isset($_POST['save'])){ $contact_sms = $_POST['contact_sms']; $check[] = $_POST['check']; $firm_name = $_POST['firm_name']; … Databases |
| | Please, why I got this error(SQL Error: ORA-00907: missing right parenthesis ) whats wrong in my code? CREATE TABLE DomeniuAB(ID_DOMAB NUMBER(10) constraint ID_DOMAB_PK PRIMARY KEY , DENUMIRE VARCHAR2(20) NOT NULL, DETALII VARCHAR2(20) NOT NULL, ISBNAB_CarteAB VARCHAR2(15), CONSTRAINT ISBNAB_FK FOREIGN KEY (ISBNAB_CarteAB) REFERENCES CarteAB(ISBNAB), CNPAB_AutorAB NUMBER(10), CONSTRAINT CNPAB_FK FOREING KEY (CNPAB_AutorAB) … Databases sql |
 | Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record FAILED. Please contact your systems administrator." From the code below, do you see where my error may be? What corrections …  |
| | I'm writing stored procedure with dynamic sql having dynamic table name as, CREATE OR replace PROCEDURE Pr_get_result (p_table_name IN VARCHAR2, p_object_Id IN VARCHAR2) IS p_prop_code VARCHAR2(50) := 'pH'; BEGIN EXECUTE IMMEDIATE 'DECLARE ' || ' TYPE ObjCurTyp IS REF CURSOR; ' || ' v_obj_cursor ObjCurTyp; ' || ' v_stmt_str VARCHAR2(32000); … Databases sql |
| | Hi, I need help to create a relational database for shop.The database should contain a column for barcode in order to register items and also to read details of items using barcode scanner.Besides this database will contain tables for performing all operations for shopping store items what are those operations … Databases sql |
The End.