6,934 Topics
 | |
| | |
 | Hi all , can you pls say how i able to send the email notification alert with the datas getting from Sql server 2008 using windows service . - Thanks in advance  |
| | Hey guys I'm in the middle of connecting my website to my SQL database at the moment i have the following and I need some help if you guys dont mind config.php //Mysql Connect | mysql_connect("host","username","password"); //Below example to connect in localhost $a=mysql_connect("localhost","root",""); //select your database $b=mysql_select_db("database_name",$a); submit_form.php $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; … |
| | I am about to make website, where explain my skills (if any), kind of portfolio. I'd like to make two seperate choices in menu, one for the client-side work (HTML, CSS, JS) and one for the server-side work (PHP, SQL) seperately. I thought of word "Coding" for client-side work. But … |
| | Please can someone help me optmize this query, it is slow and brings the same data for the debtage column SELECT customer.custid,customer.compname,customer.phone,customer.depot,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate, STR_TO_DATE(transactions.timestamp,'%Y-%m-%d') AS debtage, format( customer.balance, 2) AS balance, customer.balance AS balance1 FROM customer,mastorders,acctofficer,transactions WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff AND customer.depot='$depot' GROUP by customer.id ASC. … |
| | Hi I am new, Pls help me the following issue. When click the update button, ID should be to another page to process the update function. Below is my entire code index.php <?php include_once '../../inc/config.inc.php'; $sql="SELECT * FROM demo order by id"; try { $result = mysqli_query($con,$sql); include 'view.html.php'; } … |
| | I have a table with the following fields: client, project number, project manager, project manager email I have a form with text fields for each field of the table and I want to have a query run when the user presses a button on the form. How to i make …  |
 | Hi everybody!! I'm starting with asp.net and i would like to try my code online.. can you advise me some free hosting for asp.net with the possibility to use sql server? Thanks  |
| | i am trying to get data into oracle table from CSV file with SQL *LOADER but not getting the date which is in time zone format I.E. 2013-02-23T10:41:14.000Z in my csv file. i am using DATE as a type for Creation_Date. pls help me to resolve this problem asap. |
| | How can I perform SQL Server backup recovery task? Please recommend solution for my query. |
| | Hi I have the following code so far. Basically I have a drop down list were the user selects the type of membership he wants. When he clicks the button buy now from the database the membership cost and type are displayed in the pg. The problem is that I … |
| | I'm working on a Database assigment but I'm kind of stuck. It seems to be the Double value that's causing the issue because when I use the Varchar data type I can create my table. Is there any way I can use Double without using Varchar. Any help is much …  |
 | I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you  |
 | |
 | Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because … |
| | I have a query which i am trying to get the last date and when i do, the purchdate and LastPayDate is the same for all the data. the query is below: SELECT DISTINCT customer.custid,customer.compname,customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, preAgg1.LastPayDate,customer.depot, MAX(mastorders.lastsuppdate) AS purchdate, MAX(mastorders.id) FROM customer,mastorders,acctofficer, (SELECT DISTINCT T.custid, Max(T.timestamp) … |
| | Hi Guys I've now sorted the sql query and the database is now sorted, but now I want to connect the PHP and sql database Config.php file //Mysql Connect | mysql_connect("host","username","password"); //Below example to connect in localhost $a=mysql_connect("localhost","root",""); //select your database $b=mysql_select_db("database_name",$a); I take it I need to specify the … |
| | I've developed an application in vb 2010 and my back-end is sql server 2008. What are all the softwares i need to install in the client machine ?  |
| | Please can i get a help on joining these 3 queries SELECT customer.id,customer.custid,customer.compname, customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastpaydate,'%d-%m-%Y') AS debtage,customer.depot, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate FROM customer,mastorders,acctofficer WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff GROUP by customer.id ASC SELECT customer.id,customer.custid,customer.compname, customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, customer.depot FROM customer,acctofficer WHERE acctofficer.acctoffid=customer.acctoff GROUP by customer.id ASC … |
 | Hallo, I get stuck when installing SQL Server 2012 : Services Account Name Password SQL Server Agent SQL Server Database Enginee SQL Server Analysis Services SQL Server Browser This Sharepoint Server connected to DCSHARE1 (Domain Controller) The problem is I do not know what to fill for Account Name & … |
| | Hi, I have created a parameter table, added 1 column to it and populated that column with 1 value as shown here: CREATE TABLE tbl_param( maxcount NUMBER); INSERT INTO tbl_param VALUES (5); My problem is I want to create a loop from 1 to 5, but instead of just using … |
 | Hi everybody, I'm back and I bring problems. :D I've done a fair bit of research - I know Android can't run JRE 1.7, and I know JRE 1.7 is needed to get Java to read SQL. I've got this project that says I need to make a way for … |
| | Friends , I have a database in sql server named "Deposit" with a table "Receipts" .I want to display the data in a list box.My code is given below Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim cnn As New SqlConnection("Data Source … |
| | Good Day Daniwebbers! Wonder if I can have some help. I am trying to build an 'admin panel' of sorts where the user can add content to their website, edit and delete it, all from one spot (Not unlike a CMS system I guess but purely for the purpose of … |
| | Hello Experts Here is my connection string [CODE] string con = "Data source =YS-8462BA359936;Initial Catalog = Schooldata;Integrated Security = True";[/CODE] and my store procedure is [CODE] SqlConnection objCon = new SqlConnection(con); objCon.Open(); SqlCommand cmd = new SqlCommand("Studentinsertadmission", objCon); cmd.Parameters.Add(new SqlParameter("@Studentid",Convert.ToInt32( studentid.Text))); cmd.Parameters.Add(new SqlParameter("@StudentName", firstname.Text)); cmd.Parameters.Add(new SqlParameter("@Image", image.image )); cmd.CommandType = … |
| | Hallo, This is funny. I export mysql codes to the webserver. Yet, I cannot run the codes correctly, there are some errors when I run the codes: Error SQL query: -- -- Database: `project_infracom` -- -- -------------------------------------------------------- -- -- Table structure for table `infracom_admin` -- CREATE TABLE IF NOT EXISTS … |
 | how to get all available SQl SERVERS on the network and their databases?  |
| | Hi, I need to make a registration page to my Private Silkroad server on my website, and it works with SQL Server 2012. I'm not really into PHP neither SQL, just figuring it out with poor online guides on the web about it, and I didnt find any help with … |
 | Hiya guys, I am wondering whether anyone can help me, I have been stuck on this for weeks. I have got a similar thing working but I just cannot get this working. I have got a SQL Server Database integrated into my VB application. There is a table called 2HaulierLogIn … |
| | i am creating a form in vb.net, the aim is to be able to insert data to the sql server from the form interface. the form's textboxes fields include Name, DateofBirth, Address, Telephone, PostalCode, Nationality, DateofRegistration Sex (ComboBox), plus two buttons names, Submit and Cancel. kindly assist with a code … |
| | I'm using: Windows 7 Word 2010 Visual Studio 2013 Express for Desktop An Access database with one table As this project is for proof of concept I'm keeping things very simple until I can get the VB working correctly. The project consists of one form (Audit.vb) which contains one textbox … |
| | Hi, If I could please get some help? I have missed the lectures on creating tables due to my daughter being sick. I am trying to follow the lecture notes but I am having issues. I get the following error Error at Command Line : 4 Column : 21 Error … |
 | Hello Im trying to display a label when my program starts, to check the server status.. For example if the user is successfully connected to the server it should say on the label "Connected" and if not the label should say "Not Connected" , my Database is located on a …  |
| | Hello everyone I have DataTable in C# Windows Application and I want Send This DataTable to SQL. In SQL This DataTable as Table variable but i cant do this because i must create datatype as table But i dont know the total code for this first in C# second in …  |
| | Hi, I just recently started a website with the hope of connecting a program I made with the licensing database that I've already created. I have all the usernames and passwords I need. on a side note, I'm using Visual FoxPro 9. But each time I try to connect I … |
 | I want to pull the image name from the database and insert it to the folder directory path using php. I am wondering is this possible and if so how? Ive attempted it a few different ways but i can't figure it out? while($row = mysql_fetch_array($result)) { echo "<tr>"; This … |
| | This is what I have: create table Employee_T (EmployeeID varchar2(10) NOT NULL, EmployeeFirstName varchar2(10) NOT NULL, EmployeeLastName varchar2(15) NOT NULL, EmployeeAddress varchar2(20), EmployeeCity varchar2(10), EmployeeState char(2), EmployeeZip number(5), EmployeeDateHired date default sysdate, EmployeeBirthDate date, EmployeeSupervisorID varchar2(10), Constraint employee_PK primary key (EmployeeID), Constraint employee_FK foreign key (EmployeeSupervisorID)REFERENCES Employee_T(EmployeeID) ); create table … |
| | I setup Merge Replication between SQL server 2000 and Windows 7 64-bits. It setup successfully and working fine in LAN and WAN. But the replication will fail after run few times successfully in WAN. The error msg :"The process could not not connect to distributor ''. SQL server does not … |
| | i really have a problem to this code. can anyone help me? Try Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Import data from Excel file" End With If fBrowse.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fname As String fname = fBrowse.FileName … |
| | If anyone can help me , I wanted to know how to use a progressbar while the sql query is executing. Just a "Beg"inner in VB.net here's my code: dataopen() cmd.Connection = con cmd.CommandText = "Select User_Name, userpass from Borrower where user_name='" & EmsTextBox1.Text & "' AND userpass = '" … |
| | Hello, I have two tables one for 'users' and another for 'vendor_service' in database named 'star'. In vendor_service table i've stored users id as a foreign key. Now if i try to insert values in vendor_service table it shows following error. Cannot add or update a child row: a foreign … |
| | Having a problem setting up a login form for my project, here's the code: Imports System Imports System.Data.SqlClient Public Class Login Dim con As SqlConnection Dim cmd As SqlCommand Dim rd As SqlDataReader Private Sub dataopen() con.ConnectionString = "Server=IGNITER-PC\OBEXPRESS;Database=EMS;User ID=sa;Password=au" con.Open() End Sub Private Sub EmsStickyButton1_Click(sender As Object, e As … |
| | |
| | We just need the save button to save to a sql database. This is done other than that. it is saying, "Error: No suitable driver found for jdbc:derby:charityDB;create=true" import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; // Event listener import java.text.NumberFormat; import javax.swing.*; // GUI building import java.io.*; import java.sql.*; // JDSB …  |
| | Why is stored procedure is better than executing a sql query. What is meant by exeution plan  |
| | hello dani, I am using shape sql for datareport without dataenvironment conncetion towards parent-child relation ship table. But doesn't work with error. Because parent fields only accepted in my project. I am attaching my vb 6 project to your kind attention please. Option Explicit Dim con As ADODB.Connection Dim rs … |
| | I am getting into more detail with my advances in MVC and started out using the entity framework to build repositories and contexts for intefacing with data in my SQL Server database. Previous to this I coded my own SQL using the SQL command namespacess and some data adapters instantiating … |
 | i want to fetch data from date and time with limit for latest data in database ..how to fetch..? |
| | I have JList and the JList contain names of fields of table in the db this is my code. I'm stuck in writing the query I understand that the sql query should be like this "SELECT column_name1,column_name2..etc FROM" however now I got the column formated this `// System.out.print(aa + bb);' …  |
 | hi all i have made c# project that use sql database and i want publish this project and make a setup file and include sql server program to the setup .. i meen when the project is setup sql server setup too .. |
The End.