11,053 Topics
I have a very complex java program written with net beans 7.1. It consists of 1 .java file that has a main(), and over 25 supporting .java files (most used for routines inside of tabs). In addition there are 15 different databases (embedded) associated with it. The program is virtually …
so we were trying to make a simple log in form and our professor simply told us to copy the codes he wrote:  i copied it but i got a red line under line 20 and 21 . I dont know what to do, no one is responding to …
Hello This is a simple php login script with sessions. It connects to mySQL for usernames and passwords. I’m using a variation of the code from [url]http://www.phpportalen.net/wiki/index.php?page=Enkel+Inloggning+med+Mysql+och+sessioner+-+Komplett+kod[/url] (index.php is the relevant part) Here is my code (my script is called login.php): [code=php] <?php session_start(); // Always at the top include …
hii how can i make self join and sum data in other table by username i have table like this members (id, username, referral) ref_bonus (id, username, bonus) members id | username | referral ---------------------- 1 id1 id2 2 id2 null 3 id3 id2 ref_bonus id | username | bonus …
Hi DW. I'm creating a chat system which will alow guests to send DMs to the operator and the operator can reply to it. I'm using MYSQL as my database, fingerprint2js for identifying the user since user has not yet logged in or registered but want to first communicate with …
Hello all, We have just launched a startup. Now, we are looking for a simple web-based relational database system where we can easily add tables and connect them to one another through foreign keys. For example, we would want to create a suppliers database in which we could perform a …
What code should i use?
Hi, I'm using a MDB database that i would like to filter based on selections made in 2 comboboxes. say: cmbBase and cmbMix. cmbBase connects to "Base" cmbMix connects to "Mix" I have use the automated database method in C# [Click Here](null) private void BaseMixBindingNavigatorSaveItem_Click(object sender, EventArgs e) { this.Validate(); …
Any programming language or software that can help in database design and manipulation
Can someone help me with this as I am having problems. My problem is that after i click button 2 for placing the order the data from the checkout form should go to the database but it does not work, there is no sign of that. I don't know if …
I'm trying to modify a web script. Currently, upon uploading a video, in the upload Form, among other things, the uploader chooses a sub-category and enters tags and then submits/uploads. I'd like the sub-category that is selected, to also be searchable as a keyword. Presently, the 'videos' table has a …
Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query: IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition FROM sys.columns WHERE name = 'ModifiedDate' AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE()) However, you can not compare a …
i need code for insert multiple rows into database please help me
Where is the SQL Server Database Trigger Wizard or Dialog Box? This question is about SQL Server In the past, I have created a stored procedure that was run on a timely basis by (if I remember correctly) a database trigger. As I recall, there was a wizard (dialog box …
hello i'm trying to schedule event from mysql in node js i know how to execute query (connection.query("select * from test") but how to do that in nodejs --------> CREATE EVENT IF NOT EXISTS reurring_event ON SCHEDULE EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP ENDS CURRENT_TIMESTAMP + INTERVAL 1 minute DO INSERT …
Hello everyone. I saw services on the Internet where you can search for keywords in the Instagram biography. These services have their own base and they search for it and sell it later. Are there forums on the Internet where there is already a parsed database in the form of …
Hi, I am currently working on a banlist and I am thinking about which data type to choose for storing the IP address in the database. Will the Binary data type be ideal?
Hello can someone help me how could i start the work on a project on sentiment analysis for my college project.
Illustrate a database for the video club using a recent video club entities
I want to find a programmer, grab the data of Chinese operators, web visitor numbers, and cooperate. This is a very good business.
I have some php code on view invoice and it's getting all the data I need to from three database tables but for some reason it's not getting the data for one specific column and unsure why I have done a echo sql and it is echoing the sql query …
1.Write the SQL statement to list all columns of the Product table for products costing more than $50. Order the results by product manufacturer (ProdMfg) 2.Write the SQL statement to list all columns of the Product table that contain the word Ink Jet in the product name 3.Write the SQL …
...hello.. ...uhm...I am now working with a Student Profiling System...I already have the layout for my system..but with regards to its database, i'm still quite confused... ...another thing...i can't find the right resources for it.. ...could anyone please help me by sending a link where i can find guidelines for …
Our database is running into problems, as many transactions are waiting for locks held by other transactions. Here is what each transaction is waiting for: · T1 is waiting on T4 · T5 is waiting on T8 · T2 is waiting on T7 · T6 is waiting on T2 · …
I have a database like attached (no1). I want to set the values to a treeview in vb.net liked attached (no2). Hey guys plz help me on this.  
Hi guys do you have a c++ program that computes electric billing system with databases?
I have the following table: my_contacts which contains the following columns: [CODE]contact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, frist_name VARCHAR(20), interest VARCHAR(20)[/CODE] [CODE]-----------+-----------+---------- contact_id | fisrt_name | interest + ---------------------------------- 1 | smith | swim + 2 | mark | dance + ----------------------------------[/CODE] I need to move the interests column …
A balanced tree is one of the data access techniques in a database. How does it work? How data can be inserted in. How data can be deleted from it; how data can be updated? And how data can be reviewed? By giving an example explain all of them. Your …
Consider the following database Room (room_no,room_name,room_type,charges) Guest(Guest_code, Gname,city) The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either ‘AC’ or ‘NonAC’. Q 2) A Create the above database in PostGreSQL and insert sufficient records.
I am starting an online business with an American lady. I don't know anything other than her phone number. So want to verify her records.
Would you mind if I troubled you for some help? I’m working on an NDA’ed project and we’ve been asked to try and address a problem which is currently causing some pain. Imagine there was a merger between two blue-chip communications/media companies, and Company A was offering discounted deals to …
Create database with the name of "university". You have only two table with the name of "signup" and "student". In Student table you will collect all data of student like cms, name, address ,age, mob and cnic. Perform Multiple Task which are given below. 1) Create Login and Signup page …
Take a relation and apply Primary horizontal fragmentation. define all the step that followed in PHF and also find the correctness of the fragmentation.
I have developed a software in VB6. I want to give a menu option for back up. ie. to copy the database files to a pendrive I have given the below code Dim sourcefile,Destinationfile as string sourcefile = App.Path & "\HHA.mdb" Destinationfile = Textdrive.text & "\HHA.mdb" Filecopy sourcefile,Destinationfile When worked …
I want to split database access and permissions with another person. The problem is we don't know how we can make sure we both have the same rights and permissions to operate the database. So if anything goes wrong for example, one wants to change the password of the database …
What's up guys! My question is: Has any form or tool been created that allows data to be saved in an offline database if the customer's internet goes down? I will explain better, my application is Web, made in .Net, runs entirely on the Browser and at first, it will …
I have a database where there is an table `wm` for water meters : +------+---------------+ | Code | name | +------+---------------+ | wm1 | water meter 1 | | wm2 | water meter 2 | | wm3 | water meter 3 | +------+---------------+ and another table c`ounters` where there are …
Good evening, I need a little help. After having extracted the data from a database table, I would need to print them on the screen in a certain part of an html page with 3 frames (exactly in section B of the "test" page as shown in the example)  …
Hello guys, I'm starting with mORMot and I'm having a hard time finding some example or tutorial on the subject, could someone give me a good tutorial or some example where I can start to understand better how mORMot works. Thanks. And sorry for my bad English.
'Column named Quantity cannot be found. TextBox1.Text = DataGridView1.CurrentRow.Cells("Quantity").Value.ToString TextBox2.Text = DataGridView1.CurrentRow.Cells("Total").Value.ToString TextBox3.Text = DataGridView1.CurrentRow.Cells("Price").Value.ToString TextBox4.Text = DataGridView1.CurrentRow.Cells("Description").Value.ToString
Hi everyone I am wondering if someone can help me understand why the Sub-Query's SELECT statement ended up producing the column name 'Code' vs. the initial SELECT statment call 'local_name' in the below screenshot Thanks in advance! 
[ATTACH=RIGHT]20145[/ATTACH][B]Building your first DYNAMIC Database application. This is Part One of a four part tutorial on how to install and use your database, Part Two will teach you how to build successful connections and Part Three will teach you how to build database interaction and management of your databases.[/B] There …
Dear all i want to know how to show particular records from database by select any record from combobox what is the coding and how to display record in another textbox by selecting from combobox like if you choose any record from combobox it will appear in textbox, in image …
Hello Could I please ask for assistance? I need a file that I am able to download that holds all the streets and postal codes of the Ireland.
Hi, I need a little help with someting I'd like to implement, but not sure how to do it. I'm running eBay like classifieds site. There are a lot of filters on my site e.g. you can filter ads by price, by category, by city, by condition... Let's say we …
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 …
The End.