2,569 Topics
 | |
| | I've inherited a small C# command line program that takes a date and creates several spreadsheets containing data pulled from a microsoft sql server database based on that supplied date and some names hard coded into the program. I'm looking to change the program to pull the data from a …  |
| | Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from …  |
| | Can anyone assist me. I keep getting and error stating that the Column count doesnt match row 1. I have counted all of my fields and referenced all of them but still no dice. $con=mysql_connect($host, $username, $pass); if(!$con) { die("Could Not Connect: ".mysql_error()); } mysql_select_db($db); $CustLName=$_POST['CustLName']; $CustFName=$_POST['CustFName']; $CBR=$_POST['CBR']; $AcctNum=$_POST['AcctNum']; $CustCode=$_POST['CustCode']; …  |
| | Hey everyone, So I'm starting a new thread because my other thread was solved and I had forgotten it was. Anyway, I am creating a forum stite from scratch as a side project and I have a main forum page that "includes" two tables that get data from three different … |
 | Hello dear ALL I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e … |
| | i have 2 dropdownlists and a submit button when i should click the submit button the selected values shold be taken as input parametres for filtering and populating the data in gridview? |
| | I'm managing a server running Windows Server 2008 R2 for a client and after investigating some high memory usage, I discovered that the Windows Internal Database SQL instance is using over half of the server's RAM. Capping the instance's memory usage is easy, but unfortunately my user account (which is …  |
| | so i now how to write quies and really really easy. its alot easier than being computer programmer. but sql salary are really high and computer programer which is alot harder is lower. why is this. a phd student told me that sql job are really boring. is that true??  |
| | hi trying to get a job where i have to write sql queries. i have writen some queries but i have to do a project. that way i can show the project to other people. any ideas of a sql projects?  |
| | Hey everyone, So I'm doing a project just for the heck of it. However, I'm stuck on an issue. I want to query the database to select the last comment in the answers table so I can display it on the main forum page under the specified topic. How do … |
 | Hi all, I have a very nasty issue here where SQL values are changing but I haven't been hacked because the changes are just too abnormal. People vote for their servers and every so often the top few servers values roll back. For example at 03:00 a server has 66 … |
| | I need help and thank you in advance for any advice. I'm new to Php and Mysql. I've put three drop down menus in one cell of a table and I want to display results of a simple query (4 fields per record) in another cell of the table. Only …  |
| | I have two tables (points, pointsmatch) Table 'points' have following fields id (int) seriesid (int) team (varchar) points (int) id seriesid team points 1 9 Chennai 4 2 9 Delhi 0 3 9 Kolkata 0 4 9 Mumbai 0 5 9 Bangalore 0 6 9 Mohali 0 7 9 Rajasthan … |
| | hope i worded this well enough... :D trouble working out a query Table: weeklyrevenue Week Number||value 25||20 26||40 28||60 Table daily_totals Week Number||quantity 26||10 27||10 28||10 Need week 27 totals to be multiplyed by week 26 revenue not week 28 revenue as the revenue would have been generated by the …  |
| | l need to generate a dynamic PDO update query. l am not sure of the behaviour where we have the same placeholder name in th update and WHERE clause for example UPDATE users SET name = 'Master User' WHERE name = 'Dev User' As you can see placeholder name will … |
| | 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 …  |
| | 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 … |
| | 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 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 … |
| | 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 … |
 | 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 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 …  |
 | 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 … |
| | 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, … |
| | 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, 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 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> … |
| | ok so , i have a sql query puzzles . say that i have a table "PERSON" with the data look sumthing like this: PERSON Name ID ----------------------- John 12123 Kimberly 33311 Leo 87892 And i have a table score that look sumthing like this: SCORE ID MARKS ------------------------ 12123 …  |
| | Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and …  |
| | $plugins = $Server->Get('plugins'); echo "<br /><br /><b>Plugins</b><br> "; foreach($plugins as $plugin) { echo $plugin."<br>"; } That snippet above spits out a long list of plugins from a server. How can I store each plugin listed into SQL so that its stored as '$plugin[0]<br/>$plugin[1]<br/>$plugin[2]<br/>' and so on so that when I … |
| | Hi all, ive got a big question about conducting mysql_queries.. i have a schedule program that needs to sort through and pick the records that apply.. the date will change, and used a php date() formatted to mysql date and pick out the ones records that are active vers inactive. … |
| | I'm learning as I go here, but I'm stuck at the moment. I am trying to dynamically create a datagridview and populate it from a database using SQL. I have created my columns, but I don't know how to assign the data coming out of my sql query to its … |
| | In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& … |
| | Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable …  |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … |
 | Hello i have a database table | col1 | col2 | col3 | col4 | col5 | | val | val | val | val | val | | val | val | val | val | val | | val | val | val | val | val | … |
 | Hello, i got this error when i click my button save. Error: .Net SqlClient Data Provider: Conversion failed when converting datetime from character string. please help me... this is my save button code: Private Sub btnSimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim check As Integer Dim … |
| | Hi all, In the program I'm working on, I am making a form that submits data to an Access 2007 database. I can connect to the database fine and run a select query, but when I try an insert query I get an error: "statement contains the following unknown field …  |
 | Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not … |
| | Hi, I have a problem on getting data from XML file. I am honestly have 0 knowledge on this. Here is the XML data content, i opened the XML file using notepad then pasted here. <?xml version="1.0" encoding="utf-8"?> <?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:Test-Form:-myXSD-2012-09-02T13-13-23" solutionVersion="1.0.0.55" productVersion="14.0.0.0" PIVersion="1.0.0.0" href="http://share.test.com/it/Test%20Form/Forms/template.xsn"?> <?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.3"?> <my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" … |
| | Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm …  |
The End.