2,569 Topics
 | |
| | I am trying to figure out some web development using ms vwd in C#. I want to link a couple of textual titles to hyperlinks. However, those hyperlinks are stored in a database object's column using ms sql server and so I need to use the oledb commands and iterate … |
| | Hi, I'm creating a form application using vb. I'm still new to this and I'm teaching myself via the internet so please don't be too mean. I wrote my code using queries that I created in visual studio. I don't quite remember how to create an update query and write … |
| | I asked this basic question a couple of days ago but I probably didn't include enough information in my question. Sorry for reposting, but I am really lost here. This is a web application in VB.net connecting to an Access database on a 2003 server. The problem: I have a … |
| | Hi, I have a windows form with a "ComboBox" on it. The "ComboBox" has the words "Production" and "Development" in it. If the user selects "Production", I need my C# code to point to the Production database. If the user selects "Development", I need my C# code to point to … |
 | hello ! i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with …  |
| | Hi everybody, I found an error-based sql injection in my webserver.My database doesn't contain any private info. I want to know if its possible to own my server just by using the info in information_shema. Please tell me because i want to know if i have to fix it.I don't … |
| | Ok over the last several weeks i've been building a website for fun. Its basically a forum site, with topics and comments. I use queries in their basic form. Now that i'm trying to protect my site I'm getting the impression that i have to rewrite all of my code. …  |
| | hello ! i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with …  |
| | Hey guys...I have a MySql table like this. and [B]Grade [/B]column is a derived attribute. and it is based on [B]Marks[/B]. u know the basic thing. [CODE]create table Enrolled( student_id char(14), subject_code varchar(10), marks int, grade char(2) );[/CODE] I want to fill the [B]Grade[/B] column based on each student's marks. …  |
| | I've been looking to secure a site that has many queries involved. I've always known about mysql real escape string for a while but recently i ran across prepared statements. I had a few questions about them. Is it a good idea to use both? is this over kill? When … |
| | I am attempting to create a global temp table to be used between two sessions being called from a webservice. When I attempt to access the temp table from the second session it can not be found. The reason I am using a global temp table is because the initial …  |
 | Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is … |
| | I'm trying to set up a query to sum a value for each user by month and then calc the percentage of that user's total vs the total month's value. My query below works as long as its limited to one month. I've tried to group my subquery the same … |
| | So I am trying to make let's say, a chat software. For this example there will be two users X and Y and the Database named DB: 1. Both X and Y are connected to DB 2. X sends a message through a form by clicking submit, 3. the message … |
| | Friends i want to submit project in my college on employee management system.... front end should be c# and back end sql server 2008... i got one project on net but its backend is microsoft access I want to change this to sql server 2008.... what changes i have to … |
 | Guys this thread is basically for the beginners who want to learn ASP.NET from the very beginning.. Plz give your valuable suggestions and kindly provide appropriate answers for the queries... |
| | I'm trying to create a table in oracle here's the code [code] drop table class; create table class (schedule_num integer primary key not null, semester varchar(10), course_name varchar(14), credit int, department varchar(15), /* meeting_time time,*/ meeting_place varchar(20), enrollment_limit int); [/code] I don't how to initiate the 'time' data-type, can someone … |
 | So i was busy playing around with the python module MySQLdb and looking at sql injection. [CODE] import MySQLdb def hack(name): db=MySQLdb.connect('xxx','xxx','xxx','xxx') cursor=db.cursor() sql="SELECT * FROM PLAYERS WHERE NAME = %s" %(name) print sql cursor.execute(sql) print cursor.fetchall() [/CODE] i entered Hack("'pete' OR '1'='1'") results were: SELECT * FROM PLAYERS WHERE … |
| | hi, I am using SQL client as the database and VS 2008 standard to bild my project. i need to browse for a file and upload it to the SQL database. how can I do this ?? I have the code to browse for the file and insert to the … |
| | 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)); …  |
| | I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … |
The End.