2,569 Topics
 | |
 | Hi Guys, At my work I been provided a QAAWS that will provide me with certain. For privacy reason I cannot give you the actual QAAWS but it is simila to [this one](https://liveoffice.etosoftware.com/dswsbobje/qaawsservices/biws?WSDL=1&cuid=Afg7hriNfChBslO9TDgBqLc). I know how to create a web service and pulled the data using my own SQl queries …  |
| | I wasn’t sure which forum to put this under so I just selected web development. I have run into an issue that ironically I have solved before but thanks to my wonderful drop-box the changes I made were not saved and when I changed them again on another computer, the … |
| | Hi . I am writing sp that i will use for generating SSRS reports . In the sp , i hv passed month name as input parameter. I am able to get the required output but need to filter it based on months .i.e entries present for current month upto … |
| | I’ve been looking and researching ASP.NET hosting provider for the past few weeks. Please kindly help me to choose the best hosting provider for me. I will be more details about my requirement below. I’m leaning towards Microsoft Azure Web but a bit concerned about the price. I will talk … |
| | I want to add data to sql databse using vb.net form And I am new to programming :( I get an error message saying "Incorrect syntax near "deatails") Can somebody tell me the reason the following is the code I'm using Imports System.Data Imports System.Data.SqlClient Public Class Customer_Profile Dim con … |
| | I want to ask how to pass the '30','31','32' to SQL WHERE IN clause For example EXEC SQL DECLARE abcd CURSOR FOR SELECT Consignment FROM Transaction WHERE order_type IN (:dest) where dest will hold the value '30','31','32'. I have tried as above example but it is not working SQL did … |
 | I am a 19 year old guy who is yet to get a CS degree from the university. I learned web development on my own from resources online. Mostly from youtube videos precisely from thenewboston and phpacademy and a few text-based tutorials from w3schools.com. I am good with HTML, HTML5, … |
| | [Click Here](http://dev.appcotech.com/pwrdup/static/become-postie.php)[1] UnderConstruction please go to upper link and click on SIGNUP TO DRIVE (Blue cruve Button) there will be a tab open type `london` (Not From Drop Down) only just type `london` and hit enter page will redirect to dev.appcotech.com/pwrdup/static/become-postie-vehicle.php page (This mean post keyword matched 100% with database) …  |
| | Hi there , How to write multiple update_batch query in codeigniter? My script is not working ... Please give some solutions for multiple update row using update_batch... getting below Error: A Database Error Occurred You must use the "set" method to update an entry. Filename: D:\xampp\htdocs\DEAL\system\database\DB_active_rec.php Line Number: 1273 mycontroller … |
| | I am a 19 year old guy who is yet to get a CS degree from the university. I learned web development on my own from resources online. Mostly from youtube videos precisely from thenewboston and phpacademy and a few text-based tutorials from w3schools.com. I am good with HTML, HTML5, … |
| | I am getting an error message with my dapper code below. Any ideas? Thanks! Error 5 Cannot implicitly convert type 'Data.EmailAddresses' to 'System.Collections.Generic.List<Data.EmailAddresses> **1. Data coming from sql query** StudentId Gender EmailAddress 123456 Female maryjoe@gmail.com 123456 Female mary.joe@mycollege.edu 123456 Female mj@hotmail.com **2. Classes** public class Student { public string StudentId … |
| | I'm referring to this tutorial: http://www.techfounder.net/2009/02/02/selecting-closest-values-in-mysql/ My query and code to execute search (This doesn't return any result).I need to get 100 closets value to the postcode given by user which is collected by $postcode = $data['postcode']; ERROR shown are: 1) Fatal error: in C:\wamp\www\search\ajax2.php on line 79 2) PDOException: … |
 | Hi, I have a query ... I have changed php max_execution_time in **php.ini** to say 600 seconds. It worked on Windows platform. However the same code doesn't work in Linux redhat5. I even tried **ini_set('max_execution_time', 600);** in a php file but it still executes its default time that is **10 … |
| | I need help parsing json data to a specific format so I can put it on a line chart. More specifically a line graph using [highcharts](http://www.highcharts.com/demo/line-basic) This data comes from a query $data['graph']=$this->mymodal->graphmodal($id); foreach ($data['graph'] as $row) { //modify array.. } echo json_encode($data['graph']); The result this produces is the following … |
| | Morning guys hope that you are all well. need to pick your brains because I'm ready to bang my head against a brick wall. I'm building a multipolchoice quiz I want to just show 20 random questions from the 80 questions that I have in the question bank, in my … |
 | 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 … |
| | **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 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 … |
| | 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 …  |
 | 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 = … |
| | 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 …  |
The End.