6,934 Topics
 | |
| | Hello! I need to write a query that selects TableID (a previously concatenated string) and also selects a substring of TableID as another column. All data in TableID is in the format %System.Variable, %Class.User, etc. I need to select from the % to the '.' to return something like %System … |
| | Hi, I'm just want to ask if it's possible if I want to update multiple record with same condition at the same time. For example, I have a table named *userTable*, it has two field, *year* and *status* fields. On year *field*, it has value of years and on *status* …  |
| | hey i am having three columns "fname", "mname", "lname" in one table... i want to take each column's DISTINCT value without relating fields in one query.. i mean distinct of "fname" in first column, distinct of "mname" in second column and distinct of "lname" in third column can anyone help …  |
| | Here is the code that can be copied into sql server to better assist with what I am trying to accomplish. Hope it makes sense and post back with any questions you may have: create table #temp(period int, location int, custnum varchar(10), driver varchar(25), dollar decimal(10,2)) insert into #temp values(201201,221,'ABC123','dwcustcomm',52.37) … |
| | i installed .net framework windows installer and then sql server 2008 then sql server management studio 2008 iam using windows xp it shows very less shared features while installation... i want to know why it showed so less features? is it because of poor hardware resources?  |
 | hi all, I am new to php and have started some coding.I want to insert values in one table1 and update values of table2. It worked for me last day..but today it doesnt work.I have hardly changed any code.i guess except fr deleting some comments in code..u plz tell me … |
| | Hi, I have this datatable that I need to loop for my excel exporting function. And I have to export data that exceeds the row limit of excel worksheet. now I want to know how to create a query of limit on the datatable.select in such way like in sql. …  |
| | Hello Daniweb. Im currently working on a solution that involves querying a specific user (either by getting the user to 'login' or by detecting who the user is that is logged in to the machine) against the domains active directory structure to determine if they are a member of 1 … |
| | hi, just want to maek sure some thing. so i have a table called user. in user table i want to add a field called date of birth. but i dont know which type to choice. it has int, varchar, date, datetime etc. but no date of birth. do i …  |
| | Hi Friends Iam newbie to vb.net .iam creating a registration form.iam also creating database table in sql server.now how to store record in that table.how to do this? regards apking |
 | I have a dataset (GrindItems) with 4 datatables successfully populated from dbf files. If I understand the concept of a dataset, I no longer need an open connection to the source db and I should be able to query my dataset. My first question is whether I need a Connection … |
| | I'm trying to make multiplication in web shop that will show real price: **discount * tax * product price * 1 piece= real price** But I just don't know how to do it, I try 1 million things, spend about 48h just to make it, but, without success, no matter … |
| | I need to order these dates in descending order (last should be first) and in fact how they now appear. However they do not necessarily appear like those so I need a SQL Order By clause to order these descending: 2012-01-23 09:53:24.097105 2012-01-20 17:31:57.565458 2012-01-20 17:01:09.154587 2012-01-20 16:28:40.685735 2012-01-16 12:03:54.99954 … |
 | The aim of this tutorial is to save burgeoning self taught developers some of the early pitfalls that lurk on the road to programming enlightenment. It will attempt to do this by distilling the last 50 years of software engineering philosophy into a relatively short single tutorial, applying the concepts … |
| | 0 down vote favorite I am trying to write a script that will return the latest values for a unique documentid-physician-patient triplet. I need the script to act similar to a group by statement, except group by only works with one column at a time. I need to date and … |
| | Hi, *I have installed sql server 2008 management studio with "use sql server authentication". *I have created a database with database name:stock owner:<default> *In Vb.net created a windows application;clicked on Add datasource;changed d datasource to microsoft sql server database file(SqlClient);clicked on option button use sql server authentication n then provided … |
| | Hello all i have some problem with update query. select query works all right but update qurey doesn't i have tried to to run that query in mysql directly from phpmyadmin and it runs fine ... can you check what i m missing here in code in update query and … |
| | In this assignment, I am having to insert user information to tables that we have created and I am having this error that keeps on telling me " Code No: 80040e14 Code Message: IDispatch error #3092 Error Source: Microsoft OLE DB Provider for SQL Server Error Description: The name 'Br' … |
| | I've had this problem many, many times. And it's always turned out to be a small typo or "" around an integer, but I just cannot find what's wrong with my SQL Statement this time! [CODE]SELECT Card_ID FROM Payment WHERE Customer_ID = 12 AND Card_Number = 1231231231231231[/CODE] The table and …  |
| | i need to filter my table between 2 dates but it makes wrong filtering really i dont understand why. but it might be my wrong codes here is my codes... what should i do? Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim da As New … |
| | I have a website for a painter where the painter uploads a picture. The picture name is added to a mdb (access) database table, the picture is added to the end of a table called galleries, and the file is uploaded. It is also then resized to a small image. … |
| | Hi, I have to make a GUI to input data into an SQL server 2008 r2 database, and I was hoping someone could give me a heads up about the how to do it? I remember the basics of doing it in Access but of course its different with each … |
| | hie m using visual studio 2005 and sql 2005 i want to export my sql database to excel.. |
| | Hi guys, I'm trying to create an array with the length according to the number of rows in my database. So here is my code. I getting "array out of bound". import java.sql.*; import javax.swing.*; public class prg extends javax.swing.JFrame(){ String nameC = "HDB"; String nameCC = ""; int count=0; … |
| | this line of query run in php get the right result which is 4 but I use it in php will only get 1..how come? function totalrental(){ $result = mysql_query("SELECT SUM(Rent_time) FROM product") or die (mysql_error()); $count = mysql_num_rows($result); if ($count >= 1){ echo $count; }else{ echo "0"; } } |
| | Hello , Can anybody tell me that is wrong in this statement `$data = mysql_query("SELECT Column1 FROM '$tbl_name' WHERE Column2 = '$image'");` I then tried `echo $data; ` - But no result Basically i want to retrieve the value of Column1 where the value of Column2 is equal to the … |
| | Hi Friends I am new to asp.net, i want to display menu title from database using VB in asp.net, the display should be done in list format while href tag, i am expecting the display as below menu1 menu2 menu3 Please can any one help me to solve this issue. |
| | Hello, I am trying to display various types of search results on a seperate page: Here is my PHP CODE for the form: --------------------------------------------------------------------------------------------------------------- <table width="75%" cellspacing="10" cellpadding="10"> <tr> <td width="22%" class="subtiwhite"><strong>Search by Name:</strong></td> <td width="74%"><form name="form1" method="get" action="searchname.php"> <input type="text" name="namelist" id="namelist"> <input type="submit" name="searchname" id="searchname" value="Submit"> </form></td> <td …  |
 | hi friends, i have a problem with using vb.net application, i want to restore my database from my vb.net application so that user clicks the restore button an OpenDialog open which Open the .bak and then restore the database to a state befor backup taken. i try the follwing code … |
| | I'm having a problem of displaying all the data of a column in a text file I can display only the first data, so please someone tell me what can I make to display them together in a text file. Connection con = DriverManager.getConnection(host, uname,password); Statement stmt = con.createStatement(); ResultSet …  |
| | How does one validate username and password from sql database? I have used parameters in doing validating my database, but have noticed that username and passwords are being accepted when i type it straight out(EG. username= e001 , password=dave@road) , even though they have characters in capital letters(such as username=E001 … |
| | Using VB.NET 2010 All helps is greatly appreciated! Currently I am parsing through 1,000s of text files each day and inserting them into SQL. I am unsure how to break up the actual pipe delimited data and insert it properly into my database columns so I am doing that through …  |
 | **Is this possible to establish connection with sql 2008 R2?** Dear Experts, I am trying to create connection between Sql 2008 R2 and Visual Studio 2010 (I have installed Sql first). Is it essential to work with windows 2007? I have to format my computer because of this, would you … |
| | So i have this table: numb_1 | numb_2 | numb_3 ------------------------ 5 | 5 | 5 1 | 5 | 5 2 | 2 | 3 5 | 3 | 6 5 | 4 | 7 how do i find the most common value in the 3 fields? so for … |
| | I 've a following query that going to use in python api. SELECT n.FIRST_NAME as "NAME", a.STREET_1 as "ST1", a.STREET_2 as "ST2" FROM SCHE.EMPLOEE_NAME n, SCHE.EMPLOYEE_ADDR a WHERE n.eid=a.eid AND n.estatus='ACTIVE' The above query yields the result cursor().execute(sqlQuery) sqlTupleRows=cursor().fetchall(); sqlQueryReturnedDict={}; for sqlTupleRow in sqlTupleRows: columns=cursor().description ...... Here the column names …  |
| | Hello, Does anyone know how to connect to a ms sql server from a unix platform Below is the code i found. I've setup the slq server and allowed it to accept remote connection. Port 1433 is open for connection and firewall is configered to allow remote connection. The host … |
| | Hoi At the moment I'm learing Databases. this is some code that I'm using. The question that I have is, can I insert a row without ID. I mean that the database increase the ID number itself. Thanks in advance. command = new OleDbCommand(); command.Connection = connect; command.CommandText = "INSERT … |
| | I am trying to create a search form for my database where a user can search for a customer name and all of that customers addresses will be displayed. my structure looks like this Customer table + ID + First Name - Last name - Company Name Address Table + … |
| | Hey Guys, I'm working on a practice Project at the moment where I'm recalling user information from a database, placing it into a form with several textBoxes, comboBoxes, etc and then proceeding to update the information in the database when the user clicks save. I understand this is simple, however … |
| | |
 | i get this msg from sql server when i restore the back up file TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\TenderingSys' is incorrectly formed. SQL Server cannot … |
| | Help!!! I cannot get my combo box to populate using a select statement from mysql database. Please see below for coding [code] CN = New ADODB.Connection 'Connecion to database CN.Open("driver={mysql odbc 5.1 driver};server=localhost;database=v_control;user=root;password=;option=3") RS = New ADODB.Recordset RS.Open(SQLdata, CN, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockPessimistic) If DBconnect() = True Then SQLSearch("select * from engineer … |
| | I have created a linked server in ms sql 2005 on server machine A . It links to another database(say D1) located physically on a different server machine B. I have jsp code on Server A which accesses local database on server A. Can I access the remote database D1 … |
 | I would like to develop a SQL injection vulnerbility scanner. However, i dont know how to develop it, It is any module in python could help me develop this app? My app requirement User able to input the target URL and apply SQL injection scanning on target URL After that, … |
| | Dear All ! Please Correct my SQL String. sqlcmd = New SqlCommand("Select top 10 Distinct[Batch No], [Item Name],Decentralization, UOM, Balance from Decentralization order by Serial desc", conn) When I run this Command I get Following error : incorrect syntax near the keyword 'Distinct' |
| | Hi, I am writing a Silverlight Bing Maps based application and I am trying to merge two (and more) polygons. The approach I am using at the moment is the following: The geometry for the polygons is stored in a database, and Im writing and reading from it through a … |
| | I have a Query string > { "id": "105201322211272730088", "name": "Rayidi Radha Krishna", "given_name": "Rayidi", "family_name": "Radha Krishna", "link": "https://plus.google.com/105201322211272730088", "picture": "https://lh3.googleusercontent.com/-UTEdowBnUUE/AAAAAAAAAAI/AAAAAAAABd0/FrCv9VX1Pp4/photo.jpg", "gender": "male", "birthday": "0000-09-23", "locale": "en" } I want to convert this Query string to an array. thanks in advance. |
 | OMG Optimization.... One of those things that is widely discussed but with no real specifics because everyones setup and situation is different. So I spent all day trying to find ways to accomplish this as our SQL server was maxed out. Let me do a bit of setup explination.... We … |
| | Hi, i am trying to pass the value of a text box to a sql statement, the only thing is that the sql statement is located in a different file to where the text boxes are. i have had some trouble in the past with this, as when i call …  |
 | Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end … |
The End.