7,494 Archived Topics
Remove Filter  | |
| | 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 |
| | Hi, I am a newbie for MSSQL. Previously, I was given a question regarding MSSQL. Although the interview had over, but I am curious to find out on how to solve the question below: There are 2 tables, NAMES (ID INT IDENTITY(1,1), NAME SYSNAME) and RELATIONSHIPS (NAMEID INT, PARENT_NAMEID INT) … Databases linked-list mssql |
 | Hi- Here is my question. People, where I work, friends of mine, other programmers, etc. are always talking about "best practices" in application design. Specifically, people are taught/told to minimize the number of SQL queries sent. Now, here is the thing, I am personally under the impression that it doesn't … 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, Am sort of in a fix at the moment. Am at the stage of creating my database from my ER diagram of which certain tables rely on the InnoDB storage engine for referential integrity, transactions etc. By shockingly enough my ISP doesnt offer InnoDB table types due to the … |
| | 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 |
| | Greetings, I'm using Flash MX connecting to an MS Access database via JET. I've stored dates using Flash/Jet into my database as 'dd/mm/yyyy hh:mm:ss' into a DATE/TIME field. However I can't update because of the WHERE clause as I am not specifying the date correctly. I believe syntax wise I … Databases flash microsoft-access sql  |
 | |
| | Hello All, I have declared one of my fields in the database as PropertyName varchar(100); Now the problem is that when I try to insert the text having an apostrophe using my html form it gives me an error. Can you please help me with the issue as I am … Databases mysql  |
| | 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 … |
| | HELLO, CAN I GET RESPONSES TO THE FOLLOWING QUESTIONS ON ORACLE 10g. 1. HOW CAN I CREATE 2 EXTRA CONTROL FILES FOR MY DATABASE, I CREATED ONE WHILE INSTALLING ORACLE 10g? 2. HOW DO INCREASE MY DUMP AREA SPACE? 3. I GOT THIS MESSAGE UNDER ALERTS "SQL RESPONSE TIME IS … Databases oracle  |
| | I need some help. Some collegues need to link their AutoCAD files with an external data base, in this case in Oracle. So far pretty simple, and done... Next step is to link functionality, if a record is deleted in the db, we want the corresponding CAD drawing component deleted … Databases open-source oracle |
| | I am running a .sql file against my database to build the tables. However Once i reach the Create tbl_static i recieve the following error on one of the insert statements: MySQL said: Documentation #1366 - Incorrect string value: '\x80\x99s Ba...' for column 'fld_description' at row 1 The Insert Statement … Databases mysql office-suite |
| | I have a DB to setup using products: This is what I have and am seeking input and design for Inventory. I want to separate inventory by product properties (i.e. Sizes [Small - Medium - Large - X-large ] Color [White - Black - Green] ) So, count by color, … Databases |
| | 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 |
| | hi all experts here, i am currently doing my web project using PHP and facing no clue for the database connection between 3 tables....here it is: i'd created 3 tables, one keeps users' username, password, and id....the other keeps the details that user input from a form...both contain a common … Databases mysql |
| | i am adding elements to my db and the elemtents which have been add will be displayed on a different page. i am using an upload page which creates a thumb nail of an uploaded image and then stores the path for this image in a variable called $thumb_name. the … Databases mysql |
| | Hello I'm trying to teach myself how to use mysql and php via a couple of books and a lot of hacking away. I have Jesse Feiler's book "How to Do everything with Web 2.0 Mashups" and I'm stuck on chapter 11 which is a practical exercise in mashup building. … Databases file-system mysql web-server |
| | 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 |
| | hi i am trying to do a simple access database, with quantities, and a query with a report I have create a table with one of the variables being a numeric value, but i need to have 2 decimal places. when i format with 2 decimals, what ever i type … Databases microsoft microsoft-access |
| | I need some help suggesting an elegant way of doing something. I'm currently in the planning phase of a media management solution that comes in two parts; The administration website, and the deployment website. What I'm considering doing is, at the time a member signs up for an account, I … Databases mysql |
| | How can I create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. In syntax: [code]UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);[/code] I … Databases mysql |
| | Hey everybody, I'm new to mysql, but I'm developing a real estate website, mostly for condos. I'm setting up the database and want to make sure it's sufficiently designed so that customers can search the database for the type of place they want. Specifically, if someone wants to search for … Databases database-design mysql |
| | i have created an image upload page in my web site which stores the images on the server using php. i now need to get the images to display on a different page. here is the code i have used to set a variable to the file directory // the … Databases mysql web-server |
| | How to create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb); Databases mysql |
| | Ok I got a new multimedia search engine that im hoping to launch pretty soon. ([URL="http://im1musicc.cs-webhost.com/search/"]temporary link here[/URL]) I all ready got the number of mp3 downloads counter set up there using flat files, but I didnt do that. It was all ready done when I got the script. Now … Databases multimedia 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 … |
| | |
| | I have two tables - products and productpropertyvalue I need to select multiple fields from the productpropertyvalue as it corresponds to the product id. The script I am using is select a.id, a.productname, a.siteprice, b.propertyvalue from product a, productpropertyvalue b where a.id = b.productid and propertyid=590 This allows me to … Databases mssql  |
| | Hi I'm a final year university student and i'm running into a bit of trouble with my final year project (It's very important) My task is to create a DBA (Database Administration) tool in visual basic to allow me to add/edit/delete users from an existing oracle(sql) database. I really don't … Databases oracle visual-basic |
| | 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, … |
| | Is it possible to make a column on my database that automatically copy another column on the same table string together with another url? for example on my database "ewelby_k5" I want to create a new column called (fullthumb) on table "files" where "fullthumb" stores "http://k5live.com/thumbs/ + column "thumb" " … Databases mysql |
| | Hi guys, I'm fairly new to MS Access and I am running Ver.2003. I have a problem with comparing a Excel speadsheet with an Access DB. The result I require is as follows.... If field 'Last' and ID Num in Excel speadsheet matches 'Last' and EmpID in Access DB then … Databases microsoft-access |
| | Hi I want to write a query which will return me Sum(MarkU) and also the avg. Which is something like (Sum(Sum(MarkU)))/5 in mathematically operation or TotMark = Sum(MarkU) AvgMark = TotMark / 5 I hope you get an idea what i need. How to write this type of query in … Databases mssql |
| | Hi there. i would like this procedure to delete all rows in 'sale' where date_modified < (getdate() +0.02) and all the related rows from 'sale_detail' and 'sale_address' i have written the code below, but ti think this might only delete one row from sale and its related rows in the … Databases mssql  |
| | 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 |
| | I have an application that was written for me by a programmer who represented VFP as the "best thing since sliced bread" and that would be robust for many years in the future and more importantly handle huge customer databases over a LAN instantly. Now, after two years the server … Databases asp.net |
| | mysql4.X is installed on my system.while i tried to install Phpbb forums in my personal computer it is giving the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 48 Warning: mysql_error(): supplied argument is not … |
| | hi all, i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only. which is better (altering … Databases mysql  |
| | 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'm looking into creating a Access database for marking my students and so they can get there marks online. The online part is much later mind you but that is my goal. I need help in the structure of my tables, quaries and reports. I've been using access for a … Databases microsoft-access  |
| | I had my site working which require mysql database... so now im trying to host that site here at home... my site comes up but now on the top of the main site 3 errors come up... Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'milatcom_clipsha'@'localhost' (using password: YES) in /www/www.mysitesname.com/include/adodb/drivers/adodb-mysql.inc.php … Databases mysql |
| | I'm working on the conceptual phase of modeling a database for a company right now. I have two considerations: 1) This database will obviously be integrated into a web application, but more importantly it will be a user/pass based system with rights and privileges. 2) I trying to model a … Databases database-design web-design |
The End.