6,934 Topics
 | |
| | there are five tables (personTb, addressTb,churchTb) each holds data pertinent to an individual; (personAddress,personChurch) each hold the primary key for the person table and corresponding table IE personAddress holds primary key for addressTb. both snippets work, my question is;** Is my join correctly formatted? ** select concat(personTb.p_fName,' ',personTb.p_mName,'. ',personTb.p_lName) …  |
| | Hi all, I'm working on a SQL procedure to insert a row for new clients based on a template account that already exists in the database. I thought about Declaring a variable and selecting the value from the table one at a time, but with many columns needed, this seems … |
| | Hello, I built a website on my personal server and everything work fine. But when I uploaded it on the production server there is a problem with the database - the character encoding is wrong so the text is unreadable (users submit greek words). The collation of the tables is … |
| | Hi all, I am trying to compare data from $_POST['Net'] which has 6 elements to check to see if the data has changed in the form when submitted. Below is the Post array from form. array(16) { ["Submitted"]=> string(4) "true" ["NetValue"]=> string(1) "0" ["ProductID"]=> array(6) { [0]=> string(5) "76458" [1]=> … |
| | The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all … |
 | Not sure if this is the right place for this, if not, please remove. I'm an Admin for a very large SAP landscape which includes variety of DBs. I've been evaluating the Xandria product from syslink ([www.syslinkams.com](http://www.syslinkams.com)) and so far been very impressed. I was wondering if anyone had any … |
 | `Select * from contacts WHERE behavior = 'nice'` [SQL Clause is coming to town.](http://imgur.com/gallery/KvsXO) Not mine, [Little Bobby Tables](https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables) almost ruined Christmas. |
 | Hello friends. Please help me to solve my problem. I am using sql server 2008. When I try to access it recieve the following error: "Cannot connect to localhost ". So my question is, how to repair sql server? Hopefully someone will be able to help me with this.  |
 | Hello all, I have the following code. Connection connection = getMySQLConnection(); try { Statement st = connection.createStatement(); String SQL = "SELECT ID, NAME FROM STUDENT WHERE ID=5"; ResultSet rs = st.executeQuery(SQL); System.out.println("SQL =" + SQL); while (rs.next()) { // do something... } } catch (SQLException se) { se.pringStackTrace(); } From … |
 | when i upload image in form using cakephp at that time the image is insert but other data will not inserted...?? |
| | I am working on a report that is requesting to count the total number of errors per element in the total row of the report for a given County. When I use the COUNT function it is taking the max value from the number of reads complete column for that … |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
 | Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot … |
| | i try to redirect one controller page to another controller page using cakePHP but it not working so please help me to solve this query....  |
| | Hello all, I have an spring MVC app, that connects to my backend MySQL DB. I have my data source configured properly in my spring bean config XML file, as follow: <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3406/mydb" /> <property name="username" value="root" /> <property name="password" value="passwd" /> … |
 | Help me....! Actually I have records about 1000 credit customers, My collection boys go to their door on due date(eg. 15-11-2016) for collection of money. but they have no money to pay,that's why they call my collection boy after 10 day(eg. 26-11-2016). Now, I want the query in Sql. if … |
| | How to get values from listview and display it to textbox using sql database ? and then i can update the items in listview using a button..then refresh the listview after i click the button... tnx for the help in advance..im just a newbie in vb.net   |
| | [B]Retreving images from sql to datagrid View windows Forms[/B] Hi i have two colums in table, id and image i have stored my images in the Table ImgTB but the problem is while retreving the images. I just get a red cross.It would be great if some one can help … |
 | Hi everyone, I have database in cassandra . I am facing difficulties in cassandra. So I want to migrate cassandra tables in mysql. Is it possible ? How I can do this? Please help me.  |
 | Hello, I have SQL Yog Installed. I wonder if it is an alternative to SQL Server. I do not have to install SQL Server also at the same time right? Please help me understand how to use it. https://www.webyog.com/ Thanks, Davy |
 | Hi, can some one please help? I want to double-click on a "customer name" in form1 datagridview and then see "customer details" of selected customer on form2.. (in ms access it called "linked forms") I use VS2012 (vb.net) and SQL database.. Thanks, Michelle |
 | I want to make a script that changes pictures depending on the type . I am getting a error on Sql but i dont know what i am doing wrong this is the script function Pic($profilePic) { if($profilePic) { $profile_pic=BASE_URL.UPLOAD_PATH.$profilePic; } else { $sql = "SELECT type FROM messages WHERE … |
 | I am using the Ionic framwork for the mobile app and Bootstrap for the web app, this has been set by my University as what we have to use, so we can't change them, but is there a way to link the data base to both services? Thanks in advance … |
 | I inserted data in sql server using asp.net (MVC 5), and its flowing nicely, but my problem is this. I don't want to insert in sql the exist data. How can I do it?  |
| | Hi guys, I am trying to fill a datagridview on the form with data from sql server databse based on the name of the company selected in the combo box. But the code i am using gives me an error message saying "The data types text and varchar are incompatible …  |
 | I got two dropdowns in each product in my cart. When i select my both option my class on success is not updating the cost. It only updates when i refresh the page, i dont want to refresh my page to get the cost. this is my script... $(document).ready(function() { … |
| | I am looking how to join two different tables from two different databases into one datagrid view. To make things more clear I am using two different connection strings to get the data.I perfer VB but if I need to use c# I can adapt.  |
 | Hello everyone, I need to open mdf file but I can't install SQL server. Please advise how to view data in sql mdf file? Thanks in advance, Richard |
| | From were we can generate backlinks? how its possible to generate a backlink for a day? Many are saying that it is through off page submissions?.. But do anyone know that how much submission should be done for a keyword?.. Please help me out  |
| | Hi, I have a column "statustime" in a table , which has values( like,10:24:10 PM,12:04:00 AM) with mixed of AM and PM . I want to display the other values by "statustime" in ASC . How to do? |
 | I edit [this][1] todo app and make a multiple topics version of it. Like todos for X, todos for Y, todos for Z... However i couldn't find a proper way to edit this part : app.param('task_id',function(req,res,next,taskId){ req.db.tasks.findById(taskId,function(error,task){ if(error) return next(error); if(!task) return next(new Error('Task is not found')); //if there's data, … |
| | currently I have a survey with 10 questions on a html/ php form. I use post data and then have a long insert statment. My code looks something like this. <php? $surveyid = $_POST['surveyid']; $q1 = $_POST['q1']; $q1comments = $_POST['q1comments']; $q2 = $_POST['q2']; $q2comments = $_POST['q2comments']; $q3 = $_POST['q3']; $q3comments … |
| | I am trying to follow the steps in an example on fpdfmakes webiste. However I am using sql server instead of mysql. Could someone give me some pointers so I can get this to work correctly? thanks <?php require('fpdf.php'); //Connect to your database $serverName = "myserver"; $connectionOptions = array("Database"=>"mydb"); $conn … |
| | Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried … |
| | Ok, so this site sell me on developing a website saying "Death to the DIY" MoPro is another cookie cutter platform that says they will build it but..... well you tell me. eeshop.us I need help to understand how to put content, products and vblogs on the site. And if … |
| | Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to … |
 | I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration …  |
 | i dont have codes yet  |
| | Hi Guys, i am building an application in VB.Net with sql server for databases. I have a screen on which the items in a table are populated in a datagridview based on the combo box selection. A button to commplete the sale has a code that must subtract the number … |
 | Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), )) |
 | My Error info isnt being clear enough for me to understand the problemIs there anything worng here so i can continue on lookng for the probelm: $sql = "INSERT INTO boards ( title, genre, creator, tagline, intro, remessage, visability, recruitment, reqsheet, reqdice, reqgroup, ppweek) VALUES ( $title, $genre, $creator, ". … |
 | Dear Developers, This is the part of my blog.While adding new post to my blog the category option not updating to database add_post.php <h2>Add Post</h2> <?php //if form has been submitted process it if(isset($_POST['submit'])){ $_POST = array_map( 'stripslashes', $_POST ); //collect form data extract($_POST); //very basic validation if($postTitle ==''){ $error[] … |
| | I have Post code column and I want to get 60, 30 and 10% for each area code that I have, but the thing is there is a between statement which makes things a bit complicated. I need 60% from the first postcode then 30% from the second and 10% … |
| | Hi can any one please help me with some sample for multiple textbox value in php search. all the fields in the search are in one table. I have attached screen for the reference.   |
 | Hi I using jquery in my page and i have a combox . Now i need to save the combobox value in an single session storage each time when i select the values from combo box and then use these values in other page . Can any one help to …  |
 | I have a problem that in my sql is always updating the last records. I need to loop in every row and update each record in that row i tried this code underneath but only last record is updating . <tr> <td value="<?php echo $_SESSION['flowertypename'];?>"><?php echo $_SESSION['flowertypename']?></td> <?php $query7 = … |
| | Dear all I am a beginner in web development. Please help to resolve the below problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers. > When customer select the specific job we need to filter particular job … |
| | Dear developers How to show contact details while clicking the particular name from <li> list Contact_list.php <?php $con=mysqli_connect("localhost","user","pass","nilambu1_mydb"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM n_info "); while($row = mysqli_fetch_array($result)) { echo "<li><a href='contact.php' data-transition='slidedown'> <img … |
 | : CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not … |
 | Hi! Having a hard time figuring out how to solve this problem at hand. basically i have several tables that are inter connected in some manners but i need to full all this data and format it in a manner that it will show the total number of trips and … |
The End.