6,934 Topics
 | |
| | Hi everyone... this is my first post... so I would be quite descriptive I am working on a Web App which is a Helpdesk Solution and is based on PHP and interacts with MySQL, MSSQL, Oracle, Postgres SQL... we also support Linux based and Windows based installation... There is quite … |
| | I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT … |
| | Hi guys. I have an ASP.Net assignment to do and need some assistance if possible. I previously read a post from a person with the same assignment but this is for ASP.Net LINQ to SQL not windows form. The following is my code forthe batting average. Code-Behind [code] private void … |
| | can someone help me with why this code is not inserting into the database [CODE] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT INTO Workers (FName, LName, FullName) VALUES ('" & Me.txtName.Text & "', '" & Me.txtSurname.Text & "', '" & Me.txtFullName.Text & "')" 'Dim data_base As String … |
| | Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title for any Recruiters who have worked on more than/less than 6 projects within a specified period. These are the tables: dbo.tblResources ResourceID Company Name dbo.tblRecruiters RecruiterID ResourceID dbo.tblProjects ProjectID Datecreated dbo.tblProfiles ProfileID ProjectID … |
| | Ok, so I've been looking all over the web to try and solve my problem... I have an SQL 2005 database on a web server which displays information to customers via an asp.net web site which also offers interaction with the data. I also have a Windows .Net application which … |
| | Hello Dear all, i have created a html page to insert data in sql table. my html page have date , month and year columns. which is stored in sql table in their respective columns. now i want to retrieve data from sql table in a php page. but i … |
| | Hello all... I'm trying to populate a Flexgrid using an SQL query that involves values external to the database being queried. The database contains latitudes and longitudes of points of interest on Earth. Ie. Point A, -43.5644,-79.5432 Point B, -89.5433, 76.3343 Point C, 54.6433 , 65.4432 What I want to …  |
 | Hello Is there a querry to convert a whole column into MD5 but i only need the first 19 characters of the MD5 thanks |
 | Hy guys as mentioned before on my threads I'm a self teaching person learning VB. I' sucessfully created a project fully functional using access database. I've read about SQL connection on VB .net. But I'd apprecite a help to have some one guiding me step by step on how to …  |
| | I am making a program on library management but in my program I am getting the error when I am extracting the date from MySQl(my database). Below is the short piece of code where I am getting the error. [CODE] Calendar c1=Calendar.getInstance(); ResultSet rs=stm.executeQuery("Select AccessionNumber,Name,Fine,DueDate from issuer natural join classinfo;"); … |
| | hello my first thread to as for something here but i like daniweb a lot i'm trying to save data from listview to sql server [CODE] Dim iCount As Integer Dim iLoop As Integer Dim query3 As New SqlCommand Dim lvitem query3.Connection = New SqlConnection("Password=sasa;Persist Security Info=True;User ID=sa;Initial Catalog=Tel;Data Source=HA-PC") … |
| | As the title goes how can i transfer a table from one DB to another but first i need to delete the table1 from DB1 coz table2 from DB2 has the same name as table1... |
| | i have this insert code that is refusing to work it is giving me error 26: something to do with the network or connection. i am using sql express 2005 and vb.net 2008 any help will be greatly appreciated [CODE]] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT … |
| | hi there, i have a question in giving access to separate table to users. i have a database call Admin and in that there are some tables that the one user should not aloowed in viewing, how can i restric that user in avoing looking at that table i am …  |
| | Hi Please help me out in providing connection string for the SQL datasource at runtime...i need to connect to different database based on the login option....i removed the connection string in the web.config file and tried to select the connection string during page load but it shows an error...can this … |
| | [ICODE][COLOR="Red"]Please send any Example for [B][U]DataBinding of WPF with SQL Server[/U][/B][/COLOR][/ICODE]:):):) |
| | Dear all. I need help regarding on my error.. this is the sample code: [CODE] Private Sub GetDetails(ByVal id As String) Dim conString As String = (ConfigurationManager.ConnectionStrings.Item("ItemListing").ToString) Dim objConnection As New MySqlConnection(conString) objConnection.Open() Dim sdr As MySqlDataReader Dim sSQL As String = " SELECT i.SuppCode,s.SuppName,s.telno,s.Faxno,s.email,s.Salesman,s.Mobileno,s.add1," & _ " i.masterefno, i.invoicerefno,a.remarks, … |
| | HI im new to asp.net and i want help when click insert button same record is inserted instead of new record. Pls reply asap as my project is based on this [code] using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; … |
| | |
 | Hey everyone. I have a mysql project that requires only some basic queries except one. Nothing more challenging than some really basic select/insert statements. No problem there. But the one complex one isn't working out. I typically work a little with SQL server and wrote the following at work in … |
| | I’m trying to pull athleteid, firstname, lastname, rushyards, teamname …while athletes.athleteid = ‘200’ My main goal besides getting this data out is that some athletes may move teams. So like atheleteid = ‘200’ may be on team 10 during weeks 1-4 but on team 15 for weeks 5-16. I’m trying … |
| | I have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. If I declare Public Class Form1 Public payPeriodStartDate, payPeriodEndDate As Date How then to I declare that variable in …  |
| | Hi, this is what i've got so far: [CODE]$sql = "SELECT * FROM ".$_SESSION[dbprefix]."users, user_skills WHERE user_skills.userid=users.id AND ((users.username LIKE '%" . $queryString . "%') OR (users.email LIKE '%" . $queryString . "%') OR (users.firstname LIKE '%" .$queryString . "%') OR (users.lastname LIKE '%" . $queryString . "%') OR (user_skills.skill … |
| | Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation? |
| | hi, i have a problem in login in to the MS SQL server 2008, i installed the MS SQL with the authentivcation mode as Mixed mode and and for the SQL server administrator i added the current user and for the password i gave a different password, which is not … |
| | Hi all, i'am having a problem with my sql database.I'm able to insert and retrieve data.but i couldn't able to view the data in my sql interface.all the columns are empty.so where the data being stored ? why it is not appear to the sql interface ? |
| | what is the best way to read millions of record from sql server database.i have tried data set but still the performance is not so good. |
| | hi there, i have a question in connection my application to ms sql 2008. i wrote a desktop application in visual studio 2008 in the C# language. and i have installed the MS SQl 2008 DBMS software. and when i try to connect to the MS SQL in Mixed mode … |
| | Dear friends, I'm doing a PROJECT work in ATTENDENCE... i need to check, HOW MANY DAYS employee IS ABSENT... I need a PL/SQL PROCEDURE to ACCEPT 4 DATES: DATE 1: When he gave the LETTER for LEAVE DATE 2: When he was GRANTED leave DATE 3: FROM - DATE. which …  |
| | Hi, I want to know how to use Python variables in My sql statement and below is the syntax i am using import MySQLdb name="XYZ" number="123456" db=MySQLdb.Connect("localhost","root","12345","phone") cursor=db.cursor() sql= ("""INSERT INTO phonebook(number, Mobile) VALUES(%s,%s)""" , name,number) cursor.execute(sql) db.commit() db.close() but this throws the error please refer the attached screen shot … |
| | Hey, im trying to get some information out of my database, which i have tableadapter and dataset. Both created with the VS2010. I have made 4 queries in the tableadapter taking different parameters, to make a WHERE clause in the sql sentence. But it simply doesnt work and i dont … |
| | Hi Everyone, I got a problem while creating a views in sql server 2005. In my database there are several tables which are accounts_transaction bill_info member_bill member_info relationship is exist between “member_info and accounts_transaction, member_info and member_bill, bill_info and member_bill” but there is not any relationship between bill_info and accounts_transaction. … |
| | Hi, I'm new to mySQL and I've got to run a bunch of queries on a database that I've been designing for a hypothetical record company. If anyone could check my queries, I would appreciate it greatly as they don't seem to be returning the correct results and I'm not … |
| | I have been trying to get it so that my php will check that the website stored in the database is actually there before offering a link.( in a multiple list) eg. if the site http://www.boohoo.com exists there will be a link to it, if not then it will simply …  |
| | I am starting a new website.I want a best Login Logout Php mysql script with for get password fearutes.Where i can get it. Please help me |
| | Hi Guys, I'm having an issue with my sum() function on my queries. My DB has 3 tables 1. plans 2. handset 3. matrix [B][U]plans;[/U][/B] - planNum - planCode - planName - planLength - simRebate - commission [B][U]handset;[/U][/B] - handset - RRP [B][U]matrix;[/U][/B] - planNum - handset - subsidy The … |
 | I want to search through an sql table called hardware for a partial serial numbers. I have the following code but there is something wrong with the way i am doing my sql query. hope someone out there can help me. [CODE] Public Function GetDatabysn() As DataView Dim SelectQry = … |
| | Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields … |
| | I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but … |
| | I have the following code that will update one field called RCon in sql, does anyone know how i can update a few at the same time? i would like to update the sql field (called stockdesc) [CODE] Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString … |
| | Hello I am building a web page and decided that this time around I would make many user web controls as to have a very modular and customizable site with ease.. Anyways it was going off without a hitch until today I designed a new control. Its a panel with … |
 | I need some help. I have a website where people can create a class or event with times and places for the class or event. Once this instance is created they are supplied a link for people to sign up and a passcode for them to use to modify the … |
| | I am trying to display the number of rows I have in my database, but instead of the number being displayed on my page I just get the word 'array' My code is below [CODE] $productCountSql = "SELECT COUNT(*) FROM products WHERE `user_id` = '" . $_SESSION['user_id'] . "'"; $productCountResult … |
| | Hi everyone! I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query? For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so …  |
| | Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL … |
| | Hi, everyone this is my first post here and let me tell you my problem I have a C# application, i have SQLServer 2005 installed on my computer my database is there and the program works fine the problem I'm facing is that i need to make an installer for …  |
| | Hi, i am using c# window application I have create one Login Form. I want that when user put its username and password first it should check in the database and then it should give the out put. i have even create on signup form first it should be register …  |
| | Evening All, i am trying to input 72003 3131/1 from text from a text field into sql as a string. I have the following code but getting an error Error while inserting record on table, incorrect syntax near '3131'. the end user will be able to change this text to …  |
| | Hello All! I didn't see a place for SQL commands and I apologize if I overlooked it, but i'm really stuck on this. Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2). My constraints are: •That I have … |
The End.