[query] Forum Topics

Hello, I have the below case. CREATE TABLE "PRBT"."TM_TABLE_1" ( "NID" NUMBER, "STRNAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, "NORDERCODE" NUMBER NOT NULL ENABLE, "NSTATEID" NUMBER DEFAULT 1 NOT NULL ENABLE, "STRDETAILS" VARCHAR2(256 BYTE) DEFAULT NULL, "STRAUTHOR" VARCHAR2(128 BYTE) NOT NULL ENABLE, "NPICTUREID" NUMBER DEFAULT NULL, "STRLATINNAME" VARCHAR2(512 BYTE), "STRLATINAUTHOR" VARCHAR2(512 …

Help me sir for this error, Connect Error (2002) No connection could be made because the target machine actively refused it. my connection //my database class class Db { // make sure we dont connnect database to every function public $mysql; function __construct(){ $this->mysql = new mysqli('10.100.2.234','sa','P@ssw0rd','PLAZATOYOTA_MSCRM'); if (mysqli_connect_error()) { …

Hi Everyone I hope I find you well this beutiful day. I have two dialog modal popups that I want the webpage to refresh on when the dialogs are closed. The code I am using looks something like this: <div data-role="dialog" id="dialog1" class="padding20" data-close-button="true" data-overlay="true" data-overlay-color="op-dark" width="1000px" height="400px"> <h2>Heading</h2> <div …

Let's say I have such table: +----+------------------+ | id | participantsId | +----+------------------+ | 1 | 1,24,192,3481,12 | +----+------------------+ I'd like to select every single result in this table, where user with ID `3481` has partcipated. How can I do that? Ye old `SELECT * FROM example WHERE paricipantsId=$id` won't …

see why is is not working its not taking combo name why

Hello, I try to limit query results and fetched items in same time. But, with my script, that is not functioning together. Selected item is not staying as variable in query. Something is badly ordered in this script. <?php if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { $startrow = 0; } else { …

https://jsfiddle.net/jLt3reca/ `nav a div { display: none; }` is being ignored. I don't know why, it's just these 3 simple "selectors" on to another, I really can't see it. In `<nav>` there's a `<a>` and there's `<div>` in this `<a>` that needs to be hidden. It doesn't hide. This isn't …

Hello Daniweb Community, I've been looking around online for help with this but I can't seem to find a way to get a query to do what I want. The image below should pretty much say what kind of result I'd like to get, it's pretty much merging the tables …

I am passing string, but in mysql query not executed. because IN not taking integers please check and solve this one. My query not working SELECT * FROM `employee` WHERE `employee_id` IN (1001,a/bb/001,a/bb/002,a/bb/003,a/bb/004,a/bb/005,a/bb/006,a/bb/007,a/bb/008,a/bb/009,a/bb/010,a/bb/011,a/bb/012) ORDER BY employee_name ASC correct one is SELECT * FROM `employee` WHERE `employee_id` IN ('1001','a/bb/001','a/bb/002','a/bb/003','a/bb/004','a/bb/005','a/bb/006','a/bb/007','a/bb/008','a/bb/009','a/bb/010','a/bb/011,'a/bb/012') ORDER BY …

I checked my spellings and everything for so many times already Here's the code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If Not cnn.State = ConnectionState.Open Then 'open connection if it is not yet open cnn.Open() End If cmd.Connection = cnn 'check whether add new …

I want to build a mysql query to search comma-separate string with in another comma-separate string. For example : search string '1,3,5' from '1,2,3,4,5,6' What will be the mysql query?

Hi, I need a help from you. I tried but I can not. Can anyone tell me how to increase the font size in mPDF, Here is the code, where I tried, require('mpdf/mpdf.php'); $mpdf=new mPDF('C','legal','10');

Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. …

Hey I have a problem with execute query into sql I got an error I want to add query like sql into sql can I put query by click on new query then i execute it I need to make the same idea but without open sql I need to …

Currently I have something like this (a bit modified): function function1($param) { $ans = @file_get_contents($param); if (!$ans) return ("Failure"); return json_decode($ans, true); } Extremely straight forward. However, the `file_get_contents()` gets answer from an API, that has proven to be a little stinky boa. It sometimes answers incorrectly, or "Access Denied" …

Hello, I am working on a project for online store but i am getting the error Fatal error: Call to a member function querry() on a non-object i have tried everything i can think of, please help me, i am in a bit hurry. Here's my code init.php : <?php …

Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ?

Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. …

i have an access database with table relationships, queries and i want to convert into mysql is there any free software that can help me to do it, i searched for MySQL workbench but its not opening in windows 7 64-bit

hi thrr is no one who can help me this is the prog which when i run faces problem of session. [B][U]session_start(): Cannot send session cookie - headers already sent [/U][/B] pls plssssssssss help me to solve the problem below is the code any one this is simple prog but …

Anybody help me ? I need a php script that will run automatically every day on Morning 09:00 O'clock. But my script not working. My script. <?php date_default_timezone_set('Asia/Calcutta'); $now = date("h:i"); $base = '09:00'; $to = 'test@mydomain.com'; $subject = 'My Subject'; $message = 'Hello'; $headers = 'From: test@mydomain.com' . "\r\n" …

i am trying to generate daily,monthly,and annual report of contractor from stored data which include id,in time,out time,late in time,early out time, my project is in advance java i have used CRUD in each module,and phpmyadmin i ll be glad if i get answer of my question.

hey , I'm at unhandled error. if you can give me help I apreciate it :) when I run software it say "connection already open". I find all, but I can't find. If Len(Trim(txtloanids.Text)) < 4 Then MessageBox.Show("Please Check Custormer ID", "", MessageBoxButtons.OK, MessageBoxIcon.Warning) txtloanids.Focus() Exit Sub End If query …

I have a list of objects that having becode as string(setter,getter),i want to set the ststus as "active" for all the becodes.below is my query.but its giving exceptions as "java.lang.ClassCastException: com.rogers.tpia.model.updatetpia cannot be cast to java.lang.String".pls help me u will get appriciated. public void activateUser(List<updatetpia> act){ Session session = sessionFactory.getCurrentSession(); …

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 …

Im making a website that works around a very basic MVC structure. I have three folders, the Model, View and Controller. I want to display the content of the database in the dropdown once the page has loaded. My view has: <div id="appCalc"> <form id="applianceCalc" method="POST" > <?php if(isset($error)) { …

Hi all can you help me I really don´t know why my web app is being deformed when a message is shown I Been trying the update panel but it just does nothing when try to retrieve information from a database in access

I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | …

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 …