6,934 Topics
 | |
| | Hello, I am trying to query a table for todays date based on this format mm/dd/yyyy hh:mm:ss AM/PM I tried date() but it only returns results based on the mm/dd/yyyy formate. Any assistant is apprecaited! Thanks, Wez  |
| | Hello All, I have two tables that can't be changed. One contains Stock codes / country codes, the other has country code / description for each code. I have a combobox with all the country descriptions that can be added to the stock code table. my problems is i can't … |
| | Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe … |
| | Heya people, Here's my problem: i have a (for me quite lengthy) piece of SQL code which is automagically generated by my own application. However, when i try to execute it, it gives me an recordSet error ("Either BOF of EOF is true, or the current record has been deleted"). … |
| | Hai , I have 2 tables 1. [B]Transport_Details[/B] having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee[/B] having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. My problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and … |
| | I am trying to do inline SQL Inserts & Updates within my ASP. When I go to the Master Page and validate the SQL I am getting The Multi-part identifier not bound on all of my TextBox and data entry fields on the panel that I am using in the … |
 | I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 … |
| | help me update my database.. when i click edit it will add a new record.. i want to update a record.. to edit a new record it will be base on the cutsomer's nameu [CODE]Dim conn As ADODB.Connection Dim RS As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = … |
| | Ok I am stumped so bad. I am using a form to insert a topic and comment into a table and if the topic is new it creates a new table specific to that topic. So I pass the topic name through the url and Im trying to retrieve it …  |
| | I have run into an interesting problem. I have inherited a database for daemon process that polls and accepts reports from remote embedded systems. Each site that has one of these systems can monitor over a dozen different fuel tanks. (In practice, most monitor 2, 3 or 4 tanks.) When …  |
 | This code supposedly generate a web chart but it does not work. How is the correct way to bind data using SQL into web chart. thank you all :) [CODE]Function GetReader() As IDataReader Dim strSQL As String strSQL = " SELECT aa.alert_id, " strSQL = strSQL & " (SELECT alert_value … |
| | Hi. Good day! Hope you could help me through this. I'm having trouble with my customize table sorting in BIDS. i used this formula in group sorting. [CODE] =Switch(Fields!AGE_CAT.Value = "0 - 1", 1, Fields!AGE_CAT.Value = "2 - 4", 2, Fields!AGE_CAT.Value = "5 - 9", 3, Fields!AGE_CAT.Value = "10 - … |
| | Hi friends... I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working. I google it and found some solutions but not successsful yet. Can anyone give me detailed guide (step … |
 | Hello everyone, I'm a java programmer writing a half graphical half text rpg. For the moment I read my data from text files, e.g. Enemies.txt id name hp and so forth. However, I want to make it a little more clear to handle, as in a database format. I can … |
 | Log In Failed for User '' The user is not associated with a trusted SQL Server connection Well, that's the full title of my problem. I'm working on a C# program that supposedly could access a database run by SQL Server Express. I know the program works, because it works … |
| | Hello all. I'm trying to keep table structures in sync across 2 seperate databases on the same SQL server instance using a DDL trigger on ALTER_TABLE, CREATE_TABLE, DROP_TABLE. Using EVENTDATA() as shown below, I can catch the TSQL that fired the trigger, but I cannot figure out how to execute … |
| | Hi all, I've a very weird problem. Actually I've Sql setups as .iso and from those setups i need to extract binary version of "sqlsrv.exe", but it is not possible for me to install every single version of sql and install and then generate binary version so does any one … |
| | in table department i've class_id as f.k and in class table class_id as p.k i want to update class_id in department table.. n getting error  |
 | Hey guys, I am making a bot for a link sharing site. I am using the request external curl class and i have a dilemma that i think you guys could help with. Query Variables appended on the end of a url such as ?something=234 I do not know how … |
| | I want to use jQuery tooltip in a table which is created with php doing a while loop. I want that when i hover over a row, the tooltip fills up with data according to that row. I found something similar using asp.net, but i dont know how to implement … |
| | I downloaded mysql-connector-java-5.1.18 and put it on my USB drive. I brought my USB drive to school and opened up Eclipse, in there I added an external .jar (the mysql-connector-java-5.1.18.jar). Then I wrote this java code: [CODE] import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Scanner; public class Main …  |
 | hey guys. i need advice and guidance for a new project i want to start. imagine a company with some subsections that each one has a program and a separate database on sql server 2008 express. what i want to do is unit these apps so that all of them … |
 | I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the … |
| | Hi all With the following SQL " Dim Query As String = "UPDATE JobName_tbl SET [JobDate]=@NewDATE, JobAddress=@Newaddress Where JobID=@ID" nothing happens nothing gets updated nor do I get an error. But as soon as I remove the [JobDate]=@NewDATE, it works fine. Hope someone can help me with this situation. Here … |
| | Hai , I have 2 tables 1. [B]Transport_Details [/B]having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee [/B]having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. But my problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 … |
| | Hi, Anyone please help me out. Am having a table with field name 'status' with the values 'yes' or 'no'. Really, i wants to change this 'yes' or 'no' status automatically using mssql server. But i don't have an idea to continue on this work. for example, now the value … |
| | Hello, i need help to do the insert inside repeater, but when i debug the stock_code inside sql command is not declared. what should i do? [CODE] Protected Sub repeaterAlert_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles repeaterAlert.ItemDataBound Try stockCodeheader.Text = " Stock Code " plcNameheader.Text = " PLC … |
| | Hello dear community, I have a problem which I have no idea how to walk around, see I have a really large database, with france zip codes, I imported this data from excel. the thing is that when it imported all the zip codes starting by 0 are not starting … |
| | dear all I have the following sample code which i am trying to use to connect to sql*plus in visual studio 2010 but i keep getting the error message connection string is not well-formed. see my code below [CODE] protected void Button1_Click(object sender, EventArgs e) { string oradb = "User … |
| | Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strsql = "delete from student_info where Student_No = " & ctrl & "" Dim sqlcmd As New SqlClient.SqlCommand sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqlcmd.ExecuteNonQuery() MsgBox("Student Deleted") Me.fillclasslist() When I try to delete a student in the list … |
| | I am designing a project in asp.net. I one page i have created a gridview having template field as checkbox. When I select any row in gridview using checkbox,that checked row goes to a new gridview on button click. Now what i want to do is to save that new … |
| | Hi Guys, I want create a link for .xls file in sql server like access we can create a linked file. Is it happen in sql server. i have googled this thread but no solution found yet. anybody have any solution... Thanks in advance  |
| | Hi Friends I want to set the image to picture box from get sql. I wrote this coding , But Its not Working Properly . [B]byte[] mydata=new byte[0]; mydata=(byte[])dt.Rows[0]["img"]; int arraysize=mydata.GetUpperBound(0); MemoryStream stream = new MemoryStream(mydata,0,arraysize); img.Image = Image.FromStream(stream);[/B] where i wrote wrongly Please tell .. Thanks in Advance :) |
| | I have an intranet using php 5.3.8 on Server 2003 using IIS 6.0 and SQL 2005. I run a command to call a batch file that starts and stops sql server and then calls a stored procedure to delete records from a table Items and then refreshes the records from … |
| | Guys I have a table with image datatype and I wana insert an image in the image field, for example [CODE=SQL]insert into dbo.Products(ProductID, ProductName, ProductPrice, ProductImage) valeus(144, '8 Gig Lenovo memory Stick', 250.00, 'Image from C:Drive or where ever the image residing')[/CODE] Thanx in advance |
| | [CODE] //Creating a variable for the connection called //"con" Connection con = DriverManager.getConnection("jdbc:mysql://IP_ADDRESS:3306/DATABASE_NAME", "USERNAME", "PASSWORD"); ... [/CODE] If I don't want at least the username and password to be shown in clear text... is there something I can do? Have them in a file thats encrypted or... I don't know.. … |
| | Hi Every one. Dears i need to store a decimal value into the database inside the db its type is decimal(4,4).From c# code i explicitly convert the textbox value to decimal bt it throws exception.If i change the decimal(4,2) its work fine but my requirement is that i want to … |
 | So I learn and write php. Very messy I am sure. I find that MySQL is deprecated and no longer the latest and greatest. I want to take my app offline. Ok, but how can I do that if the remote server is not a option? How do I store … |
 | hi there, im a beginner really and have just tried to finish a new computer based booking system for my work, im using sql and a database to store the customers and then store bookings too, but im having problems with the customer form, when i run it it kind … |
| | I want to create a SQL login in SQL2005. I tried creating it but it gives me error message [COLOR="Red"]"Create failed for login 'username'. User does not have permissions to perform this actions"[/COLOR] What to do now to create a SQL login in sql 2005 |
| | how to get 10 th record from record set using SQL server? there are a lot of code in the internet that can get first 10 results using "TOP" keyword in sql. but i want to get 10th row valus. I'm using VB 2008. please help me.... Regards Pra$ad. |
| | Hi guys, hope you can help. I'm creating a mixture of an employee scheduling system with elements of a Human Resource Management System for small to medium businesses. I ideally want to create a java application with a database backend, which I'm trying to see if I can apply sql … |
| | This is my first time really dealing with C# i did this in VB with ASP but never with C#. What i need to do is take data that I enter into a textbox and save it to my SQL server and there is also a Image that needs to … |
| | Hello all, Sorry for asking this newbie question again. But I need to get the server name and all database name on SQL Server. I want to make application, which can switch between server and database quickly. So user can choose server, then input username and password, then the list …  |
| | hi all. here's my problem;. I would like to have a macro to export data from an excel file into the database(SQL) for insert and update data purposes. but i'm not sure how to do this.Can someone please show me a code syntax on how to do it?the excel file … |
| | [B]I am a newbie so please be kind.[/B] I have put together a form using multiple queries which pulls information from MySQL tables that are joined by ID number. It displays the info in a form so updates can be made. I cannot get it to update more than one … |
| | how do i delete all the data which is stored in the sql table???? i want to delete only the data present in one table without dropping the table when i click on the command button in vb6 plz help :(:(:(:( its really urgent  |
| | I'm new to MS SQL and trying to solve a problem where I need to extract specific data from a remote SQL Server 2005 DB into a local SQL Server 2008 R2 DB. In a Stored Procedure, I'm trying to use Linked Server via Ad Hoc links in the following … |
| | I know this question has been asked dozens of times, but the code I have been looking at has not helped me. So far I have been able to connect to the string and the database from where I need to check the username, but in my page it is … |
| | Hi, Someone pls correct the error. [CODE]SELECT orderid, merchant, buyprice, commission, refund, (buyprice - refund) as expenseOrder , (commission - expenseOrder ) as profitt FROM business WHERE merchant LIKE "GO%"[/CODE] error: MySQL said: Documentation #1054 - Unknown column 'expenseOrder' in 'field list' Thanks.  |
The End.