2,403 Solved Topics
Remove Filter  | |
 | My company has been using an Access 2003 database for a couple years now and the person who previously worked on it just left, the problem is he never gave me the password to unlock the Visual Basic editor window, and I can't seem to contact him. Does anybody know … Databases microsoft-access visual-basic |
| | Hi, I have a derived attribute in my table and I'm sorting the table in the descending order of this attribute. My query should retrieve all the tuples which have the maximum value for this derived attribute. If I use SELECT TOP 1, I'm only getting one of the required … Databases mssql |
| | Hi all! I'm trying to write a "last login" message in my login script. The plan is to store dates in the database with UTC_TIMESTAMP and then show them back to the user with CONVERT_TZ, using each user's specified timezone (they have set that on registration). However here lies the … Databases mysql |
| | The two queries are returning two different no of rows.Outer join is not supposed to duplicate the rows in the first table right?How do I correct this. [code=sql]select * from clientcode order by cc_clientcode result:(5627 row(s) affected) select cc.cc_clientcode,cc.cc_rmcode,cc.cc_panno,cc.cc_productname ,c.Client_panno,c.client_userid from clientcode cc LEFT outer join client c on cc.cc_panno=c.client_panno … Databases mssql |
| | Hey guys, quick question. I have a movie table which records information about certain movies. See below for the table structure. id Title Length ------------------------------------------- 1 American Pie 160 2 Van Wilder 115 3 Not Another Teen Movie 115 4, Road Trip 130 5 Shawshank Redemption 130 6 Scarey Movie … Databases microsoft-access |
| | I've got this site that I've been working on that functions very similar to Digg/Reddit. Users submit headlines and the rest of the community either upvotes or downvotes them. Right now I'm just setting a cookie every time a user votes on a story, but this only lasts for awhile, … Databases mysql  |
| | I am currently working on this table. It will contain the transactions made. But the transaction varies, it may be a purchase order, transfer from inventory, rental, etc. I have different IDs for each type of transaction (e.g POID, TFID, RENTALID). My question is, should I place all of this … Databases database-design |
| | I have a really weird thing happening in my database. It used to work fine but all of a sudden now when I preview the report, it shows up too large. Please see the pictures to understand what I mean. I have tried undoing every change that I had made, … Databases microsoft-access |
| | Hello, I would appreciate if anyone could help me with this. I'm new to this sort of thing and don't really know where to start. I have a survey results table that looks like this: [CODE]user question answer Mike 1 2 Mike 2 1 Mike 3 5 John 1 5 … Databases mssql sql web-server |
| | Hi, first post, and am a real novice, looking at the problems and solutions posted here. I have a database (Access 2003) where I want to change the name of a field within a query (to be used in forms and reports), depending on a decision the user makes. Can't … Databases microsoft-access |
| | Someone please enlighten me. I am just beginning to experiment with mysql and php on websites. I just took over a new site that had an exsisting sql file. I need to add a new table to the database and can not figure out how. If I just open the … Databases mysql |
 | Hi Everyone, Is it possible for a table in MySQL to be updated on a regular basis from an Oracle database? |
| | Hey Guys, Thanks for taking the time to read this, I have the following, rather complicated queries that I am trying to join, and I've spent the past two days attempting to do so, but had no luck so far so any help would be very much appreciated. I have … Databases mysql |
| | Hello, I've been given the task of transferring a website from one server to another. Unfortunately the website was written in asp and is linked to a MS SQL database and I haven't had much experience with either. It was using a MS SQL 2000 database but the new host … Databases client-server mssql sql |
| | I need to write a stored procedure to analyse appointments for the last 12 months. I need to get each salesperson (by ID) and for each person carry out a count of the number of appointments and count them by outcome (sale, second meeting , failure etc.) and then display … Databases mssql |
| | OK this is driving me mad and it needs to be done for a deadline. It is just a simple query to update a few database fields. Here's the PHP for it. [code=php] $sql5 = "UPDATE videos SET title='$new_video_title' WHERE artist_id='$i' "; $query5 = mysql_query($sql5) or die( mysql_error() ); $sql6 … Databases mysql |
| | Hi all, I hope someone can help me with this. I have been racking my poor stupid brain for days over this. I need a way to be able to create a view of the data in a single table. Let's call it tblStatus. Here is a list of fields … Databases mssql |
 | Hello Friends... Tell me how to store my product information in xml file using php ... Is this is a replacement of my database... Please tell me any information on this... Thanks in Advance.. Shanti |
| | Hi, first of all sorry if I post this in the wrong section. Cant find where is the VBScript Section. I'm new to VBScripting. What I need is the VBScript to count the number of record in my MSAccess table. I tried [ICODE] total = "SELECT COUNT(*) FROM Product" [/ICODE] … Databases microsoft-access vbscript |
| | Hi there, Just joined the community! Been having trouble all day with the following select statement and MS Access database: [SELECT * FROM client_referrals WHERE client_id = 1 AND ((date_of_referral >= #9/21/2008#) AND (date_of_referral < #9/28/2008#)) ORDER BY referral_lastname ASC] The [((date_of_referral >= #9/21/2008#)] section of works, so all dates … Databases microsoft-access sql |
| | Hi, I have a problem. I would like to, from a text form, filter out what the user wants to see. I have a mysql database with info on every order placed. Each row is a new order. All users has their own ID. I would like the users to … Databases mysql |
| | Hi guys, i need some help with a too complaicated query for my little brain. I have the following query: [CODE]$query = " (SELECT pic, text, main, gr, min(nr) AS nr FROM info WHERE (gr>0) AND (stl LIKE '$stl') AND ((quantity >= 0 and utg!='J') or (quantity > 0 and … Databases mysql |
| | Hi, I've got a major headache with a SQL Union statement. Basically I'm running a SQL Union statement in ASP that is not returning the first few unions. But if I run the SQL in enterprise manager it runs fine. I can't find anything on the web that even remotely … Databases asp mssql open-source sql web-server |
| | Hi, newbie here just been going through the "Sam's Teach Yourself - PHP, MySQL" book. I've retyped the code for viewing records in an address book. My problem is this line appears to have a problem. Does it look correct? [CODE]$get_list_sql = "SELECT id, CONCAT_WS (', ', l_name,f_name) AS display_name … Databases mysql |
 | I'm working with MS SQL Server 2005. I am trying to add two columns together, and I have more or less succeeded. However, it obviously adds the entirety of each column, rather than calculating for each row. I can't just include each column in the original SELECT statement, because it … Databases mssql |
| | Hi Friends I am working to draw a graph . I need to get the data monthly, for example JAN total hours FEB total hours , How to write the query get the total values per month? Advance thanks for your reply. Databases mysql |
| | I am looking for some database software I can use on my website. Some type of software that is just like forum software only scaled down without the members posting. More or less looking for something were I can easily post and update items all formed in a database just … Databases first-post  |
| | I have setup the following table:- [code] IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TlHold') DROP TABLE THold GO CREATE TABLE THold ( pid int NOT NULL IDENTITY(1,1), TS NUMERIC(2,2) NOT NULL, TR NUMERIC(2,2) NOT NULL, TB NUMERIC(2,2) NOT NULL, TP NUMERIC(2,2) NOT NULL, TP2 NUMERIC(2,2) NOT NULL, filler1 … Databases mssql |
| | Hello all! I have a few questions about putting images into the database. I have chosen to put the images on my server and then the location will be put in the database, instead of doing the blog thing. However, I am having a hard time trying to figure out … Databases mysql web-server |
| | Hi, I want to create a form with 2 textboxses(starting number and ending number) and 1 button. When i click on button it is going to list all the records between two numbers in a report. How can i do this? Thansk Databases microsoft-access |
| | 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, … Databases mysql |
| | i'm using Macromedia Dreamweaver MX, and i fail to connect with mySQL database . any tips ?? pls help .. :confused: Databases mysql |
| | 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? |
| | 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 … Databases mssql |
| | 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( … Databases database-design mysql |
| | 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... … Databases |
| | 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] Databases monitoring-software sql  |
 | 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 … Databases mssql |
| | 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 … Databases html-css linked-list mysql |
 | 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 … |
| | 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 … Databases mysql |
| | 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 … Databases database-design |
| | 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] … Databases mysql |
| | 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 … Databases mysql |
| | 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 … Databases asp.net mssql web-server |
| | Hi Code below generates this error "Table 'sis_audit.pay' doesn't exist". [code]UPDATE pay SET Ref='111', date='2008-11-11' WHERE id=29[/code] When i create same table in different database, no error at all. Why? Thanks Databases mysql |
| | i am assigned to convert data from microsoft excel to mysql... pls tell me how. pls help. thanks ! :( Databases mysql |
| | Hi, How do we save person's pictures in database?Do we just create column "pictutePath" and enter this value "../pictures/user1.jpg" for each person or is there any other way? Thanks Databases mysql  |
The End.