6,934 Topics
 | |
| | i want to Calculate and list the average response time taken from the current set of job recruitment records, i.e. all the communications between the School and casual candidates for the express Job, and then update the response time for each casual staff according to updated response time =(currentresponse time …  |
| | Hi, I am new to mobile app development. I would like to know what is the best way to connect to backend, I have a database in sql server 2005, and a web application in C#.NET. Now I would like to have a mobile app of that application. But fairly …  |
| | ----------------- sql ------------------------- CREATE TABLE IF NOT EXISTS `friend` ( `uid` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(30) DEFAULT NULL, `friends` text, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `friend` -- INSERT INTO `friend` (`uid`, `username`, `friends`) VALUES (1, 'admin1', 'a:2:{i:0;s:1:"4";i:1;s:1:"5";}'), (2, 'admin2', … |
| | SELECT t.* FROM (SELECT * FROM jobs WHERE `status` IN (0,1,2,3) ORDER BY `status` DESC, job_datetime LIMIT 11, 20) AS t That's a cut down sample of my sql. It was more complicated, but I've pared it down to this just to see why I was getting some strange numbers …  |
| | I'm trying to use a drop down form box & select statements to gather certain pieces of information from my database however i'm recieving the error **Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /study/comp/c3329871/webpages/mysql/queryContinent.php on line 26** This is the code from my php file … |
| | Hello guys, i need a help slightly with this project of my university. my equipment are working with some components, 1. Radius Server - MySQL - OS Linux Ubunto 12.04 or OS Microsoft WindowsServer2008 - SQLServer. 2. Router Linksys Wrt-54g 3. Other Server with certification unit, which we need manage, …  |
| | Hi, I am having some trouble, i am trying to create a site just to learn ASP.NET c#. I am stuck though trying to get values from my database, i want to say if the "customer" is logged in that i can display his address details some textboxs. Similar to … |
| | protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { int c=0; String u1=request.getParameter("u1"); String e1=request.getParameter("e1"); String user=request.getParameter("user1"); request.setAttribute("u1",u1); request.setAttribute("e1",e1); request.setAttribute("user", user); out.println("welcOme"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("Jdbc:Odbc:db5"); String str = "select * from Table1 where email=?"; out.println("welcOme"); PreparedStatement statement = con.prepareStatement(str); statement.setString(1,user); ResultSet … |
| | trying to view a game on website but comes up with error 'ERROR gc_g2 - Game not availible!' the PHP code that launches the game is as follows <? /*********************************************************************** Jackpotsoft GamingCenter™ GAME LAUNCHER v1.0 ************************************************************************/ Error_Reporting(0); unset($l); session_start(); session_register($l); include ("includes/config.php"); include ("dbcon.php"); if(isset($l)){ if ($mode=="fun" && $l!="guestlogin") { … |
| | hi i need some help, i need to creat a file in access 2003 running a aplication asp.net (c#) using a sql query, if anyone knows that plz tell me:) thanks |
| | Hi, i have a Sql Server 2008 database, with a table that has around of 2.000.000 registers. The schema of the table is the following: idSpecie (PK, int) | Kingdom | Phylum | Class | Order | Family | Genus | Specie The kingdom, phylum, class, order, family, genus and … |
| | Hello, I need to trigger an insert statement into my SQL database every time certain buttons are pressed. There are a total of 6 buttons, which makes having: string connString MySqlConnection conn = new MySqlConnection(connString); MySqlCommand command = conn.CreateCommand(); etc, etc. 6 times over in each button seem very inefficient …  |
| | Hi ok so i want to read images from an sql server database..the images are saved in bytes but im struggeling to retrieve them my code for the retrieving this is the code i used to save the image and its working. Dim sql As String = "INSERT INTO item … |
| | Hi, I have a stored procedure that will display an activity if the user enters the correct appref. This stored proceudre works fine on SQL management. However when i bind it to the gridview on my page it doesn't work on the internet, keep getting the error. Cannot open database … |
| | Consider you have a website visited by millions of people. 50 people or so fill in a registeration form and both press submit at exactly the same moment. Can SQL deal with all these requests at the same time, is there any chance it will accidentally generate the same primary … |
 | This code to save, Edit and delete data in VB.Net using SQLServer as backend. this code is continuance from my previous post "Show Data in DataGrid with VB.Net 2003 and SQLServer 2000". so i didn't write code how to connect SQLServer 2000 with VB.Net 2003 cause this already in there. … |
| | hello, i have a project and im a beginner in this type of programming.. im using sqlcserver 2005 to connect into visual studio 2010.. may i ask what is the correct syntax connection string.. i have my code already but i can not connect because there is an error stating … |
| | Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create … |
| | I'm developing a website, so when a user hits a button the following sample sql code is run. This is for registeration and basically meant to take information entered in a form and save it. BEGIN TRAN *sql code* *sql code* COMMITT TRAN BEGIN TRAN *sql code* COMMITT TRAN IF … |
 | Hello there, I need help to create simple rank system 1st thing I need is how to number the players in my database from 1 to ...... so if I create multipage in each page there is the actual rank for them 2nd : I need to create change indecator … |
 | i have two tables with the following columns: departments: departmentID tinyint not null department varchar( 30 ) not null employees: employeeID SMALLINT(5) not null departmentID tinyint not null firstName varchar(30) not null lastName varchar(30) not null how do i create the two tables using SQL with a foreign key linking … |
 | I am writing a program for a company and would like to limit how many users can use this program at one time. IE if they have a 3 user licence when the 4th user tries to log in it wont let them. I have no idea how to accomplish …  |
| | I need to split my Access 2007 .accdb and place the back-end on SQL Server 2008. I am not able to utilize SSMA due to security reasons. SQL Server resides on a different machine from the Access Database. I tried looking for books or tutorial to no avail to any … |
| |  |
| | anyone please explain to me what is the diffrence of this two query select * from tbl_Booking where [Date of Pres] between 'October 11,2012' and 'September 17,2012' (this query can display the information) select * from tbl_booking where [Date of Pres] between 'September 17,2012' and 'October 11,2012' (while this query … |
| | I just task with sql related Syntax,using ERP software.How i want to more about sql database?  |
| | Hey guys. I am trying to move a SQL database from one SQL server to another. One is SQL server 2003 and the destination is running SQL server 2008. Can anyone provide some guidance with this. I have never done this before so any pointers with be greatly appreciated! Thanks! |
| | How do I do that using SQL queries? I need a code to do that: For every "Name" on "names" column on DataBase, do this: { name: 'NameX', data: [Value from name X] } I need a code to display in categories, all names that theres in the "names" column … |
 | if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this app1 will retrieve first 500 records app2 will retrieve next 500 records means no over lap SET Transaction Isolation Level … |
 | Hello, I am trying to migrate sql file from one computer to another computer. And while trying to import the sql file these error appears why is it? I am trying to migrate sql from Joomla. Pencarian SQL: -- -------------------------------------------------------- -- -- Table structure for table `nafqc_usergroups` -- CREATE TABLE … |
| | Hi Thgin i seek is to create a connection (android) to the latest postgresql 9.2 database. Theat is running on a distant server. Can i Do it? Is postgre 9.2 JDBC driver fro andoid out? & little bit distant question. If the prevous is doable. How i an write tet …  |
 | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
 | Hello! I want to add query to report viewer, but i don't know how. I can't find a tutorial that does what I need so please help me po. I want to fill the data tables or report viewer of datas coming from different tables. Here is my sql code: … |
| | i have three db tables products product_id- Name 1 | hairoil 2 | lotion 3 | cream Countries country_id- Name 1 | UAE 2 | France 3 | UK Now i wanna that when select multiple countries for one product from Html form, then in third db table should insert … |
| | Hi All, In my table (dbo.partha) i have three fields. the first one is id, 2nd one is CM_Name and the last one is empid the table looks like id name empid 1 Das 5 2 Ram 9 3 Abi 5 1 Wed 5 4 Sat 4 5 Sun 3 … |
| | Hye, can one please explain to me about the code below. I need to know what exactly should be inside Field1 and Field2? I'm new to vb.net. I know that tbltemp should be the name of our table but im confused about the Field1 and Field2. Dim strSQL as String …  |
 | C#, SQL SERVER 2005 first. Sorry for the bad english :> can anyone give me ideas, techniques, theories, or any posible solution. Here is a scenario i have a form called SearchItem and a database table doc_Item doc_Item has a 1 million. . . data. when i click a button … |
| | Hi, An event proxy is responsible for reading in the input file (see details below) and forwarding events (updates and queries) to either a query client or an update client. All events (i.e. including updates, queries, and system failures etc) are specified in an event file which is called Input.txt … |
| | How can I avoid negative numbers from being inserted in my database table? i have a code that works but will not prompt until the value itself in the table is below 0. $nega = mysql_query ("SELECT * from `bgl` where product_code = '$product_code' and stock > 0"); $row = … |
| | i have a login page within asp.net 3.5 (c#) website, and sql server 2008 at backend, i wrote a store procedure to save password in hashed form using SHA1 algo during registration , now during login i want to compare etered passowrd with the one save in db, so i … |
| | I need help!! What I want is when I add a new teacher, it will search the tblteacher_info. If there is already a record of that teacher, it will just update his/her record. If there is no record of that teacher, it will add his/her info in the tblteacher_info. I … |
| | Hello, I'm building an application with asp.net. And I need to send emails to selected customers. What is the best way to send email ? Is it by using System.Net Class or to send it by using MS Sql Server ? Thank you Paul |
| | i want to hash my password to SHA1 algo, in asp.net code and then want to compare it with hashed password in sql 2008 db, for login so how to hash it in asp.net code ? |
 | Hello Everyone, ASP.NET (C#) I have problem in retrieving the images from Table created in SQL Server Management Studio. Actually I had uploaded the images into folder in the Application Server on Visual Studio and the path of the images is given in the Table Attribute. Thus I have table … |
 | i have this two tables fields: table1 (BOQSectionsAndParts_ID,BOQSection,BOQPart,ProjectNO) BOQSectionsAndParts_ID is a primary key table2 (BOQItemEntry_ID,ProjectNO,BOQSectionsAndParts_ID,BOQ_Item) BOQItemEntry_ID is a primary key and BOQSectionsAndParts_ID is a forign key. this is a sql server in my vb forum : i view the BOQ sectin as a combobox what i need is when the … |
| | HI I am very pleased to join this forum I am new to SQL programming , I am facing a challenge our sql server database entry is crossing 1lakh per day,so connection becomes slow.... For this how can i handle the situation!! our databases deals with leads and hits in … |
 | SQL> DESC TOPPING; Name Null? Type ----------------------------------------- -------- ---------------------------- TOPPINGID NOT NULL NUMBER TOPPING VARCHAR2(10) TOPPINGTYPE VARCHAR2(5) TOPPINGCOST NUMBER(4,2) SQL> DESC PIZZATOPPING; Name Null? Type ----------------------------------------- -------- ---------------------------- PIZZAID NOT NULL NUMBER TOPPINGID NOT NULL NUMBER SQL> DESC PIZZA; Name Null? Type ----------------------------------------- -------- ---------------------------- PIZZAID NOT NULL NUMBER PIZZANAME … |
| | I am working on a VS2010 Winform (not ASP web form). I have a copy of the local database on my computer. In this application, I have 3 forms in my application that need to connect to the same database, but different tables. Right now I am defining my connection … |
| | Hi so I'm making a site for sneakers. A person can sign up and say they like Nikes, Vans, Reeboks, etc. I then have it where you can make a group for people who like certain sneakers as well. So the group can say they like Nikes, Vans, Reeboks, etc. … |
 | Ok let say i have the following xml file <Users> <User> <Name>David</Name> <Attempts> <Place>Paris</Paris <Date>3/29/2012</Date> <Duration>50 seconds</Duration> <Distance>100</Distance> </Attempts> <Attempts> <Place>New York</Paris <Date>7/28/2012</Date> <Duration>30 seconds</Duration> <Distance>100</Distance> </Attempts> <Attempts> <Place>Paris</Paris <Date>8/19/2012</Date> <Duration>70 seconds</Duration> <Distance>60</Distance> </Attempts> <Attempts> <Place>New York</Paris <Date>9/29/2012</Date> <Duration>60 seconds</Duration> <Distance>200</Distance> </Attempts> </User> <User> <Name>Lenny</Name> <Attempts> <Place>Paris</Paris <Date>9/29/2012</Date> <Duration>51 seconds</Duration> … |
The End.