2,570 Topics
 | |
| | Hello , I wanted to ask if for these statements in mongo: collection.find({},{}).toArray(function(err, result) { collection.find({email : req.user.email},{}).toArray(function(err, result) { the equivalents in postgresql are: client.query( "SELECT * FROM theTable ", function(err,result) { client.query( "SELECT * FROM theTable WHERE email = 'req.user.email' ", function(err, result) { result should be automatically … |
| | 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 … |
The End.