Database

FirstPrevNext

Re: how to display data in a listbox? Rharzkie22-Aug-07 21:41 Rharzkie 22-Aug-07 21:41  my MSDN library is not installed...i just borrow the cd can you just tell me the process, pleassssse! Re: how to display data in a listbox? Rharzkie22-Aug-07 21:43 Rharzkie 22-Aug-07 21:43  do you have yahoo messenger? so we can easily talk about it, this is mine: pinkaliciouz_rharz@yahoo.com Re: how to display data in a listbox? Rocky#22-Aug-07 21:49 Rocky# 22-Aug-07 21:49  For Heaven's Sake! just open the MSDN.com over the web. go to the index and type ListBox COntrol. There will be a section of data binding. Read it and Follow the instrunctions. These forms are meant to benefit all the people, Thats the way we play the game. You can find a few articles on CP as well. Learn to LURk Before you leap. Search this same topic in this fforum as well. I'm sure you'll find something useful\ Thanks Rocky You can't climb up a ladder with your hands in your pockets. Re: how to display data in a listbox? Rharzkie22-Aug-07 21:51 Rharzkie 22-Aug-07 21:51  OK THANKS... Invalid Cursor Programm3r22-Aug-07 1:17 Programm3r 22-Aug-07 1:17  Hi all, I keep recieving this error when I try to do an UPDATE on an existing record: [Microsoft][ODBC Driver Manager] Invalid cursor state I'm making use of Oracle 10g with an ODBC connection. What does it mean and How can I fix it?? Many Thanks in advance Regards, The only programmers that are better that C programmers are those who code in 1's and 0's Programm3r My Blog: ^_^ Re: Invalid Cursor DerekFL25-Jul-08 8:18 DerekFL 25-Jul-08 8:18  Check out http://support.microsoft.com/kb/183295[^] Joining Three Tables ShuklaGirish22-Aug-07 1:01 ShuklaGirish 22-Aug-07 1:01  Hi,my requirement is i want to join three tables in which first and second table are related and second and third tables are related.I want to get data from all three tables so how it is possible. Pls send me some reply. GIRISH Re: Joining Three Tables Programm3r22-Aug-07 1:42 Programm3r 22-Aug-07 1:42  Hi, You could do a join on the three tables with their foreign keys. After the join you would be able to get all data from the three tables. Depends on your database but here is an example: SQL (JOIN)[^] Regards, The only programmers that are better that C programmers are those who code in 1's and 0's Programm3r My Blog: ^_^ Re: Joining Three Tables ShuklaGirish22-Aug-07 1:46 ShuklaGirish 22-Aug-07 1:46  Thanx for ur reply, if possible just see this query and tell me wt is wrong in this, select PurPRMaster.*,StkItemMaster.Name as IName,StkItemMaster.Unit,PurPRTrans.* FROM PurPRMaster inner join purOrderMaster on PurPrmaster.prno=PurOrderMaster.prno inner join purprtrans on purmaster.id=purtrans.mastid inner join StkItemMaster on StkItemMaster.Code=PurPRTrans.ItemCode It is doing cross multiplication. wt could be the reason. Thanks in advance. GIRISH Re: Joining Three Tables Rami Said Abd Alhalim22-Aug-07 1:56 Rami Said Abd Alhalim 22-Aug-07 1:56  ============================== TABLE [Customers] ( ============================== [CustomerID] [CompanyName] [ContactName] [ContactTitle] [Address] [City] [Region] [PostalCode] [Country] [Phone] [Fax] CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ( [CustomerID] ) ON [PRIMARY] ================================== TABLE Employee =================================== EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone Extension Photo Notes ReportsTo PhotoPath Table Order ======================== 3 OrderID 0 CustomerID 0 EmployeeID 0 OrderDate 0 RequiredDate 0 ShippedDate 0 ShipVia 0 Freight 0 ShipName 0 ShipAddress 0 ShipCity 0 ShipRegion 0 ShipPostalCode 0 ShipCountry SELECT dbo.Customers.CompanyName, dbo.Employees.LastName, dbo.Employees.FirstName, dbo.Orders.OrderDate, dbo.Orders.RequiredDate FROM dbo.Orders INNER JOIN dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID INNER JOIN dbo.Employees ON dbo.Orders.EmployeeID = dbo.Employees.EmployeeID Rami Abd Alhalim Two Tables with Same Name vimal_yet21-Aug-07 23:43 vimal_yet 21-Aug-07 23:43  Hi All, I am using sql server I have two tables with a same name in a same DataBase .this was created by two different DataBase users of that DataBase.I use ASP and get some values and insert the values to that table. my doubt is which table will the data get inserted???????? please help me............... If U Get Errors U Will Learn If U Don't Get Errors U Have Learnt Re: Two Tables with Same Name SimulationofSai22-Aug-07 0:17 SimulationofSai 22-Aug-07 0:17  It depends on the which schema the login which you use(connection string from ASP) to connect to the database belongs to. If you're using "sa", it uses the "dbo" schema, by default. SG Re: Two Tables with Same Name vimal_yet22-Aug-07 0:25 vimal_yet 22-Aug-07 0:25  Thanks If U Get Errors U Will Learn If U Don't Get Errors U Have Learnt Trouble with IN operator Navneet Hegde21-Aug-07 22:50 Navneet Hegde 21-Aug-07 22:50  Hi All consider Table # tblTest fldMainId fldSubID 1 A 1 B 1 C 2 A 2 B 3 A Here I have written Query : Select fldMainid from tblTest where fldSubID IN (A,B) This gives Result fldMainId's : 1,2 and 3 How can I write query so that only fldMainid which has A,B strictly is choosen.So here 1 will not be choosen since it has C also, and 3 is not choosen since it has no A Hence only 2 is choosen as it has A and B. Navneet.H Develop2Program & Program2Develop Re: Trouble with IN operator Giorgi Dalakishvili21-Aug-07 23:10 Giorgi Dalakishvili 21-Aug-07 23:10  In T-SQL you can use this query: Select fldMainId from tblTest where fldSubID='A' Intersect Select fldMainId from tblTest where fldSubID='B' Except Select fldMainId from tblTest where fldSubID='C' If you have more possibilities for fldSubID then either you will have to write longer query or use subquery #region signature my articles #endregion Re: Trouble with IN operator Navneet Hegde21-Aug-07 23:14 Navneet Hegde 21-Aug-07 23:14  Hi GD, Thank's a bunch , I will try it out and let you know. thank's again Develop2Program & Program2Develop sqlserver2005 saravanan0521-Aug-07 20:53 saravanan05 21-Aug-07 20:53  hi friends Is Any server required to install the sqlserver2005? regards saravanan Re: sqlserver2005 Colin Angus Mackay21-Aug-07 22:12 Colin Angus Mackay 21-Aug-07 22:12  saravanan05 wrote: Is Any server required to install the sqlserver2005? Do you mean a server class operating system? Express and Developer editions can run on XP and Vista. Standard and Enterprise editions need a server class operating system. -- Always write code as if the maintenance programmer were an axe murderer who knows where you live. Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ... * Reading: SQL Bits My website Re: sqlserver2005 Giorgi Dalakishvili21-Aug-07 22:13 Giorgi Dalakishvili 21-Aug-07 22:13  You will find all the information here: requirements[^] #region signature my articles #endregion How to export sql query results to excel file RichardBlare21-Aug-07 20:16 RichardBlare 21-Aug-07 20:16  Hi, I would like to export the result set from a query to excel file using sql statement. Would you please help me how to do it ? Thanks in advance. RB Re: How to export sql query results to excel file Blue_Boy21-Aug-07 21:53 Blue_Boy 21-Aug-07 21:53  Export to Excel[^] I Love SQL Re: How to export sql query results to excel file Giorgi Dalakishvili21-Aug-07 22:53 Giorgi Dalakishvili 21-Aug-07 22:53  Export to Excel[^] -- modified at 4:52 Wednesday 22nd August, 2007 #region signature my articles #endregion How to create a SCRIPT from a Stored Procedure in SQL Server 2005 T4AMD21-Aug-07 13:32 T4AMD 21-Aug-07 13:32  How to create a script from a Stored Procedure in SQL Server 2005?? Re: How to create a SCRIPT from a Stored Procedure in SQL Server 2005 Colin Angus Mackay21-Aug-07 13:48 Colin Angus Mackay 21-Aug-07 13:48  T4AMD wrote: How to create a script from a Stored Procedure in SQL Server 2005?? Right click the stored procedure in the Management Studio and click the appropriate create script button. -- Always write code as if the maintenance programmer were an axe murderer who knows where you live. Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ... * Reading: SQL Bits My website Sort in an SQL Select - Non Typical I think... code-frog21-Aug-07 7:45 code-frog 21-Aug-07 7:45  Here is what my data looks like this will be in comma delimited but it's exactly the data in the table: RecordID, EventDate, EventTitle, EventCity 1, Nov. 1, Surgery Day, Boston 2, Nov. 1, Surgery Day, Atlanta 3, Nov. 3, Surgery Day, Asheville 4, Nov. 3, Surgery Day, Boston 5, Jun. 8, Surgery Day, Boston 6, Jun. 9, Surgery Day, Asheville The problem I am having is that when I select events from the table I haven't a way to sort them in a proper monthly order. (Jan, Feb, March, Apr, May...) instead they sort alphabetically. Is there a way to structure the SQL so that it orders properly by month? How would I do that?

Last Visit: 31-Dec-99 18:00     Last Update: 14-Jun-24 18:30 Refresh ᐊ Prev1...1443144414451446144714481449145014511452 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.