[sql] Forum Topics

I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros please take …

I've developed a software using VB.net and SQL server 2005. This is the connection string that used. [CODE]Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True[/CODE] But now i want to use SQL server compact edition. So what should i change in this connection string?

I couldnt find a forum for sql so Im going to post here. If Im in the wrong forum then please move me. I have a table with following data Fields: OID, Product, Condition, QTY DATA: 1, Product A, NEW, 60 2, Product A, B, 60 3, Product A, C, …

Hello All, I have two tables that can't be changed. One contains Stock codes / country codes, the other has country code / description for each code. I have a combobox with all the country descriptions that can be added to the stock code table. my problems is i can't …

Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe …

Heya people, Here's my problem: i have a (for me quite lengthy) piece of SQL code which is automagically generated by my own application. However, when i try to execute it, it gives me an recordSet error ("Either BOF of EOF is true, or the current record has been deleted"). …

I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 …

I have run into an interesting problem. I have inherited a database for daemon process that polls and accepts reports from remote embedded systems. Each site that has one of these systems can monitor over a dozen different fuel tanks. (In practice, most monitor 2, 3 or 4 tanks.) When …

Hello everyone, I'm a java programmer writing a half graphical half text rpg. For the moment I read my data from text files, e.g. Enemies.txt id name hp and so forth. However, I want to make it a little more clear to handle, as in a database format. I can …

Hi all, I've a very weird problem. Actually I've Sql setups as .iso and from those setups i need to extract binary version of "sqlsrv.exe", but it is not possible for me to install every single version of sql and install and then generate binary version so does any one …

I want to use jQuery tooltip in a table which is created with php doing a while loop. I want that when i hover over a row, the tooltip fills up with data according to that row. I found something similar using asp.net, but i dont know how to implement …

I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the …

Hello dear community, I have a problem which I have no idea how to walk around, see I have a really large database, with france zip codes, I imported this data from excel. the thing is that when it imported all the zip codes starting by 0 are not starting …

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strsql = "delete from student_info where Student_No = " & ctrl & "" Dim sqlcmd As New SqlClient.SqlCommand sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqlcmd.ExecuteNonQuery() MsgBox("Student Deleted") Me.fillclasslist() When I try to delete a student in the list …

hi there, im a beginner really and have just tried to finish a new computer based booking system for my work, im using sql and a database to store the customers and then store bookings too, but im having problems with the customer form, when i run it it kind …

I know this question has been asked dozens of times, but the code I have been looking at has not helped me. So far I have been able to connect to the string and the database from where I need to check the username, but in my page it is …

hi everyone. i want to list and show the table names in a database in a php page. how to do that? in phpmyadmin 'show tables' works in query window. bt showing it through a php script i think i would have to SELECT?

Dear all programmers I’ve search all over Google and have not found an answer. [B]My question is.........[/B] I have two DBF tables called product and ullage. The user enters data from products table into ullage, by searching for product id and adds their count into the ullage table. This part …

Hi! I need some help. Let's say I have 3 tables (t1(id,ds), t2(id,ds) and t3(id,ds)) where the tables don't necessarily have the same id fields. For example: t1 id ds 1 1 2 0 5 7 t2 id ds 8 5 1 2 t3 id ds 9 3 8 5 …

I am trying to connect to a sql database and read from a table to determine if a username is valid upon a user entering in theirs. To just give you a background of the program: 1. The user needs to enter in their username and ID number. I already …

Hello, it now seems that I might be able to use SQL/MS Query to do what I tried to find a [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/388319"]workaround[/URL]. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.) So: is there a way to perform in …

Hi, I'm having trouble finding out whether I am doing my diagram the correct way or not. These are some of the properties of the diagram. Make an ER diagram and tables of the diagram: -Classroom contains the name of the building, the building number, and the space. -Reservation contains …

Hi all, I queried results form MySQL database using php and stored the results in a text file. Now i want to store the text file contents in a single string variable. I would be thankful if anyone could help me with this. Thanking you. Have a nice day. cheers, …

Hi guys i hm havig problem....My Code is [CODE] <?php $conn = mssql_connect("FARHAD-PC\SQLEXPRESS","",""); mssql_select_db("Testing",$conn); $query = "select * from User1"; echo $query; ?> [/CODE] The error iss Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\Testing\SqlConnection.php on line 4 Hope someone will help me.. Regards.. Farhad

I'm using Visual Studio 2010, Win 7, MS Access 2010, C++, Direct ODBC, 32 bit. The first SELECT statement executes. The INSERT, SELECT, SELECT and UPDATE statements don't nay help is appreciated. Thanks. [CODE] #include <windows.h> #include <stdio.h> #include <sqlext.h> const char* DAM = "Direct ODBC"; SQLCHAR szDSN[256] = "Driver={Microsoft …

I'm struggling very hard to get this to work and I don't know what I'm doing wrong. I have a register page that I want to take the data inserted into the form and INSERT it to the database with jQuery and AJAX. I'm not very experienced with AJAX AND …

Hi fellow programmers! What I want to do is this... * I have a list of registered users * next to each user is a link "Add as friend" * user_1 clicks the link to add user_2 * user_2 now needs to confirm or deny the request WILL THIS TABLE …

Hey guys, Alright I have a tricky assignment to do in a view that will enable my next program to run MUCH faster and more reliable... Now I need to list all Items (1 table) and their locations where they are stored (2nd table) in a way that enables 1 …

Hi everyone! Ok, let me quickly explain what I want to achieve. I have two tables. The first table is Requests and it looks like this [CODE] +------------------------------+ | Requests | +----+-------------+-----------+ | id | user_from | user_to | +----+-------------+-----------+ | | | | | | | | | | …

Can anyone help me to do this : Select previous field based on previous field in sql. I had tried a lot of ways but it seems doesn't works. [CODE]Select alert_value , year_id from company_alert where year_id = "2010" and year_id = year_id - 1 group by year_id[/CODE] could anyone …