2,569 Topics
 | |
| | 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 … |
| | Hello Below is the schema with sample data of table es_preadmission  I am trying to get the number of male and female students from each categories (GEN, SC,ST,OBC), bpl, sgc, handi,ser_cat class wise. Example class 1 => GEN => Male = 3, class 1 => GEN => Female … |
| | i have 3 tables and i want to display companyname,maincategory,city,place 1.SELECT `id`,Companyname from spa 2.SELECT `id`, `mainCatagoryid`, `RelatedCatagory`, `spaid` FROM `relatedcatagories` SELECT `id`, `MainCatagory`, `name`, `size`, `path` FROM `catagorykeywords` SELECT `id`, `Subcatagory`, `MainCatid` FROM `subcatagorykeywords` 3.SELECT `id`, `city_id`, `state_id`, `spaid` FROM `city_place` SELECT `city_id`, `city`, `state_id` FROM `cities` SELECT `state_id`, … |
 | I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name (varstring) I want to order by Time_Stamp and Time_stamp_ms and then each time cycle reaches 1, I want to get … |
| | 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 … |
| | I have a Visual Studio form that is linked to a SQL database table. I am adding a query via a tool strip to search the database and I have the following text boxes the user can enter information into: Client, Project Number, Project Manager, ServerArchived, PaperArchived. The user does … |
| | i have a text field with name "date" and i want to retrieve all he records from database when user write a specific date on that text field.......I am using MS access data base......Query below is not showing any record String date=request.getParameter("OrderDate"); String query = "SELECT * FROM DoorStepRequests where …  |
| | 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 …  |
| | Hi, I have the below datatable created through my C# code: Stock TotalPrice Qty TransactionType XYZ 400 10 BUY ABC 800 20 BUY XYZ 800 20 SELL ABC 400 10 SELL I want this datatable to be processed by LINQ / LAMBDA expressions in such a way that will give … |
 | 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()); … |
 | 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 … |
| | Good afternoon, I'm trying to formulate what should be a simple query that will create a result set of ALL records from a table that have a date that is in the previous month... Basically something like this one that I use that gets any records prior to the current … |
| | how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ? |
| | [code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite") MessageBox.Show("connection established") sql = ("select newuniqueid,newteh_code,newpcate_cd,newplano, pen_nm,rel_cd,pen_fnm,ccate_cd,pan_code,pvillage,ppo_cd,spo_cd,start_qtr,last_qtr,bundle_typ,bundle_no,mo_srno,pen_amt,pen_comm,status,operatorcode from ekalyan.welpen") cnn = New SqlConnection(connetionString) Try cnn.Open() cmdd = New SqlCommand(sql, cnn) cmdd.ExecuteNonQuery() cnn.Close() MsgBox(" ExecuteNonQuery in SqlCommand executed !!") Catch ex As Exception MsgBox("cannot … |
 | 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. …  |
| | Hey all, I am trying to update submissions from my SQL database from an edit page via an edit link in line with the submission which captures the ID of the database entry. When I click the edit link a new page opens and it has a form to update …  |
 | Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records … |
| | Good Morning All, I'm about to write a script that will actually be run in a CRON job weekly. I created an overview of the process so you would understand what I'm doing but I have questions with 2 of the MySql queries that will be required, and wondered if … |
| | I m getting the following error when trying to add a .mdf file and .log file to my account on somee.com ERROR--> "You don't have the permission to open this file, contact the file owner or a administrator to obtain permission". I need to get my database on the server …  |
| | 1. For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will. 3. For each directory, print out his name, in which directory it is located, and how … |
The End.