7,494 Archived Topics
Remove Filter  | |
| | Azul(Hi) i created program on php where i can output data set of any table by submitting query. i need help to input i mean to load data into the table from the HTML file can any one give help please thank you. this is the program i created, so … |
| | I can't figure out how to perform a calcuation in a query and have the result output for use in a chart within a report. Forgive me I'm a newbie Databases microsoft-access |
| | hi friends i do organization schema for my company. i make a simple design of org. sch. like ; organization_schema=> org_job_ıd ,bigger_org_job_id,job_id(for example more than one department have computer enginner) job=>job_id,job_name and also employees have relation with organization_schema than my problem is i need to history of organization_schema for it … Databases |
| | Hi guys, I'm stuck at this query I'm writing. I'm hoping someone will be able to help me. I have 2 linked tables: subjects and visits with a relationship on subject_id: table subjects: Subject_id, name, birthdate table visits: Visit_id, Subject_id, parameter1, parameter2 Now I need to query that will get … Databases mssql |
| | |
| | Hi I am designing a database for a local garage which sales and repair cars, I have come up with attached ERD diagram could anyone give me any advice on it and let me know if there is something wrong with it. Thanks for your help. Kind Regards HB 25 Databases |
| | Can I reformat a phone number in SQL manager. I imported a foxpro dbf with the dts wizard and it imported the phone number as (609) 555-1212 I need it to be 6095551212 Databases mssql |
| | Hello, I am trying to run my tables in the Sql Workshop using the Sql Commands option in Oracle, and I get this error - "ORA-00922: missing or invalid option". I read that this is somehow related to the NOT NULL option, but I think this is how my table … Databases oracle |
| | Hi, I have a problem with an insert into ms sql(web-based). I keep getting an error Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ';'. /admin/dataentry2.asp, line 147 the actual code the asp page is [code]function addRecord() v_Name = replace(Request.Form("Name"), "'", "'") … Databases asp mssql sql web-server |
| | yeah i am currently working with raima database and there is no forum i can ask about it. Databases |
| | I'm trying to create a simple advertisment booking system for a community newspaper. The paper is published (printed) every two weeks and relies on local small businesses taking out small ads. We want to keep track of all of our customers, and their bookings both past and future. Each issue … Databases data-structure |
| | Hi there, I need to normalize the following structure: Wall covering wood (category) (Product)-----(Models)-----(Prices)(Measurement) Log Cabin-----5/4 x 6------1.85$/square foot-----0.80$/linear foot Log Cabin-----2 x 8--------3.00$/square foot-----1.50$/linear foot Log Cabin-----2 1/2 x 8----6.50$/square foot-----3.50$/linear foot Doors (category) (Product)------(Models)-----(Prices) Panel Door------18"----------85$ Panel Door------24"----------90$ Panel Door------26"----------95$ Panel Door------28"----------100$ Panel Door------30"----------105$ Tables (category) (Product)-------(Models)--------Not peinted-----Waxed----Lacquered … Databases |
| | [url]http://www.picturebang.com/images/331323386942[/url] Hi to all, this the first post in the forum and i have some of questions need to be made in SQL Statements.. i tried to answer some of them and the other i don't how to make it.. so plz help me becauze i'm a new in SQL …  |
| | Currently connected to remote server but remote configuration is not yet possible this is msg shown when trying to connect remotely to a database what does it means Databases mysql |
| | hi, i am a newbie in mysql and i have some questions about performance tuning. 1-) in a system where you have to store information about a user, such as, user_name, id, last_log, is it better to store all the information needed in one table (lets assume 30 fields in …  |
| | I'm in the planning stages of an inventory db. The part I can't figure out is how to design the database as far as changing costs go. If I have a cost associated with an item, how do I handle when the cost changes? I know I need to have … Databases database-design microsoft-access |
| | I have the problem: "List all details about software records. Sort the output by package ID within tag number." I'm a little confused about what they mean "within tag number" Is the following sql right or wrong, if wrong can you help me fix it? Thanks. [code=sql]Select * from software … Databases mssql |
| | I am having a problem with a database that I am trying to create for a railway reservation system. some part is as follow : <station table> stationid station_name <Journey table> journeyid stationid <train table> trainid journeyid seat_type seatno now the problem is that i need a candidate type key … Databases database-design |
| | hello to all , i have problem , my sql table called Kings and its look like this ID Game1 Game2 Game3 Game4 Game5 Game6 Game 7 Date Username 1 213 222 323 232 522 212 122 3.4.09 user1 2 214 212 325 432 262 222 292 3.4.09 user55 3 … |
| | Hi I will explain what I am trying to do: I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings. Now I need to retrieve all the bookings for a specific date. For achieving this I have created two … Databases mysql |
| | hi, this is saif from pakistan. i have get a project to make a database on library management system.could u tell me that how many entities i can add in this data base.if u know pls reply me wid the names and how. thank u. Databases oracle  |
| | Hello everyone ! This mysql user management fcking damn BULLSHIT (i think we can state it) begins really to drive me mad.. I got a win 2003 server running mysql, somehow i lost root access from the localhost meaning that i'm actually unable to make a backup from my database, … |
| | I have a table off which I need to parse out the data using certain criteria. The table contains 3 datetime columns called '[B]ReadingTakenOn[/B]', '[B]StartedOn[/B]', and '[B]StoppedOn[/B]' Here's the criteria for selecting the records: The Dates in the 'ReadingTakenOn' column should lie between the Start Date and Stop Dates (both … Databases mssql |
| | Im trying to run a query like this: Display the names of pairs of customers who have booked the same room together with the details of the location and room. I did try like this: [CODE]select cust_name, room_name, cost_per_day, capacity, loc_name, avenue_site.address from customer, aroom, booking, avenue_site WHERE aroom.room# = … |
| | Hi am using sql server 2005.. I hav a query like this. [CODE]create PROCEDURE [dbo].[csp_UpdateAutoPart] ( @Code NVARCHAR(6) ,@Quantity INT ,@UnitPrice DECIMAL ) AS BEGIN -- Update the autopart details UPDATE dbo.AutoPart SET dbo.AutoPart.Quantity = @Quantity ,dbo.AutoPart.UnitPrice = @UnitPrice WHERE dbo.AutoPart.Code = @Code end[/CODE] While executing it, almost 32 rows … Databases mssql |
| | For example you want two tables that have a column that has an identical id and that id you want to print out in another table. how will you code it? Databases mssql  |
| | I have mySQL 5.1 installed on a Windows Vista machine. I'm really curious as to where the file lives that holds the databases I created. I'm assuming it's in the mySQL install directory but I just don't know where (C:\Program Files\MySQL Server 5.1\?). Does anyone know? Databases mysql windows-server windows-vista  |
| | anyone has an idea where i can setup the language (the dateformat) for my ms sql database?? Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas?? |
| | I am a 3rd year student.this is my minor project.i have to make a project using vb as front end & oracle as back end.In this i have to design a form in vb which contains company information.The companies which are coming in campus for selecting students have some criteria.these … Databases oracle |
| | Hi. I am working on a php-mysql project. My table contains a field called "ID", which i have declared as teh PRIMARY key. but what i want is, that when the user tries ot insert record B into the table, an **ERROR message** should be displayed, showing that a record … |
| | Hi friend I have a question of 2 parts I have to insert new entries from a file in a table once every month Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of … |
| | Hi, I need some help with normalisation please. I need to enter an event multiple times using the same event number under the "supply" table, however I receive the "unique constraint violated" error. I have attached my normalisation up to 3NF, but believe I have messed up somewhere. I'd appreciate … Databases |
 | this is the link i got it from: [URL="http://www.learnphponline.com/scripts/email-activation-for-php-forms"]http://www.learnphponline.com/scripts/email-activation-for-php-forms[/URL] this is the error im getting please also consider im n ew and dont know how to find the manual maybe it is a common known thing or something im asking anyways i wouldnt know waht to look for either its … Databases mysql |
| | Hi I'm new at this I have created a database Person with (ID,Name,address) in MS SQL an d I have the following code [CODE]protected void Button1_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlConnection conn =new System.Data.SqlClient.SqlConnection(); conn.ConnectionString ="integrated security=SSPI;data source=SQL Server Name;" +"persist security info=False;initial catalog=northwind"; try { conn.Open(); string sql = … Databases mssql open-source sql visual-studio |
| | Hi, I am new. I have two table like this [code] create table1( ID VARCHAR(10), CONSTRAINT PKeyt1 PRIMARY KEY (ID) ) create table2( ID1 VARCHAR(10), ID2 VARCHAR(10) ) [/code] I want to add foreign key to table2 which ID1 and ID2 is different but referenced same column ID and ON … Databases mssql |
| | Hi all ! I have been assigned a task to implement an insert query into table a [i] only if [/i] a record doesn't exist in table c. I have been scratching my head for past 2 days and even my best friend [i] google [/i] didn't help me much, … Databases mysql |
| | Hi All, First of all, thanks for taking time! The problem i've got is the following: I am trying to do an update to a range of data in a field: I've got some products stored in database like this l-aa223221 l-aa2243232fe32 l-aa224322ddew23 I would like to transforms these multiple … |
| | Hi. Intel Xeon CPU 2.40Ghz -- 2GB Ram Windows 2003 R2 Standard edition - (SP 2 applied) SQLServer 2008 Management Studio 2008 (v 10.0.1600.22) I am trying to add a maintenance job using the wizard to perform a backup and I get almost to the end and then I see … Databases mssql session windows-server |
| | I apologize beforehand if this topic is in the wrong place. Quite honestly I am desperate for help. I have a project for school involving Firefox and making an extension that is a visual database. My professor suggested I use SQL Lite to make the database. I am so beyond …  |
| | Hello, I have the following tables: tbl_Products, tbl_Categories, tbl_CategoryFields, tbl_ProductDetailsText tbl_Products houses basic product data, such as ID, CategoryID, Title, Description, Body, Date, Status, etc... tbl_Categories has ID, ParentCategoryID, Title, etc... tbl_CategoryFields has custom fields that the user can add in a CMS for specific categories. For example, Category A … |
 | Dear all, I have 2 tables : [CODE]create table test ( FieldA varchar(10), FieldB varchar(10), FieldC varchar(10) ) and create table test_trigger ( FieldA varchar(10), FieldB varchar(10), FieldC varchar(10) )[/CODE] I create Insert Trigger in test table. Every time test table is inserted new row, automatically inserted in test_trigger table. … Databases mssql |
 | hi all i would like to create a registration and login and selection database, css, mysqladmin. need lots of help.. thanx something like this for example.. I am/We are a: Man Woman Couple (man and woman) *Interested in meeting: a Man a Woman a Couple (man and woman) a Group … Databases mysql |
| | Hi all Convert(decimal(10,1),(taxid*10)/100) as tax value in taxid is 1. And also im getting .0 result but it should return .1 Plz help me..........why im getting wrong answer. Databases mssql |
| | Hello everyone, I have a fairly simple question about database design. I have a database for county voting equipment. Each county has multiple pieces of voting equipment. I currently have two tables, one with counties and one with voting equipment. Is there any reason to have a relational table between … Databases database-design |
| | OK.. I'm trying to write a query which combines data from two tables. (I'm pretty novice at SQL Queries, so bear with me!) However, I want to exclude duplicate data (based on just one column -- an address field). Basically, I want to only have one result per address. The … Databases mssql |
| | What SQL statement would I need to join the employees/work orders tables to create the desired output (below)? ++++++++++++++++++++ + employees + ++++++++++++++++++++ + id | name + ++++++++++++++++++++ + 1 | Jim Smith + + 2 | Susie Helms + ++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++ + Work Orders + ++++++++++++++++++++++++++++++++++++ + id … Databases mssql |
| | Hi i'm trying to write a simple SQL command to use within PHP. I want to select the whole table, sort by one of the columns, then only display the top 100 rows. Without the[B] WHERE rownum <=10[/B] it works fine. But it displays the whole contents of the table … |
| | i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE … Databases mysql |
| | how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb … Databases mysql |
| | Could someone please give me the simplest possible C# code snippets / SQL queries to determine whether: * a given SQL database exists, * a given existing SQL database is accessible, and * a given table exists within a given existing SQL database? Thanks for whatever help anyone can provide. |
The End.