[database-design] Forum Topics

I have a table with the following fields: CREATE TABLE text ( drawing INT NOT NULL, blockID INT NOT NULL, entityID INT NOT NULL, style INT, txt VARCHAR(255) NOT NULL, attrib INT); My csv file contains the data: 19 1CB2 E49 2 CLIENT MODULAR 1C2A 19 1CB3 E4B 2 CLIENT …

I have a website in laravel [instazood](https://www.iinstazood.com/) I want to apply limit clause with eager loading. I tried many other ways made r and d but could not get any solution. function fetchData() { $user = new User; $data = $user->with('comments'=>function($query){ $query->where('status',5); $query->limit(1); })->get(); }

i created a registeration form which i linked to my database whenever i try to make i data registeration i always get this error:Object not found! The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again. If you …

How to Update Database Datetime in This Format " dd MMM yyyy HH:mm:ss 'GMT' "With Vb.net Program I Searched a lot about how to Get The Time online and i found a solution You will found it in my Codes. > My Aim is to make a MemberShip DateTime , …

Dear sir, Please help me about below query. here is two table sale and purchase. i want product wise result in output table like below picture. please help me 

Hi All, I'm currently working on a church attendance monitoring project, and this community had helped me a lot during my college days in building php base projects, now I'm here again to ask for help. The scenario is I want to track every individual who are present every sunday …

hi, i just need some help, i hope someone could help me, thank u. i just need to add some conditions but i dont know how, my main point here is if the data already exists then it will update if not then insert, thank u. <?php session_start(); include "connect.php"; …

can someone help me take a look i face (oledbexception was unhandled (too many fields defined)) below is my code . Private Sub btnBrowse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBrowse.Click Properties='Excel 12.0;HDR=NO;'" Dim Chosen_File As String = "" If openFileDialog1.ShowDialog() = DialogResult.OK Then Chosen_File = openFileDialog1.FileName End …

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

Please Help me with my project. I'm currently first year in college and one of our projects is to make a system that will have database. What I want to do is when I login to the Interface the value of the username will be diplayed throughout the whole program. …

Hola

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 …

Good Afternoon All We have create a web application in asp.net mvc 5 and we want to if my application web form 4 textbox and data are same then show error duplicate entry else in 4 textbox any one box data is diffrent ( Data not exists in database ) …

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 …

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?

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 …

I don't know whether this question fits here or not, but if it doesn't let me know. I'm a much much beginner in programming, and I've started it in vb.net for a project I've to do for my college work. To add the data of a user in the database …

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 …

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. …

Hello guys , can you help me how to get the ID from mysql DB , if the listview is click the name and the ID well retrieve to textbox1 and textbox2, i dont know how to get the ID?, on the listview the ID wasnt retieve , can you …

Can I ask for a help? On how to program billing system with source code? I just need it for my case study.

I want to print database value on multiple pages using C# using HasMorePages property. I have worked on the same, but the loop goes infinetly (without stop) and the same data is repeatating on each page, how to solve it?

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, …

I looking to create a database form for people to create receipts to issue to customers but I need to be able to lock the record so that it can't be edited once it has been printed and saved. How can I do this?

help with ER diagram for package courier service systems

Hi all, I have an application which saves data (books details like book title, author and location) to a mySql db and performs CRUD operations. I thought I'd use hibernate to take care of the ORM side of things and everything was OK when it came to create a record, …

How do I assign a database query value in such a way that the value becomes the selected value in a drop down box.

can someone please help me with coding. I need to create a dropdown menu with the options being the category the user has inputted into a file upload page.

Hi, I can show data from the database using query [CODE=php] <?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); } $a= $_POST["SiteId"]; mysql_select_db("abc", $con); $result = mysql_query("SELECT * FROM sitepinfo WHERE SiteId='$a'"); echo "<table cellpadding=2 cellspacing=2 width=100% > <tr> <th bgcolor=#5D9BCC>SiteID</th> <th bgcolor=#5D9BCC>Maintained By</th> </tr>"; …

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] …

Hi, I'm wondering if it's possible to have a desktop app with a database online? Can you give me an example? :P

I need help with reading data from web page. I wanted to do database of rates (forex). For example: whan price is (eur\usd) 1.4231 then 1.4230 then 1.4229 then 1.4230. I wnated to make text file and application (c\c++) write there those price. In tex file: 1.4231 1.4230 1.4229 1.4230 …

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 …

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 …

Hi, I do need help with my solo project called Salary Expenses project in PHP and Laravel and I don't see any data for the current month in the **Monthly Expenses page**, even the data is recorded during the current matching month. Can help? My project file: https://drive.google.com/open?id=11qrmVHOwdgiiYQbw981o4y_CNp9DrTUM

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 …

hai all , iam using the jsp in that i have small dought , DBtable: id,description,created by ,create time,modified by ,modified time ,isactive Jsp: i want to store that values in databse using the jsp;here id is auto increment,description is user enter ,created by created by ,create time,modified by ,modified …

I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing. BOOM, every database I had there - gone! GRR! …

I have to Create an application that enables the user to create a file named grades.txt in which to store grades. The app should allow the user to write to grades.txt file: student number, student name, surname, subject, individual assignment grade, group assignment grade, test grade. When you click Create …

My program fail to generate the auto ID on my text can help me. Private Sub getNextNumber() If Not app.State = ConnectionState.Open Then 'open connection app.Open() End If Dim da As New OleDb.OleDbDataAdapter("select top 1 ID from ADMIN ORDER BY ID desc;", app) Dim dt As New DataTable 'fill data …

> 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 …

In this case I display values into datagridview from Projects table which it has only 2 columns: PROJECT_NAME VARCHAR ID INT // Which is hidden in datagridview, and as AUTOINCREMENT I have already done with editing values in this table and it works fine: `private void dataGridView4_CellEndEdit(object sender, DataGridViewCellEventArgs e) …

hello dear experts hello dear user, first of all; many thanks for this great wordpress-plugin. This is just overwhelming. currently i am planning to set up a site: well – We would like to create a dropdown menu that selects jobs from different sites on a WordPress-multisite. Scenario: imagine – …

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] …

Team, Hope you all are doing fine I have one admin server which is being used dedicately to run cron jobs on hourly basis, fetching the details from Database which is in a different server.These cronjob are run on every hourly/5 minutes basis depending as per end user requirement. The …

Currently i can search in a box for a specific thing in my database but i can't search in my drop down menus which i need so it can help "find" it as well so it can narrow down the search. my current code: [CODE] <?php $mysql_link = mysql_connect('localhost', 'root', …

I am making a small example of adding, editing, deleting and saving the treeView directory tree into the SQL Server database, what must I design to store in the database and write code ?

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 …

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' ) …

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']; …