7,494 Archived Topics
Remove Filter  | |
| | Hi, I have two databases (live and staging). Extra columns have been added to various tables within the staging database by another developer while they were extending the websites functionality. Now has come the time to put the new functionality live, which means taking the staging database schema, creating a … Databases mysql |
| | Hi all, User table has an ipAddress column, & userid column as pk...maybe more than one user has the same ip! UserActivity table has userid as fk, and activityid which is fk to activity table So, I'm trying to get a count of how many rows in the user activity … Databases mysql |
| | Hi there, most interesting forum and I hope I can get some help here. I have 2 record sets, one which looks up a product by SKU and the table contains a field with "related SKU's" in a comma separated text field. I have created a Var with the "related … Databases mysql |
| | If I am violating a rule please delete this thread. I posted this question in the Linux forms. [url]http://www.daniweb.com/forums/thread298067.html[/url] I have a screwed MySql install in Linux, I assume someone will have the answer to this over here as the Linux forums seem dry. Databases mysql  |
| | 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 … Databases microsoft-office mssql operating-system sql |
| | Hi I am new to this SQL and I using access to build the below statement. Below is a working SQl statement but I need to output DISTINCT records. How do I compose this syntax inorder to display DISTINCT record using this {SR.No#] field ----------------------------------------------------------------------------------------- SELECT Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem … |
| | Hi all, I'm using ASP.NET programming with SQL Express 2008: Basically to simplify and summarise, I have Users who can message to each other: Users table: UserID (PK); UserName Messages table: MessageID (PK); UserIDSender; UserIDRecipient I want to Select * from Messages table and also the UserName for the UserIDSender … Databases asp.net database-design mssql  |
| | Hi i have data in a mysql table which is about 70000 rows. In one column there is information that I would like to split into 2 rows. The information I want to send over to the other named row is nicely sat in brackets eg (18) . It is … Databases mysql  |
| | Hi I'd like to run a flashMovie in a .php page to the norm html. Fla's run ok, except they don't handle 3D object key command .swfs. [url]http://www.flashsandy.org/demos[/url] Click on 2nd image of a type of jet_copter Gavia AT-1008 as the best example of what is possible. Use keyboard arrows … Databases mysql |
| | Hi, Trying to run this script via MySQL workbench. Can anyone see anything wrong with it? I suspect the foreign keys are not defined properly? Thanks [CODE]USE streamlibrary; DROP TABLE IF EXISTS streamlibrary.FileProperties ; CREATE TABLE IF NOT EXISTS streamlibrary.FileProperties( PK_fileName VARCHAR(50) NOT NULL, extension VARCHAR(4) NOT NULL , sizeMB … |
 | Hi Geeks!, I need help. I want to format label's text into date but the value of my label is fetched from the database so I shouldn't use Now() function. ex. 7/31/2010 would be July 17, 2010. Thanks in Advance Guys! Databases  |
| | Hi, I’m trying to return a value from VB 6 to Access 2007 report and the unbound textbox remains empty. It seems that actually the problem is not coming from the coding itself, but due to connectivity between the two ends. In fact, I tried to enter a Beep instruction … Databases microsoft-access |
| | Hi to all, i am building a site with movie reviews.. due to the fact that a movie may have more than one category ex action, adventure, sci fi etc i ended up using a sinlge column to add all tha categories in comma delimited form.. 1st question. is the … Databases mysql  |
| | I'm going into my last year of a computer science degree, and after looking around at job postings for software developers I've noticed that *many* of them require knowledge of Oracle - something that I haven't yet learned very much about. So I was wondering if anyone could point me … Databases oracle  |
| | Hai, [B]Problem we are Facing Currently[/B]: Records getting inserted as only one during the process of updating the server. Previously, all the given records get inserted into the database table during the updation process. "updateprice" is the .mdb exists locally in the same folder where the calling file for updating … Databases mysql open-source sql storage web-server |
| | I have one table METER with the primary key serial, another table TC with the primary key tc, and a third table History with the primary consisting of the 2 foreign keys serial and tc along with week and create_date. Every TC has 0 or more METER's. How do I … |
| | Hello! I have a Case Study Scenario for which ERD & Use Case Diagram are required. My question is... Should Use Case Actors be the same number of Entities into ERD? E.g. If i have 5 actors in UML it means that I should also have 5 entities of these … Databases |
| | i have a scenario where i need to know what are the entities it has. i found 5 entities. 1- Company 2- Customer 3- Package 4- Shipment 5- Staff I have been told that the company is not an entity. is it true here in this scenario? it says that … Databases |
| | Hello everyone. Does anyone know if a database has a maximum capacity to much data can be stored inside of it? Someone told me that the max info a given database can hold is 4 gigabytes. Also, if there IS maximum capacity per database, does anyone know how to INCREASE … Databases mysql |
| | I am trying to get the following functionality working which requries some SQL. The need is to be able to produce a list of general staff who are not on holiday or on other sessions on a given day. I have two sql statements that will give me the information … |
| | Hallo dont now if its right forum and excusse for bad english. I hawe a site on one.com and tried to restore my sql data base. i hade a backup, before i restored it i dropped all the thables to read in the new wone. buth it dosent work it … |
 | Can anyone help me create an .exe using Mirosoft Access. I have an Access application and I want to place an .exe file on the server so that everyone can have access to it. Please Help!!:!: :cheesy: Databases microsoft-access |
| | hi , I want to split the field by comma and that should check the values in another table and display multiple values as given below. Here is my table format: Table1: ====== id : nos 1 12,13,14 2 14 3 14,12 Table2: ======= id : values 12 PHP 13 … Databases mysql |
| | I have two tables tbl_1_id_pk tbl_1_diska_fk (relationship) ---> tbl_2_id_pk tbl_1_diskb_fk (relationship) ---> tbl_2_id_pk and tbl_2_id_pk tbl_2_name When I create views/queries for the name for each disk, it returns nothing. Why? Databases mssql |
| | Hi How can I transfer some tables created in a database in MySql on my computer to a friend's computer. I have sent to my friend the tables stored in C:\ProgramData\MySQL\MySQL Server 5.1\data\mydatabase folder via email. But when it is pasted in the same location in another computer, it isn't … Databases mysql |
| | hello people, when i run this below written query then i get error as "ORDER BY clause is invalid in views,inline functions,derived tables, subqueries and common table expression unless TOP or for Xml is also specified". i want to have the top 5 result based on the Gross_written_premium . can … |
| | Hi I am new to the database concept and I have to make a college project such as hospital management, Transport management system etc. in DBMS. Our college is teaching us MYSQL. Please can anyone advice me as what to use in making these projects. What database type to use … |
| | Hi all, I am having a bit of a problem with implementing a nested statement that will update based on conditions. I know the logic behind it, but do not know how to implement it with nested queries. Please see below the pseudo code I've written along with an example … Databases mssql |
| | I have a table which holds the status of a machine in our factory. When the machine is running a line is written with a status of 1, when it stops it writes a status of 5 until a program records the error then it writes a line with a … Databases mysql |
| | hi, i have been working on creating a view in my database: [CODE] CREATE OR REPLACE VIEW productnotgot( ProductID, Product, ClientID, ClientFirstName, ClientLastName, Email1, Tel1, Email2, Tel2, ProductSold) AS SELECT Product2ID, 'Product2', c.ClientID, c.App1FirstName, c.App1LastName, c.App1Email, c.App1Phone, c.App2Email, c.App2Phone, p.clients_ClientID FROM clients c JOIN Product2 p on c.ClientID = p.clients_ClientID … Databases mysql |
| | I am new, any one can tell me how can add image link in mysql after adding image link how can we display image. |
| | Hi, I am practicing MySQL JOINs and was hoping I could get some insight on how to do a particular problem. I am using the World database, it has a table called City with name, population, country code. It also has a table called Country, with Code and Name. What … Databases mysql |
| | Hello everyone. I have tried to fully install MySQL on Windows Server 2003 for a few days now, with no success. There are two things stopping me from completing the install: 1) I forgot the initial password that was used for the root user 2) Every time I get to … Databases mysql windows-server |
| | HI, I have a requirement where I need to compare the data in different database(tables having same structure/schema). I know manually I can execute the queries in each database, compare the results and it is done. As this execution is repetitive in nature, how I can automate this. Thanks In … Databases data-structure mssql |
| | Example of GRAND TOTAL, TOTAL1 TOTAL2 TOTAL 3 SUBTOTAL 1, SUBTOTAL 2 SUBTOTAL 3 How many chairs we have in our village? Grand total chairs in houses =total chair in house A + total chair in house B Total chair in house A = TOTAL CHAIR IN ROOM 1 + … Databases mysql |
| | I have created a website in Dreamweaver CS3 that includes mySQL databases. I have been using xampp, and have a test server running on my local machine. Everything seems to be working fine, and now would like to put the website online. I'm not sure how exactly to do that. … Databases mysql |
| | I have a table with information about the type of scrap generated on a bag making machine. Every time scrap in generated on either side of the machine (left or right, there are 2 packing machines on the one bag maker) a line is added to the table with the … Databases mysql |
| | If I want to search record by age like (30 to 35) just like dating script but I will not use in dating site, I have my school website and I just want to display record by age but If I want to display age between 14 to 17 kindly … Databases mysql |
| | Hey using the following sql [code] SELECT DB_SALGSPRIS from pris_interval WHERE DB_INTERVAL_START < '11.78' AND DB_INTERVAL_END >= '11.78' SELECT DB_CUSTOMER from pris_interval WHERE AND DB_INTERVAL_START < '7.19'AND DB_INTERVAL_END >= '7.19' [/code] I get multiple results, 3 from first, and 2 from the second to be precise, what I am wondering … Databases mssql |
| | I have tbl 1 id_column(1 2 3 ) tbl 2 id_column(1 1 1 2 2 3 3 3) I need result tbl2 join with tbl 1 values (3 3 3) Thank you in advance i'm strugling from two days for this. Databases mysql |
| | I need to create a row and its content to be unchangeable and undeleteable, as a secure way to ensure that the administrator will always have access to the website. Does anyone have any idea how to do this? A Google Search gave no results, but perhaps someone knows how … Databases mysql |
 | Is it possible to get the max values from the columns in 1 table and copy them into another or would this not be recommended. The more I think about it the more I begin to think it isn't such a good idea. Here's an example what I'm looking for: … Databases microsoft-access |
| | [code=php]<?php $host = "Localhost"; $user = "User"; $pass = "Pass"; $db = "DB"; echo "<b>This will test your SQL Server connectivity...</b>"; /********** testing connectivity ***************/ echo"<font color = 'green'><br>connecting to Server....<P>"; $link = mssql_connect( $host, $user, $pass); if( !$link ) { die("<font color = 'red'><p>Failed to connect to server: database … Databases coldfusion mssql |
| | 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 :) |
| | I know, is a very basic question, but I am in the process of re-learning sql stored procedures, and this is what happended: I was practicing with some simple delete / insert routines, when encountered with this: if I ONLY insert records: 1. dog 2. cat 3. t-rex 4. llama … |
| | Hi, select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_expenditureinvoice c where a.client_id=b.client_code and a.client_name=b.client_name and a.location=b.client_location and a.receiptno=35 and b.fully_recived not in ('Y') and b.amt_balance>0 and (c.fyear_code=b.fyear_code and b.inv_no=c.inv_no) union select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_invoice c where … Databases mssql |
| | This is a User Defined Function to perform simple encryption on an input string. This is performed by transposing the ASCII value of each character in the string by the increment value (@increment in the parameter list) Pass the function the string you wish encrypted and the increment value, which … Databases encryption mssql |
| | Hi I have created two tables in MySQL using Navicat. When running an update query, I noticed that first, when I am entering a price for a product, the price is rounded to whole numbers it seems. Secondly, one field that I enter data in to be added to the … Databases database-design mysql |
| | i got this error in my code in my hosting account plz help ti solve it [COLOR="Red"][CODE] "Error connecting the database"[/CODE][/COLOR] this is my connection codes [CODE]$MYSQL_SERVER='jsnf.db.6477609.hostedresource.com'; //sessions not need for this one $MYSQL_USER='jsnf'; $MYSQL_DB='jsnf'; $password='[removed]'; mysql_connect($MYSQL_SERVER,$MYSQL_USER,$password) die("Error connecting the database"); mysql_select_db($MYSQL_DB) die("Error Selecting the database");[/CODE] this information give me … Databases mysql |
| | Hi everyone, I need help in my school project which requires me to send data from a mobile application to a database table. The inputs for the table data is through textfield and when i press the submit button, it will send the input fields into the database table. Will … Databases java-netbeans mysql os-x |
The End.