Databases Forum

Hello all! I have been told for many reasons that when a user wants to end their account on a website, that you shouldn't delete the user out of the database for awhile. So if I need their information to be off the Internet, but still remain in the database, …

we are able to query successfullu from a Column called "ParentUUD" (without space) using query "SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'" we have a column whose name is "Parent UUID" (with space) We are trying to query the column from PYTHON. we are getting error.I think the error …

Hi i was making this code so I could connect to my server and run a database: [code=php]<?php mysql_connect("localhost","root", "samiscool"); mysql_select_db("test_db"); $sql = mysql_query("SELECT * FROM test_table"); while ($rows = mysql_fetch_assoc($sq1)) ( var_dump ($rows) ) ?>[/code] and this eror message came up "supplied argument is not a valid MySQL result …

i changed my password in mysql using the mysql server instance config wizard from the start menu. once i changed it, the access is denied to view all the database in phpMyAdmin.. #1045 - Access denied for user 'root'@'localhost' (using password: NO) - this error appeared in the screen. i …

i'm using Macromedia Dreamweaver MX, and i fail to connect with mySQL database . any tips ?? pls help .. :confused:

Hi, I recently started learning data modelling and can anyone pls advice me where can I find some examples to practise the conceptual modelling ? Thanks.

Can anyone help me on this I recently installed MS SQL 2005 Developer on my PC (XP Pro)and that works oK. I installed another on my Notebook (Vista Ultimate) and somehow got connected to my PC Database. But that is cool. At least I know I can connect to my …

Hello I am new in this. Just installed MS SQL 2005 on my notebook for learning purpose. I found that though using the default instance, it keeps giving me a logon screen which I am having problems loging in with Server Name: JMZCONS-PC Error Number: 18456 Severity: 14 State: 1 …

i am using oracle 10g along with php 5. the problem is i cannot connect with oracle database from php with the function oci_connect. i can understand that this is because of the way php is configured. can anyone help me configure php to connect and manipulate oracle database?

How do I upload an Excel or CSV file into a MySQL database. I 'Googled' it and tried a couple things but nothing worked. Appreciate any help

Hi All, I have put together a service delivery application in Access that needs to send SMS messages to technicians in the field. Any ideas on how I may achieve this? Regards

I have a datetime column in a T-SQL table that I need to sort desc. However, when I do this the NULL values for that field will show up at the bottom. I need them to be at the top of the list, while still having everything else sorted in …

Hi i want need to fetch sec highest marks from given tables. my database design is like: My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (pk)Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, Sub_id And i come up with the query: Select Student.stud_id, Student.stud_name Max( …

Hi everyone.... Could anyone tell me... I have a C++ program, source and exe. And I have a txt file that acts as a database. That program reads and operates with that database and is intended to be useable on my one site. Now... what I want to know is... …

Hello, I have a problem that someone can hopefully help me with. I have a page where Make, Year and Model menus are dynamically created via mysql. Upon selection, the user presses submit and those values are fed to the database where the production numbers for say, a 1958 Plymouth …

Help - I am fairly new at MS SQL, but understand the concepts and have looked at the code in MS Access many times. But here's my problem: I need to create a complex query across multiple tables within the same database, but I'm just not sure how to do …

Hi, Stored proc code below works fine in MySQL command prompt. It returns John because it is in table. However, i can't return or read the Out parametter in PHP. I mean i cant retrieve John. I did ask this in PHP forum but no answer. [code] CREATE PROCEDURE `findname`(IN …

Hi I've used Access to model a new database that now needs to be created in SQL Server Express. Wow - that's alot of data types! Can someone tell me what the SQL version of the Access Memo data type is? Thanks _________________ [url=http://www.freefixit.net/monitoring-parental-control-software-advice/]Parental control software[/url] [url=http://www.loans.cc]free parental control software[/url]

My database knowledge is pretty limited but im hoping this will work...... The idea is to have a database for customers who have their grass cut fortnightly. The database will be mail merged to form bills every month or so... So far I've constructed a database with the following tables: …

I have one question! How can i check form fields against the database and then display an error! Please help me for example go to mycsmi.org There is a form on the index.php page .... a user submits the info to the database but what if there is a duplicate …

Hi, I want to create a DataBase Diagram using MS SQL Server Management Studio 2005. But on context menu of DataBase Diagrams Folder, I am not able to see New Database Diagram menu item for any of the Database. I am getting only two menu item "Working with Sql server …

Validating form field with table fields in MYSQL through PHP .... how do i do that!

I wasn't sure if this should be in the MySQL or PHP forum. I have a database to enter student info for a school (it's a detention list - I'm the VP) I have a form to update records in a database as each student is assigned detention. It only …

Hello there, I am having trouble with a form/database. I have 3 age groups that needs to be sorted into 3 separate tables. Users fill in a form (dropdown list with the separate age groups) and when they click submit, the data gets sorted in tables on another page. With …

how do i select data from a table by sorting the first word from a column? for example: "user1 hello" "user2 one two three" "user3 where are you" "user1 im fine" how can i select all the data starting with "user1"?

Hi There. I'm just hoping someone can answer a question for me, as although i have been a IT Network Administrator for a long time, I know very little about web design/database design. I'm currently in the process of setting up a website to will contain a very large amount …

hi for all....im sabeel... here's my prob.... i have a column named date select date from blabla returns all the date i need to select duplicating dates from blabla.... what is the function to find the duplicating data..? thanks in Advance....:-)

hi, im new to this platform.i want to know, how can i insert the url link into a mysql database? and also php query also.some help me....

I have a from that displays an employees info when selected from a list. The employee then updates text boxes as well as combo boxes to describe a type of project they are working on. I'm trying to add what the employee selects to the Project table. Here is my …

I am using phpMyAdmin and as I delete a row, it stuffs up the auto increment once I insert a new row. Example: Delete - 21 Insert - 22 (should be 21) Thanks, Regards X

Hello, I'm writing my first model and I wonder if someone can make sure it will work for my project. My one concern is that I had a fan trap and my solution leads to a potential chasm trap. The objects are going to be business listings. Business listings may …

I've developed a software using VB6 and MSSQL 7.0. Now I need to create a backup-restore program on behalf of my software. For this I need to fetch down all the table names located inside the database used in the software. My database name is -->BILLING_SYSTEM and I've also created …

Hi, presently i am working on mirroring in between two servers of mysql.can you please provide me a code to do mirroring

Hi, i don't know how to do the following or even if it's possible. These are 3 tables from my database sport: [team]-|-----<-[team_match]->-----|-[match] [LIST] [*]Team: [LIST] [*]id (int) [*]name (text) [/LIST] [*]Team_match: [LIST] [*]match_id (bigint) [*]team_id (int) [*]score (text) {this is not an integer because it can contain "f" for …

Thanks in advance for anyone who can help me with this query. I want to select all from table one and the matching image from table two. Using the following inner join query works great: [code] $result=mysql_query("SELECT * FROM members inner join avatars on members.user_id=avatars.user_id where members.user_id ='{$user_id}'");[/code] but if …

Hi all... Let's say that I have a database with two tables: departments (dep_id, dep_name) & employees (emp_id, emp_name, dep_id). I need to select the departments that have the employees with ids 10 AND 20. How do I do that with SQL? Note: The following is NOT what I want: …

I'm doing an internship, and my managers require me to create a form using Oracle WebForms. What I don't get is that when I searched Oracle's website, I can't find much information about Oracle WebForms, but I can find a lot of information about Oracle Forms. And when I played …

I am working in an organisation. In this we want to create a database in MSAccess (MSoffice 2003) about the system information about the computers. By using one software we have the following inforamtion in text format. In this, We want to craete the first part as the field name. …

Hi, I need help on this sql. I have a table a and b and i need to select where a.id=b.id and b.mid=1 and few hardcoded a.id which does't exist in table b. i used left outer join but its still listing all in a table. Can anyone help pls. …

I support a jet 4.0 database application that is deployed out to multiple users. These users have different types of Windows Operating Systems. There is some support from the vendor for this system, but they are not able to answer all problems. The data files live on a central server …

Hi all, I need to import a database (currently in excel) to Mysql. I searched a little and found out that CSV files can be imported. However, there is a problem that I am facing. The delimiter for fields in a CSV is a ',' obviously. But many of the …

hi all,can anybody point out wats wrong in my database design, guide me right database ,i ve 4 tables i type all its attributes its for hospital database patient table pid, pfname, plname, pcontactno, page, pplace ,pdocname, pprob ,ptype(this is for out patient,inpatient), pbill. doctor table docid ,docname, docplace ,doccontactno …

hi, i ve hospitaldb created in MYSQl, i have connectivity problem like[CODE] String connectionURL = "jdbc:mysql://eall:3306/hospitaldb"; // declare a connection by using Connection interface Connection connection = null; // declare object of Statement interface that uses for executing sql statements. PreparedStatement pstatement = null; // Load JBBC driver "com.mysql.jdbc.Driver" Class.forName("com.mysql.jdbc.hospitaldb").newInstance();[/CODE] …

Hi, I just want to retrieve name of the employees who have two or more than two email_id in employee table. pls help me out..

Im a newbie, I have compiled apache and mysql in the same server;i need to host a site that has perl scripts and the database linking .How to integrate the mysql server to apache for smooth functioning of this site??

I want to know the disadvantages in keeping a 'dedicated' Database Server. I asked my professor, and he told me tht having a dedicated database server will mean tht there will always be a DNS look up.....which will increase the time required to talk to the database. Is it always …

hi friends.. i'm studying mca(5th sem).. this sem we've a middleware project which connects 3 different databases.. yet now i used only one database.. so i dont know how to give datbase link.. i've googled.. but none has explain that clearly(not upto my satisfaction)!! can anyone give an idea how …

Hi I want to write a query In my table data like this sapno plant amt status a SG20 7 1 b HK10 24 4 a HK10 60 4 b SG50 20 12 a HK10 7 4 c HK10 7 4 if more than one sapno is same value then …

Hi, Thanks for checking this out. My goal is simple. Create a list of all the years that have had articles published in them (so basically every year). I have three unique dates in the date column, 2008-08-20, 2007-08-20, and 2006-08-20. The code below only returns this as the print_r …

Hello everybody,, I'm developing a web application using ASP.NET and i'm new in databse (basic knowledge:) ) ,,and i have to create a table that stores any changes made in the database tables includes (insert,update and delete) ,,i googled about how to do it and i found many articles about …