7,494 Archived Topics
Remove Filter  | |
| | html body mysql result: <? $sqlcomments = "SELECT * from sellercomments where Status=1 and SellerID=".$_REQUEST['SellerID']. " order by AddedDate desc"; $resultcomments= mysql_query($sqlcomments); if (@mysql_num_rows($resultcomments)!=0){ ?> <br> <? while($row_comments = @mysql_fetch_array($resultcomments)) { ?> <div align="right"><img src="../<?=$row_sellerdetails['AboutUsImage']?>" width="40" height="40" border="0"></div> <?=$row_comments['CommentBy']?>] to <a href="index.php?SellerID=<?=$_REQUEST['SellerID']?>"> <?=$row_sellerdetails['idName']?></a> <span style="color:#000000"><?=$row_comments['Comment']?></span> <br> <? } } ?> …  |
| | Hi, I am trying to export my Joomla 1.5.23 mysql database. I have no phpmyadmin. I used several ways like this (http://faq.1and1.com/web_space__access/mysql/13.html) but I get an error message saying: There was an error during export. Please check your values: MySQL Database Name: HIDDEN MySQL User Name: HIDDEN MySQL Password: NOTSHOWN … |
 | I need to pass the @startDate and @endDate as variables to @range in the code given below. But when I execute the below code, I'm getting the Error as follows. What is going wrong in my code, and how can I correct it? Errors: Msg 102, Level 15, State 1, …  |
| | I have an issue and I would like to know how I should go about this. I have two tables. Athlete and EachAth_Games create table Athlete ( AthleteID INTEGER NOT NULL, Firstname varchar(10) NOT NULL, Surname varchar(10), Position varchar(1), TeamID INTEGER NOT NULL, CONSTRAINT pk_Athlete primary key(AthleteID, Firstname), CONSTRAINT Player_FOREIGN_KEY …  |
| | i run the below script to get the left and right as per the binary i did and it is ok Script select a.ID,a.Node,a.direction, a.Reference_ID, a.Recommended_By from members a JOIN members b ON a.Node LIKE CONCAT('%(',b.ID,')%') Where b.ID = 2 order by b.id,a.Recommended_By' Result **ID** **Node** **Direction** **Reference** **Recommended_By** 4 … Databases mysql |
| | Hello all, Im looking for a tool that allows me to visualise a single entry in a database, so i can see that entry, and all entries that have a foreign key to it, and foreign keys to those etc. Im not talking about an ERD, but more like a … Databases mysql  |
| | hi recently i have installed oracle 11g and i try to work through oracle enterprise manager browser to start up the local host there i found "Host Credentials" i have not set any user name and password for my os while installing i am using windows 7 what will be … Databases oracle |
| | This is my SQL statement.. SQL Statement: SELECT tbl_subjectsenrolled.SubjectID, tbl_subject.SubjectDesc, studentsubjectgrade.Finals FROM tbl_subject INNER JOIN tbl_subjectsenrolled ON tbl_subject.SubjectID=tbl_subjectsenrolled.SubjectID INNER JOIN studentsubjectgrade ON tbl_subjectsenrolled.SubjectID=studentsubjectgrade.subjectID WHERE studentsubjectgrade.StudentID='04-0044' But the OUTPUT is this: SubjectID1 SubjectDesc1 Finals1 SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 Finals2 SubjectID2 SubjectDesc2 Finals2 Instead of this: SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 … Databases mysql |
 | Remove the last word while using left in sql query...I weant to avoid broken words while doing so... My query as follows: select top 2 tempJobTitle.id,tempJobTitle.JobRefId,tempJobTitle.JobTitle,LEFT (jobmaster.JobDescription2, 330)+'....' as JobDescription,jobmaster.PostedDate from tempJobTitle inner join jobmaster on jobmaster.JobRefId=tempJobTitle.JobRefId where tempJobTitle.Status='Approved' and jobmaster.ClosingDate >= '2013-03-01' order by tempJobTitle.DateofEntry desc  |
| | Hi I finally screwed up.In order to get rid of a minor problem I uninstalled Wamp Server and reinstalled it.Now when I try to start it it will not accept my old password.What can I do? Do I have to uninstall everything mySql, Workbench,Wamp server and maybe php? Another thing, … |
| | I've have been doing some research on how to export export a pipe delimiated file from sql management studio but I cannot quite seem to figure it out. How would I simply turn this output into a piped file. [CODE]select * from #tmpRPLRouting where propertydatamap = '3' [/CODE] Databases mssql |
 | Hi all I am currently working on a Battlefield player / server statistics application that i have written in C#. I am storing RAW player / server data in a table at the moment. My question is what is a recommended maximum columns per table as this statistical data which … Databases mssql |
 | Hi, I have a problem with a code harness given to me by my tutor. Every time i enter values into a form, I get the following message: > Warning: mssql_query(): message: Invalid column name 'N56DSRT'. (severity 16) in /web/users/l1099341/SDD/insertCarController.php on line 27 Warning: mssql_query(): General SQL Server error: Check … |
| | |
 | Hi . I installed oracle 10g in D Drive(Because C drive is full). But when i try to uninstall , i cant see that in "add or remove programs". How to uninstall it?.. Any solutions.. Databases oracle |
| | Hi there How are you? Would you please explain how the following queries work //alternate rows select * from emp where rowid in (select decode(mod(rownum,2),0,rowid, null) from emp); //3rd max salary select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal); … Databases sql |
| | Hi, I have tried several solutions for my application which lets several users upload files to a database. The users belong to groups and should only be allowed access to their files or the groups files(if 'sharing' is on). I have tried to give every group their own database, but … Databases database-design |
| | Hi everyone, i am designing database for books application. I have main table **Books** and its child table is **Chapters**, chapters child table is **Sections**, So here is the problem, that some chapters has also divided into 3 steps **chapter Name -> Part 1 -> Divisions 1** and each chapter … Databases mysql |
 | Good day, I am having trouble with the computation in SQL. i want to subtract the intStock and the intTotal_OutBound_items to just to get the items available. here is my SP.. INSERT INTO CO09_Report ( intMaterial ,txtDescription ,txtMaterial_Type ,txtATP_check ,intDelivering_Plant ,intOrder_Quantity ,isHeld_by_Finance ,isRejected_OOS ,isRejected_Others ,intOpen_Order_Quantity ,intOrder_Quantity_NKA ,intOrder_Quantity_RKA ,intOrder_Quantity_Others ,intStock ,intDSD_Delivery … Databases sql |
 | Hi How can Iremove all object that Im created in oracle database. I have 8 tables and I would like to remove all which commans should I use? Databases oracle |
 | First we had the news that [URL="http://www.daniweb.com/news/story276878.html"]IBM was helping clean up crime[/URL] in the US and UK, now it seems that Sweden is getting a touch of the Big Blue Brother effect. The city of Stockholm is launching a project using IBM's streaming analytics technology in order to gather real-time … Databases |
 | Hello, i installed MS SQL Server 2008 0n a stand alone/member server runing windows server 2003 R2. I connencted it as a member server to a Domain Controller(child1.parent.local) in another site. This worked very fine both the replications were succecssful. The domain controller which i connected to, is a child … Databases mssql windows-server  |
| | How can I insert two row to supplier table? CREATE TABLE supplier ( supplier_nr NUMBER(10), supplier_id VARCHAR2(20) NOT NULL, price NUMBER(10) NOT NULL, CONSTRAINT supplier_supplier_nr_pk PRIMARY KEY(supplier_nr), CONSTRAINT supplier_supplier_id_fk FOREIGEN KEY(supplier_id) REFERENCES varugrupp(supplier_id) ); Databases oracle |
 | I'm having a problem with a MYSQL Join accross three tables. I'm new to MYSQL Join functions, and can't quite figure out how to write the code. My current code is horribly innefficient and does not implement explicit joins, which I believe is much of the problem. Here it is(in … Databases mysql |
| | |
| | Good day, I want to get the latest value of the newly inserted record in my label.. The value that i want to get is not the primary key. Here is my code . //for saving _patientInformation.firstName = txtFname.Text; PatientInformationBL _patientBL = new PatientInformationBL(); if (_patientBL.addPatientInfo(_patientInformation) == true) { lblMsg.Visible … Databases |
| | what is the driver and url for oracle 11g and kindly suggest me suitable jdbc jar file for oracle 11g Databases oracle |
| | I'm trying to create a table writing in SQL and I need to validate the 'Date of Birth' field 'Players must be over 16 years of age' So how should I validate this. my table name is : Players field name is DOB and the datatype is 'DATE' I tried … |
 | How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended? i have used this function datediff(ss,grn_date,GETDATE()) . this function gets the jobs done how ever if the diffrence btw the dates is huge … Databases client-server mssql sql  |
| | Hi I try to insall Oracle SQL Developer 3.2.2 on windows 7 64 bit ,but I dont know why I cannot connect to server I got this error? http://ubuntuone.com/68jUmnjxm1458xARIaDNcL by the way any one know who ca I unstall Oracle SQL Developer 3.2.2 from Win7 64bit? |
 | In my project i want to create a database through my application, how can create new database using sql statement.( i.e create database...)  |
 | how i can make the relation ship in MS SQL ? |
| | Hi All! I have 3 tables: test1 id name1 1 value1 test2 id name2 1 value2 test3 id name3 3 value3_01 4 value3_02 I want to display all records of table test1 with values of table test2 (test1.id = test2.id) and values of test3 (if test.id match with test1.id) - … Databases mssql |
 | I have a table named Machines with fields: MACHINEID, MACHINEName MACHINECode, FACILITY where MACHINEID is a primary key. And i like to create a general stored procedure that does ADD, EDIT and DELETE operations and after updating i want the old record to be kept. How can i do that? Databases mssql |
| | Hi, Was wondering if someone could help me with an issue I'm having. I'm new to databases and have to compose an E-R diagram in mysql from a set of given instructions. I'm happy enough with most of it apart from one small section: -----Property Rentals” has several branch offices … Databases |
| | Hey Everyone, I have table called vdet_sa_archive and in that table there are so many fields and i want to access the data on datetime range. sample data in table starttime endtime 1 14-02-13 01:30:15.000000000 AM 14-02-13 02:01:57.000000000 AM 2 14-02-13 4:30:01.000000000 AM 14-02-13 5:30:01.000000000 AM 3 14-02-13 01:30:01.000000000 PM … |
| | Hi so I have three database tables, aspnet_Membership, aspnet_Users and tableUsers. These tables keep record off users on the system and what I am trying to do is to create a gridiview that lists the users that are locked out. The columns I would like is userID, customer name, customer … Databases sql |
| | Don't really understand Basketball and I have to do an ERD . Can someone tell me how to link the 'manager', 'coaches' and 'club' tables. e.g. would it be one manager has MANY coaches to manage. e.g. One club has MANY Coaches. Don't get it. Also I have these following … Databases database-design |
| | Hi guys, I would like to know is it possible to connect and create databases locally on my Mac or even windows? using Oracle SQL Developer. I have installed Oracle SQL Server with XAMMP but this doesn't seem the correct way. Hope someone could help.  |
| | How can I learn oracle easily? what are the softwares required for testing & running oracle code Databases oracle |
| | **How to show the scoring of each match & show players individual performance for each match on an ER Diagram for a basketball system? ** Hello, I have to create a database for a basketball system. I’m confused about the 'scoring'. I have kept the scores in the ‘GameStats’ table … Databases |
| | Hi guys, This is my first time using SQL. So, go easy on me :) I'm executing these queries on some websites online where there is an already made database with Country name,Area,Population,etc What I would like to do is, to get the names of all the countries in Asia … Databases sql |
| | I created a stored Proc: Create PRocedure InsertTBL_Supplier ( @SupplierNumber nvarchar(50), @SupplierName nvarchar(50), @Address nvarchar(50), @ContactNumber nvarchar(50), @ContactPerson nvarchar(50) ) AS BEGIN INSERT INTO TBL_Supplier (SupplierNumber, SupplierName , Address, ContactNumber , ContactPerson ) VALUES ('10000','JenRoses Shop','Pasig City','09159675567','Dara Lim'), ('20000','Lawren FlowerFave','Makati City','5564818','Aiden Lee'), ('30000','FLowers&Scents','Marikina City','7280823','Dennis Park'), ('40000','Pretty Flower Spot','Pasay City','09276543789','Joshua Tan'), … Databases mysql |
 | Hi All, I have the following statement which is intended to have a Year over Year Percentage change: select CurrYear.Variable_Date,CurrYear.Variable_Value,cast(100*(CurrYear.Variable_Value-PrevYear.Variable_Value)/PrevYear.Variable_Value) AS Percentage_Change from dbo.tblCPISC as CurrYear left outer join dbo.tblCPISC as PrevYear on year(PrevYear.Variable_Date) = (select MAX(Variable_Value) from tblCPISC where year(Variable_Date) < year(CurrYear.Variable_Date)) order by year(CurrYear.Variable_Date) For some reason, I … Databases mssql |
| | Hi Hope someone can help with this as I dont really know where to start. I am trying to automate a quite large txt feed I get from an external url to import into database. I currently do it manually through database software, but it takes too long each day. … Databases mysql |
 | |
| | |
 | Hello there, today I noticed there are two operation in PhpMyAdmin, Replication and Synchronization. and now I want to use these operation as the following scenario. I have local db, I want to copy its content to remotly db so when I connect to any db I see the same … |
 | hi ihave create simple stored procedure for test in sql server 2008 studio then i run it inside sql query : exec test it gives me red line under test (strored procedure name) and when mouse come over it tolled me "could not find stored procedure test" then i go … Databases |
| | Hi, I have a problem that in a database (named DDS) i can change or delete records in all tables but there is one which i can't. There isn't any primary or foreigh keys(There is one dependency, a view). So could you please tell me that is there any way …  |
The End.