[sql] Forum Topics

In my code, I loop through 3 random users, and I am trying to add 500 to their total number of credits. The variable $credits isn't being captured correctly, as it shows blank when I try to echo it. The odd part however, is $userid (primary key) is captured into …

Hi all. I am working on a small credit/debt management tool. I have a table that contains the main record for the debt: id, amount, client info, interest, paid back, etc Then I also have a "history" table where all operations on a debt are stored: when it was first …

I'm hoping someone can help me here. I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me. [code]sql …

Hi, I'm a recent IT graduate, I want to upgrade my skills from what I learnt at college to the SQL Server 2008 platform. I want to also get certified with Microsoft, it seems a lot of companies are asking for this now. If you have gone through the certification …

sql 2000 i have this sql stored procedure i want the last coloumn fAcc_Total to be updated when a record is inserted. the value in the [COLOR="Red"]fBill_Amount[/COLOR] should be add to the value of the [COLOR="Red"]fAcc_Total[/COLOR] in the same time the record is inserted if there is a value in …

Yoe guys, need your help.. I want to know on how to setup my client computers and the server so they can connect to sql server 2005 Developer Edition. Client computers are Windows XP. Server is Windows Xp installed with a SQL Server 2005. They are on the same Workgroup. …

Hi I am using SQL express 2005 and I need to be able to take old data (data inputed two weeks ago or older)from a table in data base A and move it to a table in database B. I have very little experience with SQL so any suggestions will …

I'm making some sort of mistake in the following code: [CODE]use xPress_CR select * from (SELECT * FROM dbo.T_JOBS WHERE ENDDATEANDTIME = null UNION SELECT * FROM dbo.T_JOBS WHERE STATUS = 'Failed')[/CODE] Any idea what I'm doing wrong?

I have a column in my database that has a list of keywords. sometimes the keywords are a couple of words and sometimes just one. Each keyword (can be more than one word) is separated from a comma. for example - this is my column - hi, how are you, …

Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " …

Hi I need to write a sql script to split a string in two or more parts. e.g. I have a string: "tag: key1, key2, key3" I would like to use the ":" as a seperator and thus end up with two strings: "tag" and "key1, key2, key3" Is this …

Hi I was wandering if sql tables can determine the order in which forms appear in a delphi application and if so how does it determine this order and will I be able to go in and edit the order. Thank you in advance

So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they …

Boas. Estou com uma dúvida para o qual preciso mesmo muito da vossa ajuda. Criei um report que inclui dados de 1 trabalhador (id, nome, residencia, bi, categoria profissional, etc...) e preciso de fazer o seguinte comando SQL: [B]SELECT * FROM Trabalhadores WHERE id_trabalhador = ' + valor + '[/B] …

So far progress overall has been going well in general on my pet project I call the TAXA project (nickname for taxonomy). The heart of it is a botanical tree on all the woods of the world. Since viewing it can make it easier for any of you to understand …

Hi everyone, first of all, sorry for my english... I'm in this situation: I have a table in my database named products with the fields [B]id[/B] and [B]model[/B] in it. Now, I need to get 'all' the products but with different model names and each result represent a valid product. …

Hello guys! I'm trying to make a script for a school website, so the principal can send mails to all of his students, teachers or other admins, it should be very simple but the page just keep coming blank or sending me syntax errors. Right now it's showing the following …

Hello all...incoming newbie question. I'm new to building desktop apps after a couple of years using ASP.NET online. I'm using MS Visual C# 2010 Express to play around and learn with. In order to test something that would be of real use to our company I want to be able …

Hello guys! I'm trying to make a script for a school website, so the principal can send mails to all of his students, teachers or other admins, it should be very simple but the page just keep coming blank or sending me syntax errors. Right now it's showing the following …

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 …

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! 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

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 …