2,570 Topics
 | |
| | Hey, so I have a form and i want to break down the form into 2 sections when inserting into my database. I have made 2 tables to hold my values. this is my SQL statements. [CODE] $sql_insert1 = "INSERT INTO `agent_users` (`user_name`, `password`, `primary_email`, `secondary_email`, `join_date`, `last_accessed`, `activation_code`, `first_name`, … |
| | OK, this may not be possible in SQL, but here goes. I'm writing an app that allows the end user to select a date range and filter by area code, but I want them to be able to select as many area codes as they want. My question is with …  |
| | i write the procedure for login in this user can give username or emailid for the login. this is my code.... please check is there any change is required for this [code=text] ALTER procedure [dbo].[users_login] (@username varchar(50),@password varchar(50), @emailid varchar(50),@ret int output) as begin select username,password,emailid from users where( username=@username … |
 | Yesterday [URL="http://www.daniweb.com/blogs/entry3943.html"]I reported[/URL] how the security vendor Kaspersky had allegedly fallen victim to a SQL Injection attack, with the usa.kaspersky.com website hacked and plenty of data potentially exposed. I said that Kaspersky would no doubt make an official statement sooner rather than later, and it has. Unfortunately it is one … |
| | Hello All, I apologize for what seems to be a simple thing to solve but I'm not sure why I can't get the correct result below. Here is the code and the problem: I'm using .HTACCESS to password protect a directory. I'm taking the username and storing it in a … |
| | Hello everyone I have a problem using a "search" statement in mysql, using c#, here is my code: [CODE] private void btnBuscar_Click(object sender, EventArgs e) { SearchBook(txtBuscar.Text); } private void SearchBook(string bookID) { String connStr = "Server=localhost; Port=3306; Database=biblioteca;Uid=root;Pwd= -----;"; DataTable dt = new DataTable(); const string query = "SELECT … |
| | Hello, I've wound up with a strange problem with my php script. The script goes into a SQL DB and checks the values of two different columns to see if they are equal. If the columns are not equal, then I store all of the possible values in column 1 …  |
| | Hey guys, I'm working on an SQLite3 wrapper using C programming. I was wondering if you know how can I set database properties such as mode, headers and echo through the C application. For example when running the SQLite shell and you are connected to the database you can do … |
 | Hi I need to insert a flat text file into a SQL Server table using C#. The text file lines are 500 characters long and I will need to break it up into columns. Column 1 – 6chars, Column 2 – 1chars, Column 3 – 8chars I’ve managed to read … |
| | Hi, I searched all over the net for a clear solution but what solutions i have found just leave me with more questions and answered. I have a multi step form using IF statements such as: [CODE] if(isset($_POST['2'])) { echo "step2 data"; }else if(isset($_POST['3'])) { echo "step3 data with text/ … |
| | I purchased a book that included an evaluation version of 2008 enterprise. I had downloaded SQL 2005 express and had tried to download 2008 which said it succeeded and I was left with 2005. I checked the OS list of supported ones. XP professional is on the list. XP home … |
| | [code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table …  |
| | Hi, it's me agian... I was asked to do reasearch on how to upload a txt file's data into a MS SQL Database (corresponding columns etc.) I've searched a bit on the internet but don't find what i'm looking for... I just want to ask does anyone have an idea …  |
| | Hello everyone I've been trying to google this and had no luck with this issue So i have this form where it prints a certain record i search, but im trying to do restaurant form and a print form that it will print the last order done. So I Know …  |
| | Hello, I'd like to get help for a database engine in Python. I know that there are loads of databases out there and I cannot create one which would be even near as good as SQL but I'd like to do it for getting a good understanding of databases and …  |
| | I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this |
| | Can anyone please point me towards a good C# SQL tutorial. I've been looking for about 10 minutes, but I can't find a good one that actually works. I would apperciate anyone that helps me! Thanks! Nile |
| | In VS 2008, for example I have sql command like SELECT * FROM STUDENTS WHERE STUDENTID = @STUDENTID Then I append value into it, for example 15 How to I catch this sql command SELECT * FROM STUDENTS WHERE STUDENTID = 15 Thx in advance |
| | I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do … |
| | Hello guys! I am developing simple desktop application that suppose to connect to SQL DB launched on remote server. Everything going fine, exept that when connecting to DB I get exeption "Login failed for user 'guest'." So, looks like i need to create some user with password and give him … |
| | hey everyone need some help again, i have two computers both running in vista ultimate. one is a server and the other is like a terminal. my problem is, how do i connect the terminal to a database which is in the server? please provide me a step by step … |
| | I am trying to return the value of a column if a condition is met: [CODE] cmd.CommandText = "SELECT plan_entity_id FROM PLANNER_INFO Where plan_id = plan_id"; cmd.Parameters.Add("plan_id", SqlDbType.Int, value); con.Open(); returnValue = Convert.ToInt32(cmd.ExecuteScalar()); [/CODE] for instance, if Plan_id is 1 it returns the entity ID which is equals to 1. …  |
| | Currently using ASP.net 2005 I am havin an errot in update statement my code is: Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim ssql As String = "UPDATE passwrd SET password ='" + TextBox1.Text + "'where username='" + TextBox2.Text + "'" myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data … |
| | I have a T-SQL function (transact SQL is SQL server 2005 programming language, with many limitations compared to say C# or Java). It currently works but has severe limitations. Its input is string (formula) that has ternary operators used in it. The function converts it into CASE statement and returns … |
| | This code demonstrates how age might be calculated and filtered using the DateDiff method in SQL. Also, note that both the parameters are set to NULL by default, hence making them 'optional' to a certain limit. |
| | The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …  |
 | I am working in VS2008. I use vb.net and asp.net. MS SQL2005 as database server. Occasionally when two sets of data are inserted at nearly the same time, I find that one has "stomped" on the other, over-writing it's data. The inserts are done via a stored proc using SCOPE_IDENTITY() …  |
| | Hello, can anyone help me find a document explaining a general way to design "Live" tables in SQL? i have an application linked to a db that contains live tables in it (tables that have records always updated, inserted, deleted and many applications read/write in it) my biggest worry is … |
| | File under FAIL: social network widget maker RockYou has fallen victim to a SQL injection flaw and as a result some 32.6 million users are being urged to change their passwords as a matter of urgency. Security specialists Imperva discovered the problem at social networking development site Rockyou.com and issued …  |
| | Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record … |
The End.