6,934 Topics
 | |
| | Dear Sir / Madam, Date : 12th February 2008 Hi, I am Ayan Mukherjee, a Programmer seeking for help. Please help me out. Software Specification : I have Windows 2000 Server with service pack 4, IIS version 5, IE 6 with service pack 6.1. Working Environment : I have to … |
| | Here is what I am trying to achieve: I have an access database with a table [GroupTable] with 3 fields [RecNo, Group, SubGroup] (Group & SubGroup use integers) I want, under program control, to populate a table adapter with a subset of all records eg I want to be able …  |
| | I have been running SPybot and Adaware, but have some spyware that keeps returning. Spybot was unable to remove Clever IE Hooker. Here is my hijack this log: Logfile of HijackThis v1.98.1 Scan saved at 2:31:26 PM, on 9/24/2004 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP1 … |
| | I've got two tables - members and sponsor, their simplified structure below. members: id_num program_id sponsor_program_id sponsor: id_num sponsor Some of the members in members table are sponsors. I need to update the field sponsor_program_id in all records in members table with their sponsors program_id field. Sponsor table tells me … |
| | I have developed an access database for my company and want this to be available to multiple users remotely from different offices. I have been told that i need to migrate to MS SQL Server. Is this the case?? If so how do i do it? If not what do … |
| | I am currently using the visual studio 2005 express edition. I would like to upgrade to the 2008 express. So I would be using Visual Web dev 2008+Visual Basic 2008. These run on .net 3.5, at the moment there isn't an sql server 2008, would I be ok still using … |
| | I need to write a shell script which does the following: script shld be in such a way that I just need to pass a parameter and it shld generate the report by running a sql script and store it in a directory and email this report in every 30mins … |
| | well im login in sql server through window authentication then wat code i should write in C# to write my connection string urgenttttttttttt  |
| | Hai, i am tried to use the SQL Server with Java and Tomcat 5.0 Application Server. I am using the JDBC Driver for Java connecting with SQL Server. I m using SQL Server 2005. But the JDBC Connection doesn't create. I have used the following code for java database connectivity … |
| | Hi all, Could anybody help me in getting a FULL systax of SQL Statements in vb 6.0. Or could anybody suggest me a site that could do it. Rajesh Khanna  |
| | Hello, I am writing a program that connects to a webservers db. I have a testing db on my local machine and i add a new dataset to this local db. I have tried to go into the app.config and change the connectionstring to a global variable i created useing … |
| | Hi pple I need help... How to retrieve data from a table in sql server 2005? I used databound for my dropdownlist in my web form. I hope my explanation is clear. Please help...advance thanks.. nandhini |
| | Hi all, This is my first time... and i'm not an sql guy by any means, but i can insert, update, blah blah... I have a question to ask, i have a table that has UniqueInt | Date1 | int1 | Date2 | varchar 1 I have duplicate records that … |
| | How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment. If anybody out there have another method, … |
| | [B]Hi people, I want to know how could we embed SQL code into C/C++ code. Please, give me a link or give me a small example. Thank you very much. Begueradj.[/B] |
| | is there a way to generate sql reports with sql reporting services through the visual basic 2005 or 2008 express edition?. is there an add-on or something for express edition?.  |
 | hi there, creating a structured databse (maybe in SQL) that I want accessable from a UI in c#. Is SQL the best way to go about this ? cheers |
| | Hi, I'm workin on a website where i need to update a password using a stored procedure. I tested the stored procedure on SQL server and its working fine. but somehow i cannot seem to call it from C#. Can any one please help me? Stored Procedure CREATE PROCEDURE dbo.sp_ChangePassword … |
| | Read multiple columns data from SQL query ( 1 row ) Hi all. I am using an SQL express where I’ve designed a table named User_DB_Main I have also created a procedure that makes some selections : [code] @UserId varchar(20), @UserPassword varchar(30) AS /*- Check if UserID exists*/ SELECT COUNT(UID) … |
 | Can anyone please tell me how can i copy a table. thank you. and also how to fin out the second highest value of a field in a table. eg. select the employee cashing in the second highest salary in the company. Thanks a lot. |
| | hi my name is Anna and i have got this problem i am trying to practice sql queries using following database relational modell i know most simple ones but with these ones i got trouble it is about book lybrarry database using oracle. The primary keys are underlined. The foreign … |
| | Hello! I have two tables in an MS SQL database that I'm trying to join and display through PHP. My connection is fine and I've done it many times before, so don't worry this isn't a PHP problem. It's a my-query-won't-finish-executing problem. Table A: (about 2 million entries) id | … |
| | can anybody tell me abt the difference b/w sql server 2000 and 2005 |
| | Hi, I am trying to create dynamic contents in a web application where I retrieve a list of data from my database.. Let's say from table MembersInfo And in this table it consist of Membername, Member Particulars, Member Address, file location of their photo in the server. i do a … |
| | Hi there. I have a datagrid that prints out data from an SQL d/b. I also have a 'Save' button which I am struggling to write an event handler for. the Datagrid data is editable, and when I press save I want the changes to update the D/b too. Any … |
| | but i hope someone can point me in the right direction. here's the story 2 pc's, one upstairs with database one downstairs used to access and make changes to. This was working no problem for months. Then the downstairs pc needed a new AGP video card, easy install no configuration … |
| | [B][B]hi every body i'm new to MS SQL and i want to learn it if any body knows good source or web sites about sql server 2000, i'll appreciate if he lets me know thanx for your help, everunloaded, bye[/B][/B] |
| | Hi I need to insert a string in a database but the string might or might not contain a quotes('). There is no problem if there is no quotes. But in case of quotes it throws a syntax error in insert statement and that obvious also. What i am thinking …  |
| | When submitting a page via the internet, I get a 500 error and the name of the file. Are you able to help?? Basically I have an expense system implemented with JSP in JBuilder 4 using Oracle 9i and SQL Plus. When submitting any pages in the system, I get …  |
| | How can i Load images in to each cell of a table based on its product id? The picture url is stored in field:[I] Product_picurl[/I] [CODE]SELECT `Product_id`,`Product_Name` , `Product_picurl` FROM `prod_listing` where `Product_id` ="$ID" [/CODE] I have looked around for a photogallery script but cant find one!! Thanks in advance  |
| | hi Me now facing another array format promble again SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE"; how to store data into to this multi array again?? DataFOr UPload_date $arrDate[0][1]=19/2/07 $arrDate[1][2]=21/3/08 $arrDate[2][3]=2/1/08 $arrDate[3][4]=4/3/08 data for TotalRawAmount $arrData[0][2] = 1000; $arrData[1][2] = 2011; …  |
| | hi i now still new for php , me now facing a problem like this How to convert this sql statement into this array SELECT SUM(RAW_AMOUNT) as TotalRawAmount, SUM(FG_AMOUNT) as TotalFGAmount, SUM(WIP) as TotalWIPAmount, UPLOAD_DATE FROM raw_fg_sum GROUP by UPLOAD_DATE"; how to store data into to this multi array UploadDate … |
| | my sql query is this [CODE] Set rs = conn.Execute("SELECT COUNT(Question) FROM QnE where fldChapter = 10")[/CODE] on my tble that fldChapter have a value of 1,2,3,4,5,6,7,8,10~~~~~,20 and im getting a random cell value form fldChapter HOW can i get a random cell value form 1~10 only??? pls help me … |
| | how to save an image drawn with GDI+ to sql 2005 database? |
| | hello all, I have a form with multiple chechboxes. Depending upon what the user chooses I need to make a select from a database with 6 tables. I pass the results from the form to the SQL statement up to the moment I need to put in a where request.form>0 … |
| | I am trying to move a website from an other server to one of our servers. I am not familiar with ASP. Teh website is asp and visual basic. The database is mysql. I have imported the database in Mysql server and I have loaded the code to iis6. I … |
| | Hello All, Iam using Sql Server 2000. I want to Bind the Gridview with the Database, by giving the name of the table in the "Use Data Source" option in the Smart Tag of the Gridview. In the Add Connection Dialog Box I give "Microsoft SQL Server(SqlClient)" as a Data … |
| | Hi, I have this app running fine on my pc with connecting to SQL server on my localhost using windows authentication. Now I am going to deploy it on my client's server where SQL Server 2K DB is on server "abcd" with SQL Server credientials (No windows authentication) My problem … |
 | Hello all, i have recently finished work on a clients database. they now wish for one field in the database to have 10% taken off for each record. can this be performed soley through an SQL statement on the MYSQL database. |
| | Hello guys, I have been working for a long time a project in vb.net using a database which is in SQL Server 2000.I am currently trying to upload an image!The file i want to upload is not type image but nvarchar.I have made save it inthe database as ID of … |
| | Hello, I was wondering if there is any altrernate to Ms SQL Enterprise Manager? and of course a free one Thanx |
| | Hi, Here is the scenareo as well as I, a nubi can 'splain' it. Three pages: 1. Order Form page. Collects the data and use input. Very complicated, but works and does its stuff well. 2. Processing page. --a. checks for errors, returns errors - all ok --b. If no … |
| | Hi all, I've been designing a program in VB6 to extract certain rows of data from a SQL Database and shoot them out over email. Problem is, the farthest I can get is to printing them on the VB form, and can't do much else. I get an error when …  |
| | Hi new to the forum. I hope there is someone that can help me. I need to retrive some data from a table in sql server. The data is going to be used in an import to some other tool. The problem i have is as follow. I want to …  |
| | i have three table 1st viewleave 2nd applyleave 3rd personal based on the leaveid in viewleavetable i wnt to fetch the spid in the second table,based on the spid i want to select spid email address........please tell how to do tat.. CREATE TABLE `viewleave` ( `leaveid` varchar(25) NOT NULL, `message` … |
| | Hello, Could you help, with sql injecton about from where i can download it and who it is works. plz  |
| | Someone please help!! I am use to working with MS Access. So, for me, working with SQL is a downgrade at this point. But, I have to do it. I am working with Microsoft Visual Web Developer which apparently is supposed to be easy!!! The help feature is pretty extensive …  |
| | Hi to All , I am getting this type of error while running the Sql through JDBC. java.sql.SQLException: Invalid column index java.sql.SQLException: Invalid column index at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.OraclePreparedStatement.setIntInternal(OraclePreparedStatement.java:4635) at oracle.jdbc.driver.OraclePreparedStatement.setInt(OraclePreparedStatement.java:4627) at weblogic.jdbc.wrapper.PreparedStatement.setInt(PreparedStatement.java:536) I am implementating the Paging in jsp. I m using The TYPES. parameterList.add( … |
| | OK, one last thing. Now I have 3 textboxes and here's what I wrote: [CODE] SqlConnection conn = new SqlConnection(); conn.ConnectionString = "data source=.;initial catalog=ForumDataBase;integrated security=true;"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO PostTable(ThreadTitle,PostMessage,UserName) values('"+ThreadTextBox.Value+"','"+PostTextBox.Value+"','"+NameTextBox.Value+"')"; cmd.Connection = conn; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); [/CODE] Can you please tell me what's … |
| | Hello, I am very new to Python and have, what I think, is a rather simple question. First, I am running Python 2.1 on Win XP. What I want to do is open a CF page after my process has run and pass the processID, that I will set, and … |
The End.