6,934 Topics
 | |
| | 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. …  |
| | Hi guys i need help i want to move the existing data from table 1 into table 2 how i need to write the query. I tried the select into statement but it did not work at all. So how to do it . Please help i doing this on … |
 | 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 …  |
 | Hello Everyone! I have SQL Server 2008 R2 Developer Edition at my work place and at home I have SQL Server 2008 Personal Edition. When I copy Developer Edition Database to Personal Edition Database it gives error. Is there any way to copy a database from Developer Edition to Personal … |
| | 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 got this error when i trying to submit a form.. 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 'order(firstname,lastname,email,address,city,postalcode,country,totalprice,paymen' at line 1 appreciate if you could assist me.. [CODE] $sql2= mysql_query("INSERT INTO … |
| | I was working on this script which let's you upload and everything is logged in the database. I got this error, any help? 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 '/home/a6771073/public_html/upload/img.png)' … |
| | 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 …  |
| | I created on Employee master form. The details which i enter in this form is saving to sql table. But if i use Wild characters example in Name field if i enter "Varghese D'Costa", then the following error comes : Line 1: Incorrect syntax near 'Costa' Unclosed quotation mark before …  |
 | 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 … |
| | ive a dynamic dropdownlist, which items are retrieved frm db. but when i select an item from the dropdownlist, the item does not stay selected instead the dropdownlist make a postback and stay as default value. wad shd i do? is there any mtd to get d value selected? THANK … |
| | 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 … |
| | Hey guys, so I have been trying to get images to appear with an SQL query using PHP. My table has a column called picture, it is datatype nvarchar50. I have a folder in my project called images and in there an image called 4.png. So in the field of … |
| | 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 … |
 | i wanna make setup file to my app C# Database app with SQL SERVER 2008 R2 i wanna specific steps 1 - 2 - 3 and what about database file (.mdf), how can i handle this and i wanna when i take this setup file to any another pc once … |
| | I am trying to set up a database with Students, Courses and grades. This is the main bulk of my code, I am stuck with the error below, could anybody help me? [CODE] Imports System.Data.OleDb Imports ADODB Public Class Form_Main Dim cn As OleDbConnection Dim StudentUpdateCommand As New OleDbCommand Dim …  |
 | So, the question is, if I have a table on a SQL server with 20 columns, and I need to retrieve just 4 columns for a form, and I am using stored procedures to do most of my queries, should I create a stored procedure to retrieve just the 4 … |
| | Any idea what I did wrong? 'WHERE id =' at line 16 I am not sure why it says line 16 but I think it is talking a bout line 64. [CODE]<?php include 'resources/init.php'; if (isset ($_GET['id'])) { $q = "SELECT * FROM Client WHERE id = {$_GET['id']}"; $result = … |
 | 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 … |
| | I'll try to keep this short, and to the point. I've set up a Windows Home Server 2011, running MS SQL Server 2008R2 Express. I enabled TCP/IP protocol on 1433 static, and named pipes (no changes to named pipes). Remote connections work no problem via remote SQL Server Management Studio. … |
| | 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 … |
| | HI I would Like to Know how can Display the error Message When Executing the SP .. and the Stored Procedure doesn't having any value to Fire the Event .. [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: <sabari,,Name> -- Create date: <Create Date,,> -- Description: … |
| | 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 …  |
 | My table has these info T123 T153 T174 Basic SQL count works fine which results to (3).. but when I use this function needed for my query the output is 4. [CODE] COUNT(DISTINCT CASE WHEN id LIKE '%T%' THEN RIGHT(ID, 3) ELSE 0 END) AS Count [/CODE] what's wrong with …  |
| | hi there i have problem with my MS SQL server some one execute unwanted update statement on huge table and make loss for my data i fix it by using available backup but, i need to know who,can i do it if there are some logs for sql statement please … |
| | I want to make option to approve users before they can login or to ban them, here is code [CODE]<HTML><HEAD><TITLE>Fakultet informacionih tehnologija</TITLE> </HEAD> <BODY TEXT="#ffffff" BACKGROUND="fakultet/Assets/bg.jpg" LINK="#FFFF00" VLINK="#CDCD00" BGCOLOR="#000000"> <CENTER><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH="700"> <CENTER> <FONT SIZE=+4 FACE="arial,helvetica"> Fakultet informacionih tehnologija <HR> </CENTER> <?php session_start(); // dBase file include "dbConfig.php"; … |
| | 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']); … |
| | Hi, I have a table that stores records of students. Now what I want is that after a particular period of time the account of the student gets disabled automatically. Is there any time based trigger that can be hit automatically if i set the time limit for that. Or …  |
| | 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" … |
| | I need to count the number of records in an SQL database and compare it to a text file that contains a records number. Although I know how to access a SQL database in C#, I do not know how to count the number of records, or how to access … |
| | please correct the syntax[CODE]$sql = "INSERT INTO products WHERE cat_name = '".$_POST['cat_name']."' (cat_name,pro_name, file_name, manufacturer, manufacturers_code,detail,page_title,page_keywords,page_description,active,featured) VALUES( '" . $_POST['cat_name'] . "','" . $_POST['pro_name'] . "','" . $_POST['file_name'] . "', '" .$_POST['manufacturer'] . "', '" .$_POST['manufacturers_code'] . "', '" .$_POST['detail'] . "','" .$_POST['page_title'] . "','" .$_POST['page_keywords'] . "','" .$_POST['page_description'] . …  |
| | I'm lost on this one. I've got 3 tables involved here. An Accounts table, AccountsContacts table and a Contacts table. The AccountsContacts is a junction table between the two. The key columns for the tables are: Accounts: ID AccountsContacts: AccountID, ContactID Contacts: ID I need a way to select from … |
| | Hi, I'm having a data base which looks like this patient(pk_id)--(fk_pat)appointment(fk_doc)--(pk_id)doctor(fk_spe)---(pk_id)specialty The goal is to select all the patients which had an appointment with a doctor with 'dentist' speciality. I made 2 requests, one is correct and the other is incorrect correct one: [CODE] select distinct patient.name from pataient, appointment, … |
| | 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 … |
| | I have Sql2008 enterprise edition and want to install on windows 7 ultimate edition,it is giving error for version compability.what is required to do? |
| | This is my very first trigger and I'm not sure I have it set up correctly. I have a table called PayTypes. Here is my trigger syntax: [CODE] ALTER trigger payTypes_trigger on PayTypes AFTER INSERT, UPDATE, DELETE s PRINT 'AFTER TRIGGER EXECUTED SUCESSFULLY' [/CODE] I run this with a breakpoint … |
| | guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: … |
 | 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 … |
The End.