2,403 Solved Topics
Remove Filter  | |
| | I'm trying to make multiplication in web shop that will show real price: **discount * tax * product price * 1 piece= real price** But I just don't know how to do it, I try 1 million things, spend about 48h just to make it, but, without success, no matter … |
| | I need to order these dates in descending order (last should be first) and in fact how they now appear. However they do not necessarily appear like those so I need a SQL Order By clause to order these descending: 2012-01-23 09:53:24.097105 2012-01-20 17:31:57.565458 2012-01-20 17:01:09.154587 2012-01-20 16:28:40.685735 2012-01-16 12:03:54.99954 … Databases sql  |
| | 0 down vote favorite I am trying to write a script that will return the latest values for a unique documentid-physician-patient triplet. I need the script to act similar to a group by statement, except group by only works with one column at a time. I need to date and … Databases sql |
| | Hello. I'm new to php and sql. I nee to insert data in multiple tables and rows. the problem, in the first table, I just nedd 1 row, and that's fine, in the scond i need to input data in the minimum of 1 row and max of 6 row's. … |
| | Hi Friends i like to know more about the difference between mysql, Phpmyadmin, sql and also which one is more safe and secure for webpage. Can any one help me to know about it.  |
 | Hey Friends, I recently came across a question which asks to approximate the data volume of a table which contains 10 Million records. Any idea on how to do it? Thanking You In Advance. Databases mysql |
| | I am wondering if anyone can help me or point me inthe right direction. We are currently subscribed to a company that allows us to list products onto eBay. We can upload images through their web interface. For every 10Mb of images we are charged extra. Their is a count … Databases image |
 | Im going to create database.there are few table in that db. I need to know what is the best ; add more column to table or use separate table rather than add more column Databases |
 | I'm new to triggers, but have been working with MySQL for quite a while. Now I need to implement a trigger. I want to create a trigger on my 'persons' table so that after an update, ***if the attribute clubid is changed***, attribute clubname should be changed. I have a … Databases mysql |
 | hi I am having a challenge with a Fetch statement being used in a stored procedure. I am declaring a cursor and fetching data into a set of variables. The variable types match the column declarations exactly. There is data in the table from which I am fetching. @@FETCH_STATUS is … Databases mssql  |
| | I have a column called pEditDate in the table rc_Pages I need to extract the date for each page so when the users goes to page /example the last edit date shows at the bottom. I try to do is but can't. Using SQL Server Comptact and C# Databases mssql |
| | Hi, These are the opening lines of my code USE myDatabase GO PRINT '@@FETCH_STATUS: ' + CAST(@@FETCH_STATUS AS nvarchar(30)) This returns FETCH_STATUS as -1. I have just opened the connection. Can anyone tell me why this is occuring? Databases mssql |
| | Hi guys I got a table called rc_Pages then I got a column called pName (Pages Name) and now I have made a new column called pCategory (Page Category). Since there are like 60 pages and updating the pages manually can be a big issue. I need to set the … Databases mssql |
| | how to delete duplicate record in a table by using SQL query |
| | how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error. |
| | In my script, I have a table displaying the results of a SQL query. However, I am using the results as a sumamary, but the SQL is making the page display the table as many times as there are results (rows) in the returning SQL that are allowed because of … Databases sql |
| | Hi, I'm creating a website/database that my dad and his partner will use to help manage there business. update new appointments / manage customers ect. My dad wanted to host it on our server, however I'm not confident about setting up security so I was just going to use a … Databases mysql |
| | Hi all, Here's to hoping that a SQL Server guru is hiding among the ranks of DaniWeb members. I have two servers, DB01 - the production database server and BKP01 - the backup server, that are in two different geographical locations. Since some queries on DB01 are accessing BKP01 there … Databases mssql  |
| | I created an instance and did some fault while moving the files from one location to other and now the server doesnt start and i need to execute a query in SQL SERVER Management studio in order to open a new query feature it again ask to start the server..the … Databases client-server mssql |
| | Hi, If i want to create a user in MySQL only to allow the Php program file to access the database and show results in my website what priviliges should i give to the user. So that access to my database is never compromised if someone can get the password … Databases mysql |
| | I have two tables. One with orders and one with lines items for the orders. The line items have a unique code that relates to the line item number. When sorting on this unique code, you are able to see the order in which the item was added to the … Databases mssql |
| | Ohayo I Hav a Doubt regarding the storage of database.. Suppose i have a college database...among Master Model Tempdb MSdb were do i store this college database??in master?? even if i create a new database how to add the new data into the existing database??  |
 | Hey guys so for a class of mine we have to build a program for a client that is going to require a Database. The database is going to be purely for demo purposes so an actual server is not necessary. Now I have never done this before and I … Databases client-server mssql visual-studio |
| | I want to know, is it possible to use a mySQL database simultaneously from a PHP website and a Java Website both making continous read and write operations. Are there any tradeoffs? Does connection pooling affect this? |
| | hi have a nice time, guys can you provide me a complete list of orcle queries (SQL / PLSQL) Databases oracle  |
| | Hi guys... I am developing an windows application in c# with sql server as back end with windows authentication i want username and password for sequrity purpose can i set username and password without changing it to server authentication. Thanks in advance. Databases mssql |
| | Hello, I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set) I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox. I have: INSERT … |
| | Hello: I'm trying to get a record from mysql based on the query of another the queries separately: set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,queue_num,clientID,customerid, todays_date, request, details,status FROM queue_sys ORDER BY todays_date; outputs row_number queue_num clientID customerid todays_date request details status 1 14 44DWS … Databases mysql |
| | I know this is a simple quetsion but I am stuck. I need to create a view that displays the discount house price by 5%. CREATE VIEW v_hou_discount AS SELECT hou_price - (hou_price * '.05') as '5% Discount Price' from house; What am I doing wrong? Databases mathematics mysql |
| | Good evening I'm running a tipping competition, and am hoping to make the updating slightly less tedious. The code currently reads as follows: <?php $query = " SELECT SUM(comptipsterselections.profit) as Profit, comptipsterselections.stable, comptipsterboard.link FROM comptipsterselections INNER JOIN comptipsterboard ON comptipsterselections.stable=comptipsterboard.stable WHERE comptipsterselections.comp = 'aintree 2010' GROUP BY comptipsterselections.stable, comptipsterboard.link ORDER … Databases mathematics mysql php |
| | long blob size is way too small for me. how can i make it bigger??? i want thing when i making col image. i can set Attributes to or lenth/value? but i dont know what to type in help plz Databases |
| | hey all im new here... well as u know people are joining here are all usually having trouble or problem... just same like me... im having trouble in doing my project.. i wish somebody would please help me... here im in the mean time doing my project on DBMS.. so … Databases |
 | I am building this database : http://imageshack.us/photo/my-images/217/diagramg.png/ I have a difficilty Regarding Renting. Because in this system one can order either DVD Or Game. Therefore how am i going to link the Game or/and the Dvd to the Rent table ? Currently it does not work due to the fact … Databases |
| | Hi, I have table (MyIsam) and want to set an index but fail to do so. Field : Varchar(10) Not Null Index Type : Unique Index Method : Hash Everytime I try, index method automatically assigned as BTree. Is this combination wrong for setting an index defined above? Thanks Databases mysql |
 | HI All, I have three tables tbl_category, tbl_subcategory, tbl_product . where categoryid is foreign key in subcategory table and subcategoryid is foreign key in prduct table. I want to show category and subcategory on home page menubar. I just reach upto display category on menubar but not able to get … |
| | Is there a way to use Order by RAND() for a query so that it returns a list of results and guarantees that adjacent values will be at least 'x' from each other, on either side? The results are all numbers, no strings. So if it returns 5 results r1 … Databases mysql |
| | Hi, I'm new to the forums and could really do with some help on the following... I've got a mysql query which i'm running to log a user in to a secure section of a website. I've successfully managed this on another website, however with the query i'm running it … Databases mysql |
| | Hi all, I have problem getting data from mysql table . What i am trying to do is that i want to get data from specific Category-id column and search a specific word or starting letter search from Name column , suppose this structure, -Database ---Table ------Category-id, Name My query … Databases data-structure mysql |
| | Hi I have a real conumdrum here - I just can't expalin this behaviour!! A colleague has designed a view that contains the following : `CONVERT (nvarchar(4),YEAR(dbo.SYSFinancialYear.FinancialYearStartDate)) + N'/' + RIGHT ('00' + RTRIM(CONVERT (nvarchar(2), dbo.SYSAccountingPeriod.PeriodNumber)), 2) As YearPeriod` When you are in the design view, of the view and … Databases client-server microsoft mssql sql |
 | hi All, I have two tables table-1:customeramount table-2:customerpurchaseamount table1 have customers bonus amount and table 2 i have customers purchase amount now i need to calculate balance bonus amount i tried with following query but It shows unexpected result , could any one guide me.. SELECT CM.`custid`, SUM(CM.`amount`) - SUM(CP.`Amount`) … Databases mysql |
| | Too weird but still I have a doubt.... I have two table.... -> OutpatientDetails -> InpatientDetails But the fieldnames are same except for the ID....i.e. OutPatientID and InPatientID respectively..... I want to combine both the tables and produce one output.....I dont know whether it is possible or no.... I want … Databases mssql |
| | I have two tables namely student and subject joined by a table called student_subject. With the following structure student: +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | student_ID | int(11) | NO | PRI | NULL | auto_increment | | studentCode | … |
| | Hi, I'm wondering if someone can help me with a problem I've been trying to solve for almost a week now which concerns shared ranking (i.e. whilst I am trying to rank things in order of one field, if two or more entries share the same value then they receive … |
 | Hi I have a single search field ' agent_name' in a form which is a dropdown field of data based on the concatonation of 2 fields: reg_fname and reg_lname When I do the SELECT Query though I'm getting a bit mixed up..... The data from reg_fname & reg_lname does not … |
| | Hi, I would like to know how to set a character set once and permanently, since when i alter the character_set% variables that are shown on 'show varables like 'character_set%', when i alter them the next day they are back with the old values? Thank you very much Databases mysql |
 | Hello, I've built a timekeeping aplication from a fingerprint machine with automatic import to db and I'm getting some reports. One report is that I'm getting the employees time if they are late from work. But my table is small with 20.000 entries, but with the following query, the results … |
| | I'm not very good with php or mysql so I can't figure out what I'm doing wrong. I get this error: Failed 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 'tests,'20120508,'5.5,'20120508)' at line … |
| | I have an ssis package the loops through an entire folder importing records into a sql 2005 database. I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing … Databases mssql |
| | Hello Friends, I have three table ->PatientDetails ->ParentDetails ->InsuranceDetails -Patient id is the common column in all the three tables... While saving the data in table using VB.Net there is a column in PatientDetails i.e. Insured If the patient is insured then only the values from text boxes and the … Databases mssql |
 | Hey guys. Can you have a look at my queries? I can't spot the error with my foreign key linking. As of now, the table staff has already existed: StaffID char(7) Staff_Name varchar(50) Position varchar(50) And now I'm trying to create a new table called SalesInvoice: create table SalesInvoice( SalesInvoiceID … Databases mysql |
The End.