Databases Forum

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 …

Hello Everyone, Need help with posting this problem I have with Access 2003. There is no field named contact in the current record. thanks

--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 …

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 …

Hi all, please help. I m trying to create an "empty" table from existing table for the audit trigger purpose. For now, i am trying to create an empty audit table for every table in a database named "pubs", and it's seem won't work. Please advise.. Thanks in advance. Here …

Hey guys! I was wondering if anyone could help me. I am a student on my work placement year and I am developing a web based database. I have been asked to design it so users can if need be add a new table to the database or add a …

[code=sql]CREATE TABLE Persons ( FirstName VARCHAR, [Last Name] Text, Gender int, [Date Of Birth] DateTime, MaritalStatus Integer, IsMarried Bit, PersonalIncome Money, HouseholdIncome Currency );[/code] Can u plz tell me where I have to write this Query in MS-Access to craete the Table.

Hi, I have a simple SQL query [CODE=sql]update testcourselog set grade='a' where statusid=4[/CODE] It updates 114 records I am trying to write a trigger that will change a flag to 1 for all record updated by the query. [CODE=sql]USE [online] GO /****** Object: Trigger [dbo].[gl_courselog_iscounted_update] Script Date: 12/10/2007 16:49:32 ******/ …

I write programs using VB as the front end with Ms Access as the back end( database), and i will love to switch my back end to oracle ( so i think of starting from 9i).Please does anyone have the note or documentation I can read on my own in …

[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"] …

Hi, I have a table with 10,000 names. I'd like to group them into groups of 3 and also display the remaining 1. Can anybody help with a suitable query please. Taffd

I need to [U]create [/U]a data file called students.dat and [U]insert [/U]a few records into it. I need (3) fields: 1) student id no. 2) last name 3) first name I thought it would be pretty straight forward, but I get a compile error: Invalid Outside Procedure and "students.dat" is …

Hello Everybody!!i am confused to do the database design for diving reservation. Please helpp me!! Thank you.

Hi, I am using oracle 9i. I've got hard time rying to rename columns or constraint definition. I use the following for renaming a column: [code] ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name; [/code] but I get this error [inlinecode]ORA-14155: missing PARTITION or SUBPARTITION keyword [/inlinecode]. The same thing …

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 …

[CODE=SQL] please help any one, how to write PHP, what is the use of PHP, syntex, advantages etc.... [/CODE]

Hi, When i add new product into "Products" table, a trigger will add a record into "stocks" table. Example; stock=10,productId=99 How can i do that? Thanks [code=sql]CREATE TABLE products( productId INT(10) NOT NULL AUTO_INCREMENT, productName VARCHAR(10), PRIMARY KEY (productId)); CREATE TABLE stocks( stock INT(10), productId INT(10), FOREIGN KEY (productId) REFERENCES …

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 …

Can I query a SQL Server 2000 mydatabase.mdf file directly via SQL? If so, how?

Hi all, First post on this forum so a BIG hello from me to all you IT Gurus out there! Need some advice solving a little problem I have with my database! Current setup: I have a person table that is made up of 39 columns. I also allow for …

A publishing firm that consists of twenty five employees utilizes a Microsoft Access database system to store and process requests related to their business transactions and operational data such as product sales and customer information. Over the last five years the firm has experienced tremendous growth; as a result, the …

hello, everybody i have a problem , i have table , it contoin column ORDER ID, customer ID, amount, DATE. a problem when i type or create this table, i make a mistake i dont know where is my mistake when i type in mySQL database BY using ( MYSQL …

how to write nested queries ex: [code=sql]SELECT * FROM [table1] WHERE [column] IN (SELECT [column] FROM [table2])[/code] in a function. i tried this but MYSQL is getting stoped. is there any alternate.

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 …

Hey, I am deji, i have been on this site for a while now but i have never been on this database forumn.... I used to be on the c++ forumn.... I was given a project with one of my coursemates in school.... we were asked to automate our school …

A publishing firm that consists of twenty five employees utilizes a Microsoft Access database system to store and process requests related to their business transactions and operational data such as product sales and customer information. Over the last five years the firm has experienced tremendous growth; as a result, the …

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 …

how can i create a database for a medical record maintenance system for an institution?

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 …

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 …

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 …

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 …

Hello this statement below works when the date is set as 02/02/2008 but when i enter it like this 2/2/2008 it dont search the date, in the database the date is set as 2/2/2008 because i need it in that format. i want to search dates from and to like …

I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this: [code]CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2 MEMO, Check3 INTEGER, Check4 DOUBLE, Check5 DATETIME, Check6 BOOLEAN) VALUES (1, 'DefSML', 'DefLRG', 0, 0.0, …

i want to generate a query example: if the english question s given ->list all the details from my_table where name='smith' and age <30 it shld generate a mysql query for the question ->SELECT * FROM my_table WHERE name = 'Smith AND age < 30;

Dear programers, i am new to mysql and webhosting. i have one website script,i want to instal the same script to my two domain names(for example: domain1.com and domain2.com) i dont want to add this two domain like addon domain. i have two different hosting for this two domains. for …

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 …

hello i am using Mysql plse send DataBase Connection and ROOt

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.

If you read an earlier thread i started i was having completely the opposite problem that i am having now. Before it kept telling me that the table already existed and now it tells me the table does not exist. I have created the table in the db.php page where …

Hello all, I'm new in this group and with designing databases. I would like to design a databse for managing data about the sports day for a school. I have been able to create the following tables: Pupil(differnt class and age group), Event(hockey, rugby, swimming,relay race), Staff, Equipment(used for the …

Girlfriend would like to learn about MySQL. Can you recommend any book that purely deal with MySQL? No adds on as PHP or any other web developing technology? I know there are many sites with great tutorials but she insist on book so I have the "pleasure" to find the …

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 …

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 …

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 …

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 …

hi i am using sql server 2003. can we get the position of record / row index in sql server while retrieving records? like in some case we fetch records as per our criteria. And if that time need to know the postion of particular record then? how to get …

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 …

Hello everyone, I was elected to be the company "IT guy" at a printing company aside from my day-to-day job here (lucky me), and have done a minimal amount of coding (HTML, ASP), but could definitely use some help on this project. We have some large clients who insist on …