1,694 Topics
| |
Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records … | |
1. For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will. 3. For each directory, print out his name, in which directory it is located, and how … | |
Hi guys I'm still having trouble actuly letting users register with my website. I need a simple PHP and SQL script that I can use and the scripts that I have wrote are not working correctly and I'm now getting really stressed out about it | |
hi Team, i am facing 1067 error while starting My SQl service in windows. share your suggestions for this request. OS: windows 7 pro 64bit AV: Symantec 12.14013 Thanks Shiva | |
Hi folks, I have a question regarding auto-generate row oracle using sequence. So the deal is, I need to make a list of inventory based on its quantity. So I have a table with 3 columns, 1. Component ID 2. Quantity 3. Sub_component. So when user input a component id … | |
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']; … | |
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'; } … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 .. | |
using vb.net and sql query i need to join multiple tables to view in one datagridview control .In each table i need to take only one field and want to dislpay all in the datagridview control...can anyone provide me the apat code for this | |
i am using a store procedure to access field in asp.net View, i am putting db columns in HTML table, it's workign except for one field, 'NetSalary'. It can't be accessed, it says that model doesn't contain it. i tried many ways but couldn't get to work. ALTER PROCEDURE [dbo].[GetMonthlyReport] … | |
I'm stuck on this problem any one know the answer. **Write a query that displays the grade of all employees based on the value of the column JOB, as per the table shown below. Order the result according to the grade! ** JOB GRADE PRESIDENT A MANAGER B ANALYST C … | |
hi my name is vishal for past 10 days i have been going nuts on how to combine selected datas from 3 or more tables into single sql select query in vb6. i have 4 tables named table1 name: Inward column Name DataType mfr_ref_number text no_of_bundle integer supplier_id integer DC_date … | |
I have an old access 2.0 database, i converted it in access 2007 but the old code doesn't work.. i heard that it is about DAO and ADO anyone can help me to convert this DAO code to ADO coding.. thank you so much in advance.. Private Sub cmdSave_Click() Dim … | |
hello everyone, im pretty new in this language (vb.net) so i have difficulties understanding its function, right now i am able to populate my database to datagridview, i've been looking for some related answers. but found no luck. so i decided to post it in here. so i have this … | |
I'm trying to calculate and list the websites in order of biggest overall reduction in response time from one time period to the next. I don't strictly need to use a single query to do this, I can potentially run multiple queries. | 1 | 1 | 93.26 | 2014-01-28 … | |
I am creating a pageant scoring system. I managed to display the field names from different tables : [Click Here](http://oi58.tinypic.com/5c0jz5.jpg) The first column "Participants" is from Participant table and the succeeding columns is looped from the Criteria table. This is the code: Private Sub CreateDataEntry(ByVal CatID As Integer) Me.CriteriaTableAdapter.FillByCategory(Me.PSSdbDataSet.Criteria, CatID) … | |
hi my name is vishal for past 5 days i have been nuts of how to combine data from multiple tables into single table using sql select query (join query) Given below i have tried solution but i get error message data not found. But in table i have datas … |
The End.