1,694 Topics
| |
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 … | |
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 … | |
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 … | |
Sirs, please suggest a good way to handle large amount of data. This is my newbie idea: - create a database on one of high powered pc(dedicated for whole company) - then sync every changes to another copy of this database to the online hosting service with security note: theres … | |
Hi Guys, I've just picked up an old projcet I was working on (about 6 months ago) and trying to get my head around my own messy N00b code. I've managed to get the grid views working with links back to the tables and showing data in the correct places. … | |
I am inserting values into a database but i get an error, it says the variable name @emp_login has already been declared. How do i resolve this? This is my code `SqlDataReader readerReference = cmd_Reference.ExecuteReader(); SqlCommand cmd_Insert = Connexion_Insert.CreateCommand(); string insert = "INSERT INTO EMP_tracking(emp_login, emp_dom_code, emp_domain,emp_surname") VALUES (@emp_login,@emp_dom_code,@emp_domain,@emp_surname); int … | |
how to update databse in remote machine,i am having .sql file which i have to update my database schema in remote machine,client will provide me his machine ip address,database username,database password,database instance name...pls help me pls package com.prion.testConnectivity; import java.io.BufferedReader; import java.io.FileReader; import java.io.Reader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; … | |
I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line. select revertrsn from LN08PENm where aano in(754,870,1136,1138,1139,1140) the data coming in the row that I am retreiving is like this: As … | |
Yesterday when I was working on php script I noticed that categories and subcategories works seperatly if I clicked on main category its show all articles under this main category and nothing imported from subcategories, now am working on somthing like this, so what should I do to avoid this … | |
Hi, I am new to Java and is working on code in java which i need to keep a static sql script in property file and passing variable to it through java code and then iterating that property file to pass the variable value and writing that generated script to … | |
I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are … | |
Hello, Does anyone know how to write recursive SQL statement for hierarhic output places from next table: TABLE PLACES: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I don't know if this is totally correct SQL recursive statement: WITH recursion AS (SELECT id, place, idParentPlace, 1 AS hierarhic … | |
Hello guys, Do anyone know how to write recursive SQL statement for hierarhic output places from next table: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I was looking for alot of tutorials but didn't find anything useful. Any help is the most welcome! Regards, TP | |
Okay, so I am not entirely sure how to fix this. Im attempting to make a tag feature for my site but I am getting: Fatal error: Call to a member function prepare() on a non-object in /Users/Home/Sites/functions/users.php on line 10 Here is the code that relates to this. First … | |
Im doing a reservation site for a project. And Im trying to disable radio button(s) if the sql statement returns true. Example: User selects a date and a time, and radio button(s) would be disable depending on database. So far, I have this: $result=mysqli_query($mysqli,"SELECT tableselect FROM reserve WHERE reserveDate = … | |
Hello every one, i want to make a programme that read data from .xls file. a sql table will create on the basis of top row of the xls file, and rest rows will treated as data and inserted into the table. actually i am working for a office, their … | |
Hi, is there another way of hiding or formating column value in asterisk in select statement? im using the command replace SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if … | |
Hi, i am trying to implement a federated search. I have no idea how to start implementing it? i have several questions relating to this. 1. has the application needs to be web based or desktop based? 2. do i have to have a database in the application side? i … | |
Dear Experts,I want to know how i can sync tables in sql server 2005 and oracle 11g tables. Table structure will be same in both server (sql server and oracle). I would like to prefer some tools available either in oracle or sql server.Thankspardeep | |
I published my project in vs2010 and im trying to deploy it to other computers. I used this connection string that runs smoothly on my pc. This code tries to retrieve the servername and try to connect to database mysysDatabase. This forcely change the app.config. Private Sub btnOk_Click(ByVal sender As … | |
Heyy...i'm trying to save the attachment file location in mydb...the thing is it's just saving the file name eg.database.txt i want it to look like this C:/bla/bla/test my codes addtask.php <html> <head> <title>Task Management System</title> <link rel="stylesheet" href="Appcss.css" type="text/css"/> <script src="datetimepicker_css.js"></script> <script type="text/javascript"> // Javascript function which takes care for … | |
Hi, I've had a look around the forums but I couldn't find a specific answer to my query. I'm following a worksheet I was given from university. We have just started working on SQL and databases and on the worksheet it uses SQL 2008 Server Management Studio. The version I … |
The End.