6,934 Topics
 | |
 | Me again... So now I am confused... I have a form: <form action="addanimal_submit.php" method="post" enctype="multipart/form-data" style="padding-left:10px"> <p>Name: <input type="text" name="name"></p> <p>Date of Birth: <input type="text" name="dateofbirth"></p> <p>Description: <input type="text" name="description"></p> <p>Available For Adoption? <select type="text" name="available"> <option value="1" selected>Yes</option> <option value="0">No</option> </select> </p> <p>Image Of Animal:</p> <p><input type="file" name="fileToUpload"></p> <input … |
| | I am trying to sum a field in my MS Access database that I long ago stored as a string. I was using dbCommand.CommandText = "SELECT SUM(SubTotal) FROM Glasses WHERE OrderDate >= #" & SearchDateStart & "# AND OrderDate <= #" & SearchDateEnd & "#" and this would work for …  |
| | **Student and Courses Record Management System (LinkList of LinkList)** In this Assignment you need to create a small student and courses record management system with following functionalities. 1- Add New Student This function will allow you to add a new student record,you can use any three attributes of your choice … |
 | i have done a project is a web browser uses a sql server 2008 as a back end so i want make setup file for that project to work in a computer that has'nt sql server , in onother word i want bind my database with the project and make … |
| | Hello, I am right now having a dedicated server and when i try to execute a INSERT query in table of 2 Lakh rows it takes about 0.02 seconds. so i am having a website where i need to update all 2 Lakh rows every 15 mins. but it sims …  |
| | Hi, In a form, I have 4 select boxes(default), and two text boxes(default). If I click the first (static values) based on that next second(new) select box will come (it has been done by ajax), based on the new select box, I display checkboxes based on the select box values, …  |
 | Hello everyone. I am modeling a simple dictionary application using the presentation-business logic-data layer pattern. I already have the design but am not sure it is correct: My presentatioon layer is a simple GUI where users insert their queries. They have a form for entering new words and their definitiom …  |
| | I have 1 gridview with big table...colums:k,mi,ib and 3 textbox...texbox1 is first column,textbox2 is second and textbox3 is third! I want when i type some number in textbox1(That number is K),i want to textbox2 and textbox3 give me value of mi and ib in same row as k...but i got … |
| | Hello Experts, I hate PHP when these things comes in front of me every time when i create and insert query I stuck up by viewing everything is ok but not working don't know why. please help me out previewuser.php <?php include_once('includes/header.php'); include_once('includes/session.php'); include_once('includes/functions.php'); include_once('includes/connection.php'); if(isset($_POST["submit"])) { echo add_user(); } … |
| | Hi, I have two computers (Desktop and laptop), The desktop is my office computer and I have been using it for my application development(Visual basic). I have Visual studio 2013 and SQL Server 2014 installed on both computers. I exported the database from my desktop computer to the laptop and … |
| | Hi. Im having some problems to understand how to make search in SQL database actually I use this code DV.RowFilter = String.Format("name Like '%{0}%'", TextBox1.Text) DataGridView1.DataSource = DV and it work, but Im trying to show in a datagrid view results from the table but searched by 2 or more …  |
| | hi everyone. I have this code to retrieve image from sql server using asp.net with vb, the problem is the image cannot display in the web page and I don't know what is the problem can you please help me.` Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits … |
| | I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))] table1 …  |
| | I cant seem to understand the issue with this statement, admittedly i have not written this code myself but have found it and modified it to work with what im doing, as most open source code is. This is for a secure login script that will pull a salted password … |
| | Hello, I hope that I can get an answer for this question. I have a MYSQL table for charges which contains the following fields: ChargesID, ChargesTitle, OfficialFees and ProfessionalFees. What I need is to make a dropdown list which contain ChargesTitle and upon selection to autofill the OfficialFees and ProfessionalFees. … |
 | Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to … |
| | hi, I am creating a form for user to update their details which is saved in the database. So far i can show their details in the form where i have a submit button but the updating part doesnt work(it doesnt update at all). here is the code: [CODE] <html> … |
| | Here's my scenario: I have been trying to re-establish mirroring on my SQL Server 2008 R2 instance since a VMWare outage took it down a few months ago. Here are the servers I'm using: Primary- prodDB.mydomain.com, on DataCenter1 Mirror- recoveryDB.mydomain.com, on DataCenter2 Witness- testDB.mydomain.com, on DataCenter2 DataCenter1 and DataCenter2 are … |
| | I called one sql table "CarDetails" in more than two jsp's and i want to when from 1.jsp are updated "CarDetails" table then at that time update kendo grid from 2.jsp. thank you.  |
| | Hi , i need some help in completing a small task . " How to insert,update,delete record in data grid view using inline i.e (suppose if we update a record in the data grid then after click on the next row the data which is updated should be save directly …  |
| | Iam doing a website in wordpress and i want to send registration data of frontend users to my database. Please assit. |
 | Hi! I'm using Microsoft Visual Studio 2008, Microsoft SQL Server Management Studio. I need help. I cant figure out this if else statement for this condition: ///to check condition either the way ID exist in database ///if not exist then way ID can be delete ///if exist, message box appear … |
| | Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, … |
| | Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter … |
| | I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the … |
| | Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks … |
| | hi everyone. I want to retrieve image from sql server database using asp.net with vb, but the image is not display and I don't know what is wrong with my code. please help me. Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Public Class _Default Inherits System.Web.UI.Page Public sqlcon As SqlConnection = … |
| | I'm sure there is a really simple solution for this matter, but I have tried all I know without success. I'm trying to modify this working SQL string to yield only the Top 25 results, not all results. "SELECT * FROM" & "data.CSV" & "ORDER BY " & "Elapsed" & … |
| | public partial class Form4 : Form { private OleDbConnection connect = new OleDbConnection(); public Form4() { InitializeComponent(); connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Bino Unity\Desktop\user1.accdb;Persist Security Info=False;"; } private void Form4_Load(object sender, EventArgs e) { } private void login_button_Click(object sender, EventArgs e) { connect.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connect; command.CommandText …  |
 | hello everybody...nice to back again i m working on project to calculate measures and numbers and insert data inside datagridview(dgv) from number.text and measure.text but if value of measure.text present in dgv son update number cell with new value + present value problem is how to do so.... i tried … |
 | Can SQL 2005 Run on Windows Server 2012? |
| | |
| | Hello ALl, I have found this project online which I would like to do. The link for the project is http://1000projects.org/network-intrusion-detection-system.html#comment-249119. If I am correct, this application if built properly is meant to look at all the packets and store them into SQL server?. I have got many problems before …  |
 | Hey, i dont know how this is called but i have ideas and if it possilbe that someone can help Help me about this: i have file index.php and 2 folders called: blue, red. in these 2 folders therse a pages that content the same backgroundcolor as the foloders name. … |
| | hello i'm beginner at programming and i want to connec to my database with PHP PDO with SQL SERVER 2008 R2 the problem at the begining it appears to me an error with this message "could not find driver" after a little searching about this i found how to download … |
| | Hello, I am trying to update my record but nothing is happening please help me out update.php <?php require_once("connection.php"); if(isset($_POST["update"])) { $uid = $_POST["uid"]; $user_name = $_POST["uname"]; $f_name = $_POST["fname"]; $l_name = $_POST["lname"]; $company = $_POST["company"]; $address = $_POST["address"]; $phone = $_POST["phone"]; $fax = $_POST["fax"]; $mobile = $_POST["mobile"]; $email = … |
 | Dear all, I have two identical mysql server with same databases and tables structures but with different data. ServerA ServerB Database Shaqib Database Shaqib Table users Table users ID | Name | Phone ID | Name | Phone 1 |Test1 | 123456 1 |Test13 | 1256456 2 |Test2 | 785632 … |
 | Hi, I am working on a wbsite for a training centre. I am querying a web service for the list of their courses. There are three parametres in the query: centre, coursetype and courselocation. When querying it directly or using SoapUI it can be queried using 1, 2, 3 or … |
| | Hi, I have been working on a application that used sqlserver 2008 R2. we had used filestream that was there in 2008 r2. there was a decision to move from 2008 R2 to 2012 express. Now i understand that file table is a new addition to 2012 and will do … |
| | Someone can help me to find my error: $query=mysqli_query($con," SELECT * FROM item WHERE ITEM = $ITEM ") or die ( mysqli_error($con)); i reciveing this error,i dont know wherer is syntax error. *You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …  |
| | How to edit and save image to sql server and retrieve back in html.  |
 | # Performing Selective Includes in Entity Framework with the Fluent API # When we are using Entity Framework as our data access choice to work with SQL Server then there are some potential pitfalls. One of these pitfalls is doing selective includes. What do I mean by selective includes? To … |
| | I'm trying to query from two tables but whenever i run my php script i get this error, any help would be highly appreciated Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | Can any one help me to load SQL server dlls in PHP.ini |
| | Hi . I want to know how pass the data from the datagrid to textbox through query string with only the ID of the selected row being passed as query i.e when I select a particular row all the attributes of that row should be displayed on the textboxes of …  |
 | Ok, here is what I get when I run the query. 1064 - 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 newmessage`int(4) unsigned NOT NULL DEFAULT `0`,`companyi' at line 4 Here is what … |
| | Hello everyone, Dim SI As String = "" SI = CheckedListBox1.SelectedItem Dim TextcommandSQL As String = "" Dim myCOLUMN As String = "" myCOLUMN = ComboBox1.SelectedItem TextcommandSQL = "SELECT * FROM test_table where " & myCOLUMN & " = " & SI MsgBox(TextcommandSQL) Dim con As New SqlConnection con.ConnectionString = … |
| | Hi , i hv created 2 tables : a Department table with fields Deptname , Deptid and Employee table with Empid , Empname, Salary . I have created a datagrid with fields empname , address , Salary , Deptname and edit and delete command columns . By clicking on edit …  |
| | id name class marks 1 H 1 60 2 H 2 50 3 S 1 70 4 S 2 60 5 V 1 55 6 V 2 80 7 K 1 60 8 K 2 70 This is my table structure. I want mysql query to get result like id …  |
| | Hello I am creating a little application, using VB.net, and Access database. I want to count the number of records whitch have more than 6 hours difference between records. Is it possible to have a query to count the number of recordset where the "Time End" and "Time Start" of … |
The End.