7,494 Archived Topics
Remove Filter  | |
| | Hi there, I have built a simple CMS that is generally working well, the issue I'm having is with building dynamic navigation. On the site the content for the individual pages is fine but getting the menu data and creating the menus is causing problems. I have 2 possible structures … |
| | I added a user to my database ijdb for a project i am doing and have tried repeatedly to delete them with no luck. The user is jess; mysql>GRANT SELECT ON ijdb.* ->TO [email]jess@"%.host.net[/email]" ->IDENTIFIED BY "jessrules"; mysql>GRANT UPDATE (name, email) ON ijdb.author ->TO [email]jess@"%.host.net[/email]"; I have tryed DELETE, and … Databases mysql  |
| | whats the difference between a table created in innodb and one created in myisam?'Advantages/disadvantage of innodb over myisam and which will you recommend on a web based application specifically meant for dating? thanx u all. Databases mysql |
| | Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates. I have a table called conference_room_status which has the fields Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo … Databases microsoft-access |
| | [CODE]<?PHP $results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error()); ?>[/CODE]  |
| | I have data.sql file and there is 151262 insert statement in SQL file. but while i try to IMPORT it in MYSQL database this give me following error. Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpmyadmin\libraries\import\sql.php on line 111 Pls give some solution for this Problem. -keval |
| | Hello everybody, I am a designer but I have just graduated from university for 2 months so I have not more experience in this field. Could you help me show useful tools to design logo and brand I am from Vietnam and now I am working at Dizen Creative company … Databases  |
| | I am using a custom made application that is using MSDE 2000 transact SQL. Thing is that I've made a simple batch file in order to save databases automatically every day but it seems I made a mistake... I never expected the server to save in the same file if … Databases file-system mssql |
| | Hello I am a fresher and I am involved in designing and developing a database. Please critique my er diagram These are the following tables client-----auto generated Primary key(clientid) vendor----auto generated Primary key(vendorid) clientvendor---composite primary key(clientid, vendorid) employee----composite primary key(clientid and employeeid) invoice(aphistory)----composite primary key(vendorid and invnumber) aplid(invoicelineitem)-----composite primary key(invnumber, … Databases database-design |
| | basically i have a table which has different branch names recorded in the same column as other data. I cannot change how the data comes in so i have to find a way of extracting and matching data from this column. eg +---------+---------------------+------+------------+--------+ | Company | Branch | Tml | … |
| | Hello, I have two tables product table and accessory table. also i have a order table. order table have either product id or an accessory id. those are two nullable fields. now i want to choose from product or from accessory table, either product name or accessory name. can i … Databases mysql |
| | hi,im really new to MySQL,can some one help me in joining table pls...i hv 2 tables,customer table and record table customer table with CustomerID,Customer Name,CustomerAddress, record table with RecordID,CustomerID,Date, how to make the CustomerID in record as foreign key? how to join that two tables so that record will be … Databases mysql |
| | Hi all, I've been asked to do a website for a rural based school. They want an online application for admissions. I have a basic knowledge of webpage design but not advanced enough...here are the following requirements: Aim: to develop an online application management system. 'front end' users can apply … Databases |
| | hi, i'm really new to programming in general, and i think i've figured out how to insert and select data from mysql databases, however, i can't seem to get values from a table and work on it here, i'm trying to 1) grab a number from my table 2) generate … Databases java javascript mysql |
| | Hi, i was wondering how if it is possible to enter a large amount of information into mysql database easily. I have about 15,000 rows that i have to enter and i would like to know if there is a way anyone knows to enter it fast rather than entering … Databases mysql |
| | Hello, So here is the story: I'm trying to select from two diferend tables ( bank_wire and visa) [CODE]CREATE TABLE IF NOT EXISTS `bank_wire` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `method_name` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Bank wire', `checked` smallint(1) unsigned NOT NULL DEFAULT '1', `commision` char(255) COLLATE utf8_unicode_ci … |
| | I have a bit of a unique situation. I am loading a DropDownList (asp.net) from a SQL DB. Let me explain my scenario. [Products] [DB2.dbo.Orders] -Product_ID -Order_ID -Product_Name -Order_Product_Name -Product_Price -Order_Product_Price -Order_QTY [DROP DOWN] [PRICE_LABEL]* [OrderQTY] +ADD ProdName1 ProdName2 ProdName3 [PRICE_LABEL]: *(gets pulled by Select Product_Price where Product_Name=DropDown.Selected) After I … |
| | guys can i call this a database and how to use it this is the file mysql.php [CODE]<?php if(!defined("SQL_LAYER")) { define("SQL_LAYER","mysql"); class sql_db { var $db_connect_id; var $query_result; var $row = array(); var $rowset = array(); var $num_queries = 0; // // Constructor // function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency … Databases mysql |
 | I'm making some sort of mistake in the following code: [CODE]use xPress_CR select * from (SELECT * FROM dbo.T_JOBS WHERE ENDDATEANDTIME = null UNION SELECT * FROM dbo.T_JOBS WHERE STATUS = 'Failed')[/CODE] Any idea what I'm doing wrong? |
| | Is it possible to edit the contents of fields after a select statemen? For example, I have a table Person (Id int, Username varchar(50)). Most of the rows in Username has the format of, say for example, aaa_01, bbb_02. I want to select this usernames with the underscores and the … Databases mysql |
| | Hi I have a very simple database which lists students who have went on exchange both in and out of our university. I am able to do a simple user entered query along the lines of [Enter university] or 'between [enter year] and [enter year]' but here is where it … Databases microsoft-access |
| | I'm attempting to write the formula for a computed column in SQL Server 2005 using SQL Server Management Studio 2008. I get the error validating formula and I'm not sure how to write the formula to work. If it were standard math the formula would be: (mmtot * 22) + … Databases mssql |
| | Hi There Is There A Way To Make Access File As Exe File Thanks In Advance Databases file-system microsoft-access |
| | I am trying to join two tables and havent been very successful, can anyone please help! The two tables are joke and author; I need to get the authors name and email address in the joke table! The database is ijdb; mysql> USE ijdb; Database changed mysql> SELECT LEFT(joketext, 20), … Databases mysql |
| | Hi again! I have a db table named "users" . Within that table, a column named "havechildren". When a client registers on my site, they will choose whether they have children or not by a simple yes or no drop down. That information is stored in my table in the … |
| | Hi all, I have a cities table in MySQL with 3 rows in it. Table 'cities' row 1 'city' row 2 'statename' row 3 'stateabbreviation' With 52,593 cities in the DB. I would like to create an auto search form so that while typing a city in it will show … |
| | Hi all, I m designing a hospital management project, and I need to provide unique id to every patient. The requirement from our client is that the format of this unique id is: ddmmyyxxx. For example, 080710001, 080710002 etc Here is what I did: concat dd mm and yy strings. … Databases mysql |
| | I'm writing an application to catalog a very large number of files (2 million+ files)on a share drive. For each file in the directory tree, I'm adding a record to a mysql database. The share drive is active, in that files will be regularly added; thus the app will need … Databases mysql  |
| | Hi all i have a problem in a task assigned to me in sql 2005 i have table contains column called ID which is an integer i would to retrieve top 10 rows order by ID in descending order and i want the result of this query to be in … Databases mssql |
| | I have a column in my database that has a list of keywords. sometimes the keywords are a couple of words and sometimes just one. Each keyword (can be more than one word) is separated from a comma. for example - this is my column - hi, how are you, … |
| | I want to build a site similar to ebay (a mini version of it) and I'm wondering how they built their system. The part I don't understand the most is how they manage their categories. They have one search code and probably one code for posting items for sale as … Databases database-design |
| | Hi guys, Need your help/advice/opinion for below sql. I try to select all count record that exist in tables between to date insert by user.Currently, just put dummy date to test. The result is ok, but it only view for match data. How to include the record that not match … Databases mysql |
| | Some background: I'm a programmer, not a network administrator, who has been asked to migrate some accounting software ([url=http://ioasoftware.com]Integrated Office Accounting[/url] version 3.2) from an existing domain (OLD_NETWORK) to a new domain (NEW_NETWORK). No-body at the office knows how it works under the hood. It is a split Access 2000 … Databases client-server microsoft-access windows-server |
 | Hi I need to write a sql script to split a string in two or more parts. e.g. I have a string: "tag: key1, key2, key3" I would like to use the ":" as a seperator and thus end up with two strings: "tag" and "key1, key2, key3" Is this … |
| | |
| | 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 run a non-profit association bulletin board using vBulletin software. I have been unable to find a vBulletin coder to help me with a MYSQL query. Seems straight forward to me. I have a csv email file of paid up association members. I also have vBulletin members/users who might or … |
| | Hello, I wrote a query to find the products names by the name entered and to count now many records are outputted. $query="SELECT COUNT(product_id) AS tot,product_id,product_name FROM tblproduct WHERE product_name LIKE '%$pname%'"; $query="SELECT COUNT(*) AS tot,product_id,product_name FROM tblproduct WHERE product_name LIKE '%$pname%'"; I tried both way. but always it returns … Databases mysql |
| | Imagine functions (as in coding): there is a function call, to each function there are parameters and whereas the names and the amount of parameters is specific to a function, the value of that parameters is specific to the function call. For example: Add (Number1,Number2) ADD = function Number1 & … Databases mssql |
| | Join a table to itself with no specfic ID I have a table of customer records which has no ID column, a customer may appear in the table more than once with various of the columns populated. I have managed to build a column INIT_SURNAME which is fully poplated but … Databases mssql |
| | 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. i have a Stored Procedure like this DELIMITER $$ DROP PROCEDURE IF EXISTS `foundation`.`TEMP_TBL` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `TEMP_TBL`() BEGIN -- DROP TABLE IF EXISTS TEMP_TBL; DECLARE done int(10); DECLARE a,b,c,cname CHAR(26); -- DECLARE cur1 CURSOR FOR SELECT id,ccode,accname FROM account_master; DECLARE cursor1 CURSOR FOR SELECT id,ccode,accname FROM account_master; … Databases mysql |
| | Hi All, I am trying to Create the trigger which will invoke the php after record is field in record is updated. Can anyone please help me with some sample code Regards Hemant Databases mysql |
| | 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  |
| | hi everyone...this is madhuri....im new to MySql database...I hav to design the database for my project "Virtual Tutor", in which the tutor reads the words documents virtually. My role in this project is to design the front end and back end...im using JSP for front end and Mysql as backend..as … Databases database-design mysql |
| | 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 |
| | Hi guys. Here's my problem. I have a Windows Form application which connects to a mysql database by using ODBC Driver. It works fine on localhost. Now what I intend to do is to connect this application to a mysql database that is in a hosting provider's mysql server. I … Databases mysql |
The End.