6,934 Topics
 | |
 | 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 …  |
 | Sql query to index @ in full text search of a binary file |
| | I'm trying to create a table writing in SQL and I need to validate the 'Date of Birth' field 'Players must be over 16 years of age' So how should I validate this. my table name is : Players field name is DOB and the datatype is 'DATE' I tried … |
 | 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 …  |
 | Hi I try to insall Oracle SQL Developer 3.2.2 on windows 7 64 bit ,but I dont know why I cannot connect to server I got this error? http://ubuntuone.com/68jUmnjxm1458xARIaDNcL by the way any one know who ca I unstall Oracle SQL Developer 3.2.2 from Win7 64bit? |
 | 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 … |
 | In my project i want to create a database through my application, how can create new database using sql statement.( i.e create database...)  |
 | 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 … |
| | Hi so I have three database tables, aspnet_Membership, aspnet_Users and tableUsers. These tables keep record off users on the system and what I am trying to do is to create a gridiview that lists the users that are locked out. The columns I would like is userID, customer name, customer … |
 | 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 … |
| | Hi I am having an issue trying to run an sql query from a php script. I have checked the query through phpmyadmin and it runs fine but whenever I run it through php i get an error. The error is "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean … |
 | I am doing a facilities reservation database. Situation as below: Every member has a membership which is authorized some facilities. Therefore, if a member reserve a facilities which is not authorized to his membership, it need to be charged and store into the reservation record table as an attribute reservation_fees. … |
| | Hi guys, I would like to know is it possible to connect and create databases locally on my Mac or even windows? using Oracle SQL Developer. I have installed Oracle SQL Server with XAMMP but this doesn't seem the correct way. Hope someone could help.  |
| | Hy all, I'm new at using sql server compact,so I don't know yet if what I want to do is possible:)? I have the following setup: 1.Datatable created from a table from my database(this is the table that I want to update later); 2.Make modification on datatable and save it; … |
| | Hi Friends I got lots of help from you all for diiferent types of problem. I am making a project using C# , SQL SERVER 2005 and Crystal Report. I already developed the project but problem is I have to deploye it on other computer. So how can I make … |
| | 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. … |
| | Hello Group! I've created a fairly large database with approximately 170 columns. I now want to begin writing data to that database table and saving the data. I'm using a form I'm calling "frmInventoryMasterSetup". I've also created the individual textboxes that I want to link to the columns for saving. … |
| | 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 … |
 | Hello. I'm Having this problem since yesterday. My professor wants us to create a VB.net Program connected with MS SQL. The problem is when i put my VB.net Project to other pc, i need to change the current connection String. Currently im using this code for my Connection String. Data … |
 | 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.. |
| | Hy all, I have the following problem with an update in my sdf database.I want to update a table data using a sqlceresultset.This is the code that I'm using but nothing happens. connection.Open(); string sql="SELECT * FROM Table1"; SqlCeCommand cmd = new SqlCeCommand(sql,connection); cmd.CommandType = CommandType.Text; SqlCeResultSet rs= cmd.ExecuteResultSet(ResultSetOptions.Updatable|ResultSetOptions.Scrollable); IEnumerator … |
 | Good day people! I have a problem with my C# window application. I can't insert new record to database. I have sought for many tutorial in ADO.net and Entity Framework. I have been tackling it in Entity Framework because that is my preference. My piece of Entity Framework code would … |
| | 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, I have a problem that in a database (named DDS) i can change or delete records in all tables but there is one which i can't. There isn't any primary or foreigh keys(There is one dependency, a view). So could you please tell me that is there any way …  |
 | 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 i am writing a report, it must have parameters ToDate and FromDate,now the thing is i did all that but it stllrespond with just headring no data. Please help what am i doing wrong |
 | 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); |
| | can anyone help me my sql update is not working. cmd.Parameters.AddWithValue("MaterialSizeId", id); the id on this parameter is already had a value. Maybe the error is on sqltransaction. please help. public void Update(string materialSize, string KgPermetre, string PricePerCut, string MaterialType, string BarColour, string PreferredLength, string datetime) { using (SqlConnection objcon … |
| | i am doing an application at school and i always have this error message: Cannot open database "users" requested by the login. The login failed. Login failed for user 'SERVER\Student'. what is the possible solution for this? thanks :) |
| | Hello, I had a very peculiar problem today which I am sure hundreds would have had and solved before. I have developed a VB.Net + SQL Server application and installed it in a few dozen places. All worked very well. Then I installed it in a persons computer in Middle … |
| | how to add two number in sql query function SUM() is not working???  |
| | 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 … |
 | Hi to Dear Daniweb Members, The application populates data from database into JTable in Netbeans. It has 2 classes. First class retrieves all data from Employee table using Derby. Second class creates the GUI with a JTable component inside it. However i got the following messages. I am so confused. …  |
| | Bear with me please because my SQL is not that good. I want to write a query that takes into consideration information from 3 different tables. Let me explain the situation: When a customer books a room, they have the preference of several rooms and the rooms can be booked … |
| | Hi I have a problem with my SQL UPDATE It says here: Syntax error in UPDATE statement. Here's my code: Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click Dim sqlupdate As String sqlupdate = … |
| | 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 …  |
| | Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strsql As String = "Data Source=.ITSupport;" & _ "Initial Catalog=Information;Integrated Security=true" strsql = " insert into table_1 (name, address, age ) values ('" _ & txtname.Text & "','" _ & txtaddress.Text & "','" _ … |
| | 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] …  |
| | Hy all, I'm facing a problem with some data that I need to check and update it's status in my database.I've got a data grid with some info from a table in the database..now for evry entry I send that data to a server server then I get the server …  |
| | 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 … |
| | Hello i'm getting theses to error with my sql code can anyone help me ot at all i'm really lost and can't find much to help where i'm going wrong.Code is below Error 3 The best overloaded method match for 'System.Data.SqlClient.SqlCommandBuilder.SqlCommandBuilder(System.Data.SqlClient.SqlDataAdapter)' has some invalid arguments Error 4 Argument 1: cannot …  |
| | 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 … |
The End.