2,570 Topics
 | |
| | Hello I am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so …  |
| | Hello I am trying to insert some data into a sql server i have but it seems like I'm formating the information wrong. This is what i have so far. product id = int; type = string; watt = float; volts = float; String query = "INSERT INTO GoodCustomer(Product ID, … |
| | Hi All, i am not sure if this is the right forum, but i couldnt find a SQL section. I am writing an application to log data from our PLC system to a SQL database. I would like to write a record every second. I have it all working fine, …  |
 | Hi I am trying to make a bike shop for my project and i need to pull out a product details with image from sql databse. I have made a table with products and i have stored the images url but i have no idea how to pull it out … |
 | Group, The SQL Server (I'm using the edition that comes with Visual Studio 2010 Express) is different in every aspect form the database(s) that existed in the UNIX based program I work with over the last 15 years. There is much to learn and understand. With that said, I've connected … |
 | How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended? i have used this function datediff(ss,grn_date,GETDATE()) . this function gets the jobs done how ever if the diffrence btw the dates is huge …  |
 | I'm using this PDO query to fetch all the data I need from Value and dateid: $pdo = new PDO('mysql:host=localhost;dbname=contisec_portal', 'root', ''); $date = date("o-m-d"); $stmt = $pdo->query("SELECT stock_names.Value,stock_names.Fileid,date_header.dateid FROM stock_names,date_header WHERE SEDOL = '$stocksel' AND date_header.fileid = stock_names.FileID"); Does anybody know how I can sort the two columns into … |
 | how i can make the relation ship in MS SQL ?  |
| | Hello guys, I'm in need of some thinking help. I want to build an auto-complete text input to find cars, but I want it to search for Car Models and Car Manufactor too. In example, if the user type 'For', the suggestions would be 'Ford - Car 1' 'Ford - … |
| | Hey Everyone, I have table called vdet_sa_archive and in that table there are so many fields and i want to access the data on datetime range. sample data in table starttime endtime 1 14-02-13 01:30:15.000000000 AM 14-02-13 02:01:57.000000000 AM 2 14-02-13 4:30:01.000000000 AM 14-02-13 5:30:01.000000000 AM 3 14-02-13 01:30:01.000000000 PM … |
 | Hello. I have two tables, the itinerary table and location table. The itinerary table consists of all the itinerary: * A - B * B - A * B - C * C - B * C - A * A - C The user will select from the itinerary … |
| | A lot of questions in the VB.NET forum are database related. Most of the code that gets posted result in one or more comments like "use parameterized queries to avoid SQL injection attacks". I won't describe the nature of a SQL injection because it is easily looked up via google. … |
| | Hi guys, This is my first time using SQL. So, go easy on me :) I'm executing these queries on some websites online where there is an already made database with Country name,Area,Population,etc What I would like to do is, to get the names of all the countries in Asia …  |
| | Hello all, I'm fairly new to using PHP, and for my assignment I've coded it all but I'm trying to go the extra step, and code something that if the item amount = 0 it doesn't print it out on the order form The items are $LAPTOP $MONITOR $KEYBOARD $PRINTER … |
 | Hello everyone, As a freelance i am working on my own project name myOnlineDesk. I want to make a module in admin section where i can create a database backup file and save to the system. The thing that i want is ".SQL" file. When i click on a Backup … |
 | I'm planning to develop a system that can connect through online sql database and a website connected on the same sql database.. Can anyone help me.. Please response.. |
| | Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there … |
| | I am using GUI in netbeans to create a combo box. I want to import all data of a column from database dynamically not manually to a combo box.  |
 | Hi, Im trying to get the depreciation value of an equipment every month. My system gets the number of months from date of purchased up to current date for the computation of depreciation. I can run the report anytime but the computation must be like this: Sample: Date purchased January … |
 | Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and …  |
 | trying to search by the file name keep getting a "expects parameter 1 to be resource, boolean" error what am i missing? $pagename = basename($_SERVER['PHP_SELF'], ".php"); mysql_select_db("tagpoint", $con); $sql="SELECT * FROM tagpoint WHERE title = '".$pagename."'"; $result=@mysql_query($sql); $row = mysql_fetch_array($result); |
| | Hello, I know I shouldn't use mysql_. So I have a mysql_query which updates my table (for a hit counter). However, when I open the page, I get to see this: > You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | I have done the following codes to create a bar chart with the data from DB, and save it as an JPEG file. I wanted to add percentage value anywhere in the table, JDBCCategoryDataset dataset = new JDBCCategoryDataset("", "oracle.jdbc.OracleDriver", "", ""); String query = "SELECT std,id from table"; dataset.executeQuery(query); JFreeChart …  |
| | Collapse | Copy Code int s1 = Convert.ToInt16(dataGridView1.CurrentRow.Cells[3].Value); int s2 = Convert.ToInt16(dataGridView1.CurrentRow.Cells[6].Value); int s3 = s1 * s2; dataGridView1.CurrentRow.Cells[38].Value = s3; this is working fine when i change the value lively in dataGridView1.CurrentRow.Cells[3] it multiply with the changed value with dataGridView1.CurrentRow.Cells[6] and display the value in dataGridView1.CurrentRow.Cells[38] like cell[3] cell[6] …  |
| | Hi guys, I've been cracking on with this project for a few days now and had lots of useful pointers to help along the way. I've now hit a little snag where I think I have written the correct update Statement but It seems to error at the last point. …  |
 | I inherited a website here at work. The menu system uses a convoluted jquery / javascript structure. There are 8 different types of "users" for this website, from administrator to contractor or accountant, etc, and the person made 8 different versions of the menus covering nearly 80 different pages within … |
| | Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions … |
| | I want to have the following on SQL Azure: IF EXISTS(SELECT * FROM [sys].[databases] WHERE [name] = db_name() AND [compatibility_level] = 110) BEGIN ALTER PROCEDURE [dbo].[Test] AS BEGIN -- Omitted body containing lots of strings END END or a work-around that does something similar. What follows is what I'm trying … |
| | Hi, I seem to be having a problem when attempting to insert a new record into my database through vb.net. From what I can gather, there seems to be an error in the code that the command builder (cBuilder) is creating for me. Here's a copy of the code for … |
| | Hi again guys... I have a little but of an issue with a select statement I cannot seem to fathem out. Below is the code: else if (radioButton3.Checked == true) ; { //Looks at the row Selected in the GridView and then takes the Account Number and Stores in a … |
The End.