1,694 Topics
| |
Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance. | |
Hi guys hope your all well, I want to put a quiz into my website that I'm doing. I've found some code for a Multiple Choice-True False Quiz Here is the code, (yes I know its long and there are some reputation in it) You have to add questions by … | |
Anyone will help me to solve this? this is about ER diagram and some other stuff about database. This is the exercise: ----------------- "Project a DataBase to support a architectural studio which offers its customers proposals refurbishment. Each component of furniture ( table , chairs , ... ) is characterized … | |
I am importing data from an excel worksheet in to a sql table, one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data for example the number "5900397732209" is … | |
I am developing a C# Windows Form Application. Now i am trying to select value from Listbox and load corresponding value in List view using the stored procedure. And this is my stored Procedure: ALTER PROCEDURE [dbo].[spPOExport] @BST_BESTELLUNG INT AS BEGIN SELECT BH.BST_LIEFERANT AS Product Name, BZ.BDT_REFNUMMER AS Unit Price, … | |
Having problems with a malware I had to reinstall Win7 OS with recovery mgr.After I had to reinstall all my web development tools such as Visual Basic Express 2008, Visual Web Developer Express 2010, SQL server express 2008, MySql, Workbench.I cannot reinstall PHP and PhpMyAdmin no matter what I try. … | |
Hi all, I've a problem with my insert sql..I didn'y know why. here is my insert sql $goodsDesc = $_POST['goodsDesc']; $k8goodsQty = $_POST['k8goodsQty']; $valuePerUnit = $_POST['valuePerUnit']; $sql_k8goodsIn = "INSERT INTO k8_goodsin (k8regID,goodsDesc,k8goodsQty,valuePerUnit) VALUES ( '".$k8regID."', '".addslashes(strtoupper($goodsDesc[$y]))."', '".$k8goodsQty[$y]."', '".$valuePerUnit[$y]."')"; for goodsDesc the input is like this goodsDesc = 2-1/2" suction pump … | |
| I'm wanting to create an sql table, when a user registers at my site. This table will eventually be used to log messages. The code follows: <?php require('../connect/kidsblogsconnect.php'); $name=trim(mysql_real_escape_string($_POST['name'])); mysql_query("CREATE TABLE '$name'('sender' VARCHAR(30), 'message' VARCHAR(300), 'dateposted' DATE)") or DIE(mysql_error()); ?> When I run it, I get: You have an error … |
Hi, I have created a databse using sql database "TestingSQL" using microsoft management studio 2012 and created a simple vb application as a tryout. It works well in my pc and i would be able to access remotely as well. But the problem is, it is only works with my … | |
I have an identity (auto-increment) column in my mssql table, which is also my primary key. I want to use these numbers on my form, such that when I open that form, the auto-increment id will already be displayed on a textbox (so I wont have to type it in … | |
below is the code which select value from the database and increase it by 2 and update the database with the new value. how do I lock or prevent multiple read and update at the same time? please help Dim query2 As String = "select * from " + usern … | |
hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins … | |
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 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? | |
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{ … | |
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 … | |
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. ![90ef46840e7046051c341009f30ee8ca](/attachments/large/4/90ef46840e7046051c341009f30ee8ca.png "90ef46840e7046051c341009f30ee8ca") 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()); … | |
I all as anybody tried, passing a pdf tha is in memory stream and so it directly on a div, without the creatio od a file?? Best Regards | |
Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with … | |
Hi everyone, I'm new here and is in need of some help. I'm trying to complete my project, however I'm stuck at writing the data from the sql into the vb.net/asp.net gridview. Was never good at database to start with and I had never learnt how to query from VB.NET. … |
The End.