6,934 Topics
 | |
| | Hello Everyone, I have 2 checkboxes in a form and onclick of these. Once the checkbox is checked, only the fields that are relevant to the checkbox are displayed, with default values in it and to fetch the default values i need to trigger php code. So i can't perform … |
| | Hi I have zero knowledge about sql,databases,mssql etc etc. I have installed MSSQL 2005 express edition. What i need i have two access files say data1.mdb and data2.mdb. i need to create a database database1 which has tables from both data1.mdb and data2.mdb. Please tell me how i can do … |
| | Hi, I am having a table which contains emp_name, basic_pay, PF, other_info. Now i want to display as, emp_name1 basic_pay emp_name1 PF emp_name1 Other_info Like this, Instead of displaying in single row, i want to display in different row based on that emp_name. How Can I achieve this. |
| | Hi Folks: The following is the complete coding for an application which I wrote to move data from sql 2000 to MS Access 2003. The coding looks fine to me but I am still getting an error. Could someone tell me what I am doing wrong. Thanks in advance Bob … |
| | Hi i am using c# as my language & sql server as my database .. My question is there is no key ward called [CODE]limit[/CODE] in sqlserver....how i solve this type of question... the example is ---> the sql server data table has 25 rows & i want to retrieve … |
| | I have a dynamic SQL statement to insert data into a memory table from a source table. The problem is, one of my variables, when run, evaluates out to a name of a column in the table I'm selecting from. I need it to be the column name, not whats … |
| | Hello, I have looked over many examples of how to populate a dropdown with rows like [code=php] $sql="SELECT id, thing FROM table"; $result=sqlsrv_query($conn,$sql) or die("Couldn't execut query"); while ($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){ $id=$row["id"]; $thing=$row["thing"]; $options.="<option value=\"$id\">".$thing "</option>"; } [/code] But i need to populate this list with tables and will need to … |
| | Hi there. Okay heres the scenario. I have 2 tables "Logins" and "User_Details" What I want to do is write a PHP query that whenever a new user is created, that is manually entered into "User_details" table using a form, the next thing that should happen is that it should … |
| | Hi I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anybody tell me how to …  |
 | I've seen a few posts on here talking about "databases" as if they were just files and using fstream to manipulate the file pointer, etc. I'm familiar with SQL, so it would be nice to simply be able to execute sql command (as can be done from vb.net) such as: … |
 | Evening, I have built a program with full SQL functionality (from pulling to adding etc). I am using stored proceedures for the SQL queries. I seem to have a problem when adding / updating a SQL VARCHAR column when the item being added / updated has a space (ie 'Add … |
| | I don't recall ever having trouble using a similar procedure in the past but for some reason this one is giving me tons of trouble. Everytime it gets executed, it fires "Object doesn't support this property or method" error and I just can't understand why. Here is the snippet [CODE]SelectedEntry … |
| | :unsure: I dont know y this happens...i try a lot of times but....anyways, the problem is that, the crystal report does not show the actual result when an sql query is being used to extract data, even from a single table...while it runs correcty in MS Access where i have … |
| | Hi, I'm trying to populate a tooltip with a list of users connected to a database when hovering over an row in a ListView. I'm using sysprocesses to show a list of databases and the connections, how do I tie this together? [CODE]select loginame, hostname, blocked, db_name(dbid) from master..sysprocesses where … |
| | hi all does anybody here knows a good safe way to work with sql stored function with zend framework? i can do so with prepared statement but i'm sure that there is safer way to do so... i'm using postgreSql but i don't think that there's any different. thanks!  |
| | I thought I had the command correct, but I wanted to make sure since I fail to connect in my app. Here is the connection command I use: New SqlConnection("Server=TestServer;Database=MasterDB;Integrated Security=SSPI") I have verified the server name, DB name, and that the server is using windows authentication. Any help would …  |
| | I have a table in SQL sever .How to create a dynamic dropdownlist using the entries in that table in such a manner that i am able to use the corresponding values to that entry that are given in the table? |
| | how to pass two parameters using a dataenvironment. I have a table salary record in which there are two coloumns date and unit, i want to pass these parameters at run time. |
| | Alright, let's try this again. I've started over from scratch and we have got the basic functions working. Everything so far has checked out, but I am still trying to get it to pull the right credentials. I can get it to pull one of the rows out of the … |
| | Hey, I need help with setting up an authentication code. I am currently working on a project to build a blog server in python for an intro level python course. We are using the PESTO and POSTGRESQL wsgi and sql clients respectively. I am trying to authenticate against a user … |
| | Hello, I have created a project on "Hospital Management". With Front end is Microsoft Visual studio2008 Windows Application (C#)& Back end is Microsoft SQL server 2008 It's Working Successfully. But the problem is setup is working only on that system where the project is done. If i try to start … |
| | Please someone can help me. I need a function which just returns the number of rows from known table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums int SELECT Count(*) FROM dbo.MainData where id=@id RETURN @rownums END [/CODE] But it … |
| | Hey all, having a little trouble transferring my listview items into a database. I have transfered all of the listview items into a List<> for use during the population of the items in my database here is my dataaccessor class, it contains the reader writer and writer statements generator: [CODE] … |
| | hello every one, i have a problem to execute the second SQL query, its working fine on my local machine and when i uploaded it to the server but suddenly stoped functioning and keep showing error on the numRows after the query in line 213, any suggestion will be appreciated[code]<?php … |
| | hi, i'm working on a windows application with sql server compact edition3.5 database. i was working with visual csharp 2008 express and now i have installed visual studio 2008 professional edition. the problem is that i can't open my database to see tables, i get this error message" the operation … |
| | Hi all, I want to create a function in c# which receives a paramater (name of a field from a table in oracle) The function will have to return the distinct values of the specific field.I don't know how to insert the parameter into the [I]select distinct(parameter) from table [/I] … |
| | i have been having this error massage tying to do certain registration on Nigeria army website [url]www.nigeriaarmyms.org[/url], and i keep on getting this massage: "you have an error in your SQL syntax; check the manual that corresponds to your mySQL server version for the syntax to use near 'AZEEZ', surname= …  |
| | Hi everyone! I am a junior database programmer. I need to know how can I save image in SQL SERVER 2000 by VB.NET? I made a table in SQL SERVER with two fields. One is Id[nvarchar] & another pic[nvarchar]. I got two forms there in VB.NET project. In the first … |
| | I am currently doing a project where i am using C# and databases. I am using visual C# 2008 and i am having issues accessing the tables that i made. So what i have done is that i have a couple of tables, one with students in it, another with … |
| | Hi, I have page that allows the user to search using a "date range" AND "location". I'm able to do this individually. Its like, if the user searches using the date range (from begin date to end date) the results show. Then if the user searches using a specific location … |
| | How do I make the connection to a SQL database (one to many), with VB.NET? |
| | Dear All, I need help in writing a query and would appreciate any solution that would solve my problem :) Some background information: I have a table which records the price of a commodity at a given date and time (5 minute increment to be exact). The first column represents … |
| | I have to finish this project for tomorrow-so I'll Appreciate quick reply. I need to do reports in my projects. now I've created Data Environment and all that but in the SQL the only thing that work is if I select the entire table from the database. (like "select * … |
| | Hi folks: Can anyone tell me what I am doing wrong in the coding below: [code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim ConnectionString As String = "Server=hp;database=library;integrated security=SSPI" MessageBox.Show("Connection established") Dim sql As String = "SELECT snippetID, snippetName, snippetSource, snippetCode FROM snippet … |
| | Ok here is the situatation, I have three tables set up; 'Users' 'Profile' 'Linkingtbl' The 'Users' table holds the following data; [LIST] [*]Email (PK) [*]Password [/LIST] The 'Profile' table holds the following data; [LIST] [*]ProfileID (PK) [*]Firstname [*]Lastname [*]DOB [/LIST] The 'Linkingtbl' table holds the following data; [LIST] [*]ID (PK) … |
| | hi! I hope this is the place for my my question: I work on a file tagging system. I write it in java and use MySQL as my DB. I have a table that contain only one field: file's path. when directory is renamed, it's path changes. and that's mean, … |
| | I'm trying to study ASP and sql server 2005 to create the website.However, I don't know how to create a table having a column to store the image, I have never tried this before, I don't know sql server 2005 has data type of image or not. hmm, the flow … |
| | I have searched and I have searched but I can't find a way to display all instances of SQL Server in a combobox. Any help is greatly appreciated. |
| | i have tobind sql table to dropdownlist using javascript. thanks in advance |
| | i have tobind sql table to dropdownlist using javascript. thanks in advance  |
| | Hello All, I am getting the following error message when I try to execute my program as an executable jar on a remote system.The same program works perfectly fine on my local system: Exception in thread "main" java.sql.SQLException: Operation not allowed after ResultSet closed at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) … |
| | Pls send let me see the codes on how to connect a My SQL database to vB6.. ^_^ i am new to My SQL! tnhx much!  |
| | Hi, i have a program that connects with an sql database and it works fine with the sql. Now the problem comes when i publish. When i open the published program it gives me an error. An attempt to attach an auto-named database for file ..... A database with the … |
| | I want to select the last record from thousands of records, how to write the SQL query for that.  |
| | Hi Everyone. I have problems with solving a sql question. There is an assumption: The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) Ships … |
 | If I have a table sales: sales {sellerid, buyerid} I'm trying to determine the buyers favourite seller... So I need to return the most frequent sellerid. I've used this query to find out the total number of times the buyer has bought something from any seller: [CODE]$countseller = mysql_query("SELECT count(sellerid) … |
| | Hi there, I've been trying to figure out why my update script wont commit changes to the database. I'm building a simple call tracking web app for our technicians. Currently the view, add, and delete functions of the app work fine. The trouble I'm running into is when I want … |
| | hey guys, this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db. the problem is the excel file may be updated or changed and i have to periodically import it and perform … |
 | Hey guys, Could you help me understand how to implement [CODE]mysql_real_escape_string[/CODE] to prevent injection in this code ? [CODE] <?php if(loggedin()){ echo "You are already logged in."; } else { if($_POST['submit']){ if($_POST['username'] && $_POST['password']) { $username = $_POST['username']; $password = $_POST['password']; $password = md5($password); $res = mysql_query("SELECT * FROM users … |
| | i've backup data in text file and it needs to be restore on previous database using vb, is it possible? |
The End.