2,569 Topics
 | |
| | Hi Guys, I've just picked up an old projcet I was working on (about 6 months ago) and trying to get my head around my own messy N00b code. I've managed to get the grid views working with links back to the tables and showing data in the correct places. …  |
| | I am making a mysql query that gathers comments for a user, it works properly, I connect to the database and recieve the comments for a user, but it is not showing the first comment for the user. Here is the code function comments(){ //connect to db connect_db_members(); //start query … |
| | I am inserting values into a database but i get an error, it says the variable name @emp_login has already been declared. How do i resolve this? This is my code `SqlDataReader readerReference = cmd_Reference.ExecuteReader(); SqlCommand cmd_Insert = Connexion_Insert.CreateCommand(); string insert = "INSERT INTO EMP_tracking(emp_login, emp_dom_code, emp_domain,emp_surname") VALUES (@emp_login,@emp_dom_code,@emp_domain,@emp_surname); int …  |
| | how to update databse in remote machine,i am having .sql file which i have to update my database schema in remote machine,client will provide me his machine ip address,database username,database password,database instance name...pls help me pls package com.prion.testConnectivity; import java.io.BufferedReader; import java.io.FileReader; import java.io.Reader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; … |
| | How to validate textbox by allowing only characters, spacekey and backspace in vb 2010 utimate............plz help as soon as u can |
 | hi all. I want to fill the Listview from a mssql database in vb.net but it not show all the data in Listview. I have the followning code. Dim sSQL As String Dim lvwItem As New ListViewItem() sSQL = "SELECT field1, field2, field3 FROM tablenam e " sSQL = sSQL … |
| | I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line. select revertrsn from LN08PENm where aano in(754,870,1136,1138,1139,1140) the data coming in the row that I am retreiving is like this: As … |
 | Yesterday when I was working on php script I noticed that categories and subcategories works seperatly if I clicked on main category its show all articles under this main category and nothing imported from subcategories, now am working on somthing like this, so what should I do to avoid this … |
| | Hi, I am new to Java and is working on code in java which i need to keep a static sql script in property file and passing variable to it through java code and then iterating that property file to pass the variable value and writing that generated script to … |
 | guys i need ur help i want to insert data directly into the sql table using c# here is my code all that i have been able to do is get the values from the table not insert them i tried to do it this way but apprently there is …  |
| | I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are …  |
| | Hello, Does anyone know how to write recursive SQL statement for hierarhic output places from next table: TABLE PLACES: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I don't know if this is totally correct SQL recursive statement: WITH recursion AS (SELECT id, place, idParentPlace, 1 AS hierarhic …  |
| | Hello guys, Do anyone know how to write recursive SQL statement for hierarhic output places from next table: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I was looking for alot of tutorials but didn't find anything useful. Any help is the most welcome! Regards, TP  |
| | Okay, so I am not entirely sure how to fix this. Im attempting to make a tag feature for my site but I am getting: Fatal error: Call to a member function prepare() on a non-object in /Users/Home/Sites/functions/users.php on line 10 Here is the code that relates to this. First … |
| | Im doing a reservation site for a project. And Im trying to disable radio button(s) if the sql statement returns true. Example: User selects a date and a time, and radio button(s) would be disable depending on database. So far, I have this: $result=mysqli_query($mysqli,"SELECT tableselect FROM reserve WHERE reserveDate = …  |
| | Hello every one, i want to make a programme that read data from .xls file. a sql table will create on the basis of top row of the xls file, and rest rows will treated as data and inserted into the table. actually i am working for a office, their …  |
 | Hi, is there another way of hiding or formating column value in asterisk in select statement? im using the command replace SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if … |
| | Hi, i am trying to implement a federated search. I have no idea how to start implementing it? i have several questions relating to this. 1. has the application needs to be web based or desktop based? 2. do i have to have a database in the application side? i …  |
| | Dear Experts,I want to know how i can sync tables in sql server 2005 and oracle 11g tables. Table structure will be same in both server (sql server and oracle). I would like to prefer some tools available either in oracle or sql server.Thankspardeep |
| | I published my project in vs2010 and im trying to deploy it to other computers. I used this connection string that runs smoothly on my pc. This code tries to retrieve the servername and try to connect to database mysysDatabase. This forcely change the app.config. Private Sub btnOk_Click(ByVal sender As … |
| | Heyy...i'm trying to save the attachment file location in mydb...the thing is it's just saving the file name eg.database.txt i want it to look like this C:/bla/bla/test my codes addtask.php <html> <head> <title>Task Management System</title> <link rel="stylesheet" href="Appcss.css" type="text/css"/> <script src="datetimepicker_css.js"></script> <script type="text/javascript"> // Javascript function which takes care for … |
| | Hi everyone, i would like some help with a couple of mysql queries. I have a table of data which looks like this :  And represents a transaction log for players of a game. The ID is the primary key (auto incremented). DATETIME is the date and time … |
 | Hi, I've had a look around the forums but I couldn't find a specific answer to my query. I'm following a worksheet I was given from university. We have just started working on SQL and databases and on the worksheet it uses SQL 2008 Server Management Studio. The version I … |
| | Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed … |
 | Hi, I have these methods in my user class which check whether a username already exists and if not, inserts it into the database: //This function checks to see if the username entered already exists Private function check_user_exists() { $stmt = $this->_db->prepare('SELECT * FROM client_login WHERE Username = ?'); $stmt->execute(array($this->_username)); …  |
| | Hi I am really new to c#(I used to do vb.net) and I need some help with a problem. I am wondering what the equivalent of a datalist or detailsview in asp.net is in a c# winforms application and how to use it. I have data in a database and … |
| | I have two tables, table_1, and table_2. I am trying to query both tables, I want every column that is in table_1, and only one column from table_2. Each table has an AccountID column, so they can relate to eachother. I am trying to get a query result that gives …  |
| | Hi everybody, i have problem in my php code (it just showing nothing....means no error no results).......can anybody tell me what is wrong with this code.....i'm new to PHP........here is my code <?php try { $config=array( 'DB_USERNAME'=>'root', 'DB_PASSWORD'=>'' ); $conn=new PDO('mysql:host=localhost;dbname=scc',$config['DB_USERNAME'],$config['DB_PASSWORD']); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo rand_id(); } catch(Exception $e) { echo … |
 | Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity). I've tried this two ways: 1. Returns all customers, even with FirstActivity Null SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { Filter( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > … |
| | Hi I'm trying to Select Data from an Access DB. I wrote this query to Select all Invoices that were Invoiced between two dates. I get the following error Syntax error (missing operator) in query expression 'Invoiced >=02/01/13 AND <= 05/01/13' "SELECT * FROM invoiced_filter WHERE Invoiced > " & … |
| | My case is Input is "abdknmgbm". BUT The record in database that i want to query out is "abkdnmgmb" The input and database record is quite similar. String length is same, only some arrangement of character are not same. In the above case, dk and kd ; bm and mb. … |
| | hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. … |
| | Hi I have an insert statement in my VB code that updates about 20 fields in sql. I pass through todays date and a set of values. This occurs on a button click event. My problem is if the button is clicked more than once the data is duplicated in … |
| | This code is suppose to take the images array and use its value for the name of the table. When I echo the images varaible I get kids, which is what $images[3] is set to equal, but when I put it in the query the $result2 is echoed as resource … |
 | Explore Python's sqlite3 database module, create, write and read a database file. |
| | I am working with sql server using ADO provider. My code uses recordsets and commands to run quries and I fail to understand a basic issue - connections. In my code, they set a connection string (which is being built in the code, not taken from other ADO element) to … |
 | Hello people, I am new to crystal report. Normally, I would insert columns in the crystal report viewer and then look at the records at the Main Report Viewer. All the rows/records in that particular columns of that table will be shown. And then I found out about this SQL … |
 | hi people.. I was wondering if u experts could help me with this. I have attached a screenshot of my form. This is an invoice system.. I have customers table for customer profiles.. I have Products table I have manufactures table I want to save all invoices so that these …  |
 | Hello im braking my head with a problem, im using netbeans building a web application using java, jsp that handel a database with hebrew fields. String cityTable = "CREATE TABLE IF NOT EXISTS hebrew_test.table (" +"id int(11) NOT NULL AUTO_INCREMENT," +"en varchar(30) NOT NULL," +"he varchar(30) COLLATE utf8_bin NOT NULL," … |
| | Okay what I am trying to do might be hard to understand, but I will give it my best shot. I have created a script which selects data randomly from a table called albumname in a databse called characters. This array is then used again in a mysql_query to select … |
| | I am trying to make an array which has a random selection of database results in it. This is what I have so far, <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("photos", $con); $query="SELECT album FROM albumname ORDER BY RAND() LIMIT 9"; $result= … |
| | Hi Guys....i am facing a small issue with an SQL statement here. Will you be able to help me out? I wanted to grab the page title, page author's name which is in the users table, the no of comments, and the page publish date. "SELECT * FROM pages INNER … |
| | I don't quite understand how to make a Procedure as most of my processing takes place in my scripts. I have a set of 3 Queries that are almost identical that I would like to combine them to return a result set. The queries are: SELECT Date, Location, Sum(SubTotal) FROM …  |
| | # how to validate sql statement 1. hi, is there anyone who can help me in my problem? sql = "SELECT UserID, Status FROM tbl_User WHERE UserID = '" & strUserID & "' and Password = '" & strUserPW & "' " i want to validate my sql statement using … |
| | Hello Daniweb Univere, I am looking for a good program to use to store several dozen text documents, make them searchable, and ideally, allow me to link to specific lines of the document. I imagine there are programs like this, I have just been unable to find them. Any suggestions … |
| | Hi, I have done my vb.net application and ready for deployment, my database is located somewhere in my drive c:, i used this code to get connection string from app.config Public Sub main() constr = System.Configuration.ConfigurationManager.ConnectionStrings("WindowsApplication7.My.MySettings.nameConnectionString").ToString Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open ! ") 'frmMain.Connection.Text = …  |
| | I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 … |
 | Hi, This has been troubling me for the last hour and I cant think of a way around it. My SQL table looks like this: **Name, Cost** Matt, $5.00 Carl, $4.50 Tom, $6.00 Tom, $7.50 I need to make a query so that it puts anything with the same **Name** … |
| | How can I specify the Server of my database when I make my project executable I have this module I call everytime i modify my database Public Sub main() constr = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:"database file".mdf;" & _ "Integrated Security=True;Connect Timeout=30;User Instance=True" Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open … |
 | Hi Does anyone here can show me how to make an application that is like an odbc wizard that could register a sql server type connection? I have found one on the net through searching but it does not accept the UID and password of the sql server. I also … |
The End.