6,934 Topics
 | |
 | 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 m trying to make something like a login page with C# using VS 2010 and SQL server database. I am using the following code to get the password from the appropriate username but i get an error of Object reference not set to an instance of an object. … |
| | 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 need to restrict access to other table id's by making a check against an (id) of a table named users and then check that the (user_id) of another table is the same i.e table1 id username password table2 id somedata user_id if table1 id is the same as table2 … |
 | Hi !!! I have a table with two columns. The first column is called 'Login', the second column is called 'Password'. I wish with help of some query to extract how many rŠµcords I have in this columns. I use 'SELECT COUNT(*) FROM TableName WHERE Login = @login AND Password … |
| | Hello all, working in VB6 I want to pull all records from Access table named Answers that in a field named Color have "White". Within that record there are 10 fields of various numbers that I want to sum and average. In short I want to pull all records with … |
| | I am not able to establish remote connections to SQL Server 2008 enterprise edition. I have followed and implemented a lot of tutorials available. These are the things i have done: 1. enabled TCP/IP connections in SQL configuration manager. 2. added a rule to allow inbound connections at port 1433. … |
| | Hi, Im a sql novice and need some advise from all you gurus. My current environment has me running an application that uses Sql Express 2008. We have just moved into our second office and need this application to run in both offices (preferably off the same database). Old Office … |
| | 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 … |
| | I am facing a minor challenge in my coding i am trying to generate reports from sql statements.however the method i was using ealier involves making a crystal report using the "Add new item".in the menu and using the wizard until you end up putting the table you want on … |
 | Hi geeks, I really need your help. I want to query in a table in MS SQL using a data in another table. This might give you an idea on what I am talking about. This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2 WHERE TABLE1.FIELD3 = … |
| | Hi geeks, I really need your help. I want to query in a table in MS SQL using a data in another table. This might give you an idea on what I am talking about. This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2 WHERE TABLE1.FIELD3 = …  |
| | 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 |
| | Hi , i am suresh . new to this site, let me know whats the requirement of hardware for sql server |
| | I have a table with one record per certification a user has. So, user SMITH can have multiple records, one for DMV another for CPT and another for ICD. SMITH has three certificates but can have up to 20. The desire is to have a second table with one record … |
 | iam try to retrieving data from multiple table and i want that data to be shown on one page. can any one help me out what worng with this coding i cant get that resul which i want. here is the coding [ICODE] <? include("connection.php"); $q="select * from patient_detail,patient_information,patient_guardian_information,patient_discharge_information where … |
| | 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 'reasons = '', birthplace = '' dob_month = 'January', dob_day = '' at line 8 Hello aLL I am developing an online registration form that … |
| | 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 … |
 | Hi all, I am transitioning a bunch of data from html (yuck!) to some sort of separated schema. I was going to use xml: [code] <events> <event> <title> <date> <speaker> <description> </event> </events> [/code] but now I am wondering if I should use a real database instead. Can anyone comment …  |
| | Hi, As i was experimenting stored procedure's TRY-CATCH with RAISERROR, came across this issue. Would like some opinion on this. Microsoft sites documented as follows: SQL Error 0 - 10: caught in the TRY-Block, i.e. will not reach CATCH-block. SQL Error 11 - 19: caught in CATCH-Block SQL Error 20 … |
| | Just a couple of problems I'm working on-- can anyone help. Thanks. 1. You are making changes to an existing ASP.NET application. The application contains a DataSet object, dsProspect. The page you are changing displays prospect data from the dsProspect DataSet and includes an Update button. You define a new … |
| | How do I replace 63 strings in a .sql via php. Im making a multiforum software and I can't figure this out.  |
| | what is the problem? i have this message when insert? [QUOTE]Error: 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 '4'', `data_no` = ''1'', `note_date` = 1293628283, ' at line 4[/QUOTE] and this is … |
| | Hi All, I have created a form called new users, I have added my data source, draged over the objects I want from the dataset onto the form and all is well appart from the fact that I cant delete records. To add them I simply click the add button, … |
| | Guyz i have this insert function that is supposed to help me insert data but somehow i dont know how to actullay call it and get it to insert data [CODE] Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click DataAccess.InsertNewRecord(txtName.Text, txtSurname.Text, txtID.Text) End Sub [/CODE] [CODE] …  |
 | Hi Guys I have an application that developed using ASP.net.There is cancel option,user can select number of item code and cancel it,but there is isssue.The issue is once user select more than 200 item code to cancel then it generate the error messsage.Error message is "Time Expird or server is …  |
| | hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database.. now what i want is to retrieve the data for each four hours.. i.e i want to execute … |
| | Hello, I made a PM system but the thing that makes it read isn't working. Can you take a look at it anybody? [code] $postid = $_GET['postid']; mysql_query("UPDATE pm SET read=1 where id=$postid") or die(mysql_error()); [/code] And it gives this error: You have an error in your SQL syntax; check … |
| | Hello, I am trying to do the student evaluation and stuck in this problem. Each student evaluates himself and all his friends in the same class. I have a sample table below. On the query, I tried to join the table to itself to get a new column calls "StudentID-Change" … |
| | Hello everyone, I'm having some trouble converting from cell values in excel to datetime in sql queries. BTW I'm using AdvantageDatabase and Excel 2010 Let's say I have a cell value D4 "12/12/2010" Inside Microsoft query I have the following: SELECT * FROM mytable WHERE mytable.Firstdate =? Microsoft Query then … |
| | in vb.net to store this query in dataset ..In Sql query I have a Employee Id M 1 M 31 M 41 M 58 M 6 M 60 M 67 S 10 S 118 S 133 S 143 S 151 S 155 S 157 S 158 S 25 S 28 …  |
| | Hi Guys I am really stuck and cant think for the heck is wrong with this. I have a basic login jsp page that gets a username and password from a page and then sends them to a login Authentication jsp script, i use [code]<sql:query var="dbData" > SELECT * FROM … |
| | How to find the minimum or maximum value across several columns in sql server |
 | Morning, Please a clever person help me, i am using VS2010, I have a form with a button with the following code. [CODE]Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim cryRpt As New ReportDocument Dim crtableLogoninfos As … |
| | Morning all, I have the following code that gets a jpg image from sql which works fine. What i would now like to do is save this image as a file on my pc in a temp folder that i can use in a report. i would like to change … |
| | Plz send me the complete code for convert xml file to sql database  |
| | 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,so i can print on the application the time … |
| | 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,so i can print on the application the time … |
| | Hello, I need help transforming a current script into on that can loop through some data for me. As you can see I currently have the ItemName and Address commented out "-- Set @ItemName = '95B046125' Set @Address = '195 WELLESLEY ST E'" and then I have to uncomment it … |
| | I am still fairly new to PHP, so I will do the best at explaining what I am trying to do here... I have a database table where I store a bunch of invoices. I am now trying to make a front end to run queries. I don't know how … |
| | Afternoon All, I have ran into a problem that i cant get my head around, I have the following code(see below) this all works fine if there is a imgID ='5' but if there isn't a record in the sql table with the imgID 5 then i get the following … |
| | i have this insert code and its giving errors because there is something wrong with the connection string. [CODE] Dim MyConnection As SqlConnection Dim SqlString As String = "INSERT INTO items_table (item) VALUES ('" & Me.txtItem.Text & "')" 'Dim data_base As String = " Data Source=.\SQLEXPRESS;AttachDbFilename="C:\vb2008\Visual Studio 2008\Projects\morevariables\morevariables\App_Data\test_db.mdf";Integrated Security=True;User Instance=True" … |
| | hello, I have a simple problem. I need to create a new table "smaller" using the data from an old table "larger" table. When I say smaller I mean it will have the exact structure as the older table but will have only a few records. Now, i know that …  |
 | Hey everyone, im currently designing a database. i usually design my tables with "LastUpdate" field with a smalldatetime data type for tracking purpose. which is whenever user insert or update a row. there's a trigger that updates that specific field. now, i was thinking to split the information of "created … |
| | hi , i have a field in a table with the datatype as datetime. i wrote a query to get that feild but the thing is i want only the date to be displayed, how can i do that, currently the date and the time is being is displayed, how … |
| | Hi, I've built a website which acts as an online book store. Customers can log in and view books which are displayed in GridView1 which is linked to an sql database. I now need to build a shopping cart feature which will allow them to add books from the GridView1 … |
| | Greetings All, I'm working on some code to essentially build a CGI page where the user places in there SPNs in the form with spaces(example--->) (967866 4566776). Then it calls the subroutine to run a join command to take the SPNS given by the user, and parse them with commas(example--->(967866, … |
| | I was wondering if anyone could tell me why my code is not displaying anything. My connection is correct because I did copy it from a program that already works properly. *Beginner Student* [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { class Program { static void Main(string[] …  |
| | I am trying to carry out a synchronisation of two databases one on the server and the other on a local machine so that even when they are not connected on the networkthe local database can carry on accepting data but when the network is back on the local database … |
The End.