2,569 Topics
 | |
| | Hi, I tried installing MS SQL server 2008 on win 7 Ultimate x86. It was slipstreamed installation with SQL SP1. I got 7 errors during installation. All of them are showing almost similar messages (but different event ids)except the 2nd error (which was about failure to open some registry). The … |
| | Hi I am having some issues with sage pay php form integration. I have built a shopping cart that selects product information from a database and am having issues integrating it with the kit. When I test against the sage servers, everything passes except the cart contents. Is there anyone … |
| | hi there i have a database called employee and in that there is a table called EmpDetails and in that there is column namely firstname awhat i want to do is to return all the first names in the database. i am using the 3 tier architecture. from the dbcommection …  |
| | Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) … |
| | Hello my friends. I've been dealing with a problem in an asp.net page that im developing. Generally I don't develop in ASP.NET i prefer desktop applications. But here is my problem, I have to create a kind of image wall (4 Faces in a 2x2 row), i'm almost done with … |
| | Hi all i have been dancing around this problem for a couple of weeks now and have not got any closer. Description: i have created a crystal report in SQL5 and exported it fine but now i have gone to open it in visual studio 2008 and it does not … |
| | Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ? |
| | Hello all, I’m getting one strange error on my web. The web was developed with spring and has a tomcat pool connection configured for Oracle DB. After upload the web content into the server, when restarting the server and trying to open the web page, first time display error: [ICODE] … |
| | Hi there, how can i create an executable so that anybody can install in their own computer? I want to create from visual studio C#. please give me a tutorial or something, i did some but it didn't work properly please help guide in this thanx |
| | SQL 2008 database disappeared after canceling copy Hi All, We have an SQL 2008 database of around 12GB. I was trying to create a copy of the database through the Microsoft SQL Management Server Studio. The server is in production mode, and it was taking too long to copy, and …  |
| | [CODE] Create table Cameras (CameraID varchar (35), CheckOutDate varchar(10), ReturnDate varchar(10), primary key(CameraID), foreign key(CameraId) references History(CameraID)); Create table Borrowers (PsuID int not null, BorrowerName varchar(30), Email varchar(50), Telephone varchar(12), ReasonUse varchar(200), primary key(PsuID), foreign key(PsuID) references History(PsuID)); Create table History (PsuID int not null, CameraID varchar (35), BorrowedFrequency int, … |
| | I can find a lot of information about the concepts of normalization, but I don't really see documentation for how to actually bring a table, for example, from first normal form to second normal form. I'm using SQLite through Python to automate some data processing, and I have three input … |
| | [CODE]select PREMISEADDRESS1 from PREMISE PREM inner join STATUS ST on PREM.LOCATIONID = ST.LOCATIONID inner join SUPPLIES SUP on ST.STOPID = SUP.STOPID where SUP.ITEMID [COLOR="Red"]=[/COLOR] (select count(ITEMID)[COLOR="Red"] > [/COLOR]10) from SUPPLIES) [/CODE] Hello, I do not use SQL all that often but I would like to view all of the premisesaddresses …  |
| | Buddy , i have problem in to combine sql with c++ plzzz any one help for this issue hurry friends i have a library project to combine it with database. hellppppppppppp meeeeeeeeeeeeeeeee............. |
| | Hi, I am vee and I am trying to create a Natural Language search engine based on LSI. I am stuck up and I would be really glad if I could use some help. I have a two-dimensional array which is full of numbers. I want to transfer the contents … |
| | Hi Experts, I have a windows service running every minute and has many database operations to perform. It runs perfectly for many days, sometimes it suddenly stops and throws this exception. Later when we start to debug it, the exceptions goes off, but if we don't debug, the exception continues … |
| | Hello everyone! I'm wondering if there is a way to assign the values of a column in SQL as the key name in a multidimensional array. Here is what I have, my database looks like this: Table Name = SJCFPCB date | totalin | cdulep | icu | ----------------------------------- 2011-01-27 … |
| | Hi All, I have a problem and I dont understand what's happening, because my method usually works. I am querying a bunch of records from a database given a foreign key id. See code as follows [CODE] $castQuery = "SELECT * FROM cast WHERE production_id = '$newID' "; $cresult = … |
| | in my application i show database table in a datagridview , now i want to modify and change some records and save this changes on database , how can i do this ? thanks |
| | I can't insert values into a table using a stored procedure because the fields are of data type MONEY. First, is the data type CURRENCY the same as data type MONEY? Right now, I am currently using the integer value of adCurrency for the data type parameter of the createparameter … |
| | hi.. i'm using ssrs 2008 enterprice edition.. i want to send a report as email.. to my gmail address.. i want to schedule a report so that it can deliver daily to my gmail address.. how to send the report to my gmail address.. i dont know anything about smtp … |
| | I have a form set up and on that form is a DataGridView, on that DataGridView I would like to display all of a customer's transactions. I am having a problem where the debugger is throwing me a "Syntax error in JOIN operation." and I can't proceed. [CODE] ' Select … |
| | Hi there, I have a question in EncryptByPassPhrase. I am trying to encrypt the source column in the database table PForm. When I run the code it sasys, “Failed to convert parameter value from a String to a Byte[].” the SourcePath column in the database is varBinary(256) type. What is … |
| | I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my … |
| | I am trying to have a search bar where user will input a string ($var) which after i will search that sting in the field named: "itemname". i will search all the different tables in the database and create a new temporary database named: searchtable. seachtable should contain all the … |
| | hi there, I asked this question before also. i have two date times in a table in the MS SQL server database, when i write the query as below. the Sstart Date and the Due Date is displayed as 12/11/2010 12:00:00 AM it shows correct in the MS SQL business … |
| | [B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …  |
 | Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: … |
 | I'm a very new developer (if you could even call me that), and I'm killing myself here. Essentially here's what I'm trying to do. A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on … |
| | Hi there, How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2??? or if i can get a good tutorial appriciate a lot thanxxxx  |
| | Hi, I have a question in MS SQ L enter prise edition. I have writtend an application in Visual studio 2008 standard edition and I am connecting to ms sql sever enterprise edition 2008 r2. When I depoy the application I created and install inanother computer some components relating to … |
| | guys How do you Create Database in MS Access Using Oledb in vb.net? |
| | how can I select one or more columns from a table by column-index and NOT by columnname? I got the columnIndices of table by using this query SELECT name, colid FROM sys.syscolumns WHERE (id = (SELECT id FROM sys.sysobjects WHERE (name = 'table_name'))) |
| | I need a timer that will change the text of a combobox which is binded to a database. My Application which is based on hospital management wherein a doctor has to visit rooms within 6 hours. If 6 hours elapse the combo should show "need......" and if not something "......" …  |
| | Hi there, I am creating reports in SQL server business intelligent studio and when I deploy it to the report server the report is shown in only on a half a page. How can I make the report height and the width for the report thanksssss |
| | Hi, I am a beginner, and would like to do something like: I have a mysql table with date column. I would like to select all the rows from table, and print them out in tables. One table per month. E.g. January: ... ... ... February: ... ... ... etc. …  |
| | Hi I want to generate sequence number in C# window application I have got one link on Google, but I it is not helpful. I want that on click to add button an order sequence number should generate and stored in SQL Database i have written this code but it …  |
 | Hi I need to migrate an application from MS Access to SQL Server (2005), and i'm using the code bellow, but i'm getting an error when the compiler reaches the AddNew instruction. It gives me "Run-time error '3027': Can't update. Database or object is read-only". [code] Dim DBTesteSQL As Database …  |
| | I am trying to use a search script i found online and i am having a problem with the query. I am trying do a query from multi tables. I have 12 tables, all have the same fields: name, phone etc. each table is a different category of items: appliances, … |
| | Hi all, i wonder is it possible to display my images from database into table with 4 rows and 4 column? How can i do that? [CODE] $dbConn = mysqli_connect(DBSERVER, DBUSER, DBPASS, DBNAME) or die(mysqli_connect_error()); $sql = "select * from products"; $result = mysqli_query($dbConn, $sql) or die(mysqli_error($dbConn)); echo "<table border … |
| | i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button? |
| | Hi there, I have two tables. The first one holds information about cities: Locations: [code] locID | locationID | locationName | countryCode | 1 | 2922239 | Berlin | de | 2 | 291074 | Paris | fr | 3 | 295522 | Orlando | us | 3 | 292345 … |
| | Hello everyone, before i ask this question i would like to say first that im a beginner in asp c#. I would like toask for a tutorial on making a download button for binary datas. My file upload is already working fine. I just need a download button so i … |
 | Hi friends, after a long time. i am developing a small tool by using VB.Net. I want to display data in comboboxes from a table which is in an access database. I using SQL query. Its a simple problem , I think the problem is in my COMMAND. I want …  |
 | Hello, I have run into a problem where I need to update multiple rows in an SQL table at once. I have found and tried to use the tutorials on setting an ID and then looping through the data that way ([url]http://www.daniweb.com/forums/thread35096.html[/url]) but my setup is a little different: The … |
| | Hi, I have table structure as follows Table Name- facilities facility_id | hotel_code | facility_name 1 1 Parking 2 1 AC 3 2 Parking 4 3 Parking 5 3 AC 6 4 AC Now i have to find the 'hotel_code' that having 'Parking' and 'AC' both facilities ie 'hotel_code' as … |
| | i m working on certain project ,i created some tables in database sql server 2005 .and it created smoothly. for examples users table .so it append it with dbo.users .till there there was no problem i can easily access its object (table,storeed procedure) .but after few days it appended table … |
| | Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time. Not the user time because he might be … |
| | i want to generate crystal report using vb6.0 using invoice table which have rate column and total should round up like 63.7 to 64.00 invoice table is in sqlserver 2005 |
| | I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September … |
The End.