2,570 Topics
 | |
| | Hello to everybody I have a problem with a MYSQL query and I almost got it but am stuck for a while now. I would appreciate if anyone could help me or point me in the right direction. I have 3 tables: [icode][B]t1 (products)[/B] id | name ---+------- 1 | … |
| | Hi guys, I have a table that outputs all my contacts via a while loop from my database. my syntax is like this: [CODE]SELECT * FROM contacts WHERE id = $_SESSION['user_id'] ORDER BY name ASC LIMIT 5[/CODE] that pulls out all my data and only gives me 5 results. Now … |
| | hi there, my project is a desktop application, i am trying to transfer(upload) a file(can be excel,doc,txt pdf) to another sql server in another computer in the same network how can i do this in C#.net desktop application, i am not using web service or asp.net how can i do … |
| | Hi everyone I am trying to develop a friend system where you can view friends who you are friends with. I have been able to get it to show one result but it wont show any other. Please can someone tell me what I am doing wrong. Here is the … |
| | The code below is my insert statement to get values into my database. However, I now have an update page where users can update their information. I thus have a form in which their initial info is inserted and now they can change it and submit again thereby updating the … |
| | I am using the .Net 4.0 and excel 2003 How can i use an oledb connection to retrieve the cell format of an excel spreadsheet... I specifically want to find out if a cell column (or cell itself) is in a numeric percentage format. I cannot seem to find this … |
| | I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the … |
| | Really I am a PHP beginner, I am working on this code and I need help, kinda stuck. I have a database with 3 fields(id, date and venue). This is simply what I want to do; I want my script to go into the database fetch the date and compare … |
| | Hallo guys, a theoretical question I have there for you. I have a search form in HTML with several input fields, so the user can search for particular features in a db. My queiston: How can I generate a dynamic query, depending on which fields the user had filled in? … |
| | Dear Experts, I am building a program which needs to store an Image (any image type) in SQL Express 2008. I am able to read, and insert images into SQL Datatable, but I can't seem to update my images. The SQL DataTable contains columnname "picture" - Varbinary(Max) I am using … |
| | Hi all, I have a pagination script that works great apart from one last thing I require some pointers on please. The help i need is with the SELECT query - currently the select query works, but i am bringing back all records, I am trying to bring only certain … |
| | Hi, this is my query [CODE]$result = mysql_query("SELECT SUM(`qty`) FROM sims_ac WHERE region ='North'");[/CODE] How I can show this [CODE]$result[0][/CODE] without using While loop or any other loop.  |
| | Hello, for a database project (music festivals) several search options are to be included. While some search fields will be filled from a dropdown list (like "countries"), other will have a fuzzy option (like "song titles"). For this I want to use the full-text search (you may remember the words … |
| | Hi! I need some help please! I have to create a DB that has to be normalized to 3NF. I have a table 'Products' that contains info about all the products - product_ID, product_name, quanitity (left in warehouse), procurement_price, sales_price. And I have [B]TWO[/B] more tables that contain info about … |
| | please tell me how i make a sql query for selecting data's from a table where that data repeated 4 times in that column |
| | Hi all, i started programming with .NET (i have express edition) and wanted to make a conection to an SQL Server.. the problem is that i cant conect :( previously i had .net 2005 - i started having the issue there - i unistalled it, n installed visual studio 2008. … |
| | Is there a method for checking which roles a user has in SQL using SMO? I can add a role via: [CODE]user.AddToRole("Administrators")[/CODE] But cannot see an obvious method to progmatically list them. |
| | [COLOR="Green"]Table Name => PropDocument Column1 => propertyid ( foreign key from Property table ) Column2 => documentid ( foreign key from Document table ) The error ( in the attached image ) comes when I try to delete the record. This error comes often when there are 2 records with … |
| | hi guys having a problem getting a single value from a mysql query getting all sorts of problems - heres my latest version below [code=php]mysql_connect($host,$user,$password) or die( "Unable to select database"); mysql_select_db("mydatabase"); // select database to use. $user = 84; $sql1="SELECT `order_id` FROM `table1` WHERE `user_id`= '$user'"; $array = mysql_fetch_array('$sql1'); … |
 | Hello guys. I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 …  |
| | 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 … |
| | 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 … |
| | 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 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 * … |
The End.