199,114 Archived Topics
Remove Filter  | |
| | function getAllReferrals(){ $sql = "(SELECT r.referral_date,c.lastname,c.middlename,c.firstname,c.gender,r.presenting_problem,e.employee_nickname AS nickname FROM CLIENT c INNER JOIN referral1 r ON c.referral_id = r.referral1_id INNER JOIN assign_psychotherapist ap ON ap.a_referral_id = c.referral_id INNER JOIN employee e ON ap.a_psychotherapist_id = e.empid WHERE r.referral_status ='Assigned' OR r.referral_status ='Accepted' ORDER BY referral_date DESC ) UNION ALL (SELECT r.referral_date,c.lastname,c.middlename,c.firstname, …  |
 | Hi , how to add numbers in specific count of rows in Datagridview like in this[Click Here](http://i.imgur.com/IZJ39Wq.png) picture. I already run this code to sum all collumn in my Datagridview. But I need to sum the 1+2+4 in collumn TEST1 without erasing the other data. Private Sub Button1_Click(sender As Object, … |
| | $sql = (" SELECT referral1.*, client.*, employee.* FROM ( select r.referral_date,c.lastname,c.middlename,c.firstname,c.gender,r.presenting_problem,e.employee_nickname from client c inner join referral1 r on c.referral_id = r.referral1_id inner join assign_psychotherapist ap on ap.a_referral_id = c.referral_id inner join employee e on ap.a_psychotherapist_id = e.empid where referral_status ='Assigned' OR referral_status ='Accepted' order by referral_date desc ) as … |
| | Hello, first of all I am new to vb.net so sorry if my question is stupid... :( I have text files that are something like this: "#...... "#...... 1.2 2.5 3.4 5.6 4.8 8.9 . . . Now I would like to add to the first column of the datagridview … |
| | Hi all, I need help understanding a C++ problem. This is an assignment question. Create a base class ‘Account’ and two derived classes ‘Savings’ and‘Checking’. The ‘Savings’ and ‘Checkings’ information should be connected to each other using variable CREDITRATING. Transactions in any of those derived classes should be able to … |
| | Hello, I am writting a code for class and I am having a hard time inserting my variables into my "cout". I know how to do it the long way but I know it has to be easier. Right know this is the portions I am working on: void displaySlpInt … |
| | Hello. I need help with my assignment urgently. This is my assignment question and the follwoing is my code. It compiles but it doesnt give me the right output. 1. Run length encoding. Example: if the input is “AAABBCCCDEEFFA” the output will be “A3B2C3DE2F2A” 1. Input takes the form of …  |
| | Hi, after creating a software with SQL database (my other pc is the data server) this shown up " String or binary data would be truncated. The statement has been terminated " what to do? sometimes it imports the data sometimes it does not... |
| | Hi guys Need help with my php booking form code.... basically when the customer selects a particular activity the database checks for the value assigned to that activity for example in my database ive assigned football and basketball with the value of 4 badmington, tennis and table tennis with the … |
| | Hi every body, i am new in this forum that i find very interessting i have an error notice with one of my function, "Notice: Array to string conversion in C:\wamp\www\waypointhr\components\data_view_join.php on line 118 see below in the line" this error concerns this line: if((string)$row['callback_function']!=='') see the holl function below …  |
| | Can any one suggest me to access db from MVC WITHOUT Entity framework..I need tutorial .. |
 | <?PHP include('config.php'); function cleanData(&$str) { $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; } // filename for download $filename = "Piante_" . date('Ymd') . ".xls"; header("Content-Disposition: attachment; filename=\"$filename\""); header("Content-Type: application/vnd.ms-excel"); $flag = false; $result = mysql_query("SELECT * … |
 | Hello. I have one field on my submission form which is for the User's zip code. Originally I had it set to int(5), but when I submit my form with a five digit zip code it only stores 4 of the characters, omitting the first digit. Example: On the form … |
| | I am tring to work out a price with VAT included based on a VAT rate the user enters. I want to display the result in a input box. Can I display the result of this as the user enters the VAT rate and price without clicking a button or … |
| | The multi-part identifier"er.vinod.sharma@gmail.com" could not be bound  |
| | Can you save the entire contents of an xml to one varaible in c#? |
 | I am trying to execute the query on server side and send the result to the client but at the time of returning the value to the client the error occurs Am trying to achieve this using RPC Protocol but i could not find out how to send back the … |
 | I am attempting to convert a C application to python. I am having difficultiy on this particular for loop. Any ideas how I might proceede? bool Enigma2C::encrypt(char *inString, char *outString) { int16 csum = 1, checksum = 0; int16 tmpSum = 0; int16 i = 0; strcpy(m_keyCode, inString); // Calculate … |
 | Hi i want to add items from multiple listviews to other Listview (Main Listview)when i click the same button each time select diffrent item from diffrent listview how can i do this with VB.net best regards  |
| | Hello everybody. You might see that many websites such as Facebook recognize your device even after you clear the cookies of your browser, RIGHT? Try to you log in Facebook, then log out and clear the cookies, then re-open the homepage of Facebook. You'll see that the username you used …  |
| | Hi, for the project I am working on I have four folders all which have 650 xml files in them, I need to write a program that will take the first file from each of the folders and send them to a database where the results from the xml will …  |
| | Good day guys I need help for adding 2 column in datagridview my project is : the import and the varibles are : Imports Excel = Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices Public Class Form2 Friend xlApp As New Excel.Application Friend xlWorkBook As Excel.Workbook Friend xlWorkSheet As Excel.Worksheet Friend … |
| | Hi all, I am trying to create a multiple drop down list in my codeigniter project with the following hierarchy Dzongkhag(District)->Geog(Town) ->village. I am unable to get any display in the town and village drop down list. The following are the snippets from my project. //controllers/form.php $data['dzongkhags'] = array( 'Bumtang' … |
| | HI, I'm having some trouble with this program - its supposed to return an acronym based on the input of the user: It prints three of the same letter instead of the acronym. Any help would be much appreciated. def acronym(phrase): a = "" for words in phrase.split(): a = …  |
| | Hello, I have just attempted to update my database login page to MySQLi and also use prepared statements but upon submitting a form I receive the error "Access denied for user 'admin'@'localhost' (using password: NO)". I have been researching this before posting this here but have only come across sites … |
| | I am facing problem for incrementing href id. for example href="#tab1", i want to increment n=6. It will increment like <a href="#tab1" data-toggle="tab">Counselor 1</a> <a href="#tab2" data-toggle="tab">Counselor 2</a> <a href="#tab3" data-toggle="tab">Counselor 3</a> <a href="#tab4" data-toggle="tab">Counselor 4</a> <a href="#tab5" data-toggle="tab">Counselor 5</a> <a href="#tab6" data-toggle="tab">Counselor 6</a> any body help me to increment … |
| | $this->db->select('referral1.*, client.*, employee.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assign_psychotherapist ', 'assign_psychotherapist.a_referral_id = client.referral_id', 'inner' ); $this->db->join('employee ', 'assign_psychotherapist.a_psychotherapist_id = employee.empid', 'inner' ); $this->db->where("referral_status ='Assigned' OR referral_status ='Accepted' "); $this->db->order_by("referral_date", "desc"); $this->db->select('referral1.*, client.*, volunteer.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assignvolunteer', 'assignvolunteer.Vreferralid = client.referral_id', 'inner' ); $this->db->join('volunteer', 'assignvolunteer.Vvolunteerid …  |
| | Hi I am facing problem for getting difference between hours and miuntes I have two variables $one=9:30 am; $two=6:30 pm; How to get difference in Hours and minutes |
| | I was wondering if you could help me with a current issue I am having whilst developing an ER diagram. The problem I am having is with identifying the correct Entities. The scenario I am trying to complete is given below. I have also included a list of entities which … |
| | below, I have create a table using oracle sql. How can I change so that number of credits for a course is always between 0 and 6. Any idea how can i do this? CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk PRIMARY KEY (COURSE)); |
| | I need to create a new site in PHP and need to host in cloud. Can anyone say in which DB I can host my site? |
| | below, I have created 4 tables using oracle sql. I want to change the code so that when deleting a student will delete all enrollments for that student. any idea how can I do this? # COURSES table # CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk … |
| | Hi, how to plot a chart from imported excel in Datagridview? I tried the tutorial from [HERE](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview), but I do not know how to plot the chart. Previously, I used MS.Access for my Datagridview, then I manage to choose the Datasource. But, for this case, I imported an excel and … |
| | |
| | |
| | Hello All, I am trying to implement a program that takes a prefix expression/string and converts it into a postfix string. I looked up the general algorithim for this converson and tried to implement it myself into this program. The following code is taken from my main java file. My … |
| | I have to create function that reads the binary file of futball matches and shows the legue table. The table should contains, for each team, the name of the team, number of points, goals scored and goals conceded. Give 3 points for a win and 1 for a draw. The …  |
| | Hey everyone! I'm brand new to Android and have been working on a very basic app that just takes a picture with an image overlay and saves it. So far I have figured out how to get the camera preview, take a picture, and do an image overlay on the … |
| | How to Fetch Data form Sites Like Flipkart,Amazone,Snapdeal And Compare Prices Of Products Form This Ecommerce Websites..? |
| | Hello !! I use vb.net with excel I have a buttom "get the name of the column from worksheet" with a combobox thi is the code of the button: Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click Dim Excols As New Dictionary(Of Integer, String) Form2.xlWorkSheet = … |
| | I am facing to dispaly multiple values in another text box this is my code $("#firsttearesult").val(diffHour,diffMins); Any body help me to display both |
 | private void btnSearch_Click(object sender, EventArgs e) { if (searchtext.Text == "") { MessageBox.Show("Plese Inter Employee's ID you are searching for"); searchtext.Focus(); } else { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Employees.mdb"); OleDbDataAdapter ad = new OleDbDataAdapter("select * from Employee where EmpID=@EmpID", con); ad.SelectCommand.Parameters.Add("@EmpID", OleDbType.Integer); ad.SelectCommand.Parameters["@EmpID"].Value = int.Parse(searchtext.Text); DataSet ds = new … |
| | I posted earlier today about converting my MySQL to MySQLi - Upon further research I came across the following, Prepared Statements. It seems that this may be a good way to go but I am a bit confused about how to implement it. I am simply taking User-entered data from … |
| | hello guys I have a data grid view with the following rows customerID, customerName, credit, debt. how do I implement filtering based on the customerID. I want to basically perform a search and display the results. thanks. |
| | Hi , I have no idea for this, I am displaying images from db dynamically, by clicking gallery link I dislay all the images, but I want to display by folder type for a set of images. Can anyone help for me? |
| | my code is as follows: class pottertr_Point{ private String name; private double x; private double y; public pottertr_Point(){ name="Org"; x=(0); y=(0); } public pottertr_Point getPoint(){ pottertr_Point p= new pottertr_Point(); p.name=this.name; p.x=this.x; p.y=this.y; return p ; } public void setPoint(pottertr_Point p){ this.name=p.name; this.x=p.x; this.y=p.y; } public void setName(String name){ this.name=name; } …  |
| | I need to be able to generate random graphs (both general and bipartite). I require that the generated graph have a specified number of vertices and edges (in the bipartite case the number of vertices on each side is specified). My particular problem is that I also require that the … |
| | hi there, for the last one week I am deliberately trying to solve my problem. **Pls help me** For your better understanding, Layout of my page is something like this : Part -A -------- [ Dropdown list ] [ TextBox ] [ Table -1 ] Part - B -------- [ … |
| | I want to create a form builder in php. But i dont know how to do this, So please help me. Thank you all |
 | I have recently been writing some code that asks the user questions about german. br = new BufferedReader(new FileReader("C:\\Users\\Patrick\\Desktop\\Java Workspace\\germanTool\\src\\germanTool\\lesson1.txt")); String[] engList = null; String[] deuList = null; int i = 0; while (br.readLine() != null){ lineCount++; line = br.readLine(); engList[i] = line.split("\t")[0]; deuList[i] = line.split("\t")[1]; } Using this code … |
The End.