2,569 Topics
 | |
| | Im having a problem with updating data in SQLite this is the full code who execute after pressing the button try { PrintWriter writer = new PrintWriter("d:\\"+LBL1.getText()+"\\"+TL3.getText()+"_"+TL2.getText()+"_"+TL4.getText()+"_"+TL5.getText()+"_"+TL1.getText()+".txt", "UTF-8"); writer.println("Invoice Number = "+TL1.getText()); writer.println("Seda = " +TL3.getText()); writer.println("Date = " +TL2.getText()); writer.println("Documental Class = " + TL4.getText()); writer.println("Status = " + …  |
 | Hi I have firewall.log file in my c:\ driver I wonder what destination IP adresses and 3 ports the scanner have attacked most in the attack. SELECT DISTINCT dst-ip FROM c:\firewall.log WHERE dst-port !!!! I apriciate your help  |
| | Hi, I have been getting this error when doing savechanges(). System.Data.SqlClient.SqlException: New transaction is not allowed because there are other threads running in the session. I read this issue in many places and most are fixed with a .ToList() .First() or similar methods (basically not changing the object while the … |
 | My web hosting plan does not include a database. Is there a way i can get around this? Like upload a .sql file or ms access db into my server and connect to it using php?  |
| | Hello, I am loking for a concept to geting started is there a way of creating a notification like on user end any one updates his post update or upload an image then on admin panel it notifies the admin like on menu bar it shows 1 and when the …  |
| | SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist.  |
 | hello to all. I have used jdk 7 and now i have started to use netbeans8.0.1 i want to know that how to connect ms acces and sql server database using netbeans. Please send me procedure and sample code to connect to these two databases. |
| | i need some help concerning the encryption and decryption i have a login table on my microsoft sql server 2012 but i want to do the encryption and decryption remember i have 5 departments and i want to direct each username and password to a specific department form that i …  |
| | Hi Everyone, I am a newbie to PHP programming. I just need to update the status when user click delete button. Here is the piece of code that I tried. When I echo the values of $mode and $id it prints properly. But the update query block doesn't working. <?php … |
| | Hi there, I have have a challenge with my application. I am developing it using VB.Net and SQL server 2014. My database contains 2k plus records. I used to search and return the results very fast when the database was still small. The problem now is that whenever i try … |
| | i have two combobox and i have two database table in sql server 1st table name is Province and 2nd table name is City if i select province in my 1st combobox then show all cities against selected province show in the 2nd combobox when we click on combobox dropdown … |
| | Hi, Good morning. In a table I show a list of names using while loop from 'name' table and textbox for each student to enter the marks. I showed two students , so two textbox fields will be displayed, and after entering marks in two textboxes, I wrote normal insert … |
| | Hi I tried connecting to my database but I am getting this message The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server … |
| | Moving my [Vivaldi](http://www.vivaldichoir.org/index.php) choir pages to use .php to include for common elements as per [Mayne Island Conservancy](http://www.conservancyonmayne.com) (see open question from 3 days ago) & have noticed some anomolies in IE 11. Any help would be appreciated on this and my open query on "Mobile Display" I intend to … |
| | hi i'm struggling to read data from database i created a table with 5 rows as for Login form username and password i would like to have access to forms when i enter password and username of department 1 it shows department 1 but when i enter password and username … |
| | Hi guys, i am creating a search function on my web. This is the result [CODE]"SELECT [ROUTE], [INST_KEY], [INST_TYPE], [ACCT_KEY], [STATUS], [DMZ], [CUST_NAME], [ADDRESS_LINE1], [ADDRESS_LINE3], [ADDRESS_LINE4], [ADDRESS_LINE5], [METER_KEY], [SIZE], [INSTALL_DATE], [X], [Y], [Z], [ADDRESS_LINE2], [MI_PRINX] FROM [DBCUSTOMER] WHERE ([CUST_NAME] LIKE '%' + @CUST_NAME + '%')"[/CODE] This function just looking one … |
| | Hi guys! I'm getting frustrated with my code because my filter in my query is not working. All of the item_model in my receiving_details table were being suggested in auto complete but as you can see in my query that I'm filtering item model with a certain form_no. Please help … |
 | Please help me with how i may receive an sms to my java application using ozeki. I have used sample code that i got from http://www.ozekisms.com/index.php?owpn=584 , I used that sample code and was able to send sms. Using the same code how may i receive an sms so that … |
| | try { frmCombination.Mode = "Add"; this.Clear_All_Controls(); this.Enable_All_Controls(); if (!(this.Form_Name == "Secured Life")) ; this.btnGenerate.Enabled = true; this.btnChange.Enabled = true; this.mskReportDate.Text = Convert.ToString(DateTime.Now); ****** if (this.Form_Name == "Secured Life") this.txtQuotation.Text = Common_Functionality.GenerateId("ProdMix_Quot_No", "Secured_Life_Quotation", "").ToString(); else this.txtQuotation.Text = Common_Functionality.GenerateId("ProdMix_Quot_No", frmCombination.tblAnnorSet, "").ToString(); this.SetupDataGridView(); this.SqlQry = "select Tax_Sec_80CCC_Limit,Tax_Sec_80D_Limit,Tax_rate_Limit from Global_Parameters"; Connection connection = new … |
 | Dear Folks ! I´m having problems with my navigation at different screensizes. At current level the navigation display is nearly the way i want it for the bigger screensizes. But at media querry @media screen and (max-width: 320px) I want the navigationlinks to stack horizontally which i managed to do … |
| | This is more a general approach question. I have an old ORM like framework for this application. Basically what it does, if it needs to load a bunch of objects/records, is for every child object in my result a new query is triggered to get it's data. Since the nesting … |
| | The 'perf stat' output for a certain executable is shown below. 2,207,929,785,602 cpu-cycles # 1.098 GHz [58.33%] 955,083,725,303 instructions # 0.43 insns per cycle [58.33%] 412,816,464,977 cache-references # 205.308 M/sec [58.33%] 38,645,898,456 cache-misses # 9.362 % of all cache refs [58.33%] 4,692,761,524 branch-misses # 2.334 M/sec [58.33%] 0 ref-cycles # …  |
| | Hi all! I have developed my application in VB.NET that uses a mysql database. From my application, I can make mysql backups and restore them. When i take a backup, the result is a .sql file which is saved somewhere. But as usual, one can open that sql file with …  |
| | how can I select project from dropdown then execute query catching the value of the project selected I have the follow code using AJAX and JSP pages admin.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; … |
| | Hi All, I am new in PHP and MySQL. As of now i am building a web application , where i have to get the list of all those clients whose date of joining - current date equals to 30. I have a table in database where there is a … |
| | I have a form that need user verifaction from ldap before being submitted. I have an ajax code for the same, to get the value of the field onchange and query ldap so that it returns the name and email id. My code is as below : <input type="text" name="Admin_name" … |
| | Hi. Below is the code which parse data from mysql into json, but for the name column i want to have <a href="http://example.com">column name</a> instead of jst the column 'name'. is it possible in any ways. <?php $link = mysql_pconnect("localhost", "user", "pass") or die("Could not connect"); mysql_select_db("userdb") or die("Could not … |
| | I am having a huge problem. In my stylesheet I have: @media only screen and (min-width: 320px) and (max-width: 700px) { code1 } @media only screen and (min-width: 1280px) and (max-width: 1400px) { code2 } my browser window is currently 640x960, so only code1 should run... right? But code1 and … |
| | Hello, I am trying to create a little bit tricky part I thought I would be sucessfull but it didn't happend. Okay so I created a form having multiple field with the same name like users adds package details so it depends on him how much he would be able …  |
| | I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never the same. I need to update a field called last_time that corresponds to the previous date that they occur and …  |
| | Hi, I'm running a C++ program (HPCG benchmark) on an ARM processor based board (Juno) with 64-bit Fedora 21 OS. When I run perf top in another terminal to find which functions are taking more CPU time, I get an output like below. 75.84 xhpcg [.] ComputeSYMGS_ref 22.27% xhpcg [.] … |
| | I have SSRS column chart in which data of percentage complete for half day and full day is shown . The 4 legend series are half day complete,half day incomplete,full day complete and full day incomplete.Months are shown in x axis and percentage in interval of 10 on y axis … |
| | Hello, I have created many section like update delete etc on the webpage i stored a message in the session variable so when users updates deletes etc on the page a message comes up logo updated sucessfully message posted successfully etc etc so that message is stored in session variaable … |
| | PHP is an object-oriented language, based (loosly) upon C++. It has classes, methods, member variables, and all that other good stuff. It runs on your web server, not in the client, but the HTML, JavaScript, and other stuff such as CSS blocks that it emits with its output commands are … |
| | My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db procedure to create databases on the new server from the data and log files. That recovery procedure worked, at … |
 | hi i used multer to create an upload script now i would like to display the photos uploaded by eacch user on diff pages with diff adrees i.e exprome.come/photos/234 and also every photo would have its comment. any ideas? i think every comment should be saved with the photo id … |
 | Hello Is it possible to use SQL queries in a JS file? Example I have the following code, and would like for each input[type='text'] encountered, to save its value to a sql table in a column: jQuery("input[type='text']").blur(function(){ var id = jQuery(this).attr('id'); var inputVal = jQuery(this).val(); }); |
| | My problem Im almost certian is a permissions issue but im still very new to this so bare with me. I have a server running the latest mysql with mysql workbench installed and im tryign to modify the users and privilieges for either my one table or all my tables, … |
 | Hi im attempting to copy a php code and get it to work with a script im trying to create and i have come across the error below can anyone tell me whats going off any help would be much appreicated x You have an error in your SQL syntax; … |
| | -1 down vote favorite Here I'm facing problem with course registration. I have 3 tables named as dept(dept_id,dept_name) where dept_id is a primary key 2nd table is semester (semester_id, semester_name,dept_id) semester_id is a primary key and dept_id is a foreign key .3rd table is courses(c_id,dept_id,sem_id,c_name) where c_id is primary key … |
| | Hello Everyone, it seems that I cannot see the wood for the trees.... :-) I am having problems with this line of code... StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & … |
| | Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"USERNAME@email.com"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you. |
| | How to fix the following SQL error? 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Sent`, `handler` varchar(20) NOT NULL, PRIMARY KEY (`id`) )' at line 5 Code: $create_q = 'CREATE TABLE IF …  |
 | Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance … |
| | dear members, i need help, i have one datagrid and two dataset with two diff. tables, what i want is to insert data into datagrid and save grid data to other tabel in sql server. |
| | Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. CREATE TABLE mysample … |
| | hi i picked this script up from a site and im trying to install it in my system and i came across the error below You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near … |
| | Hi, I'm using PHP, I am trying to develop: 1. a login page in HTML, once user enter the correct username and password, this will be directed to the User page. 2. In User page, there will be some text fields of the user (eg. name and address), all these … |
| | hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim … |
| | The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE I am having above error on sql 2008 R2 , i have identified the table which … |
The End.