1,694 Topics
 | |
| | ok, I have what I hope is an easy problem to fix. i'm try to query a db, store to a temp table, and then query the same db, inner joined with first query. please help. I'm currently getting "access cant find table/query" error. I've tried putting quotes around tmp, …  |
| | Hi, i am trying to learn how to create login and register page on my own. But i am having any luck with it. can any one help me from start to finish? and by start to finish i mean just the login, register and database part, not the whole …  |
 | Can you perhaps tell me why I'm getting this error? I'm trying to upload a image to a database through php and I'm getting this error the whole time in my picUpload.php These are the errors I'm getting: [CODE] Warning: move_uploaded_file(avatars/beetgejo.jpg) [function.move-uploaded-file]: failed to open stream: No such file or … |
 | Hello Friends, Can anyone tell me how to find the list of SQL servers on the local machine...and not the network... I searched in google but everywhere its for the list of SQL servers on network....I just want my PC SQL server name.... Is it possible to get it? Thanks … |
| | Hello all, How many ways are there to put variables into a query? The reason I ask is that I cannot get "SELECT * FROM locations WHERE title LIKE '%".$input."%'"; The "SELECT * FROM locations" query only does give me the full table but using that input variable substitution (from … |
| | In my script, I have a table displaying the results of a SQL query. However, I am using the results as a sumamary, but the SQL is making the page display the table as many times as there are results (rows) in the returning SQL that are allowed because of …  |
| | Dear All, I want to create a dynamic website with a database. Visual studio 2010, dreamweaver CS5, sql server management studio and all other requirements are installed (like IIS 7). I set the IIS server configuration in dreamweaver cs5. I check simple ASP codes like <%Response.Write ("The time on the … |
| | hoi I would like to learn how to work with databases. does anyone know a good tutorials or sites? because at this moment I know nothing about it. thanks in advance |
 | I currently have a client who came to me asking me how to build a system for him where he can give varying levels of discounts to events based on the number of people who get referred via a unique affiliate link/cookie. The key stumbling block for this project isn't … |
 | I was wondering if there is a way to open an SQL file and execute it from a c# application without prior connection to a database and also get the name of the default server that is used when SSMS is opened. at the moment i can open SSMS but … |
| | hey there, Here's my complete code for a delete button that deletes a record in a Heirachical Flex Grid. Dim rsTour As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strSQL As String cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=" & App.Path & "\Luckshan Tours & Travels.mdb;" & _ "Persist … |
| | Hi, I'm new to PHP and I want to know how to prevent SQL injection? Any php features can prevent the SQL injection?  |
| | Hello Everybody please help me out i am in big problem the problem is my organization people gave me the WEB Application to edit it (the application was written in the C# language and it is web application so it is designed in ASP.NET MVC3 ) and i have to … |
| | Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … |
| | Okay, I know some of you are looking at that title and thinking I'm quite daft because obviously I have to have a dataadapter if I have a bindingsource. And you're right, there is a dataadapter, but it's not exposed to me. I've taken over a winforms project (attached to … |
| | Hi all, I need some help in how to achieve this functionality....the problem is ... I have some data in my database.On clicking 'generate invoice' , It should gather the data from the sql server and publish it to a document which the user can send it to a company.Basically … |
| | Hello,... i usually used win7 x32 bit and i use sql server 2008 r2 enterprice in it and there is no problem , but i change my windos and installed win7 x64 on my labtop after that i try install the same sql server which i used in this system … |
| | I've been doing some research about multilingual and recursive database design for few days. I found interesting the following article: http://www.gsdesign.ro/blog/multilanguage-database-design-approach/ and liked the 4th solution Coupled Translation Table Approach. But I'm seriously confused since I don't understand the case; I see there is only one column id on pages … |
| | I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … |
 | i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 … |
| | I am doing system using window phone 7 and sql server as database. I am using below coding to get shopping cart list at listbox. public List<Order> FindOrder(string custemail, string orderstatus) { var findorder = from r in order.Orders where (r.CustEmail == custemail && r.OrderStatus == orderstatus ) select r; … |
| | Hi everyone, In a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database. When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded … |
| | Good day to you all, am currently working on a windows application. I used sql compact edition for the database. But the first problem i got was that it kept giving me errors i copied and pasted to error code on google and I got an article that says I … |
| | Im having a issue with comparing dates below is the code. it shows all rows even dates that have passed todays date. The Date field is set as date in sql. <?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydatabase", $con); $todays_date = date("Y-m-d"); … |
| | I'm trying to make a search by different option say A, B . what i need is if user provide value of A only then it does the searching using parameter A only , if user provide A and B then it needs to do searching using condition A=value1 AND … |
| | I'm extending a website built in ASP.NET to display Spiceworks reports - basic SQL queries. The easist way (with my knowledge) is to connect to the Spiceworks db through both Management Studio and Visual Studio. I have therefore followed this '[how to](http://community.spiceworks.com/how_to/show/2271http://www.)' in this forum, plus a few others, to … |
| | I have looked through a few SQL hierarchy tutorials, but none of them made much sense for my application. Perhaps I am just not understanding them correctly. I'm writing a C# ASP.NET application and I would like to create a tree view hierarchy from SQL data. This is how the …  |
| | "UPDATE P SET Stock = T.Stock FROM prices P INNER JOIN #prices " + "T ON P.Avg = T.Avg AND P.Colour = T.Colour;" + " " + "INSERT INTO prices(Avg, Colour, Stock) SELECT T.Avg, T.Colour, T.Stock FROM #prices T " + "WHERE NOT EXISTS (SELECT 1 FROM prices P WHERE …  |
| | Hi, All, Sample Table Job_ID Job_Name Status 1 TEST00001 FOR KE 2 TEST00002 FOR KE 3 TEST00003 FOR KE 4 TEST00004 FOR KE 5 TEST00005 FOR KE I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will … |
| | Hi, Im trying to insert to a table in sql that is related to another by a foreign key. The first table has an ID, a suppliers id and a date; and the other table has an ID (that for some records should have the same id from the other … |
The End.