2,569 Topics
 | |
 | |
 | I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 …  |
 | I want to make a member login system which every member has its own database, when a user is registered successfully i want to create his special database. please help me the database creation code if you can Thank you Ali-Yare Mohamed  |
 | To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel … |
| | I am trying to cast/ convert varchar to a numeric value. I have done this succesfuly when I eval the lower range, however I get an error when I do the upper range. this is my evaluation section that works. isnull(cast(measurmentdata.measvalue as numeric),0) < productinfo.lowerrange however when I try to … |
 | I work in MVC 5 c# in visual studio 2015 web applications I have table pictures in SQL server 2012 have two fields ID Image ID have number of image inserted like 1,2,3,4,5 Image field store picture added what i need actually browsing images found in table pictures in database … |
 | Hello, I am trying to upload mysql file into my xampp. (Max: 2,048KiB) I wonder why it cannot exceed that limit? I have tried to update my php.ini file : upload_max_filesize=10M and save it but it does not change the fact. I have to upload like 2.6 M file but … |
| | Hello Everyone, I am working in MySQL Workbench 6.3 CE and trying to use a trigger inside of a stored procedure to see if it will detect if my email format is not in the right format I specified in the message text error, but I am having trouble because … |
 | Actually the form below is a registration form, and i only have ' username, email, password and confirm password field' so i want to add another field name job, but keeps getting error. see the code below; if (!preg_match("/^[a-zA-Z ]+$/",$name)) { $error = true; $name_error = "Name must contain only … |
| | Hi i am trying to insert pdo multiple checkbox value in one column into database and display it to the user, but i am getting this error Error: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined.I cant see the error and dont know how to fix it. :( That is … |
 | i have this code..,. i dont see what's wrong why its only working on the first record of LOOP of X set serveroutput on size 30000; DECLARE VTEMP NUMBER; VPARENT NUMBER; BEGIN FOR X IN ( SELECT TEMPLATE_ID, TYPE_ID, TYPE_KIND, RECORD_ID FROM RT_RECORDS WHERE TEMPLATE_ID = 106 )LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID X …  |
 | please I'm a student of standard institute of tech.. studying comp. sci., we've been asked by our lecturer that all of us should look for all way to view answer on an online CBT(Computer based testing) test which is powered with asp.net, js, HTML, css. plz I'll really appreciate your …  |
 | hello expert, i have three dropdownlist option consist of two string and one datetime that convert into string. If i want to choose first and second dropdown without the third one which is datetime, it occur error "the string was not recognized as a valid datetime. there is an unknown …  |
 | Hi friends , I have three table Countdown, Walk, Bon de reception The Id_marche is a foreign key in the countdown table and The Receipt table contains the Id_marche I want to insert in recordings in the counting table which contains Amount TTC so to calculate Amount TTC = TVA* …  |
 | Hi, i have a db system where i fetch results from two tables. A user and transaction table. In the transaction table i have two columns which are sender and reciver id which refence in the user table. how do i get a sender name and receiver name in a … |
 | Hi, I am using php 7 and I do not know why the following 2 different codes for user the user registration page is not working.*The login page php is working, though. I would appreciate the communities feed-backs. Thank You! |
| | <pre>Hi, I'm a beginner in php. Starting my learning at php 7 and not 5 or earlier. I don't understand why php 7 is acting weird. It give different result at different time. Do you guy mind checking if I got the coding wrong or if I've come across a … |
 | HI, I have the below php code that i am attempting to use to search the database for a value that has been inputted in the form. This connects to the database and works fine but brings back no results. I found the following error: Warning: mysqli_num_rows() expects parameter 1 …  |
 | I would like to show data in a table in SQL server database to Gridview in ASP.NET project, but the gridview shows nothing. Could you please help me to find where is the problem, and how to fix it. Thanks Here is my code: protected void Page_Load(object sender, EventArgs e) …  |
 | i have create a webpage using visual studio 2017. now how could i link this to database that i have created in mysql.?  |
 | Why am getting error when i think it should work fine **Error** Fatal error: Wrong SQL: INSERT INTO kladilnica (Username, Bet, Win, reg_date, Odds, isActive, ticket_id, isShared, is_winned, Location) VALUES ('Stefan', 100, 3500, '2017-02-06', 66, 1, 351358728, 0, 0, '') Error: in C:\xampp\htdocs\bootstrap\navigation.php on line 257 **Code** $sql = "INSERT … |
| | hello, i have one table in sql server and i made a form to editing this table from. so when i click edit in the table .. it takes me to the editing form with the chosen id .. what i need is to show all other feildes in the … |
 | As it seems to come up often enough I figured I'd throw together a quick snippet outlining basic methods for data manipulation in SQL Server using C#. In all examples the coder will need to substitute their own connection string details and variables. I utilised parameters for 3 of the …  |
| | 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 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 … |
 | 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 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?  |
 | 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 … |
The End.