[sql] Forum Topics

I have two databases, tvguide and episodes1. Both are InnoDB, and I use Phpmyadmin to edit them. I tried creating a foreign key between the "episode" field of episodes1 and tvguide, and this error message came up: Error creating foreign key (check data types) : episode How can I fix …

hi please i need help with the query using the values from the combo box and the result will show on the data grid sp [CODE] ALTER procedure [dbo].[sp_GetReservistInfo_ByDesignation] @Platoon varchar (50), @Company varchar (50), @Batallion varchar (50), @Brigade varchar (50), @Division varchar (50), @FirstName varchar(50), @MiddleName varchar(50), @LastName varchar(50), …

hi all, i have a little issue with SUM query from this table UNIQUEID Date Production engine1 01/12/1999 1440 engine1 01/01/2000 6061 engine1 01/02/2000 5152 engine1 01/03/2000 5347 engine1 01/04/2000 4642 engine1 01/05/2000 5264 engine1 01/06/2000 5247 engine2 01/07/1995 561 engine2 01/08/1995 3066 engine2 01/09/1995 2133 engine2 01/10/1995 2282 engine2 …

[COLOR="Green"]ERROR : [/COLOR] [COLOR="Red"] System.Data.SqlClient.SqlException: Implicit conversion from data type sql_variant to uniqueidentifier is not allowed. Use the CONVERT function to run this query. [/COLOR] I made a admin side for editing roles and user passwords if necessary.. But since the default ASPNETDB,mdf have UserID and Password in 'Unique Identifier' …

Hello all, To begin, I am working with a MySQL database using python. In the database, I am working with 3 columns: REF_ENTRY_TIME, REF_EXIT_TIME, REF_ENTRY_VALUE. My goal is to graph the net value position against time. For the time portion, both REF_ENTRY_TIME and REF_EXIT_TIME are random various times between 9:00 …

[URL="http://www.daniweb.com/forums/thread305436.html"]http://www.daniweb.com/forums/thread305436.html[/URL] accidentally i posted in the wrong forum.

I have a search a particular filename in my msaccess file . if i search through ID no , i am able to fetch the output . but if i am searching by comparing filenames then i am getting error [CODE] Private Sub cmdSearch_Click() Dim key As String, str As …

Hi all, I've been learning PHP and SQL slowly over the past couple of weeks for a project (so please be gentle!). I have a database, MEMBERS, as follows: [CODE] ID | Name | Job Title | Current Employer | State | Manager 1 | Joe Smith | Sample Title …

I have added case 9 into this document and added the appropriate entries elsewhere to make it work however i cannot get this to enter the checkboxes correctly. When i go to the form and I select checkboxes and i list the options and sav ethem, it goes into the …

Hi all, I am executing query for SQL Server 2008 like that , [CODE]myQuery= Insert into Employee(id,name)values(' 99 ' ,' Nitin Daphale ');Insert into Employee(id,name)values('77' ,'XYZ');Insert into Employee(id,name)values(' 88 ' ,'ABC');[/CODE] Here am Inserting 3 Records in an Employee table but the problem is, if any statement fails I can't …

Hi Friends, How can I change the Command Text based on a Control event like clicking a button? I want to change the sql query on clicking a button. Any help is appreciated. Thanks in advance

I am new to SQL query. I would like to join two SQL queries (MS Office Query and Computer Details Quer) into one. The tables output can be found at [URL="http://rapidshare.com/files/412276985/SQL_query.zip"]http://rapidshare.com/files/412276985/SQL_query.zip[/URL] Or, from [email removed] Thanks for your guidance, below are the query: 1) MS Office Query: ================ [CODE]select v_Add_Remove_Programs.DisplayName0 …

I am using Visual Studio 2010 for development. This is a web application using asp.net and vb.net with MS SQL Server 2005 for the database. I'm having some issues with inserted data being overwritten by the next transaction (if done within a relatively short amount of time, say, roughly several …

I am running SQL 2005 Standard Server. I am using Visual Studio 2010 for development. Let me just say that what I have below works, I would just like to have some constructive critisism. Is this the best way? Is there a better way? Are there any things I need …

I am currently producing a system in which I want the user to be able to select the product name from a drop-down menu and when selected I would like the barcode to appear in the barcode field. I would really appreciate any help, however great or small. The current …

I do hope this is the right section (since VBA is so close to VB 6.0). Well here is my dilemma: I am trying to have Access return a customized report. The format I have been asked for it to be output as it the following: Machine type // where …

Hey.. i'm making a java program with derby databse usin netbeans.. the problem is that when i crate table usin a sql query,netbeans automatically sort them by name..how can i let netbeans sort them by date of creation so i can switch between tables in order of creation??... thx for …

Hi there, I have a project created in C# visual studio 2008 standard edition and I am using a Microsoft SQl database file. I took my solution project in a filer and tried to run the application, going to the project folder and to the bin folder -> Debug folder …

how to insert last id value from one table to another plzzz help me... thnx

To view this tutorial with notes at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] yes I am aware this is more php than mysql. howerver I get asked how to do it so often I thought I'd post it here aswell :)

Im having a little bit of trouble with an update statement. if any one could take a look at it and help me with what im doing wrong that would be great. [code=c] private void button6_Click(object sender, EventArgs e) // Button6 is OK { ///////If Null///// if ((textBox1.Text.Length == 0) …

I'm looking to write a program that should be capable of holding around 1000 records, each record will contain a varying number of fields and values. Usually, I'd create a list of dictionaries for something like this but wanted to know if that's the right way to go about it. …

Hi newbie here I’m currently making a hotel booking system in mysql/php, but I’m having problems with overlapping dates/double bookings. For example if a user attempted to book room1 from the 1st august to the 5th august, but the room is already booked on the 3rd and unavailable on the …

[attach=right]14422[/attach]File under oops. The website of The Telegraph newspaper has been defaced by hackers, apparently upset at a cult British television show and the newspaper itself for mocking their country. The 'Romania National Security' hacking group has claimed responsibility for the attack which hit a couple of third party services …

Hey team, i'm having a problem with this query, [code] "SELECT * FROM marketingDB WHERE company_name LIKE 'allied' & '*'" [/code] the program ive written runs fine and it doesnt show any problem with the query infact the exact same query works fine on access but when i put it …

I am having a problem with the SQL INSERT command in VB. I am trying in move data from one table to another. The problem is I am going from a table with duplicates to one with no duplicates. Since there are duplicates the SQL statement bombs. Here is the …

I am trying to create a C++ program that queries data from an ODBC data source. I am very comfortable with C++ and SQL, im just not sure how to set up an ODBC connection in C++. I have tried searching google and have not been very successful. Im using …

hello guys . i am new to mysql and i really dont know anything about it so i need your help in creating a database that contains two places one is the username the the 2nd one is the password .So please tell me how to do it

I have a list that passes values to an sql statement to show relevant results. I have three options (All, Option One, Option Two) and cannot get the query to work. If I choose option one or option two then the results are fine but I cannot find a way …

Hello I have a Gridview that is updating and inserting information into my tables. I am using the following query to insert: [CODE] Dim InsStr = _ "IF NOT EXISTS" & _ "(SELECT [PRODUCT_NAME] FROM [PRODUCT] WHERE [PRODUCT_NAME] = '" + ProdName + "'" & _ " UNION " & …