2,403 Solved Topics
Remove Filter  | |
| | Hi, I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one. For example, … |
| | Hello, why wont this code give my "Rubrik" a link with its ID? I only get "www.yada.com/open.php?id=" [code=sql]<a href="skapaannons.php">Lägg till annons! </a> <?php $con = mysql_connect(" "," "," "); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("annons", $con); $result = mysql_query("SELECT annons.id, annons.datum, annons.rubrik, annons.pris, … Databases mysql |
| | |
| | Hi, I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before. Thanks Databases oracle user-interface  |
| | Hi, Below trigger increments double(2,4,6,8...) not single. I want single. Where is mistake? If you can not help, is there other way to do auto increment? Thanks [code] CREATE TABLE MY_TEST ( IDNUM NUMBER, NAME VARCHAR2(4000) ) ; create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger … Databases oracle |
| | Suppose a table ABC have column XYZ containing data 3PSY0001-06-08-F 3PSY0001A-07-09-P 3PSY0001-02-09-P 3PSY0001-07-07-F 3PSY0002-09-08-P 3PSY0002A-01-03-P 3PSY0002-07-07-F How can i write a query so that the data ending with P without A can be updated with A. For example, with that query, data 3PSY0001-02-09-P AND 3PSY0002-09-08-P will be updated as 3PSY0001A-02-09-P … |
| | The following code coincides with an onClick event on my form to move to the next record in a file, but I keep getting the Error Code: 424, object required. I have (3) other buttons on my form: MoveFirst, MoveLast and MovePrevious, but they all work fine. What is different … Databases mssql |
| | hi i have two tables,i want to display the details in startpost and based on the userid i want to display the username ie i want to print posttitle,date,name using single query please help [CODE] CREATE TABLE `creuser` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(100) NOT NULL, UNIQUE KEY … Databases mysql |
 | I've been away from sql for quite a well and need a little push to get restarted. Need to report out of a single table, with values coming out of only two columns. Need to group items from column 1 as the left column in the ouput table with totals … |
 | Having braved the task that is getting mySQL6.0 installed onto my machine, after listening to the preferences voiced by database users everywhere I was delighted when I finally got down to a bit of a play!!! The problem I found almost immediately, was that a lot of the returned results … Databases mysql  |
| | Hi all, I am currently designing a database for a warehouse but I cannot get the ERD Wright. The entities which I am using are( Warehouse, order,customer, suppliers, products) these are my tables but after handing in my assignment, it has been returned to me and been tolled there is … Databases |
| | can anyone tell me how to use a variable table name in select syntax?? like..select * from tablename here tablename is a variable name ..i read tht it can be done using dynamic sql..but i am not able to do it..can anyone tell me the code for it...i tried writin … Databases mysql |
| | --Que-4)Create a Query to pull all emails that contains --characters +,^,*,&,! [code=sql]create table mail3(email varchar(50)) insert into mail3 values('mansi.sharma@yahoo.co.in') insert into mail3 values('mansi.sharma+yahoo.co.in') insert into mail3 values('mansi.sharma^yahoo.co.in') insert into mail3 values('mansi.sharma*yahoo.co.in') insert into mail3 values('mansi.sharma&yahoo.co.in') insert into mail3 values('mansi.sharma!yahoo.co.in') insert into mail3 values('mansi&sharma!yahoo.co.in') select * from mail3[/code] [icode]select * from … Databases mssql |
| | Hello all, I am using MySQL version: 5.0.37 I am creating a forum. I am designing the tables for the threads and their replies and the relationship between them. Please have a look at these images and give me your thoughts. I have also included the schema. [URL="http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsTableDesign.jpg"]http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsTableDesign.jpg[/URL] [URL="http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsLogicDesign.jpg"]http://i284.photobucket.com/albums/ll40/JavaPHPNinja/threadsLogicDesign.jpg[/URL] [CODE]CREATE … Databases mysql |
| | [B]FIRST EXAMPLE--[/B]CREATE FUNCTION dbo.myFunction() RETURNS INT AS BEGIN DECLARE @myInt INT SET @myInt = 1 RETURN @myInt END select dbo.myFunction() as 'Simple Number' This Function is not returning any value,Error is coming [B]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.myFunction", or the name is ambiguous.[/B] [B][COLOR="Red"] … Databases mssql |
| | Hello Everybody!!i am confused to do the database design for diving reservation. Please helpp me!! Thank you. Databases database-design |
| | I am to create a form with 2 text boxes to receive numbers as input and 1 command button that displays a message box containing the larger of the two numbers. To do so, I need to write code in the Click event of the command to call a user-defined … Databases microsoft-access |
 | i have a database called [B]"BILLING_SYSTEM"[/B] in sql server 7.0 and I'm using sql server authentication mode to connect to the database with my [B]username[/B] [B]"BS"[/B] and [B]password "BS"[/B]. where my front-end is a VB6.0 application. [B]now I want to create this security login "BS/BS" from vb6.0 code without opening … Databases mssql |
| | Hi all. I have posted on this before with no response. Let me try a different way. I have a db with a few tables :- ATHLETE, which contains fields ATHLETE (the record Id), FIRST, LAST, AGE and SEX; MEET, with fields MEET (the record Id), and MNAME; RESULT, with … Databases mysql |
| | hello i am trying to display an image from a database which has just been uploaded by the user. when they go onto the next page the image should be displayed here. I have been able to get it to display the path for the image that haas been stored …  |
| | i am trying created a table on the server called images and when i text to see if the table has been created i get the message table already exists. as i did not develop the rest o the site i thought a table might have been created already called … Databases mysql |
| | This is my first exposure to arrays. I need to create a 1-dimensional string-based array with five elements. I need to assign 5 different names to the array. Use a for loop to iterate through each of the array elements, displaying the names in a message box. I would truly … Databases microsoft-access |
| | Hello i am having a problem with trying to create a table on the server every time a try to enter data into the database i get the message table already exists. I have moved the code to create the table on to its own page and only recall that … Databases mysql |
| | Hi, I can create all tables but order table. What is wrong, is it foreign key? [code=sql]CREATE TABLE customer( customerId INT(10) NOT NULL AUTO_INCREMENT, customerName VARCHAR(10), customerSurname VARCHAR(10), customerAddress VARCHAR(10), PRIMARY KEY (customerId)); CREATE TABLE order( orderId INT(10) NOT NULL AUTO_INCREMENT, customerId INT(10), PRIMARY KEY (orderId), FOREIGN KEY (customerId) REFERENCES … Databases mysql |
| | is this possible, i had to use the mysql class to connect to the database, but i would rather use oledb. the connection string i used is "Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword" when i try to connect a popup titled "MySql Data Source Name Setup" always comes up. even if i try … |
 | Hi All, I am a Problem with Database. I Don't Know How Can i Import my Data in MySQL Database Using CSV Format. Can anyone Plz Help me. I am Using phpMyAdmin for Accessing my Database... Plz Help me. Databases mysql |
 | I just need your take on which of these two scenarios will yield quicker results with optimization in mind. On the front end there are a lot of pages with counts per category of events e.g Restaurants (40) | Pubs (2) | Gallery (6) [B][U]First Scenario:[/U][/B] [ATTACH]5594[/ATTACH] Having a stored … Databases |
 | Hello everyone! I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how … |
| | i have once again been asked to fix some code on a website. this time the website is meant to have a content management system but once again the person who made the original website did not complete what he started. the content management system side of it is using … Databases mysql |
| | I am trying to set up a database on the server and keep getting the same error message. it say to me that it was successful in connecting to the db but access is denied for the user. what is causing this as the password and user name that is … Databases mysql |
| | Hi all The following query works and gives me the desired results. The only problem is that it is very slow, and I suspect it is because of the multiple sub-queries included in it. The table, RESULT, has multiple records per athlete, per stroke, per distance stored in the order … Databases mysql |
| | I have a table having columns like values, like this col1 col2 col3 1000 10 2 1000 20 3 1000 30 4 2000 10 5 2000 20 6 2000 30 7 3000 10 8 3000 20 9 3000 30 10 I want to fetch records like if i enter col2 … |
| | Hi All, I am struck with following problem. Please help me out. I have defined a Oracle procedure as follows. [code] PROCEDURE JOB_EXPORT IS cur CWTYPES.cursorType; l_nextdate DATE; -- JOB_NEXT_RUN l_interval VARCHAR2(64); BEGIN OPEN cur FOR SELECT JOB_NEXT_RUN, JOB_INTERVAL FROM JOB_EXPORT_CDRS WHERE ACTIVE_STATUS=1 AND JOB_INTERVAL IS NOT NULL LOOP FETCH … Databases oracle |
| | hi all, Table 1: ID | COL1 1 | 1 1 | 13 1 | 64 Table 2: ID | COL1 1 | 14 1 | 13 Output needed: ID | COl 1 | 1 1 | 13 1 | 14 1 | 64 How will i accomplish this??? Thanks … Databases mssql |
| | What would I need to add so that I can return a count of the number of rows retrieved in the query? I am not sure where to include the COUNT (another query?) and then what syntax to use to print the result. thanks [CODE]$data = mysql_query('SELECT * FROM `bus_basic` … Databases mysql |
| | Hi! I'm a foreigner working in japan and my job has recently put me in a position where I have to use Access for the first time. I've managed to create some tables and establish relationships between them, but I got stuck trying to create a form with subforms. I … Databases microsoft-access |
 | |
| | Hi, If someone can help me with this I'd really appreciate it! I installed SQL Server 2000 Standard Edition on Windows Server 2003. This server is due to take over from our present Windows 2000 Server. It was my first time doing a SQL install, so I ended up calling … |
| | I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import … Databases mysql |
| | i am trying to connect to my database which i have set up and i keep getting the same message 'could not connect'. i have a php page which sets up the database, and i recall this page with the include db.php to connect to the server. i have tried … Databases mysql |
 | [code=mysql] $result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'"); [/code] Above code is not working, pls help. Databases mysql |
| | Hi, I have two table like this: [QUOTE][B][COLOR="Red"]quote_tb:[/COLOR][/B] [B][U]ID item vendor quote[/U][/B] 11 a v1 100 11 a v2 200 11 b v1 400 11 b v2 300 11 c v1 555 11 c v2 777 22 a v1 122 22 a v2 222 22 b v1 322 22 b … |
| | |
| | select CASE WHEN FirstColumn IS NULL THEN '' ELSE FirstColumn END + ' ' + CASE WHEN SecondColumn IS NULL THEN '' ELSE SecondColumn END as ResultColumn from myTable Databases mssql |
| | today i came across to an sql problem from one of the threads in the database forum : to solve the problem i created a table named "names" having these columns : PKID | name | lastname and i entered some rows having the same values for name and the … |
 | Here is data EnqSrNo 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 11 11 11 11 11 11 11 11 11 11 … Databases mssql |
| | This has become a horror, a horror I tell you. I am not a techie. I am not a developer. I do not want to be a developer. I am trying to set up a pro bono program for a non-profit law office that serves the poor. Every time I … |
| | In Turkey we use "." as thousand seperator and "," as decimal seperator. If you are working with currencies in sqlserver, and if the money columns is of type "money" then the problem occurs beause of the seperator issue since in its default mode sql server accepts "," as thousand … |
| | How to insert big html markup with white spaces(i.e. line breaks) and single and double quotation marks to sql server : To insert that big html markup to ms sql server, i tried to copy the markup and paste it to the sql server table cell first. It didnt work, … |
| | Hi, currently I have a shared web hosting with MS SQL server 2000 database. I have already implemented the database, with all the data inside the database, on the server. Now I wish to copy the whole database (.mdf) down to my PC, in case I wanna change hosting or … Databases mssql sql web-server  |
The End.