1,694 Topics
| |
My project scope is on android forensic. 1. After extracting all the information from an android phone, the information is saved to an excel file. Currently, I'm trying to transfer all the data saved in the excel file to MySQL database in Java. 2. After which, implement a feature that … | |
I have the following PHP: [CODE]<?php define('DB_NAME', 'database'); define('DB_USER', 'root'); define('DB_PASSWORD', 'password'); define('DB_HOST', 'localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!link){ die('Could not connect to database'); } $db_selected = mysql_select_db(DB_NAME, $link); if (!$db_selected) { die('Could not connect to the database'); } $value = htmlspecialchars($_POST['Name']); $value2 = htmlspecialchars($_POST['Email']); $value3 = htmlspecialchars($_POST['Subject']); … | |
I am currently using MySQL so people can send my a message that shall be stored in the database. The only issue is I have no idea how to protect against SQL Injection, below is my HTML: [CODE]<form action="Action.php" method="POST" /> <p>Name: <input type="text" name="Name" /> </p> <p>Comment: <input type="text" … | |
Hopefully I don't have to put all my code in. I have 3 separate pages of php set up. I want a user to be able to go to my website and search a bunch of criteria to find a good school for himself. There are checkboxes, radio buttons, text … | |
Hi Everyone, I'm doing a stock Control System as a school Project using An Access 2007 DB and Visual Studio 2010. I'm trying to do an update Query based on two variables entered into comboboxes, I cannot get the VB to accept the conditions for this, Can anyone Help me? … | |
Hi Everyone, I am currently Building a Stock Control System for a School Project and Using access 2007 with Visual Studio 2010 to build the VB. I am trying to use an INSERT INTO SQL Command to insert new stock items into my Access DB. I am getting an error … | |
I am having a table named "Society" And 5 master tables "BlockA","BlockB","BlockC","BlockD","BlockE". The "Society" table contains the foreign key columns of all the 5 master tables. Now when i write the select query it takes a lot of time to execute, as 5 tables are referencing one table and joining … | |
So I've looked for an answer to this question on the web but couldn't find anything that covers this specifically. Our database stores the project version in the format #.#.# (Rev_#) so there is both text and numbers in the string. I have no control over the data so I … | |
I've successfully developed a software using VB.Net and SQL server 2005. i have this problem. when i create exe, it can use to my computer because of SQL server is already installed in my computer. but if i want to use that software in some other computer, must i install … | |
Good Morning, I need some example with SQL plus code on various SET operation. But the query have to be with SELECT keyword. For example I am giving a code: [CODE]Create table student (s_id number(4), sname varchar2(10),constraint pk_sid primary key (s_id),blood_gp varchar2(4)); create table location(l_id number(4),location varchar2(20),constraint pk_lid primary key(l_id)); … | |
Embarrassed to say how many hours I've burned on this--am hoping someone can point me down the right path. This is more a conceptual question than a straight coding one. Building a web app to enable people to reserve stuff where I work. One of the pages uses a [URL="http://jqueryui.com/demos/datepicker/#date-range"]date … | |
Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was … | |
Hi Guys, I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns. For Example: In the Phone No column the numbers can appear as follows 07712345678 077 1234 … | |
I am writing an application which calculates profit from 3 column values. The SQL is as follows in vb dataset designer; [CODE]SELECT ID, Sale - (Weight * 20) * (Rate -5) AS Profit From AgencyRegister WHERE (DatePart('yyyy', ArrivalDate) = ?) ORDER BY ArrivalDate[/CODE] I want to add another column of … | |
Hi, I seem to be getting the error "Syntax error in UPDATE statement." when attempting to update my database through visual studio 2008, using forms. Here is the code for the connection: [CODE]Private Sub btnLoadDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadDB.Click Provider = "PROVIDER=MICROSOFT.ACE.OLEDB.12.0;" Source = "Data … | |
I have a form where a user can search for properties from a database. Everything is working except for the suburb search. I would like the user to be able to search for more then one suburb. At the moment I have the information from the textbox being separated into … | |
I have this error 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 and I don't know how does this happen because whenever I check the SQL that I have made including the inserted … | |
I’m having some trouble and can’t seem to find the solution. Hopefully someone here can help me out. I have two tables in a SQL Database and I’m trying to select some information from both tables where the column‘UniqueID’ has the same value. Here is the information I require from … | |
I have an issue with some new code that I am trying to thread, I am using the code below to start my thred [CODE] Dim t As Thread t = New Thread(AddressOf Me.Main) t.Start() Panel2.Visible = False [/CODE] in my me.main I have a counter using a var, if … | |
I have the following code that works fine, it opens and excel file and uploads it into SQL. these excel files can have over 120 thousand records. I would like to put a progress bar on the upload so the end user knows how long the upload will take. The … | |
I have a program that I wrote that creates a database in SQL Server called States_02 as a sysadmin user. Later on I want to grant SELECT permissions to that database to another user, web I always get an error that it cannot find States_02 or I don't have permissions … | |
i have four computers connected to broadband ADSL router MS SQL Server is installed in all computers while i have done steps given here [url]http://support.microsoft.com/kb/914277[/url] it had worked on local networking some time ago but now its not accessing remotely. i m confused its just because of broadband ADSL. if … | |
I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … | |
I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … | |
Hi all.. I hope someone here can help me to solve my problem...I try to serach and get the solution from google..but it not help much... when I click button on page..the data will inserted twice in my database... i using select and insert statement in same connection... also have … | |
Good day guys =) ..., i know there are somewhat similar threads of this around here but i still cant find the one to solve my problem ... well i am currently building an online store.. and in this online store there's a table of products with the an image, … | |
Give Me Reply to Develop Faster Loading Sites..:) | |
Hi. I need to retrieve and list out the records from 'expenses' according to the date (eg. January 2011). I used substring to get the month (01 for January, 02 for February, etc.) and year. My date format is DD/MM/YYYY. I've tried echoing out $sql2 and the values obtained are … | |
so i have a working ish program now, when i add the record it saves and returns the save message box as it should and is viewable in the database where it saves to, but it is not viewable in the text boxes when looking back at the form until … | |
Hi all, I'm new to vb.net and Sql server... So it may be a newbie question, but i've searched many places and did't find the answer.. so, here i go: I've just installed sql server, and i want to databind some textboxes in a form... but i dont really know … |
The End.