6,934 Topics
 | |
 | we should create a program that could run through two computers and the computers should be able to access 1 database for record sharing. how can we make that? we already made the system. the problem is, how can we implement this in a networked way? thanks in advance. :)  |
| | What's the simplest way to read an excel file, get cell 'A1' in table(1,2,3), B3 to table(1,2,3), B6 to Table... import specific cell to table.  |
 | protected int getRowCount() { int RowCount = 0; SqlConnection conRowCount = new SqlConnection(ConfigurationManager.ConnectionStrings["connMSJ"].ConnectionString); SqlCommand cmdRowCount = new SqlCommand("SELECT Category FROM MonthlyBudget WHERE (Username=@username AND CurrentMonth=@current) GROUP BY Category", conRowCount); cmdRowCount.Parameters.AddWithValue("@username", Master.getUsername); for (int i = 0; i < intMonth.Length; i++) { cmdRowCount.Parameters.AddWithValue("@current", Convert.ToDateTime("1/" + intMonth[i] + "/" + ddlYear.SelectedItem.Text)); conRowCount.Open(); … |
| | SELECT * FROM myTable WHERE columnId < 45; while (rs.next(){ result of row1 goes to row1.txt; result of row2 goes to row2.txt; result of row3 goes to row3.txt; result of row4 goes to row4.txt; } |
| | |
 | I have a database with some entry. In my web application I log in with a page and show the corrosponding entries for that user on another page. I am using Jinja werkzueg for my light weight example. And using SQL alchemy. Here is my code for showing the password … |
| | Hi Guys I am creating a site and i want users to be able to upload videos to a folder on a server, using SQL to store the path of the video and the name. I have created this Code. And it does upload all the details, but does not … |
 | So I have a table I am trying to create, but as I am working on this, I am worried that the idea is flawed. Here's the SQL code to create the table so far: CREATE TABLE #ConversionLog ( EventTime DATETIME NULL, EventType NVARCHAR(20) NULL, RecordID INT NULL, EventTarget NVARCHAR(255) … |
 | ## Hey Guys ## , I've recently stopped doing some of the projects which I wanted to do and took a look at SQL and came across Microsoft SQL and i was pretty pleased with wha tit can do so i downloaded the program and watched some basic MSSQL tutorials …  |
| | hey all Im using SQL Developers version 1.1.3 and I want to totally remove it I sareched alot about an offical way to remove it but I found veryone remove its folder so I go though it but now when I want to install the software agian... I am getting … |
| | Dear Sirs, I would like to ask you, if you know any solution, for querying a servers mysql database without phpmyadmin rights, for example, querying it from the website itself with a server side solution. To be a bit more specific, here is what I would like to query on … |
| | how to insert data into datagridview from sql table using recordset in vb6.0  |
| | i have four tables (1) tbl_module: modNo | modName _ _ _ _ _ _ _ _ 1 | module 1 2 | module 2 (2) tbl_subject subNo | subName | modNo _ _ _ _ _ _ _ _ _ _ _ _ 1 | a1 | 1 2 …  |
| | Example 1 below works: echo "<p><h2>".$results['title']."</h2>".$results['shortdesc']."</p>"; I need to make the title linkable to the page url. I'm probably putting the ' and " in the wrong places for the link part. Example 2 - I've added the url code but does not work: echo "<p><h2><a href=http://www.example.com/".$results['url'].".$results['title']."</a>"</h2>".$results['shortdesc']."</p>"; Any help would … |
| | THIS CODE IS WORKING,, BUT WHEN THE SECOND TIME LOGGING IN IT DOUBLE CHECKED LIKE 2 FORMS OPEN and 4 MESSAGE BOX APPEAR Private Sub btnSign_Click(sender As Object, e As EventArgs) Handles btnSign.Click Dim connectionString As String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Renz\Documents\Visual Studio 2012\FINAL\Database\AuditDB.mdb" sql = "Select ID, LASTNAME, FIRSTNAME, LOGINSTATUS … |
 | Hi, I am using php to update data and i need to see which field query is already updated **while the *while loop* is still running** in case the process stops or in case i need to end/ stop process. Right now it shows the list of documents (doc_code) updated, … |
| | How can I change this so that my returned results will display as 2 tables instead of one? Its returning results from 2 different tables but its not displaying as 2 different tables As I want it to. Thanks for any help or tips you can provide <?php mysql_connect ("localhost", … |
| | I would like to have my users type in a term and display results from two different tables. I tried using union but i'm getting errors can you help please? <?php mysql_connect ("localhost", "","") or die (mysql_error()); mysql_select_db (""); if(isset($_POST['submit']) && !empty($_POST['submit'])){ $result = ""; //USED LATER /*$term = $_POST['term']; … |
 | I have an array ($arr) of arrays ($ar) in which I want to describe the columns in a report. The salient elements include the column headings and the MYSQL field to use: Array ( "City", 12, 29,"Y", "City_date", "City_Total" ), Array ( "Atmos", 8, 23, "Y", "Atmos_date", "Atmos_Total" ), etc. … |
| | Greetings! I'm building a PHP table from data I'm pulling from a MySQL database. I'm querying data from two tables where the common field between them is a customer ID. Table A contains customer ID and a customer score. Table B contains customer ID and a mailing code. The easy … |
| | Please help me to Checking for Duplicate Record of SQL Database before Inserting & Updating this my code please may anyone check my code If class1.sqlcon.state = connectionstate.open then class1.sqlcon.close() End If class1.sqlcon.open() dim cmd as new sqlcommand dim Qresault as integer cmd = new sqlcommand (" SELECT COUNT (*) …  |
| | How to use a loop and an update query to update all the records of a column? |
| | OKay so this my have been asked before but I have more of a general question than an issue. I don't understand Mysql_num_rows() becuase I don't have any information within my database table so the number or rows should be 0 but what happens is I get an error and … |
 | Hi, i am new in asp.net and i found it quiet difficult... i was programming in classic asp and sql server, but asp.net looks quiet different, specially if i do program in C# .... Than i hase a couple of questions : 1) if i do a form with 2 … |
 | 1.code -------------------------------------------------------------------------------------------------------------------- static void Main(string[] args) { SqlConnection sc = new SqlConnection("Data Source=pc3490ierf43;Initial Catalog=Persons;Integrated Security=True"); sc.Open(); SqlCommand command=new SqlCommand("Select Name from Persontable",sc); SqlDataReader reader= command.ExecuteReader(); while (reader.Read()) { Console.WriteLine("{0}", reader.GetString(0)); } Console.ReadLine(); } --------------------------------------------------------------------------------------------------------------------- ** 2.code** static void Main(string[] args) { using (SqlConnection sc = new SqlConnection("Data Source=pc3490ierf43;Initial Catalog=Persons;Integrated Security=True")) …  |
| | Could any one plz tell me what's wrong with my code My sql select while loop is not checking date range that's been inserted into the form. <?php if(isset($_POST['start'])&& ($_POST['end'])){ $user_id = $_SESSION['user_id']; $leave_type= $_POST['leave_type']; $comments= $_POST['comments']; $start=date('Y-m-d',strtotime($_POST['start'])); $end=date('Y-m-d',strtotime($_POST['end'])); echo $start,'',$end; **$checkdate = "SELECT * FROM emp_status WHERE user_id='$_SESSION[user_id]' AND … |
| | hello, i am coding for my project, i want to read data from excel file to to a table in sql server 2008 R2. It work ok in window 7 32 bit but not working window 7 64 bit. Please help me. My sostware in this link: http://www.biframework.com.vn/page/products/id/9/phan-mem-quan-ly-doanh-nghiep.html |
 | hi Iam using sql server 2008 r2 with database that saving Arabic and English with it, when i use this sql statement SELECT * FROM Land_Files WHERE Briefness LIKE '%Qusin%' it gives me aresult but when i use the same sql Statment with small difference : SELECT * FROM Land_Files … |
| | Hi there, Once i am on my second page where i have open the record from the database with my id record, how can i populate my textboxes with the values of my record? And ho can i populate a select with another table containig the type of user by … |
 | I have a database and I have 3 different values that I want to count, to say that You have x amount of tickets open. I am created an array $array = array( 'Pending', 'Waiting on parts', 'Waiting for customer response' ); and a query string $result = mysql_query("SELECT COUNT(*) … |
| | Good morning strangers! I haven't posted in a while, but you always seem to be helpful... I have an application that uses SQL as a back-end to store data so that multiple users can access it at once. The question I have is, the requirements have changed and the SQL … |
| | Hi guys first off excuse me if this seems noobish but i usally work in php and MySQL with some c++ a friend asked me if i could make a database application that wasn't web based for them so after doing some research i found this http://www.youtube.com/watch?v=3w2JkLcp-UA which works like … |
| | i'm inserted a image in sql server2008 as varchar(max).How to retrive in Data Grid view photo column ..i need code ...i tried many ways still getting Confused.  |
| | Hi there, i am new with asp.net and i would like to start with it!!! I was wondering if anyone could suggest me any good and easy to understand tutorial where i can learn how to make a list from sql and edit the record in a new page (add, … |
 | Here's I wrote some code to insert\retrieve images from SQL Server database 1- Create table to hold Image ID, Name and itself [CODE=SQL] USE [ImagesDatabase] GO /****** Object: Table [dbo].[Image] Script Date: 07/10/2009 23:46:46 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Image]( … |
| | In the sql database definition i am able to set my primary key to int data type and auto increment that number (identity specification), thus the result will be in `1, 2, 3,....` but how can i add some string into it? example `C0001, C0002, C0003, etc` ?  |
| | Hello, I am dealing with SQL server 2005 and i have data from a system where i am tracking an application at each stage in the system. i have data in a tabular form as follows and the dates are derived from an sql statement. how best can i write … |
| | Hello. I've created 2 pages that i'm currently working on. One is called; Test.php -- which just includes a basic form in HTML. <Form name ="form1" Method ="POST" Action ="result.php"> Building Name: <INPUT TYPE = "TEXT" Name ="buildingName"> Room Number: <INPUT TYPE = "TEXT" Name ="roomId"> <INPUT TYPE = "Submit" … |
| | Good day!. I have here a form in vb.net. It contain a groupbox named question and it has a 5 radio buttons. My problem is if i choose my answer in a radio buttons, how it can show the answer in my sql database? please help me. :(  |
| | Assume i have a table `field1, field2, field3` and i have radio button list that displaying `field1, field2, field3` If the end-user selected `field2` and inserting a value into `field2` How can i do? Any Tricks? Thanks for in advance.  |
 | I am getting following error when trying to click the next or previous button on following site: http://bdworld.co/newest.php?categoryId=35 > Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/69/9332569/html/imagewar/newest.php on line 30 Newest Pictures! ( Others ) SQL query failed. Check your query. Error Returned: You have an …  |
 | Hi Guys, Completely new to PHP! Just wanted to play around with Fields and submit stuff to a database on localhost through xampp. This code writes to the database no problem, except no insert is happening with 'Telephone' and it throws this error; Notice: Undefined index: Telephone in C:\xampp\htdocs\Inputs\update.php on … |
 | Dear Sirs, I would like to update some information in my MySQL through a PHP syntax, but it won't work. I'll show you my code. while($info = mysql_fetch_array( $data )) { if ($info['author'] === $user_data['username']) { print '<div class="registerleft"> <form action="" method="post"> <ul> <h2>A tulaj</h2> <li> Vezeteknev<br> <input type="text" name="first_name" … |
| | i have two tables (they are fixed, not going to update any more) in my databae "phoneadd" phone_nos----name(primary id),home,office,college,friend. Examble: john 87954 45698 78965 12365 martin 45698 78962 45789 45789 trull 47896 14587 85632 14563 addresses----name(primary id),address Examble home first street,new town office second street,old town college thrid street,maxi world … |
 | i need to modify this query $fields = array("lo.name", "lo.id", "lo.status", "lo.sales_status", "pt.name ptname", "lo.city", "st.name state", "co.name country", "lo.zip", "lo.phone", "lo.email"); $result = $select->selectQuery($fields, "locations lo","LEFT JOIN states st ON st.id = lo.state LEFT JOIN countries co ON co.id = lo.country LEFT JOIN location_types pt ON pt.id = lo.primary_type"); … |
 | i have EDIT option infront of every row in a table. i want to fill above form with the values for editing. i am using sql and classic asp. |
| | sample asp.net with c# sql database connection  |
| | Hi All, I am pulling out info from my db and need to tjeck if a column is 0, if it is then i need to SUM 3 other columns and pull out that total. I want to use the CASE keyword and tjeck for this, but am doing something … |
| | |
 | hi there, I have a hidden field in my page which i need to transfer to another page as request query string/paraameter. It works perfectly in IE and in chrome. When i try in Mozilla the value of the req string is always undefined. Can any one help me out. … |
The End.