2,570 Topics
 | |
 | Hi Folks, I am having problem with my web design. I am making a query that involves two table but it doesnt do anything when i click submit. do i make mistake in the query ? my code is like this, <?php if ($_POST['action'] == 'show'){ $requestCompSql = "SELECT REQUEST_COMPONENT_CUTTING.PROJECT_NAME, …  |
| | I am new to Qt and I'm trying to connect a remote database. QSqlDatabase db = QSqlDatabase::addDatabase( "QMYSQL" ); db.setHostName("IP ADRESS"); // local or IP db.setPort(3306); // Default port is 3306 db.setUserName("DB USER"); // example root db.setPassword("PASSWORD"); db.setDatabaseName("DB NAME"); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." … |
| | Hey guys I have found this code to create a quiz, I'm getting the following errors when I try and add a question Warning: require_once(scripts/connect_db.php): failed to open stream: No such file or directory in C:\xampp\htdocs\addQuestions.php on line 33 Fatal error: require_once(): Failed opening required 'scripts/connect_db.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\addQuestions.php on … |
 | I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click but what I would like to do is use a button to select the row. I.E the user could select row one, click the button and row one would be selected then … |
| | Hi I need to delete words before a set of words in a field. eg delete the words before the word price in that field. I already have a query to replace a certain word but cant see how adapt it to do what I require update TABLE set `field` … |
 | Hello to everyone. I have this table: CREATE TABLE `documents_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I am trying … |
| | Hi, I was wondering if there's a way to check an existing id in the main table when using temporary table,then use another id for inserting records.Since it may cause error for using the same id in the main table. Is there a way to do that? |
 | Ok, I ve been struggling for the last two weeks to get my webservice working on somee.com. I managed that. Then my database corrupted but managed to get it migrated it to mysql before that and everything' s fine. Now the final problem that I have and just can't solve … |
| | 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 … |
| | I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we …  |
| | Hi guys i want to make database for payroll only but i dont know how to make structure for this suppose i want to calculate payroll every month for employees as following basic salary bonus overtime absence deduction meaning salary = basic salary +bonus+overtime-absence-deduction How i make database (ERD)Diagram for … |
 | dear friend i want to insert a row in orecal which is insert into employee ('AMIT D'SOZA', 'MANAGER','500') thorugth php but there is problem to insert data like 'AMIT D'SOZA' so i want to restrict "'" (singal quets ) to enter in text fields plz help me if you have … |
 | Hey guys, I'm not very familiar with asp.net (Doing this in c#) or session cookies for that matter, just the basics. Trying to store a list of items in a session cookie, then when needed, pull those items back out as a list to then use them in a MS …  |
 | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks |
| | COMBINATION_ACIL contains column: id (primary) prodcode [group] alias lastupdate updateby and here is the steps when i import xml to sql DECLARE @COMBINATION_ACIL AS xml SET @COMBINATION_ACIL = ' <Product> <product> <PRODCODE>CADB</PRODCODE> <GROUP>CADB</GROUP> <ALIAS>ADB</ALIAS> </product> <product> <PRODCODE>CI50</PRODCODE> <GROUP>CI50</GROUP> <ALIAS>I50</ALIAS> </product> <product> <PRODCODE>CI80</PRODCODE> <GROUP>CI80</GROUP> <ALIAS>I80</ALIAS> </product> <product> <PRODCODE>HOSBA</PRODCODE> <GROUP>HOSB</GROUP> <ALIAS>HOSBA</ALIAS> </product> … |
 | I'm trying to create a table but I keep getting errors: Here are the errors: mysql> source Tables3.sql; Database changed ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at …  |
| | I found a php class that seems to help me achieve my objective of doing an advanced search of my database <?php class search { var $table; var $field1; var $field2; function queryRow($query){ //define database settings define("host", "xxxxxxxx"); define("login", "xxxxxx"); define("senha", "xxxxxxx"); //define database name define("data", "xxxxx"); //conection routine try{ … |
| | Hi, i have develop an window application using **VB.NET** and** SQL SERVER2008R2**.I have Sql server2008R2 installed on my system containing sql database file.I have my connectionstring in app.config file as:- <appSettings> <add key="mycon" value="Data Source=My-pc;Initial Catalog=MovieCatalog;User ID=sa;Password=pwd123" /> <add key="ClientSettingsProvider.ServiceUri" value="" /> </appSettings> Now what i want to do is … |
 | Dear all, I have been thinking of this task, but I have no idea where to start from. I am retrieving login logs from the database, which is cool. Now, the challenge is that in case a user has logged in more than once in the same day, I want … |
| | anybody to help me query two database tables containing different data between two dates and results given sequencially dependending on this dates on either of the two said tables |
| | Hey there. I'm building a project in PHP/MySQL and it is a sort of [FaceMash](http://en.wikipedia.org/wiki/History_of_Facebook#Facemash) project. I am able to call the images (with image name and points) from the database. I have managed to use the MySQL Update query in order to increase the points that each image gets …  |
| | Hi guys I know this might be a repeated post, someone has looked at the code and they seem to think that it all look fine, but I'm getting this following message again Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\submit-form.php on line 19 The following SQL Failed INSERT INTO 'users' … |
 | Hello Everyone, I am trying to achieve pagination using jsp javascript and servlets. Here is my code below: SearchUserViews.java `package TestPackage; /** * * @author Sagar */ private String _userid; private String _firstName; private String _lastName; private String _emailAddress; public userProfile(){ _userid = ""; _firstName = ""; _lastName = ""; …  |
| | Here is my PHP code: $fields=array('eventID','eventTitle','te_events.venueID','te_events.catID ', 'eventStartDate','eventEndDate','eventPrice'); // initialize empty array for WHERE clauses $wheres=array(); // loop through field names, get POSTed values, // and build array of WHERE clauses, excluding false values foreach ($fields as $field) { // get existing field value from POST, mark missing or empty … |
| | i am not able to connect to the sql server on my system. SqlConnection^ connection=gcnew SqlConnection(); connection->ConnectionString ="Data Source=blueboy\sqlexpress;Initial Catalog=DCV_DB;Integrated Security=SSPI;Pooling=False"; i got the string from database properties.(i have attached the same in this post) sql service is running. tcp ports are enables too. |
| | i have a works to create table report like in attached image.  i don't know how to arrange the days and grouping as Time, thank you for help... |
| | So, if - like me - you find yourself in need of installing SQL Developer on Ubuntu 12.04 and have for some or other reason ended up downloading the rpm instead of the zip from the Oracle [site](http://http//www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html) or you already have an rpm of SQL Developer lying around follow … |
| | We're learning pl sql in class, and I was just wondering if anyone noticed any glaringly obvious errors in my code? --Gets the phone number of a specific member set SERVEROUTPUT on DECLARE phone_number Member_T.Phone%TYPE; BEGIN SELECT Phone INTO phone_number FROM Member_T WHERE MemberCardNumber= 2436322287; DBMS_OUTPUT.put_line (phone_number); END; --Uses a …  |
 | I have huge csv file that i need to load into database using sql loader. In the file, there are columns enclosed by ", but some of them is not and in these columns there are single quotes and I would like to know how to deal with them (I …  |
| | Hi Guys as I have mentioned before I'm having problems with connecting my website to a sql database, config.php <?php ini_set('display_errors', true); // change to false when you go live error_reporting(E_ALL); //Mysql Connect | mysql_connect("host= 3306","username",""); //Below example to connect in localhost //$a=mysql_connect("localhost","root",""); if($a == false) { die("Connect failed: ".mysql_error()); … |
The End.