6,934 Topics
 | |
| | Hi, I have a question regarding outer joins. Suppose I have the following 2 tables each having 2 columns. Employee: EmpId, DeptId Department: DeptId, DeptId EmpId is primary key in Employee and DeptId is primary key in Department. Also, Employee.DeptId is foreign key referencing Deparment.DeptId. My first question: 1. Suppose … |
| | Im trying to create a report that only includes records that was created between to [B]Date Variables[/B], [B]dateTo[/B] and [B]dateFrom[/B]. There are three combo boxes used to get the values for the two dates. Here's the code I didn't include the select case for the month(in string) to be converted … |
| | I am writing an output stored procedure that i access using c#. I am trying to print the output values from the stored procedure. [code] using (SqlConnection connection = new SqlConnection(connectionstring)) { connection.Open(); SqlCommand emailcmdsql; emailcmdsql = new SqlCommand("returnemail", connection); emailcmdsql.CommandType = CommandType.StoredProcedure; SqlParameter paruser = emailcmdsql.Parameters.Add("@user", SqlDbType.VarChar); paruser.Value = …  |
| | Hi, how to import/include Spatial Data format (Geometry and Geography) in Sql Server 2008 ? |
| | Can anyone help me about how to post image and sql data. [ATTACH]13786[/ATTACH] Check the attached image, it is from jaiku.com. [you can see image of the user and data which is posted by user] i have one textbox(multiline mode enabled), and a button. when the user input the data … |
| | what is major differences between sql server and oracle?  |
| | I dont understand what im doing wrong! [CODE]public partial class Delete : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnSubmit_Click(object sender, ImageClickEventArgs e) { SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand comm = new SqlCommand("Delete into [Staff] (Staff_Number, Login_Password, Phone_Num) VALUES (@Staff_Number, @Login_Password, @Phone_Num)", conn); comm.Parameters.Remove("@Staff_Number", …  |
| | Hello Friends I wanted to make a same change in over 300 SQL scripts. Is there a way to automate this? Thanks  |
| | I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number … |
| | hello please help me on this i am confuse, if i will use this [CODE]sql = "select * from item_table where itmno = '" & m_item & "'" Set item_rs = con.Execute(sql) 'do i still need to use this With cmd .ActiveConnection = con .CommandText = "item_table" .CommandType = adCmdTable … |
| | Hi guys; I need your assistance. I am extracting some info from my database and I need difference between two fields of money values. Lets call the fields as Field1,Field2,& Field3. Field1 = Current Balance Field2 = Starting Balance Field3 = Field1 - Field2 From my query, I get Field3 … |
| | i got 2 html pages with the following data index.php (buttons: SAVE, EDIT) update.php (buttons: UPDATE,DELETE) Employee ID (primary key), Employee Name (here i putting 2 buttons Edit,Save) when i entered the empid and click the Edit button, the page has to go from index.php to update.php and at the … |
| | Hello all, I'm pretty new to PHP & SQL. I am having some trouble with a web voting page I'm creating. I have a PHP loop which is displaying data from SQL table A. Beside it, a small text box linked to SQL table B to allow users assign numeric … |
| | I have inherited the following query, which works: [code=text] SELECT [CM Database].[Age Range], Count([CM Database].[Age Range]) AS [Count], Format([Date Contacted],"yyyy") AS [Year] FROM [CM Database] GROUP BY [CM Database].[Age Range], Format([Date Contacted],"yyyy") HAVING ((([CM Database].[Age Range]) Is Not Null) AND ((Format([Date Contacted],"yyyy"))=[Year])); [/code] My client has asked for a Financial … |
 | This is a continuation of the [url="http://www.daniweb.com/tutorials/tutorial19303.html"]Updated: ASP.NET Login Page Tutorial[/url]. This tutorial will demonstrate how to create a registration page for new users to your site. This registration page will utilize the same principles used in the Login Page Tutorial, so this should be no more difficult to do … |
| | OK...guys... I'm about to have a cow here. It sounds real simple but I just can't seem to get it. Here is the deal: I have a normalized database made up of four tables (Primary Key in bold) Player ([B]PlayerID[/B], PlayerName) NHLTeam ([B]NHLTeamID[/B], PoolTeamName) PoolTeam ([B]PoolTeamID[/B], PoolTeamName) PlayerStats (PlayerID, NHLTeamID, … |
 | Hi All, Is it possible to take Backup of SQL Server Compact database (i.e. *.sdf) and Restore the same. Regards. |
| | I'm working on a Java program that is calling sqlcmd. It works perfectly on a computer with SQL server installed, but not at all on a computer that doesn't. I want to include the necessary exe and dll files to run this command in my jar. Anyone know which ones … |
| | I am new to mysql workbench and databases in general. I have 250 sql files I need to upload to a mysql database and I am wondering if there is a way to do it other than one at a time. If there is a way to do it using … |
 | I am using Below SQL commands at Crystal Report as command [CODE]SELECT count(id) FROM Content WHERE CONVERT(varchar(10),ImportDate,101) between '{?Para1}' and '{?Para2}'[/CODE] but its generate message value as '0',But When I run in sql server it give result as 23454.Please Help me Sort this problem Thanks Tank50 |
| | hello all I have Table1 and table2 table1 design is Name ,varchar amount , decimal table2 design is Name , varchar nominal,decimal how is the statement to find the sum of amount in table1 plus the sum of nominal in table2 ? thank you denny |
| | Hi All, I have a table in mysql in which there is a column which have following kind of data $Category=>Income;$NAV=>10.2181;$Repurchase;Price=>0;$Sale;Price=>0;$Date=>26-Feb-2008; I want to Bifurcate the data in that column into 5 separate columns in the same table in this way $Category=>Income in this thing "Income" in column "category". $NAV=>10.2181 … |
| | Hi All, I'm having a problem connecting to my database because of a syntax error on the line: $result= mysql_query($sql,$link) or die(mysql_error()); Could you please let me know what the conflict and solution is?. I included the script below. Thanks in advance. C- [CODE]mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect … |
| | Hi All, I have created a few pages using SQL/PHP and dreamweaver. All works fine, but I need some advice on one puzzle I have. I have two database tables, one holds current numbers that is used to create a table of links. These links then open a new page … |
| | I used this code to store convert pictures to "[COLOR="Red"]binary[/COLOR]" inoreder to save in database but it stores only one picture from two pictureboxes. let someone show me how, you can convert pictuers in two seperate [COLOR="Green"][B]'picturebox ("picturebox1 and Picturebox2")'[/B][/COLOR] using the function in the code snippet on something similar. … |
| | I have developed a java web application and make installer of the application. This application is using SQL Server 2000, Now I want, when user installs this application on his/her machine, the installer install the database also, if the machine does not have SQL Server then it install the SQL …  |
| | Hi All, We want to create a c#/VC++ application by using which we should be able to create sql server database SNAPSHOTs in our own file format (in online manner). And later we should be able to get data from those snapshots files in offline manner using our application ( … |
| | Hi All, Is there any way to convert the Sql Server 'Snapshot' files (*.ss files) to some other format...like 'xml','xls' or 'txt'...etc. Thanks. |
| | subreport[code]Dear friend pl help me how to call crystal subreport in vb6 backend sql !) I created two report report1 & report 2 both r working fine with below code. 2)I linked two reports by subreport concept of crystal but how to make coding in visual basic 6. Rep_form.CR1.Reset Rep_form.CR1.LogonInfo(0) … |
| | i m using sql 2000, vs 2003, asp.net, c# i want to create a serch for my web site i m doing using sql full text serch but the way i know is to show the result in a data grid . but i m looking a way to show … |
| | hi, i m trying to run a query on an MSAccess table, but it does not give me any count but only 0. There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008. the … |
| | Hi all, I have an assignment about analysing the Distributed Information System for a typical International Shipping Company such as Hapag-Lloyd, Sally Line UK etc. The assignment mentioned about some objects such as Ship, Container, Consignment, Port, Voyage, Client, Representative, Contract, Manifest log, also about Crane system, Crane controller, Cranes … |
| | Hi, I want to learn sql injection.I searched in google but the information is not sufficient to me.Will u provide some links to learn sql injection. thank u  |
| | ok i know connecting access. i want to learn database connectivity using sql server in vb.net. How do i create a table in sql server in vb.net visual studio i dont have sql server installed in my pc also performing database manipulation in windows application(i have been doing it in … |
| | Yet another date time related sql statement i need help with, oh how I loathe them. I need to find the records between now and a week ahead. I have this so far [CODE] Dim con As New OleDb.OleDbConnection Dim OleDBCon As System.Data.OleDb.OleDbConnection Dim ds As New DataSet Dim da … |
| | Hello. Because my client's table has two rows getting int values as ids from other table to display the string values. Table 1 Table 2 Item: 12 12 = 'Cat' For displaying the values I have created view in DB [CODE] create view ClientsView as select cl.id,cl.Name,cl.Familyname,cl.Position,cl.Email,cl.OfficePhone,cl.Mobile,cl.Website,cl.Comment,cl.[Date],cont.country,cl.Street,cl.City,clgr.[Group] from Clients as … |
| | Hi, I am trying to find a logic for reading sql query data and displaying it properly. i have 2 sql tables Modul & Relation (see attachments) which i am using to create a GDL file format (see Old and New GDL file attachments). I am trying to extract data … |
| | I was wondering whether anyone could tell em whats wrong with this code. Its trying to get the records where the theorydates (stored in a database as shorttime) are before 2 years ago and return the records in a datagrid but it doesnt. [CODE] Private Sub ExpiredTheoryTest_Load(ByVal sender As System.Object, …  |
| | plss give me your valuable suggestions..... i'm on a project for developing a DBMS with SQL interpreter,in java, using netbeans6.7...the interpreter interprets only some queries like create,select,insert,update&delete...for this i need 2 create database...i prefer 2 save database as a text file & 2 perform operations in the txt file.. but … |
| | hi can anyone help me with checkbox binding in c# to sql database if data is in bit format and to retrieve the same from database |
| | Hi This is my first time posting after daniweb has helped me alot but I couldn't find a solution for this so I thought hey why not ask. Basically I would like to have an sql statement which selects all the bookings from a table in microsoft access callled tblBookings … |
| | i m using sql 2000 and i have a table with 3 columns ( credit , debit, total) what i want to do is whenever a value is inserted to the credit column it should add that amount to the total column and whenever there is a debit value it … |
| | Iam writing (or trying to write) a simple join query statement in Query Analyzer. As of right now Im getting the error message Ambiguous column name 'categoryID'. My Statement is ; [code=sql]Select categoryID, Max (StockPrice) as maxStockPrice, MIN(StockPrice) as minStockPrice, AVG(StockPrice) as avgStockPrice From Category, InventoryPart Where Category.CategoryID = InventoryPart.CategoryID;[/code] … |
 | Hi, When using the following SQL query I get back just over 12,000 records. SELECT JobNumber FROM myTABLE; There are alot of duplicates within the records. I am wanting to only get back one of each JobNumber. If I use SELECT JobNumber FROM myTABLE GROUP BY JobNumber the number of … |
| | hi pls give me the full solution for this one. tnx |
| | Hello. I have searched, and found database tool the [URL="http://www.powerdbtools.com"]PowerDBTools[/URL]. Who knows how can I convert my Access database to SQL 2008 with this tool? Thank you. |
| | please help someone help me.. i need to create a phonebook application, if else, i will fail in my subject. Or help me to insert data on mircrosoft sql server using a save button. please someone... asap.. thanks! |
| | HI i am planning to create a SQL IDLE using asp.net and C# . in that i am going to implement 4 modules : 1) Student Login module 2) Student Teaching Module (like w3schools.com ) 3) Student Feedback module (personalized feedback ) 4) correction module Now my problem is that … |
| | I'm trying to create a login system that checks the username and passsword from an sql database. I've created a local server named coffee that has a table named 'users' - I have created fields for username & password. I'm using ASP.NET web application and I want to connect to … |
| | Hi, i'm sql newbies, hope someone can help. I'm trying to do a tariff lookup table for my voip service. When a user makes a call, i capture the destination phone number which has the country code prefix (the prefix may have or not have the plus sign). I'm trying … |
The End.