7,494 Archived Topics
Remove Filter  | |
| | |
| | Hi all - use the curdate() or current date to look at newly added awards in the last 3 months The SQL table used to store the created date when an award was added is **tbl_net_centre.reg_date** and keeps throwing up an error on the <= If anyone can advise the … |
| | I'm trying to work out how to import drupal blog posts into a wordpress website. I found a website that has a script but I'm not sure how to execute it and what I need to do. This is the website I found with the script http://www.binaryturf.com/migrate-drupal-wordpress-export-import-mysql-script/ If someone could … Databases wordpress |
 | So our server is located in Cali and we are 2 hours ahead so When I save my time to database it does it according to the local time. I tried to figure out how to use GetDate() and GetUTCDate() but can not figure out how to use it. How … Databases mysql  |
| | Hi friends! I have some trouble restoring a mysql database that I backed up with mysqldump. I have been trying to do this from a command prompt (Windows) This is my code: mysql -u root -pPassword databasename < C:\Backup\databaseNameToBeRestored.sql With this, I get the message that "mysql" is not recognized … Databases mysql |
| | I am using MySQL to plot data about a quiz into graphs for analysis reasons. I have created a series of queries (with the help of the members of this forum!) I am now saving them as routines so I can call them for efficiency. For some reason with a … Databases mysql |
| | I am running analyses on a quiz and am trying to manipulate querys in order to produce bar charts. I am trying to display a graph which shows the percentages of candidates passing a particular quiz. The query I am trying to run is as follows: SELECT QuizName, (100*(COUNT(PassFail))/(COUNT(XXXXXX))) AS … |
 | i basically need mySQL for learning JDBC connections. will be thankful to any information regarding this matter. didnt find anything concrete on the net... Databases mysql |
 | Does anyone know how to properly install MySql Server? I am having trouble installing it. It's one of the last steps for the MySQL installer package. Databases client-server mysql  |
| | |
| | |
 | hi everyone i have problem in my code i'm create datbase and table by write in php code but in my phpmyadmin it insert the database only the table dose noe exit here my code <?php $connect = mysql_connect("127.0.0.1","root",""); $db = mysql_select_db("login"); mysql_query("CREATE DATABASE login"); mysql_query("CREATE TABLE users ( id … Databases mysql  |
| | What is the procedure can be used in MS-SQL server 2012 in order to create a workflow as in dynamics CRM? Is there a way. Or what is the alternative? Thnakx in advance. |
| | I have an assignment where i should demonstrate concurrency controls.In order to do that i should work with two sessions in the same database in ms sql server. How can i do that. Databases mssql |
| | Hi I have these two tables:Customers and Bookings;Customers has these fields CustomerId,firstname,lastname etc.Table bookings has bookingId, customerId,datebooking,startdate,enddate etc.I want to retrieve customerId,first and last name from Customers and datebooking,start and enddate from bookings, I understand I have to use a LEFT JOIN.I tried everything but it does not work, coud … Databases |
| | Hi, I want to copy records of a table say employee into the same table. For Example Table Employee contains 5 records. So i want to insert the same 5 records again into the same table Employee 20 times. I have tried the following Query (which is inserting records in …  |
| | Hi to all, As a newbie, I am not able to have the following columns into a datagrid. (see database diagram attached) (I don't want to select ID columns because users may not be able to identify the students). I don't master JOINS . Infact I want to select all … Databases mssql |
 | SELECT getdatabaseencoding(), current_setting('client_encoding'), current_setting('lc_ctype'), current_setting('lc_collate'), version(); returns UTF8 UNICODE C C PostgreSQL 9.1.7 on x86_64-unknown-linux-gnu, compiled by gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit select lower('ČĘĖĮ') returns ČĘĖĮ Actually what I want is to seach surnames with ILIKE which is not working for those chars. WHy this can be? Databases postgresql ubuntu |
 | Hi group, I'm still learning Visual Basic and SQL. Please overlook my inabilities. I'm writing a module that is meant to write a small amount of data to a database. I've named these fields 'PrinterID', 'PrinterName', 'PrinterNumber', 'PrinterLocation' and 'PrinterAddress'. The user will eventually have 30 or 40 records to … Databases mssql visual-basic |
 | update drugs,drug_sales SET drugs.b_price=(SUM(drug_sales.fee)/SUM(drug_sales.quantity)) WHERE drugs.drug_id=drug_sales.drug_id AND drug_sales.pid=0 update drugs,drug_sales SET drugs.b_price=SUM(drug_sales.fee)/SUM(drug_sales.quantity) in drugs.drug_id=drug_sales.drug_id AND drug_sales.pid=0 The intention of the above 2 queries is to update a table called drugs based on computational results of table called drug_sales. The two queries fails and the error is: "#1111 - Invalid use … Databases mysql |
| | I am tring to recreate my oracle database -> sql server 2008. I never used sql server before, so I am using sql server management studio. I could create tables and views. The views I created using sql server management studio GUI has data in it. Now, I tried to … |
| | Greetings, I have a table which contains product information called Products contains fields: ProductID, ProductName, and another table called UnitsInStores contains fields: StoreID, ProductID, UnitsNumber, UnitPrice My first question is: Is it better design to put the UnitPrice field within the Products table or to put it within UnitsInStores table … |
| | Hello everybody ! There is an issue that's driving me realy crazy. I'ts about Adobe DreamWeaver and adding MySQL Data Connection (For document type:PHP). When I input infrmation about: -Connection name -MySQL server(remote server) -username -password Which all of those infos are correct i receve a http error saying: "HTTP … Databases http-protocol mysql |
| | Well i am having an interesting thing to discuss with you all people. i am having table in database where one column is having xml data with certain fields. I want to fetch those field using select query. So tell me if you can suggest something to me. Thanks a … Databases client-server mssql sql xml |
 | I want to synchronize the data on my machine with that held on a server using PhpMyAdmin. Can anyone tell me exactly what information is required on the synchronization page? I've tried loads of combinations and the, not helpful, response is always "Could not connect to the source". Any thoughts … |
| | |
| | I am trying to create a simple inventory database that can be accessed in an intranet. I need help on creating the entities for this database. To begin with I have the following entities: Equipment_Description, Department_Serial_No, Equipment_Serial_No, Model, Manufacturer, Status and Price. My first entity or table consists of Department_Serial_No … Databases |
| | here is my table in database: name qty unitcost totalcost A 1 10 10 A 3 10 30 B 2 20 40 B 1 20 20 here is what i want to view to user: name qty unitcost totalcost A 4 10 40 B 3 20 60 Databases |
| | I'm learning PHP and MySQL, and I'm trying to create a simple online pastebin website. I want to create both anonymous and logged in user pastes. I created a 'user' table with uid, name and password columns, and a 'pastes' table with pid, paste and uid columns. In a viewpaste.php … |
| | Hi all! I have a big problem that I would like some help. I use Mysql Workbenc 5.2CE. I changed the default port to 3301. The mysql server is up and running well (I access it from an app I'm making with VB.NET). The problem is I can't get mysqldump … Databases mysql |
 | I'm trying to find the errors in this sql statement INSERT INTO images(user, server, img-name, download, download-url, image-loc) VALUES(test@test.com, 3, Penguins.jpg, no, GaNfT, 69Z8PwE0uJLfRNDijPenguins.jpg) I also have an auto increment column but as I understand it you shoudln't supply a value It comes out with this error You have an … |
 | Hi to all just wanna ask how to achieve something like on show all data if a certain field on the table is equal to **2**. basically what im trying to make is a search form by the way the searching part is working it just that its showing all … Databases data-structure mysql |
 | Hey guys, I was wondering if you could tell me if this is even possible or if it can be done another way??? So i have a database with 6 tables all the databases have the same columns except for the tables name ahead of the generic headers pub_name, Hotel_name, …  |
 | $sql="select *, (select Faculty from userinfo where Faculty=$college) as category from award where HonoringYear=$year"; $rs=mysql_query($sql); return $rs; |
 | Hey everyone! I have a members.php page/file in which i want logged in users to see the other users registered in the database. I'm not exactly quite sure how to do this and I'm struggling quite a while now with this so your help will be VERY much appreciated. I … |
| | Hey everyone, I have a query that is to return a set of rows depending on its WIPDataValue. Say for example, I have added new WIPDataValue which is 1-9. So obviously the resulting set should have 9 rows and on those 9 rows, the value of each is 1-9. This … Databases oracle |
 | Good day, I am having troulbe with my computation here. i want to compute for the Custom_Haulage_In_Transit but when i exec my sp the value of the Custom_Haulage_In_Transit is 0. can anyone help me with this please.. here is my code SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant … Databases sql |
| | Hi I have a site built on Wordpress which has a over 4,000 posts all with the suffix -2 at the end of the post name (due to me forgetting to clear the trash) before running an import). I would like to remove the -2 from the post names with … |
| | # Given a UNF normalize upto 3NF: # UNF: (booking_ref_no, booking_date, student_no, student_name, student_address, student_tel, course_code, course_name, course_level, course_start_date, course_finish_date, course_cost, lecturer_name, lecturer_no, center_name, centre_phone, class_size) *Here's what I got after 3NF, could some one verrify whether is the right way?* BOOKING: ( booking number (pk), booking_date, student_number (fk)) STUDENT: … Databases |
| | Looking for assistance in, as the title reads, accessing an Access database via PHP when the database is open. (Please bear with me as my knowledge of PHP, when used in conjunction with a database, is extremely sketchy at best.) Using the code below, I can pull up a directory … Databases php |
| | Hi I need to change number ordering in table: This is original: SELECT MAX(`number`) FROM `'._DB_PREFIX_.'order_invoice` It selects max number from column. Now I need to change Invoice number to start from 1 again, now it is on 110. Should I create new table and start from one or what … Databases mysql |
| | Hi to all, I want to install SQL SERVER 2008 on my XP 32-bit OS. After clicking on "New SQL Server stand-alone installation or add features to an existing " link unser installation tab, Setup Support Rules window shows success status of all rules except "Restart Computer". It neither directly … Databases client-server mssql sql |
 | Please help me im new in making database i dont know what tables will i create and its content pls.. 1. Develop a database design for a Student Attendance Management System. Create an ER Diagram to illustrate the relationship between the entities in your database. Below are the suggested list … Databases microsoft microsoft-access mssql  |
| | Hi there, I am a complete newbie and need help with normalization and ER diagram. here is the case study: a college specializes in providing foreign language courses at various levels to the general public. it consists of several local centers in and around the city. at present, course enquiries … Databases |
| | Hi need some help suggestion I am trying to search data form two date range but it seems not working properly when i search for $from_date = "2013-04-01"; $to_date = "2013-04-04"; $query = mysql_query("SELECT * FROM date WHERE Date between '" . $from_date . "' AND '" . $to_date . … |
| | I am trying to implement a Login validation using C# 2005 in ASP.net 2.0 web application. The SQL Server database contains a table named "UserList" with columns LoginId, Password and Role. The Login webform should authenticate the LoginId and password and depending upon the Role assigned to that user/visitor should … |
| | hi everuone i have website but i cant connect to database for login & register how can i connect? here my code <?php $connect=mysql_connect("184.154.164.202","ahmedhay_royal","xxxxxxx") or die("couldnt connect to data base:".mysql_error()); mysql_select_db("ahmedhay_login",$connect) or die ("couldnt find data base"); ?> |
| | am doing project in c++ using mysql api i have update query like that q2<<"UPDATE `dorder` set `ddown_status`= 1 WHERE `Machine ID`= "<<"'"<<xbx4.mid<<"'"; > but when i execute it , its says Unknown column 'ddown_status' in 'field list' but ddown_status coloumn already exisits in dorder table , so any idea … |
| | Good day, I am having trouble with my condition, i dont know where should i put where in my query here is my code.. SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant ,Order_Quantity ,Held_by_Finance ,Rejected_OOS ,Rejected_Others ,ISNULL(Open_Order_Quantity,0) AS Open_Order_Quantity ,ISNULL(Order_Quantity_NKA,0)as Order_Quantity_NKA ,ISNULL(Order_Quantity_RKA,0) AS Order_Quantity_RKA ,ISNULL(Order_Quantity_Others,0) AS Order_Quantity_Others ,ISNULL(Stock,0) AS … Databases sql |
 | Hi, I would like to know how to find duplicate records based on exact match on some columns and slight difference on others... for example, I have a table with the following fields 1. Name nvarchar(50) 2. City nvarchar(50) 3. State nvarchar(50) 4. Age int(10) Now, I wish to search … |
The End.