49 Unanswered Topics

Remove Filter
Member Avatar for
Member Avatar for RC_820

i have 3 tables : users, deposit, withdraw **table users :** id , username, referral 1. 1, a1, null 2. 2, a2, a1 3. 3, a3, a2 4. 4, a4, a1 5. 5, a5, a2 **table deposit :** id, users_id, amount, status, approve_date 1. 1, 1, 10000.00, approve, 2022-10-01 14:52:53 …

1
88
Member Avatar for emart53

I have a MySQL table that lists delivery records (customerId, date, quantity, productId, cost). I have a requirement to log certain items from the delivery table into a separate table to track items being sent to quarantined areas. All quarantined products must have a serialized tag affixed for tracking with …

0
55
Member Avatar for Ciarán_1

Hello, my code at the minute fetches a record and splits it up into a tuple, this is so each individual element can be displayed in an entry. I am now trying to create a feature which reads what is in the entrybox and updates the record in the database. …

0
263
Member Avatar for James_63

I got two dropdowns in each product in my cart. When i select my both option my class on success is not updating the cost. It only updates when i refresh the page, i dont want to refresh my page to get the cost. this is my script... $(document).ready(function() { …

0
212
Member Avatar for saravind84

Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to …

0
231
Member Avatar for D137Pi

Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved …

0
241
Member Avatar for Peter_30

I have been working on this to replace every code that is shared on post in my website but is not working for me. I need everything that appear inside `<pre><code></code></pre>`to replay all the tags and give it a color using css. please if there is any simple way to …

0
131
Member Avatar for Abhishek_26

> i have bind 10 random post form json file in to marquee but the problem is arising , its show like list and showing as marquee works kindly check the code and the output , do some suggestion what to do . Thanks in advance <html> <head> <meta charset="UTF-8"> …

0
275
Member Avatar for fflime

I want to make countdown timer in multiple choice. I want to display question one by one. But when I click next for the next question, the time is start from 10 minutes again, not continue. How to make an alert if the time was over, it would be directly …

0
131
Member Avatar for glao

Hello ,I want to ask how can I succeed an analogous from mongodb to postgresql. app.post('/myjob', function(req, res) { var collection = db.collection('theDB'); collection.insert({ "my_id" : myID, .... }, function (err, mes) { if (err) { res.send("There was an error"); } else { console.log("Ok with ID "+myID); res.send({ "Done!", ID …

0
154
Member Avatar for sashiksu

HeY First I'm new to software developing side. I made some system abount money lending and some my teachers said that system good but there is wrong thing at finding profit/loss page. Therefore I want your advices guys ! :) In this system user can register new clients and also …

0
159
Member Avatar for sassy_94

Hello, i am new to storm and stream data. I have implemented a sketch algorithm in java with maven. The algorithm has as an input a continuous stream of integers. The result is an array of integer frequencies and i want to run some queries on that array, but i …

0
145
Member Avatar for Ts91

Hi Guys! im making a small website based around a very simple and basic mvc pattern (in this case just seperating files into different folders) Im currently stuck on selecting data from the database and displaying it. My model looks like this: <?php require_once('../Controller/config.php'); class Readings { public $dbconn; public …

0
237
Member Avatar for Hazuan Nazri

Hello guys, im trying to learn how to use dynamic data table, which means i want to use data table as my searching result table. but i dint know how to make it because when the search result filled in the table, the sort and other "DataTable" function is not …

0
139
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to get a posts comments within a Facebook group? I have tried using https://graph.facebook.com/{POST_ID}/comments?access_token={ACCESS_TOKEN} but all it returns is Array ( [data] => Array ( ) ) even though there are comments on my post.

0
103
Member Avatar for Stephen_10

Hello All, I have been working on a registration form for opencart for a while now. I think I am nearly there in how I have coded it. However I just do not know where I am going wrong with it. It is a standard form with text input fields …

0
102
Member Avatar for Khalida_1

Following is my code effort.... I want to read first line of file(comma separated) & then create table in JavaDB but stuck here... Please someone help me how to do next???? public class DatabaseDAO { public void FileRead(String st) throws ClassNotFoundException, SQLException, IOException{ String []tokens=null; try{ try (FileReader fr = …

0
103
Member Avatar for Chris920

Not sure if that is the correct title, but I created an additional field in the users profile. I want to add that field with the option to change that field (its a drop down) on the main homepage as well as profile page. It would be the exact same …

0
111
Member Avatar for md.Rayad

I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. set pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format …

0
241
Member Avatar for liphoso

Please help me with how i may receive an sms to my java application using ozeki. I have used sample code that i got from http://www.ozekisms.com/index.php?owpn=584 , I used that sample code and was able to send sms. Using the same code how may i receive an sms so that …

0
120
Member Avatar for edgar222

how can I select project from dropdown then execute query catching the value of the project selected I have the follow code using AJAX and JSP pages admin.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; …

0
160
Member Avatar for Dipanjana

Hi . I am writing sp that i will use for generating SSRS reports . In the sp , i hv passed month name as input parameter. I am able to get the required output but need to filter it based on months .i.e entries present for current month upto …

0
139
Member Avatar for 1111lt

I am getting an error message with my dapper code below. Any ideas? Thanks! Error 5 Cannot implicitly convert type 'Data.EmailAddresses' to 'System.Collections.Generic.List<Data.EmailAddresses> **1. Data coming from sql query** StudentId Gender EmailAddress 123456 Female maryjoe@gmail.com 123456 Female mary.joe@mycollege.edu 123456 Female mj@hotmail.com **2. Classes** public class Student { public string StudentId …

0
81
Member Avatar for staffmbm

I'm trying to make delete row function in primefaces datatable. I'm using this method: package logon; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import javax.annotation.PostConstruct; import javax.enterprise.context.SessionScoped; import javax.faces.bean.ViewScoped; import javax.persistence.EntityManager; import javax.persistence.EntityManagerFactory; import javax.persistence.PersistenceUnit; import javax.persistence.Query; @ViewScoped @SessionScoped @javax.faces.bean.ManagedBean(name = "logonTest") public class LogonTest implements Serializable{ @PersistenceUnit(unitName="Webbeans_RESOURCE_LOCAL") private EntityManagerFactory emf; …

0
119
Member Avatar for Benjamin_11

I am using the following query (thank you diafol) to group the top N rows in my data set: SELECT mgap_ska_id,mgap_ska_id_name, account_manager_id, mgap_growth AS growth,mgap_recovery, (mgap_growth+mgap_recovery) total FROM (SELECT mgap_ska_id,mgap_ska_id_name, account_manager_id, mgap_growth, mgap_recovery,(mgap_growth+mgap_recovery) total, @acid_rank := IF(@current_acid = account_manager_id, @acid_rank + 1, 1) AS acid_rank, @current_acid := account_manager_id FROM mgap_orders …

0
117
Member Avatar for Benjamin_11

![c68bc2737304743859f031861c0e27ae](/attachments/large/4/c68bc2737304743859f031861c0e27ae.png "c68bc2737304743859f031861c0e27ae") I have cretaed the data set above with a query and now I need to export ONLY a portion of it to a .csv file with PHP. The higlighted portions in the images are what needs to be exported to a .csv file. Basically, each time an account_manager_id …

0
95
Member Avatar for yaginuk

HI, I a have inhrited administration of a work database. we currently have the ability to export data to a xls file from a customers table, but i want to add employers information from the employers table i.e employers name, address etc along with each record exported. This section deals …

0
90
Member Avatar for mrkm1188

I have a Visual Studio form that is linked to a SQL database table. I am adding a query via a tool strip to search the database and I have the following text boxes the user can enter information into: Client, Project Number, Project Manager, ServerArchived, PaperArchived. The user does …

0
83
Member Avatar for Phillip_1

I am currently trying to link a mysql Stored Procedure to a Microsoft SQL Reporting Server. It is coming up with a Syntax error. I believe this is down to the Date_from and Date_to Parameters. The query is below any help would be appreciated DELIMITER $$ USE `mydb`$$ DROP PROCEDURE …

0
104
Member Avatar for gauri.ansurkar

How to validate textbox by allowing only characters, spacekey and backspace in vb 2010 utimate............plz help as soon as u can

0
90

The End.