7,494 Archived Topics
Remove Filter  | |
| | I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get … Databases client-server linked-list mssql sql |
 | Hello there, I am trying to make a sample website just to learn the basics, I already have a log in window and a home page but I want to add a featur in which users can sign up for it. My first option wuld be to use SQL but … |
| | i hav just installed oracle 8i on my laptop but i am not able to open the sql plus what is the user name & password?? i hav tried scott &tiger but not working please reply soon |
| | hi guys, quick question. i have 2 tables. Client Table: ClientID INT PK AI, ClientName VarChar Folders table: FolderID INT PK AI, FolderName VarChar, client_ClientID INT The issue i have is that i have created this virtual folder appliaction in the site and have created it now where when they … Databases mysql |
| | I'm having a hard time to return a string value. I usually do this by passing an int, which works just fine. Now, I need to pass a string but couldn't. Is this possible? Or int is only type that SQL can return? Databases mssql  |
| | hi, i opened two mysql sessions(A,B) and set the autocommit variable to 0 for both the sessions. by giving "set autocommit=0" then in session A i added a row to my table by calling a stored procedure and i tried doing the same in session B also.. but in session … |
| | Anyone want to help me with this SQL-code? [url]http://pastebin.com/VWnJmM34[/url] I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it?  |
| | I'm a beginner on MySQL. I tried to run this statement [CODE]SELECT* FROM address WHERE email=a@abc.com[/CODE] but it shown an error message. What's wrong? |
| | can someone help me to write a query that will sum the information across the row and down the column (sum) in ms access table a b sum 1 10 11 2 20 22 total_all I tried the following select a,b, sum as (a+b) from table1 the error i get … Databases mysql |
| | Hello all, I'm I am very new to using MySQL databases and came across an error that I need help with. I'm trying to make a simple Connection file in php to connect to one of my databases and it keeps giving me this error:"Warning: mysql_connect() [function.mysql-connect]: Access denied for … Databases mysql |
| | HELLO, in my database, i have the following table: video_hire([U]vide_hire_id,[/U], hire_date, video_code, Cust_membship_no, returning_date, hire_cost) video_code is (fk) ref: to VIDEO_LIST, cust_membship_no is(fk) ref: Customers IM TRYING TO code a PROCEDURE or FUNCTION TO to calculate the ammount of hire from one customer, and print the total, as well the … Databases oracle |
| | Hi, I'm designing a schema to store church records and have hit a snag trying to figure out the kind of relationship between a church member and their spouse if the spouse is also a church member. Here's my scenario: A church member can have only one spouse, the spouse … Databases |
| | Hi everyone, Can someone please explain how to determine cardinality ratio for a relationship. For example; In a database for a hospital there is an entity Doctor and Patient. One or more doctors will treat a patient. So, is the cardinality ratio between Doctor and Patient is M:1 (one or … Databases |
| | w whyhi i keep getting this warning and i dont know why [QUOTE]Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /users/2014/daf1/public_html/cs1109/lab18/adding.php on line 13[/QUOTE] [CODE]$add_topic_res = mysql_query($dbconnection, $add_topic_sql) or die(mysql_error($dbconnection));[/CODE] if anyone could help me it would be great cheers Databases mysql |
| | Hello, I have a MySQL database with 3 tables. Each table contains a list of persons, and each table represents the level of a person. For example, tbl_level1_p, tbl_level2_p and tbl_level3_p. Level 1 persons have level 2 persons under them, and level 2 persons have level 3 persons under them. … Databases mysql |
| | Hello Can someone please help me with getting a better understanding of dependency theory using Armstrong's Axioms? Thank you Databases database-design sql |
| | I am having some trouble. I have a Linux Server hosting 5.1 MySql. The Windows clients are running a POS Program written in C# using the .Net Connector. The Problem is that the initial connection takes around 12 Seconds which is not a big problem, but when you let it … Databases mysql windows-server |
| | I've done some research on JOINs and UNIONs but haven't achieved what I want to do since something I do must be terribly wrong. I have the following SQL-statement: [CODE] SELECT posts.*, channels.channel FROM posts INNER JOIN channels ON posts.channel_id = channels.id ORDER BY posts.created DESC [/CODE] What I want … Databases mysql |
| | hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, … Databases client-server mssql sql |
| | |
 | Suppose I have two tables: [CODE] Table1: Pets PetID----------|Name----------|Type----------| 1 |Shaz |Dog | 2 |Molly |Cat | 3 |K9 |Dog | 4 |Billy |Goat | ______________________________________________ Table 2:PetAttributes PetID----------|AttributeName-|AttributeValue| 1 |HairColor |Black | 1 |Breed |GermanShepherd| 1 |Age |12 | ______________________________________________ [/CODE] As you can see from the sample, the … Databases mssql |
 | Hi, I need to create a sql query that will return the sum of the total number of records in the t1 and t2 tables. Any ideas how to do it? Thnx in advance Databases mysql |
| | Hi all, I have a table where it stores Process. The Process has each processNumber which is unique, & the processNumber indicates the step of a procedure. My problem is, user request to add a Process in between existing processes. In other word the new Process overwrite the existing process … Databases microsoft-access |
| | I have problem with SQL query. I have table in my database which stores attendance of students. It has fields Teacher_Id, Roll_No, Date, Present('0' if student is absent on that date and '1' if present). I wrote following query SELECT count(Present ) , sum( Present ) FROM attendance_info WHERE Teacher_Id … Databases mssql  |
| | Hello folks, i need help for a query.. I have 2 tables .. user table: useridid city and another table, the reward table : userid reward points , I want to sum up the points according to the city and list them.. Any ideas ? I am loooooost .. Thank … Databases mysql |
 | Hi, I have one simple problem. PHP (CodeIgniter) code: [CODE=php] $query = $this->db->where('filename',$filename)->select('valid_until')->get('jos_reklama_banners'); $row = $query->row(); $valid_until = $row->valid_until; if($valid_until > time()) { $sql = "UPDATE `jos_reklama_banners` SET valid_until = valid_until + ? WHERE `id` = ?"; $query = $this->db->query($sql, array($days*86400 ,$filename)); //viena diena 86400 sekundziu //echo 'daugiau'; } else … Databases mysql php php-codeigniter |
| | Hello I am looking to dump data from a MySQL database to an excel spreadsheet. I know I can dump it to a CSV file and import that way, no problem. But I want to dump the data to a specific spreadsheet in an excel and specific cells. I have … Databases microsoft-office mysql php |
| | Hi all, I am trying to select multiple rows from the database and then separate the rows into array values so I can use them throughout my code. This is what I have right now... [CODE] $result = mysql_query("SELECT url, image, placement FROM advert WHERE user='1'") or die(mysql_error()); //This grabs … |
| | Hi Guys I have an e-commerce website. Two of the columns are for the pricing of products. What I would like to do is update the price ('prodprice') directly from the cost price ('prodcostprice'). It would be nice to set a certain markup according to price range. eg. $0-$1000 = … Databases mysql |
| | There are two server 1)192.168.*.* 2)192.162.*.* In first server there is database call department which contain table called [B]employee[/B] Now i want to copy the from above to second server in database company which contain table [B]employee[/B] Databases mssql |
| | Hy. I'm trying to do a select from multiple databases and tables for an occurence. let's say i have databases db1, db2 and db3. Each have the following tables t1, t2, t3. And in each table there is a field named id which i want to select and a field … Databases mysql |
| | Hi, I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some tables with the same names. Schema A A.Customer A.Product A.Invoice Schema B B.Customer B.Product B.Incoive My first problem is actually configuring Replication on the publisher using the … |
| | Hey guys! I'm a newbie at databases and ER diagrams, and I need help with describing [URL="http://img194.imageshack.us/img194/521/38770389.jpg"]this ER-diagram[/URL]. I'm having problems with describing "Wine" - "Stocked" - "Inventory". I've learned that "Stocked" is an identifying relationship type and that "Inventory" is a weak entity type. But I have no idea … Databases |
| | Hi All, After searching the web and this specific forum I can't seem to find a suitable solution to my problem and after hours of thinking I wasn't able to come up with a solution that will fit the problem. This is the case: I need a database model that … Databases database-design web-design |
| | I would like to create a Player database and link this to my website game how do I do this and what is the best application to create this in? Thanks in advance. Databases database-design |
| | Hello, How to use date function in my sql for current date. Table description: jid desc cname category date(posting date) 1 kpo job ab kpo 7/3/2011 2 lpo job bc lpo 8/3/2011 3 bpo job df bpo 9/3/2011 What i want to do, when i fetch data from the table … |
| | I would like to retrieve the previous date (i.e., current date minus 1) and use it in a query through an = operator. I got the following query to retrieve the previous date: [icode]select DATEADD(DD, DATEDIFF(DY, 0, GETDATE()), -1)[/icode] It gives: 2011-03-14 00:00:00.000 I would like to get only: 2011-03-14, … |
| | hi pls help me on this.. i'm using this code to get data from record: [CODE] MyNum1 = DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]") OutTxt.Value = MyNum1 [/CODE] my prob is when the data in [Outcome] is null , access having error to still get the null value from the … Databases microsoft-access |
| | Hello everyone! I'm trying to get a date from SQL without the year. Every code I've seen has included the year. Here is what I have now. [CODE]SELECT * , convert(CHAR, \"date\", 10) AS ndate from dbo.MYDB where 35 > DATEDIFF(d,\"date\", GETDATE())";[/CODE] I would like ndate to be show like … |
| | I have an SQL Server Query: select *from table1 where column in ('list of values') When I execute this, I get all the details, however, when I do this: select *from table1 where column in ('list of values') and date_of_req='2011-03-15' I get an empty table. All the column headings are … |
| | i installed Oracle 9i.when i go Start->Program->Oracle-oraHome90- i did not get Isql * plus.Kindly let me know the idea.Any help would be highly appreciated.Kindly find the attachment also. Databases oracle |
| | i m facing problem while conencting with sql server mangemnet studio A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. … Databases microsoft-access sql windows-server |
| | Hey all; I'm working on a forum/blog engine, and I basically want some opinions on whether or not I should separate the forum and blog as two separate entities or combine them into some hybrid type of table. At the moment, I'm working on the ER diagram, and they're separate, … Databases database-design |
 | the language is vb.net, but it is more of a mysql database question. I have a table that holds customer repair information (where it is, whats going on, if it was completed, etc). the table starts with a basic auto increment ID, the id is used to view the repair … Databases mysql |
| | Hi friends, I am planning to develop a local hotel search engine. ive prepared the dbmodel and i've attached it with this thread. please help me to write search queries for searching hotel. there are 11 tebles country,city,state,block,street,landmark,address,hotel,rooms,and amenities . please go through the model i've attached and help me … Databases |
| | Hello guys, I have two tables with the following structure: TABLE A: Email Address, CampaignID, Source, Unsubscribe Email1,2 Email1,1 Email1,3 Email2,5 TABLE B: Email Address, SeedList, ListName Email1,SeedListA.SeedListA Email1,SeedListB,SeedListB Email2,SeedListC,SeedListC The purpose is to merge the two tables together. But there is a really strange rationale behind this merge. If … Databases mssql |
| | Hi all, I need some help with defining a recursive relationship in a ER diagram. It is a part of my assignment and the below is quoted in the case study. [QUOTE]Admin staffs are in-charge admitting inpatient to the hospital. Several nurses work in each ward and one of them … Databases |
| | Hi everyone, I am having an issue with a query i am doing for an assignment, i have made an attempt but i know i have not done it right. below is the table structures: Customer: CustomerCode,[pk] CustomerName Movie: MovieCode,[pk] Name, Rating Video: VideoCode,[pk] Name, CustomerSoldTo,[fk1] MovieCode,[fk2] What i have … |
 | Afternoon All, hope someone can help as this is really doing my head in. I have a SQL View which has a field called MOP/T which shows the number like so 28.5140299679490 349.893390000000 349.893389892905 I want to format that field so that it only shows the number before the decimal … |
| | Hi I have a join query which I use for a report ok I have a query to give me results for a report that will give me all the stores that sold policies from a group during a period. It works however I cannot get it to give me … Databases data-structure mysql pdf php |
The End.