6,934 Topics
 | |
 | If a table contains field's like name,age tuition fee,bus fee,year, 1,2 When I tried to update 1 year details it is updating but when I try to update the entire fields it's not updating in form of jsp page  |
| | Using Crystal Reports XI, and using the command feature with this simple query: select Field1 AS Item, Field2 AS Customer from Server.DB.dbo.Table whereField1 = {?Parameter_String} Returns an error: Conversion of Value overlowed an Int Column. If the parameter value is one that matches a record, it works. If the value … |
| | SELECT CASE WHEN (Employees.End_Date is null) THEN select EmpId, Emp_Name, Salary , Start_date , End_date ,DATEDIFF(DATE_ADD(Start_Date, INTERVAL 30 DAY), Start_Date) * Salary/30 as 'Total_Salary' from Employees ELSE Select EmpId, Emp_Name, Salary , Start_date , End_date ,DATEDIFF(End_Date, Start_Date) * Salary/30 as 'Total_Salary' from Employees END From Employees; Please help me to …  |
 | I am a beginner practicing how to create tables on SQL Here is what I've done: Create Table PO (Order_id int primary key, order_date date, customer varchar(1000)); Create table PO_Line_Item (Order_id int not null, Line_number int not null, Product varchar (30), Unit_Price decimal (10,2), Qty decimal (10,2), Tax decimal(10,2)); When …  |
 | Hello Dear Friends, I need some help to check avilidity of the username on Leave event of a textbox in Database SQL Server, but i cann't get. it code is bellow private void textBox6_Leave(object sender, EventArgs e) { cmd = new SqlCommand("SELECT * FROM usertab WHERE username='"+textBox6.text+"'",con); SqlDataAdapter da = …  |
 | I am trying to create a mysql query that groups people and the ranks them. I use the following to rank them without the grouping and get that result: SELECT rank, performance, wind,athlete,dob,prov,pos,place,date FROM (SELECT performance, wind,name,surname,dob,prov,pos,place,date, @curRank := IF(@prevRank = performance, @curRank, @incRank) AS rank, @incRank := @incRank + … |
 | **problem** How to get cost per hotel and flight then add it in duration cost table based on flight date automatically . **Details** suppose i write flight date 26/07/2017 alexia 8days 04/08/2017 it must automatically get cost from hotel price table and price from flight then add it in duration …  |
 | Hello pls i am making a comment feature for my log. I want the comments to be submited from a form in the "READ_MORE.PHP" , and i want the form to be processed in a "COMMENT.PHP" page were the form values are insertrd in the Comment table... (which has 5 …  |
 | Hi all I'm creating a warehouse management system, then i want when new orders are created, a customer's name be selected from a list box and that customer's selected name from a list box be the table name that will hold records of the table's order with a random number …  |
 | Hello, I am trying to rename database MySQL: RENAME DATABASE old_db_name TO new_db_name; 1 kesalahan ditemukan dalam analisis. A rename operation was expected. (near "" at position 0) Query SQL: RENAME DATABASE wwwsoulf_revsoul TO wwwsoulf_revsoul2 MySQL menyatakan: Dokumentasi #1064 - You have an error in your SQL syntax; check the … |
 | Please help on this one: SELECT Format([expr1],"# %") AS expr2, totvisit/totrem AS expr1 FROM ( SELECT Count(*) AS totrem FROM ( SELECT DISTINCT remid FROM remtable WHERE remtable.pacid = 94) AS r, ( SELECT Count(*) AS totvisit FROM ( SELECT DISTINCT visitaid FROM jurnal WHERE jurnal.pacient_id = 94) AS b … |
 | Hi I have the following form at [http://test.genealogyresearchassistance.co.uk/newLinks.php](http://test.genealogyresearchassistance.co.uk/newLinks.php) The code is <form id="add" action="add.php" method="get"> <label for="name" id="name">Name of site</label> <input type="text" name="name" required="yes"><br/> <label for="link" id="link">Link of site</label> <input type="url" name="link" required="yes"><br/> <label for="desc" id="desc">A bit about the site</label> <textarea name="desc" required="yes"></textarea><br/> <label for="location"> Location:</label> <?php include 'database_conn.php'; $sql … |
| | I want to get sum of estimate quantity from estimates table gropBy material_id. Also want get sum of mprs quantity related to previous query table. My estimates table is as below | id | project_id | material_id | estimatequantity | | 1 | 1 | 1 | 500 | | … |
 | I am currently trying to update a database using C# My issue is that the update query is not working, there is no error produced just reloads the screen and thats it. My C# is as follows void SaveRecords() { try { String qry = "Update Ordered_Test Set Ref_Phy = … |
| | i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN … |
| | I have the following script which successfully finds the values for $payer_email, reminder_date and sub_expire_date, however where I am having trouble is when I apply a WHERE condition to the SELECT. The condition I am trying to apply is the commented out line at the end of the SELECT. The … |
| | Hello SQL Gurus, This Query below is doing the job but it is horrible slow. Is there any way to make the query faster ? Perhaps a join .. inner outer, left ? I am looooost. Thanks for any help. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Text:= 'SELECT * FROM orders_batch WHERE invoice_no=:elorder_no'; SQLQuery1.params.parambyname('elorder_no').Asstring := … |
| | Hello experts, I have to write a sql joining 6 tables. to retrieve classid, planname, workoutname,date,timeslot,status,staffemail and display them to a gridview. the tables are as below **tblclass** having columns *classid(PK)*, planallocationid*(FK to tblallocation)*, date, timeslotid*(FK to tbltimeslot),*status, staffid*(FK to tblstaff)* **tblallocation** having columns *planallocation(PK)*, planid*(FK to tblplan)*, workoutid*(FK to … |
| | Hi guys, i have a login page where i created a session trainer after login. the session is the mail address of the trainer. now from another apsx page, i would like to retrieve the staffid of the user logged in using the session as criteria. I tried to write … |
 | |
 | 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 have vb.net windows app and i can insert data to acomputer where sqlserver is installed in the same lan but could not connect from another network(different lan)to the computer. |
| | 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 … |
| | Hey,Guys now I need to know How to run an SQL stored procedure from sql through C# at a specific time? Any help please? ...  |
| | 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 … |
 | New Friends! :) The following is my member registration code as of latest. ISSUE 1: I get this error: Parse error: syntax error, unexpected '_' (T_STRING), expecting ',' or ')' in C:\xampp\htdocs\e_id\register_edited.php on line 10 What is wrong ? I copied the "'images/'_$FILES['avatar']['name']);" from a youtube tutorial on how to … |
| | 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 … |
| | I am creating a update member page. I would like the page to auto retrieve the information he or she originally used while registering on my site and display them into the individual textboxes of the update profile page, this is to prevent the hassle to rekey in every individual …  |
| | Hi, i am trying to build Employee Attendance system and was successful in assigning TAGS to employees.now i want to calculate in/out timings of employees and which TAG swapped His/Her TAG without displaying any data to end user. i had tried basic sql query but seems to be not working. … |
| | 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 would like to show content of a table in SQL database to a gridview in C# project, but there is a trouble, the gridview shows nothing. could you please help me to fix it! Thanks. Here is my code: protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { …  |
 | i have create a webpage using visual studio 2017. now how could i link this to database that i have created in mysql.?  |
| | Im working with Forms Builder. Ive built my form, when Im testing, it shows: FRM-41045::cannot find item:invalid ID. See Help>Online help for details But, online help sucks - there are only unanswered questions (forum-like site) Any help? |
 | 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 … |
 | I want to connect my database (sql) into a program i made on c in codeblocks but i cant find a way to do it |
| | 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 …  |
The End.