2,531 Topics
| |
So, I have this following snippet of code: if (isset($_POST['type1'])) { mysql_query("UPDATE table SET status = 1 WHERE id = '". $_GET['repid']."'", $c2) or die(mysql_error()); } if (isset($_POST['type2'])) { mysql_query("UPDATE table SET status = 1 WHERE id = '". $_GET['repid']."'", $c2) or die(mysql_error()); } if (isset($_POST['type3'])) { mysql_query("UPDATE table SET … | |
Hi Java Developers, I don't know if this is the right place to ask but I hope It is. First of all this is not my programming language, I am an intermediate .net developer, I just came up with this problem that I need to solve which what the thread … | |
how do i create service accounts for the various SQL Server 2008 components? | |
can any body help me by giving me a guideline on how to insert data from a populated datagrid into sql server table and how to make the values conform to the specified datatypes constructe in the sql server side...assuming the datagrid headings have already been created in the sql … | |
am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different … | |
Hi, I am getting the following error and I cannot understand why. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Before i try and insert the data into the database I print it out and this is what i get: **09/04/2012 00:00:00** The code below is … | |
Dear All, I am using VB.NET 2010 and SQL Sever CE 3.5 database. I insert some data into my database (SDF file) and I can do any all manipulations with those data. But I cannot see those data in the data table using Data Source or Server Explorer in Visual … | |
so i've been working on a database in oracle for a booking system and I am trying to create dyanmic query results... was just wondering if there is a way to create a query to add up all the seats in a arena with booking numbers (not necessarily the same … | |
Hi, I need to create windows services that will back up MS SQL database. Parameter should be time period when I want to backup database (for example every hours, every 2 hours etc). I haven't any experience with backing up database. Once I made WCF service. How can I do … | |
Ok I need help. I have a couple hundred databases, which are different cities, that I am trying to connect with one query. each city has the same Sports table in it. I want to put the 100 most recent results on one page . The code below gets the … | |
I have an SQL select statement that I cannot quite get working. Dim SelectStr As String = "SELECT * FROM Appointments WHERE Doctor = '" & ComboBox1.Text & "' AND AptDate = #" & DateTimePicker1.Text & "#" This works perfect ... however I have 2 more WHERE possibilities ... I … | |
Hello, I am working on a C# application where i have to store values of article in sql server as i have 3 products (stone, diamonds, jewellery). Now during the initial process when i enter the product details let say i have to store value for a diamonds i put … | |
Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks. | |
Ahoy, I'm having a bit of trouble executing a stored procedure using PHP's SQLSRV package thing. It's pretty much just a simple select query, with the parameters being passed through a php (it's from a property search). SqlSrv is a tough nut to crack as docuemtnation is either non existent, … | |
hi everyone , write now i have a with data which i want show the in tabular format like my query gives output like Name Location Rate AA A1 56 AA A2 27 AA A3 67 AB A1 56 AB A2 27 AB A3 67 BB A1 45 BB A2 … | |
Hi All, How i can restrict the numbers of customer from database? I use adodb with access. I know how to retrieve customers from database but i don't know how to restrict it to spesific numbers. Best Regards. Sturdy | |
Alright everybody! Here's a whopper for you. I've looked over this for the longest time and just can't figure it out. I want to update my database with the user's information when they save the html form. I'm guessing there's like a quotation mark or comma misplaced or something, and … | |
Hi, I have created the following code to get connection object to Database(MySql in my case) using a static method. I wanna know whether it is a good practice or not? Will there be any problem like concurrent access? Any information will be helpful. public static Connection connection(){ Connection conn … | |
Hi everyone. I am making an application that you need to sign up and login to. I want to use an online SQL database to store the login information. I know how to use a local SQL database, but I want to use an online database. Please help :) BTW, … | |
Hi there I have a few lines of code that I would like to ammend but have been unsuccessful in doing so. I have posted in a few other forums with no luck, hopefully somebody here can help me out. I have a delete statement which I have been asked … | |
Could you guys show me how to create a progess bar which discribes the process of a SQL procedure? | |
What I tried was using `My.Computer.Network.DownloadFile()`, and created a shared folder in the other computer to do downloading stuff. But, in fact I didn't know how to fill the path to the other computer, the error was: *"...path not supported..."* How about this: ServerName1 = cmbServerName1.Text.Trim() database = cmbDataBase1.Text If … | |
I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,Timeout I want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them. here is my code so far, but it aint working Public … | |
Please I am currently working on a web application project that works on both the desktop and mobile devices also. The web application is to be for all and sundry and therefore I need it to work on all forms of mobile devices (old and new). The web application uses … | |
In my datagrid my sql statement uses a have clause to get set information and i am having countless errors My code is as shown below, were am i going wrong ` con.Open() cmd.Connection = con Dim da As New SqlDataAdapter("SELECT MONTH(Head.SalesDate) AS Month, Detail.ProductID, Detail.Qty, SUM (Detail.Qty) AS TotalSold, … | |
I am trying to learn how to make a mobile phone communicate with a server and a database. So far, I have made a web-service on my PC using this tutorial: http://msdn.microsoft.com/en-us/library/ms733069.aspx The above tutorial makes a sortof WCF service. What would be the best Database system for me? Simplicity … | |
Hello, I'm having a problem using the jTable plugin. I'm fairly new to using jquery. Here is my problem: I have an database name reg and has fields (fname, lname.....avatar). What i want is to show the contents of the database using jTable. Now, I don't know how to display … | |
Hey below is a table i created ProductId ----- Qty ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- Wat i am trying to do is get my sql statement select and display my … | |
I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma. row1: - flowers, full color, female, Trend row2:- baby smelling flowers, heart Now if I put a search query like:- `select * from Asset where contains(AssetDescription,'flower')` It returns nothing. … | |
Hi, I am vishnu kumar. I knew the basics of Java but this is the first time i am building a project based on java (Java Swing actually). This is my final semester project and for last two months, i am doing my project. I initially thought the database(along with … |
The End.