7,494 Archived Topics
Remove Filter  | |
| | select convert(decimal(5,2),(7058/7482)*100 ,0) is showing .00 value in sql server 2000. Why ? How to retrive value with decimal part, plz. guide me. Thanks & Regards Girish Databases mssql  |
 | I want to generate a code that will automatically take the poll-id..of which the user wishes to view the result of that poll. there's the code:using mysql & java & another thing i wish to use this on a jsp page: [code] package votepiepack; import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; … |
| | The program I use is housed in a SQL Database. What I am trying to do is term Members based on meeting 2 guidelines (PCP and Insurance). WHat I want to do is term a group of members that have the same PCP and Insurance plan. This data is broken … Databases sql  |
| | Hi guys, The question I need to answer is [quote]This query is about patients who got the same illness on the same day. For each pair of such patients, display one row showing the illness code, the date of onset, and the patient number of each person involved, e.g. FLU … Databases mssql |
| | hi all! I need to set precision to the left of decimal. For the number field i have to set the field precision such that the nos should be in a format as 0001,0002,0003------------------.9999. Thanks Databases microsoft-access |
| | Hi, I have a parameter queery which asks for "Name " . I want to Enter a few characters and find similiar full names to it which are in the field "Names". For example: If I type chr it should find out "christine" Pleae help Best regards Nadeem Databases microsoft-access |
| | [code]Set rstDeps = CurrentDb.OpenRecordset("SELECT Members.OrgID, Members.ID, Members.Member, Members.PrimaryRep, Members.MembershipType " _ & "FROM Members " _ & "WHERE (Members.Member=True AND Members.OrgID=" & !OrgID & " AND Members.MembershipType='" & !MembershipType & "');")[/code] This is my query in VBA in MSAccess. I just want the number of people that fall into those … Databases microsoft-access |
| | I have a school problem, I'm not going to try and hide it. This is for Oracle9i: [URL="http://www.daniweb.com/techtalkforums/thread70629.html#"]SQL[/URL] class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. … Databases oracle |
 | I'm not entirely sure If this is going in the correct location. What I want is to set up my database so that it will updated every hour. I'm a little unsure on how to tackle this problem. Does oracle actually support this type of updating, and if not, would … Databases oracle |
| | i have to call a stored procedure that shoud return all data in a table. so how to create procedure and how to return data from procedure. kindly send me a small example program ......... Databases oracle |
| | I am using MS Access 2003 to link to an Oracle 10g table utilizing Oracles 10g ODBC driver. When I view the data everything is fine except for the datetime field (which is also an index on the Oracle side). Access shows a value of "OLE object" in this column … Databases oracle |
| | Hi everybody! I am Daniel and I am developing a Alumini Database right now using MySQL and Ruby On Rails. First of all, I must say this is an amazing forum. I really enjoy reading the posts. I hope you will be able to help me. I have the following … Databases database-design ruby |
| | Hello All, I am working on a database, and have doubts in two fields (startpoint, and endpoint locations)therefor want your comments and suggestions, my database tables look like the following: [Projects table:] project_id project_name startpoint_location_id startpoint_latitude startpoint_longitue endpoint_location_id endpoint_latitude endpoint_longitude [Location table:] location_id location_name the startpoint_location_id and endpoint_location_id is linked … Databases database-design |
| | Hi, I've tried several of the fixes for this that I've found on here, but I haven't been able to find a work around. Here is the code that I'm having the trouble with: [code] mysql_select_db($db_name,$db); $result = mysql_query("SELECT * FROM pages WHERE pagenumber LIKE $pagenumber ",$db) ; while ($myrow … Databases mysql |
 | I have installed MySql 5.0 and also configured but after installation it shows " The Service couldn't be started" Plz help me out Databases mysql  |
| | Here's my code...basically, I hard coded yesterday just to make sure it works...Im trying to get it to display results everyday [code=java] String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" + " WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID … |
| | i tried like a million things and im ready to murder someone, can someone walk me through it? thanks. Databases mysql  |
| | Hi, Was wondering if anyone could help me with this little problem I'm having. I'd like to have a comma separator after every 3 digits. E.g "3,000,000". How would i go about this? Thanks in advance Databases mysql  |
| | Hi everyone. I`m looking to solve an issue. My problem is : i have more tables, but in my example will be only 3 with 2 columns: users (id,nick) comm (id,userID,text) rev (id,userID,text) So , i need to count the comm and the rev that users make, multiiply by a … Databases mysql |
| | How to fastening inserting data on mysql??? I have 5000 record in excels. And I want to insert all record to mysql.. and it take time abaout 6 six minutes.. How to fastening become under 20 second to insert all 5000 records?? Peace DODOl Databases mysql |
| | I have two tables A and B. I want to update rows in Table A depending on the back up data stored in Table B. [code]Table A = most current table of data Table B = 5 day old back up of table A[/code] Structure of both Table A and … Databases data-structure gaming mssql |
| | Hi out there!! I have a problem in creating relationships in MYSQL. could some help me out there? Am a beginner in system development and I would like to learn more. YOuare great Databases mysql |
| | I'm developing a small, web-based poetry sharing website. I'm a beginner in PHP and MySQL. I want users to have a personalized page where they can work on their work in progress, once they feel they can publish it for the other users to view. I've already created a login … Databases mysql |
| | Hi, I'm newbie here. I just noticed that HR control panel have no feature to check and repair MySQL database if the database got corrupted. I knew CPanel have this feature and I guess the HR control panel look similiar like CPanel (CMIIW), but no feature for Check and Repair … |
| | Does anybody know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates. Databases oracle |
| | Hi there, I am looking for a sharp database design tool. Take a look ad wikipedias db schema. Looks fantastically neat. Do you guys know what this tool is called? upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema.png Visio has been good to me, but tables dont look look that sharp, doesnt export to sql scripts. mysql … Databases database-design |
| | hey i jsut have small question it might be silly but i am new to database and don`t know anything about SQL first is SQl the same thing as SQL server? second i have MS visual studio installed on my PC how can i start using SQL!!! like what is … Databases mssql visual-studio |
| | Dear All, I have a [project] table which includes Project name,Startdate,EndDate,Location.and [SubContractor] table which includes id,subContractor_name. each project has one SubContractor at time and one SubContractor may have many projects at time. There are cases in which the first SubContractor leaves the project for some reasons and the company give … Databases database-design |
| | Hi I have made a tentative db design for my system and would like some feedback on whether you think it is well constructed, it can be found here: [url]www.jpgalea.com/design.jpg[/url] Thanks Databases  |
| | I'd like to add tags to my app. I have several different resources I would want to apply tags to, such as blogs, picture galleries and a few others. More efficient to add tag columns to each resource table or create a seperate table for tags that refrences each resource. … Databases |
| | hi, dont usually ask for help since i believe in google. But im in a serious fix. intro: currently working on a table that has three fields, 'id' 'current' 'previous'. problem: i want to insert another field (or two - no too sure how to go about it) but with … |
| | Help me out guys. I am probably being such a bonehead but I can't figure out where I've gone wrong with this code for adding Next/Prev buttons to my pages: $ ID = $_GET; $limit=2; // rows to return $numresults=mysql_query("SELECT * from fragrances WHERE ID=$ID ORDER BY title"); $numrows=mysql_num_rows($numresults); // … Databases mysql |
| | Hey guys, I'm currently in the design stage of a database, and have a question of how the keys should be set up in two of my tables. I have an Orders table, which is related to a Customers table, and also to an Images table. The orders table has … Databases database-design |
| | how to write a query to insert a row that is deleted from one table to another table using sql server 2000 at the same time Databases mssql |
| | I am using Oracle9i for my applications.I want to write my data onto different Hard Drive. Can AnyOne help me oon this... Databases hard-drive oracle |
| | Hello, I'm developing a small, web-based music sharing application. I used to create static HTML contents. But now, I need a dynamic site that retrieve information from databases (also write data to database). As a beginner in PHP and MySQL, I hope someone from here can help me out.. Here … |
| | When i try to install MS SQL 2000 on Windows XP machine it says that server component is not supported by this OS.What should i do get it run on this machine? Databases mssql sql windows-server |
| | hi, how to export a table from sql*plus to an secondary memory like cd ,floppy or hard disk. I challeneged with my friend I will tell u in a week. if anybody knows please give the commands and what i need to do after creating a table in sql*plus. I … Databases oracle |
| | I was wondering if anyone could offer a solution to this database design problem. I have very little experience with relational databases in Access. I have only used databases just to get easy data, but now it is starting to get complicated. I read a little on relational database design, … Databases app-store database-design dataset |
| | hi every one, i want to know about configuring sql mail.i have sql server on my computer and i want to configure it to send sql mail.i want to know which account i have to use as local system account is not being accepted.when i try to create seperate account,i … Databases mssql sql windows-server |
| | How can i copy Tables from mssql server from my computer to oder /from my server to oder/. The Data Bases are ready created i must put only the Tables to oder DB. Please can you tell me how? Databases mssql |
| | I am using VS 2005 to connect to my MS SQL server. I dont have remote access or anyother way of getting into the box. I am missing Object Explorer in the vs. I need this in order to set some contraints on the database. Is there a way to … Databases mssql  |
| | hi, does anybody know how to update garbled characters that are being stored in the database..i am storing vietnamese characters in my db and found out that it some characters are garbled appeared as ? or squares... any help is grately appreciated..thanks in advance.. :):) Databases mssql |
| | Hi everyone, this is my first post here! I am making a small application that helps manage merchandise returns in a computer store I work for. I am currently designing the database for it and an issue has arose which is probably obvious but is eluding me right now. I … Databases app-store database-design |
| | hello... i have a little problem about how to create an auto-increment process. i'm using an oracle and all the table and data is already exist in my database. I have seen a few example from internet and it is like this. [B][COLOR=green]table users {[/COLOR][/B] [B][COLOR=green]id int(13) not null auto_increment,[/COLOR][/B] … Databases oracle |
| | Hey guys, im in deep need of help for [URL="http://www.daniweb.com/techtalkforums/thread78156.html#"]mysql[/URL]. Ive been given a few questions most of them answered although theres 3 which are really bringing me down. I was wondering if u could get some help :D Given this schema borrow([U]transactionID[/U], personID*, borrowdate, duedate, returndate) author([U]authorID[/U], firstname, middlename, … Databases oracle  |
| | I have 2 problems I need your help please: 1- How can I map the result of a select query? let's say that I have a table named "Item" and I need to delete a specific item record from this table. So the user first needs to see the information … Databases microsoft-access  |
| | hi every one, iam a newbie in .net,i have a application in which i have to send email using triggers.can any one plz help, on how to configure sql mail .my application needs to delete rows on completion of expiry date and send the administrator email notifying it. ok waiting … Databases mssql |
| | not sure im in the right section to post this but here we go. i have built a informational site that lists australian racehorse trainers. they are listed depending on which state they train in and which area. i would like to add a search facility so if you know … Databases |
| | Currently i am designing database for Portal. On Portal screen, There are some fields which are having multiselection facility e.g 1) professional is one of the field having 1)photographer 2)skydiving 3)painter 4)modeling are values, User can have more then one profession. Same type of 30 fields are available on single … Databases database-design storage  |
The End.