2,569 Topics
 | |
| | I'm trying to set up performance dashboard in SQL Server Management Studio Express. I'm currently running SQL Server 2005 SP3 ('product level') and also have installed the Performance Dashboard add-on. A couple of forums I've seen said that I could access the reporting feature by updating the Management Studio Express … |
| | I am trying to pull data from a table to fill a drop down list. Now, i got the fill part working, but am having an issue passing a variable value to my form post action. Code: $query ="SELECT UniqueIdentifier, LastName, FirstName FROM BrokerMain ORDER BY LastName"; $result = @mssql_query($query); … |
| | Hi All, I need to use the results of this query as an array to exclude files from a tree. The file and folder names that I enter into $exclude work fine but I can not seem to add the results from the query to the array. Below is the … |
| | Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column … |
| | Dear Friends, I want to know that how can we compare two hebrew string in MySQL database? I tried and search a lot on net but still could not found the answer. My website is dealing with Hebrew(main) and English as well. So please let me know How can I … |
| | I seem to be having difficulties when using the following query: [CODE]$query = mysql_query("SELECT * FROM `products` WHERE `name` RLIKE '%$s1%' OR `name` RLIKE '%$s2%' OR `name` RLIKE '%$s3%' OR `name` RLIKE '%$s4%' OR `description` RLIKE '%$s1%' OR `description` RLIKE '%$s2%' OR `description` RLIKE '%$s3%' OR `description` RLIKE '%$s4%' OR …  |
| | So I have a small database for managing stationery orders (internally with my company - I order from the stationery dept). In the orders forms i have a subform with the list of items being ordered. I have the Item_ID, description, UnitsOrdered,UnitPrice, TotalPrice. What a code that will lookup the …  |
| | Okay.. Currently i already had this code for my registration form [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.Sql; using System.Data.SqlClient; namespace Thesis { public partial class Registration : Form { Form formParent = null; public Registration(Form par) { … |
| | HI Can anyone tell me that how to configure php.ini For $_FILES['name']['type'] I am trying to upload a flv video and it is uploading successfully but it is not showing me the type. But if i upload a .mp4 extension file it is giving me the type also and can … |
| | [ATTACH]17851[/ATTACH] Hi, Format my PC and installed SQL Server 2008. Setup hangs as shown in attached image. Installing on Win 7 64 bit OS. To install SQL Server SP1 is left to do due to this. FYI, the top text reads: Running post-Windows Installer configuration timing actions the bottom text … |
| | I add connections in server explorors. Then, I use AdventureWorks Person.Contact to set up a query by searching peter and mary ,but how to add it on form 1 ? and I type part of their names and by the way how to link a "VB label of text" or … |
| | There's a query where I want to get the: - Username of the user attached to the current opportunity record - Sales Stage associated with each opportunity record - Dollar amount associated with opportunity record I want to: - Take the current SELECT IF STATEMENT result, and collapse it based … |
| | hi am new in php, i have values like A,B,C,D in database all in one box. i made a dropdown for its search A B C D , i want if somebody select A or B and search it fetch the whole row from database. or in other words i … |
| | How to connect to a WAMP server database (located in default MySQL database location in WAMP) using C# 2010? I tried... SqlConnection conn = new SqlConnection("Data Source = C:\\wamp\\bin\\mysql5.1.36\\data\\testdatabase; User ID=; Password=;"); SqlDataAdapter da = new SqlDataAdapter("SELECT * from transactions", conn); DataSet ds = new DataSet(); da.Fill(ds, "Transactions"); DataGridView1.DataSource = …  |
| | I am using VS2010 and SQL Server 2005. I have a query to search between dates. Depending on which date I select on the datetimepicker I get no results or limited results, but mostly not all the dates between the two dates I specify. For example, if i select 10/9/2010 … |
| | Hi, I'm trying to query a database to pull out all results from the database where the location and server responsible are selected from a form on a previous page which are then posted over. I can manage to post the selections from the form, but when it attempts to … |
| | This is the error when i try to execute my code "Procedure or function 'Get Customer data' expects parameter '@Name', which was not supplied." [CODE]objCommand.CommandType = CommandType.StoredProcedure objCommand.CommandText = "GetCustomerData" Dim ObjParam1 As New SqlParameter("@Name", SqlDbType.VarChar, 2000) ObjParam1.Value = ID.ToString() Dim da As New SqlDataAdapter(objCommand) Dim dt As New DataTable … |
| | hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = … |
| | Where should I keep connection object to database like ISession or SQLConnection? What's the best solution and why ? Is it Application, Session or Items ? |
| | hi, I am a SQL Guy, I like reading SQL Server books, Please suggest me some books which teaches advanced topics in SQL Server not just teaching the known things. |
| | hi.... i've created one ssrs report it works good im my system.. i.e http://localhost/reportserver$sqlexpress but how should i execute in different system... if i enter the system name then it is showing page cannot be displayed.. i.e http://sys1/reportserver$sqlexspress (page cannot be found) please help me.. |
| | hi.... as u all know about ssrs reports... now i'm using the crystal reports and i want to go through ssrs reports can anyone answer the following question. 1)what is the need of ssrs... 2)and why we should use ssrs.., 3)what are the advantages 4)what are the disadvantages 5)how it … |
| | hi... to all the following code is to deploy the reports programatically... i've one problem .. by using the filestream it takes more time to load the reports.. hence burden on server.. is there any option or any solution to make less burden on server.... one more thing the records … |
| | hi... to all i've created ssrs reports local following is my code.. public void source(string tbname,string Rptname) { ReportViewer1.Visible = true; string myQuery = "select * from " + tbname; SqlConnection myConnection = new SqlConnection(ConnectionString); SqlCommand myCommand = new SqlCommand(myQuery, myConnection); myCommand.Connection.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); DataSet dt = … |
| | I have a file uploader in a web page which allows to upload excel files only, hwat I want to do is in the code , to open the excel file and get the values in the excel file which Is in different cells to the mdf file in visual … |
| | I am a bit (well, actually a lot) confused with how exactly I should use the Dispose() method on SqlConnection object in C#. First let me tell you what I have learned so far (I've been reading a LOT on the subject for the past 24 hours, and I'm still … |
| | I have a query that has two counts in an if statement. I need the query to return all values even if they are null once equated by count. I have tried the NZ function to no effect. Any help would be greatly appreciated. [CODE]SELECT REPRESENTATIVE.Country_id, IIf([CONTESTANT.Team_id] Is Null,COUNT(*),COUNT(*)-1) AS … |
| | |
| | The joke: An SQL query walks into a bar and sees two table, walks up to them and says "Can I join you?" The riddle: Halloween == Christmas - Why? |
| | G'day guys, My boss has just asked me to develop a small CRM system. Now, writing a simple SQL Insert is not something im a stranger to, however for some reason i cannot seem to get this working. I've included all necessary libraries, and tested the actual sql statement in … |
 | So I have a basic database of books set up. I am trying to use PHP to query the db and send back the results. I can sort of get it to work, but not working how I would like. The issue is that the search term that queries the …  |
| | Hi all, Fairly new at SQL, and running into the following problem. I am trying to create a query to count the number of unique fields in a column and display, but can't seem to get it right. For example, each day there are x number of entries from y … |
| | I have no problem connecting to database, and the form is okay i guess. ¿Do anybody see the problem in here? It keeps returning me ERROR! PHP code: [code=php] <?php mysql_connect("$host", "$mysql_user", "$mysql_pass")or die("Error connecting."); mysql_select_db(users)or die("Can't access to database."); if($id) { $sql = 'UPDATE members SET '; $sql .= … |
| | Good evening, I'm trying to generate an xml file based upon the result of an SQL query. I'm making some good progress so far but there is 2 problems I can seem to solve. My php code is the following: [CODE]<?php require ("Connection.php"); $db_handle = mysql_connect($server, $user_name, $password); //load the … |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack |
| | Hi All, I am working on a booking system for vacation rental properties. I have two (simplified) tables properties and propertyAvailability: properties:- propID propName propertyAvailability:- propID dayOfTheYear availabilityStatus Rather than use dates for the bookings I convert everything to dayOfTheYear (using ColdFusion) and each DOTY for each property has a … |
| | So I have one page that basically reads the entries I have from my table and out puts them with a link around the date so that when clicked your supposed to be able to delete it. Problem is when I click the link nothing happens. Heres the code for …  |
| | So I'm trying to have a relatively simple script. I want to just have one entry in the SQL table and when new information is entered just overwrite that same entry. For the table I have the primary key as the variable ID. I'm not sure how to just extract …  |
| | I am currently wanting to know how to find out two different dates from a list of dates for each customer. I can find out the first date for each customer but I need to know their 6 month and 1 year visit. But the problem is not all the … |
| | Hi everyone, I'm a bit of a noob on the forum so please correct me if this is posted in the wrong area/or post is incorrect. I'm currently working on a new website ([URL="http://www.worldwidemixtapes.com"]http://www.worldwidemixtapes.com[/URL]) and currently stuck on the "sort by" section at the top of the page. What I'm … |
| | Hi, I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the one of the row of … |
| | Hi I am using a list view to view the data between two selected dates i have two ways: 1. [code] "select * from mytable where mydate between '" + fromdate + "' and '" + todate + "'"; [/code] 2. [code] "select * from mytable where mydate >= '" … |
| | i have this code but it cant work in my hosting usualy the error is : The following errors were reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''comments' ( 'id' int …  |
| | I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility … |
| | Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed … |
 | Hello fellas I'm actually developing some web applications in Ajax, and have been trying them in my Wamp server for Windows 7. I've been using the php_sqlsrv module since its release, because of its new features. The thing is, my office has a fedora webserver, and I'm looking for a …  |
 | Is it possible to pass arrays into a function and/or return an array from a function? I think it's possible but I don't really know how to go about it. lets say I have a function that returns a bunch of field from a database ex: [CODE]function a($sql){ $result = … |
| | Hi, I am just new using the Microsoft Application Blocks .NET. I am using a custom one... The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...? [CODE]public void ExecuteNonQuery(SqlCommand sqlCmd) {...} public … |
| | I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from … |
| | Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only … |
The End.