2,403 Solved Topics
Remove Filter  | |
| | |
| | hi Im building an asp.net application which sends data to another webservice and then sends the data back. I get it to receive the data and save it into a sql database. But I cant get it to display in the gridview. I have been struggling with this for over …  |
| | Hello! This is my very first post, anywhere, asking for advice. I have a mysql table named "children". It has 5 columns. "username" "child1" "child2" "child3" "child4" Based on my register form, A user creates a username and list the names of children he/she has (up to 4) on submit, … Databases mysql |
 | I have this long winded query [code=sql]select i.id,i.name, i.item_type_id, (select it.name from items it, relations rel, relation_types relType where it.id=rel.to_id and rel.from_id=i.id and rel.relation_type_id=relType.id and relType.name='CityCtountry') as cityCountry from items i where i.item_type_id=2;[/code] Cut the long story short, we inherited database from customer that hasn't been happy with other company, … |
| | i'm trying to figure out how to write a query like the following, but in a way that works: select * from (1,2) or select (1,2) ... the result i'm aiming for is 1 2 can this be done? Databases oracle |
| | Hi everyone, first of all, sorry for my english... I'm in this situation: I have a table in my database named products with the fields [B]id[/B] and [B]model[/B] in it. Now, I need to get 'all' the products but with different model names and each result represent a valid product. … |
| | I want to fill a Table quick. I have tried something but its not working. Here is my MSSQL-Script: [code] CREATE FUNCTION [dbo].[fillTable] ( @Amount INT ) RETURNS @Integers TABLE ( [IntValue] INT ) AS BEGIN DECLARE @Counter INT SET @Counter = 0 WHILE @Counter < @Amount BEGIN INSERT INTO … Databases mssql  |
| | I have 3 tables which hold PO's which have uniquie IDs I want to get the last ID in the list then add one to it (i can add one in my code if needed). My query thus far is [CODE] SELECT TOP 1 (SELECT 0 AS [PURCHASE_ORDER_ID] UNION SELECT … Databases mssql |
| | My goal is to have a directory password protected, and have the usernames and passwords stored in mysql. Having the htpasswd linked to my database using the mod_auth_mysql module looked like exactly what I needed, but when I enable the module it disables my site. Most of the sites I've … Databases mysql |
| | the below code is causing two records to be inserted into mysql. I have no idea why. when i remove it no record is entered. When i add it two duplicate records are entered. Any idea why? it is in an if statement. What would cause it to be inserted … Databases mysql |
| | Hey guys, I was hoping someone could help me out here again. I've seen people pulling entries from multiple MySQL tables by using the JOIN clause, but I can't seem to get it to work with what I am trying to do. I have 3 tables which I wish to … Databases mysql |
| | Can any one tell me, what is the difference between SQL and MySQL? |
| | Hi..I'm new here, posted my problem before but can't really keep track of it, don't know where it is so i decided to start a new thread,, i hope this is not a problem... I'm trying to create a database for a school..it should be able to incorporate virtually everything … Databases |
| | Hi, been looking all night on net but cannot find ORDER BY Month anywhere. This is my query: [CODE]SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE FROM monthlycommission WHERE YearPaid= NOW( ) GROUP BY MonthPaid[/CODE] However when i display this it goes June, March then May I want to add an … Databases mysql |
 | Hi there. how can i limit the value of records in Access. Is there a LIMIT function in Access like in MySQL? tnx in advance.. Databases microsoft-access |
| | Hi, I got a question to check if a date time is within another date range (So as to check conflicting schedule) There are various possible types of schedule: 1: One time start - end event. Typically such schedules is like a tour / outing / camp event, and hence … |
| | how do i fix this? the error says that the column count does not match value count. thanks in advance!:) -- -- Definition of table `assets` -- DROP TABLE IF EXISTS `assets`; CREATE TABLE `assets` ( `_id` int(10) NOT NULL auto_increment, `_controlNum` varchar(255) NOT NULL, `_category` varchar(255) NOT NULL, `_subcategory` … Databases mysql |
| | Hello How can I clone a database in MS SQL 2005 Express? I have the original database and I want to create a new database that has to be the same as the original one. regards, Vedro Databases mssql |
| | i get an error here Can't create table '.\itams\assets.frm' (errno: 150) [icode] -- -- Definition of table `branch` -- DROP TABLE IF EXISTS `branch`; CREATE TABLE `branch` ( `_id` int(10) NOT NULL auto_increment, `_branchName` varchar(255) default NULL, `_branchAddress` varchar(255) default NULL, PRIMARY KEY (`_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- … Databases microsoft-office mysql |
| | Hello: listed below is the order for the creation of tables and execution of ALTER TABLE resources in an Apache Derby Embedded db; Note the error at: alterInstructor. I create the instructor table then the booking table. The instructor table has book_num FK. After the booking table is created I … |
| | Hi! I'm trying to create my own little community for learning purposes and I'm having some trouble with getting the data I want from the table. I'm not that high on SQL but I know the basics but when you get into the more complex mysql-lines I get lost. The … Databases database-design mysql sql |
| | Hello, for a database project (music festivals) several search options are to be included. While some search fields will be filled from a dropdown list (like "countries"), other will have a fuzzy option (like "song titles"). For this I want to use the full-text search (you may remember the words … Databases mssql programming-construct sql |
 | Hi, I'm currently designing the schema of my database for an application. and there's this table that has a default content or records. i'm torn between what type should i use for its key, because im always using autonumber, i was thinking that because i have a default content for … Databases mssql |
| | Hi, I'm actually drafting a MySQL query to be fed into Jasper Reports, and since I can no longer manipulate the resulting data in PHP as it will automatically be translated into a chart by jasper, I need my mysql statement to be able to generate what I need on … Databases data-structure mysql |
| | Hi, got some help from tesu on another thread but i am struggling to get this working. my individual query returns 2 results which is correct from the database. however when i try it with a view joining the multiple table with same query it returns 2 results but only … Databases mysql |
| | Hi, I am setting up a notes table, and wondered what the best type would be? Currently i have set it to Varchar with length 500 Would that take up more space than say a Lontext type in the database? Thanks Databases mysql |
| | Hi, I got some great help on the forum to create my total due query. However it produces it with just total due, how could i have it by month? each table has a DueDate column which i would like to show on the query along with the users FullName … Databases mysql |
| | Hi guys, Need some help here. I have created an individual query for each product which works absolutely fine. However i want to be able to join it so i can display on my page who is due for a review. [CODE]SELECT clients.*, protection.* FROM (clients JOIN protection ON protection.clients_ClientID=clients.ClientID) … Databases mysql |
| | hello all! Anyone know how to count all the constraints in a given table? I'm new to stored procedure and need it to finish some work. Databases mssql |
| | Hi all, i want to transfer data one sql database to another database in same sql server. i try to insert into table2 select * from table1 , but this query useful for same database, but i want to use different database, in same sql server. help me here to … Databases mssql |
 | I have a potential client that wants to reproduce certain features from a website. That feature is something that I may need to create from scratch or I maybe able to find some type of plug-in application. Some research has informed me that there maybe some type of database involved,and … Databases flash |
| | Hello: Soon I will need to have my foriegn keys working. I have tried to set them up with no luck. Could someone show me how to set the payee_uid below? I am using an Apache Derby Embbeded Db 10.5.3. Thanks [code] stu_uid VARCHAR(11) PRIMARY KEY, stu_password VARCHAR(11), stu_lname VARCHAR(20), … Databases apache |
| | Greetings - I need your help. I have an SSIS package with a [icode]Data Flow Task[/icode] which has the following Data Flow tasks: [icode]Excel Source[/icode] -> [icode]Data Conversion[/icode] -> [icode]SQL Server Destination[/icode]. The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.) I'm … Databases mssql |
| | I want the list of columns whose datatype is "date" from mytable in oracle. how can i do this. which query is used t fetch such column names? Databases oracle |
| | Hello again I have 1 well working function and one working stored procedure which counts the quantity of rows in table. Now I've created special table which has only two rows 1. Id (int null)(!++) 2. Rows(int not null) In Rows I want to store the quantity of rows from … Databases mssql |
| | Hi, I was wondering if someone could help me, i have nearly complete my site and need some help creating the queries to produce my commission and pipeline. my table structure is: [CODE]CREATE TABLE `pipeline_commission` ( `ProductID` varchar(75) NOT NULL, `Pip_CommID` int(11) NOT NULL auto_increment, `PipComm_UserID` int(11) default NULL, `clients_ClientID` … Databases mysql |
| | Is there a way to get a distinct value from a table and echo it as a id for a div tag and still have the rest of the values echo too? Say I have a table with these values: category item With 3 categories each having 3 items I'd … Databases mysql |
| | Hello All, I am new to SQL Server 2008.I was just wondering if there is any way to add a user as an admin in SQL Server 2008? Is it possible to do using SQL Server Management Studio? Thanks. Databases mssql |
| | Hi, I have a dropdown box extracted from MySQL database and I have two records for a product as it was produced in different years. i.e. model number 75 repeated, I am trying to extract only one of them in the dropdown box and have used select distinct but it … Databases mysql |
 | im making a ASP.NET web application using a serverside database. Hi :), im making a ASP.net web application with a sqlserver backend database. i have been requested to provide both UML and ERD/Normalization i can do both of these techniques individually to a reasonable standard, however i am unsure about … |
| | Hi everyone, I'm trying to write some PHP code to update a user's password. It is not updating and I can't spot what's wrong with my query (I have echo'ed it to the screen). [CODE]$sql="UPDATE $tbl_name set 'password'='$new_password' WHERE 'user'=$user;"; $result=mysql_query($sql);[/CODE] SQL statement [QUOTE]UPDATE user set 'password'='2' WHERE 'user'=test;[/QUOTE] What's … Databases mysql |
| | hi experts SELECT porh.segment1, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' THEN prall.full_name END directman_pr,[QUOTE]to get the dept.head[/QUOTE] porh.description, porl.line_num, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' AND poph.action_code = 'SUBMIT' THEN TO_NUMBER ( … Databases oracle |
| | Hi, I can't find the missing thing in this code. "05-MAY-08" is in the table but, [inlinecode]( CURSOR_TARIH%FOUND )[/inlinecode] never returns TRUE. When i do manuel query it is ok. Thanks [CODE] create or replace PROCEDURE A_SIPARIS_EKLE_SP IS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT WHERE TARIH = to_date('05-MAY-08', 'DD-MM-YY'); … Databases oracle |
| | I am having issues with the following script. I don't see anything wrong here. Very basic but it is giving me a headache. Any suggestions are welcome. I am running version 5.1.37 and the error is: Error Code : 1064 You have an error in your SQL syntax; check the … Databases mysql |
| | Hi, I don't know if this is the right forum to post this, if not please move it or just delete it. I installed Phpauction via Fantastico after trying several purchased scripts that just wouldn't work. Everything is working fine except the "View Feedback" links which give the following error … |
| | Please someone can help me. I need a function which just returns the number of rows from known table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums int SELECT Count(*) FROM dbo.MainData where id=@id RETURN @rownums END [/CODE] But it … |
| | Hello! I need your help again... thanks! I have a table where I need to insert the same value in all rows and dont know how to. Table: equipment, Column: available How can I enter a number 1 in column "available" in all rows? Thanks again! Databases mysql |
| | Hy sorry for my bad english I have transaksi_pembayaran table and have a tgl_tran field, tgl_tran is a date but has type varchar, how can I get date range in mysql? date range like this : 14/2/2005 to 27/2/2005 (d/m/y) Databases mysql |
| | Hi all I'm new to PostgreSql i'm trying to write a simple function [code] CREATE OR REPLACE FUNCTION insert_tmp_pswd2 (int4, varchar) RETURNS int4 AS ' DECLARE tmp VARCHAR; BEGIN insert into "ExAfrica".test2 values($1, $2,now());select 1; END; ' LANGUAGE 'sql'; [/code] i really dont know why he doesnt want to declare … Databases postgresql |
| | Hi, I have tested this and get no errors. However when i am updating a mortgage record for a client it changes the client id?? So if i am updating a mortgage for clientid = 1 Test Case and Mortgage ID = 1 once i click update in my php … Databases mysql |
The End.