10 Recommended Topics

Remove Filter
Member Avatar

Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master …

Databases mysql
Member Avatar
0
2K
Member Avatar

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 …

Databases database microsoft sql
Member Avatar
0
60
Member Avatar

Hi Everyone! I am new here, and the main purpose of joining this community is getting some help. Actually, I am designing a PHP website where I need to fetch US vehicles data into PHP. I have already used this source to get the vehicle's dataset from here https://www.back4app.com/database/back4app/car-make-model-dataset. Still, …

Member Avatar
1
178
Member Avatar

I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as …

Databases date sqlite
Member Avatar
0
75
Member Avatar

Hi all, I am working on a website that requires two queries from a table at the same time. They must select a row based on the id, and then another random one not including the row just selected. I currently have: $query = $pdo->prepare('SELECT title, content FROM cards WHERE …

Databases mysql
Member Avatar
0
150
Member Avatar

DaniWeb was written in Codeigniter, and when posting to the forums, we use database transactions that look like this: $this->db->trans_start(); ... insert into the posts table ... ... update the member's post count ... ... update the tags table ... etc $this->db->trans_complete(); On occassion, the error log will show for …

Member Avatar
1
3K
Member Avatar

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 …

Databases mysql
Member Avatar
0
2K
Member Avatar

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 …

Member Avatar
1
121
Member Avatar

I have a snippet that inserts data in a row in a MySql database. If that data already exists the existing row should be updated. In my case, I continue to get insert only. What is wrong with this snippet? $page = basename($_SERVER['SCRIPT_NAME']); $ip_address = $_SERVER['REMOTE_ADDR']; include_once("includes/connection.php"); $sql=mysqli_query($con, "SELECT visits …

Databases mysql php
Member Avatar
0
92
Member Avatar

Like the title says, I'm trying to coloring an empty cell in bounded datagridview. I've got this code to coloring a cell with specitic value and is working well. This code is in the DatagridviewCellFormattingEventargs. If e.ColumnIndex = 5 AndAlso e.Value <= Date.Now.ToShortDateString Then e.CellStyle.ForeColor = Color.DarkGreen e.CellStyle.Font = New …

Member Avatar
0
270

The End.