2,569 Topics
 | |
| | I have the query below: $insert2query="INSERT INTO output_search(ref_code, title, author, channel_id) VALUES (select refcode,title, authors, $idquery as cid from chemoJ where title LIKE '%$search%' and refcode NOT IN (select exc_refid_fk FROM exclusions))"; It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the …  |
| | 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 … |
| | Hi, I am trying to get the the number of rows that are populated in a SQL Server table. I am using the code below but it only counts one row everytime when I know in fact that there are 47 row in a particular table. Could someone please point … |
| | $res=mysql_query("SELECT * FROM users WHERE username={$_SESSION['user']}"); This line is giving me a lot of trouble. It returns blank when it should be returning something. Anyone have an idea? |
 | Hi Dw. I have a timer that in every 600 interval access the database and the database I'm using is MS Access database. The problem I have is that with this being said, the MS Access database has a limitation of 64 connections on each thread so this 600 interval …  |
| | 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 … |
 | # MySQL Stored Routines: Another Useful Scenario # [In a past guide](http://blog.bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you … |
| | Is it possible to select values from 2 columns in order to calculate another column in the database table?  |
| | Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data from a vb.net datgridview. I have looked for a tool or examples but cant find any information that can point me to … |
| | 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 … |
| | Hello All, Is there any provision to ignore the trigger when i update a row in a table. Thanks, Loges |
| | 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 all, I'm using CodeIgniter with MSSQL and works ok for basic queries. But then I do the following: Add a varbinary(max) column to my table (new_col) Change the query in the model: `$this->db->get_where('user_stats_backup',array('new_col' => "0xD9E6762DD1C8EAF6D61B3C6192FC408D4D6D5F1176D0C29169BC24E71C3F274AD27FCD5811B313D681F7E55EC02D73D499C95455B6B5BB503ACF574FBA8FFE85")` When I load the page, it doesn't seem to be returning anything. I created … |
| | 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 … |
| | Hi all, I will be building a web application that does a personnel data lookup, unfortunately using SSN. So I’ve been searching for how encrypt this data so that I do not use plaintext SSN in the application to accomplish this. I found this article: http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx . Does this mean … |
 | How do I write a SQL query involving a time stamp? QUOTE_ID is a character string CREATE_DTG is a date time type RETENTION_LEAD_TRACK is a table This sql statement cmf.CommandText = "SELECT QUOTE_ID FROM RETENTION_LEAD_TRACK where CREATE_DTG > '2016 - 04 - 25 18:18:15.2891'" throws this error {"Conversion failed when … |
 | I want to insert a table cell into a table from another table by select method and after, to display an error in text prompted from the user was not found. Can someone tell what's the problem with my codes? My codes are as follows: Dim Item As String = … |
| | 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 { … |
 | Hi to all ! I need your help. Actually I have enrolled in final year project and chosed Data Warehouse. According to the project scenario I made dimension tables and fact tables. Before making star schema, I want that you check my dimension and fact tables. I am giving you …  |
| | Hey fellas, some time ago I started trying out Brackets, and guess what? Loved it! If you don't know, it's an open soude editor made out of html, css and javascript, powered by node JS and chromium and sponsored by Adobe. A lot of open sources projects coming together to … |
| | hey geet here.... i have one query please if any body know about then plz help me....... i m on trouble..... actually i am creating a project of online quiz ..and on that( question and answer section) but i dont knw how to do coding in admin section asp.net (c#) … |
| | Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number |
| | 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 … |
| | Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!! |
| | Hello! I have written a simple program which connects netbeans with SQL Server database. The program is giving an exception. I am displaying the source code of my program and exception below. Please guide me to solve this problem. public class dbconnection { Connection con = null; public static void … |
 | I am importing data from excel into datagridview its kind of working fine. my data is like this in excel 10001 MR NEW 10002 MR OLD 10003 MR CLEAN 1MB21 MR DIRTY 1BA12 MR DIXON 1EA12 MR RYDER When I load the data all is loaded untill it gets to … |
 | 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 … |
| | Hi Friend, dtpdate datetime that's my field and datatype in vb.net use dtpdate.text Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. please solve my problem. Thanks & Regards |
| | 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 …  |
| | Hey I have 4 computers. 1st computer is my server machine. I want to install mysql on these computers. Can anyone help me to do that ? * I want to know how to install mysql on server pc ? * Also want to know clint machine ? |
| | 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. … |
 | Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it … |
| | 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 all, I currently have two tables that look like this: COMMENTS +----+-------------------------+--------------+---------+---------------------+----------+ | ID | comment | profile_post | creator | created | approved | +----+-------------------------+--------------+---------+---------------------+----------+ | 1 | This is a test comment | 3 | 1 | 2016-02-26 12:26:36 | 1 | | 2 | 0 | …  |
| | 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. |
| | I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …  |
 | Hi, I have a scenario like XYZ company is creating a User management System , which allows to purchase for different company , so based on the package the system provides options to save last three or five user password to check and the max is ten . XYZ---| Total …  |
| | Hi, CREATE PROCEDURE `FindDuplicateExpenses`(IN `strExpenseDate` DATE, IN `strProfile` VARCHAR(50)) NO SQL SQL SECURITY INVOKER SELECT PD.Code, PD.ExpenseAuthorizedRefAmount, PD.FullName, PD.ExpenseDate, PD.ExpenseNatureID, PD.Ignore_Expense, PD.Profile FROM tblExpenses AS PD, (SELECT Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID FROM tblExpenses GROUP BY Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID HAVING COUNT(*) > 1) AS SUB1 WHERE PD.ExpenseAuthorizedRefAmount = …  |
The End.