Databases Forum

I"m new to this site so i"m not sure is this question has been answered before but i"ll ask it anyways. i have a simple small access database and i need to create a link between it and our website but i'm not sure how to go about it. what …

Hello everyone, I need Help connecting my website to a database. i could use anyones help. Thanks

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!

Hi I am using two linked server Both have same tables by using sp_tables_ex 'linkedserver name' this I can see list of tables.One Emp table is available in that list but when I try select * from Openquery(linkedserver,'select * from public.Emp') then it show me error like Error message: ----------------------------------------------------------------------------------------- …

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)

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 …

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 …

Hi, I have page that allows the user to search using a "date range" AND "location". I'm able to do this individually. Its like, if the user searches using the date range (from begin date to end date) the results show. Then if the user searches using a specific location …

hi! I have a table which contain files paths. my problem is, that when I insert a path, MySQL omit the separator char. for example: INSERT INTO A VALUES ('C:\qqq\www\eee.ttt'); will be saved in A as: C:qqqwwweee.ttt what can I do for saving the path as it is? (ofcourse, I …

G'day, I've got a table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` varchar(255), PRIMARY KEY (`attID`), KEY (`attName`) ) ENGINE=InnoDB;[/CODE] Now my initial set up was that [B]referenceID[/B] was linked to [B]attID[/B] …

Hi, i'm trying to setup a connection in dreamweaver. so now I have the diologbox open with the different fields I have to write in. First no problem with the: connection name, mysql server, user name and database fields. But when I get to the field password, I don't really …

I need to merge to identical tables, but one column (areas_sub_local_obj) has a reference to the Id column (Primary Key). I need a script to insert the data from table 1 into table two and to change the value in the column areas_sub_local_obj to the new Id that corresponds to …

if not exists (select * from sysobjects where name='amrreconAccountsTB') begin execute "create amrreconAccountsTB(acct_id char(2048) NULL)" end; Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2): error near the keyword 'end'. Can someone please help me and tell me what is the syntax error here?

Hello everyone! This is my first post, been a long time reader though. First of all, it's been a while since I don't program and I'm rusty (very). The problem is: I just can't learn how to use the JOIN or UNION commands, everything I read is confusing. I'm simply …

So I went to mysql docs to check out if they had info on what to do. I found this [QUOTE] “[0-9]*” matches any number of digits, and “.*” matches any number of anything.[/QUOTE] So, I tried them both out & have no result that back back. The query I …

Hi guys. I'm pretty new to sql and I'm having some trouble with a store procedure. I tried to read about it by searching goggle but all the references i got to the topic contained to complex store procedures for me and my current level :P. Here is my simple …

hi! I hope this is the place for my my question: I work on a file tagging system. I write it in java and use MySQL as my DB. I have a table that contain only one field: file's path. when directory is renamed, it's path changes. and that's mean, …

G'day, I recently gotten my MySQL certification, and have been thinking about looking into oracle. Could anyone please recommend some decent reference material to look at?

hi, Is there any sql query to check if a table exists already in a database? Thanks in advance.:)

Hi all, Did a site for a group I belong to. Now they want me to add a login page that would take people to a members only area. Need to be able to validate the users via a database. The only database I have available to me is Access …

Hi everyone, that's my first post in these MySQL forums :) In college they gave us a E/R in order to make it on MySQL Workbench and I'm not sure if it is OK. If you could help me it'd be great :D Because I started with MySQL just a …

Hello, Anybody knows about Relational Database Primer. Is there any difference between Relational Database Primer & Relational database? What is the concept of Relational Database Primer?

1)CREATETABLEProject( ProjectNovarchar2(5)notnull,ProjectNamevarchar2(20), StartDatedate, FinishDatedate,PRIMARYKEY(ProjectNo)); 2)CREATETABLEAssignment( StaffNonumber(3)notnull, ProgramNovarchar2(4)notnull,PRIMARYKEY(StaffNo,ProgramNo), FOREIGNKEY(StaffNo)REFERENCESStaff(StaffNo), FOREIGNKEY(ProgramNo)REFERENCESProgram(ProgramNo)); 3)CREATETABLEStaff( StaffNonumber(3)notnull, StaffNamevarchar2(10), SalGradenumber(2)CHECK(SalGradebetween1and12), YearsExpnumber(2), ProjectNovarchar2(5),PRIMARYKEY(StaffNo), FOREIGNKEY(ProjectNo)REFERENCESProject(ProjectNo)); 4)CREATETABLEProgram( ProgramNovarchar2(4)notnull, Titlevarchar2(20), Languagevarchar2(20),PRIMARYKEY(ProgramNo), CHECK(Languagein('VB','JAVA','ORACLE','C','XML'))); for the code above, what type of integrity constraints will be on them? (how many do u think?) also; i've created this code (below) but there seems to be …

hey guys, im doing a databases project and im a little stuck this statement wont work(its part of a jdbc) and i get the following error messahe, any suggestions as to why? [CODE]stmt.executeUpdate("CREATE TABLE LOCATION (" + "serial VARCHAR(10)," + "notice TINYINT(10),"+ "intransit ENUM('T','D')," + "dtnoticeissued DATETIME," + "lat NUMERIC(8,4)," …

Hello there, I've been having problems creating a part of my mail system that makes messages look red when they haven't been read, and white when they have been read. This is what I'm using right now [code=php]mysql_query("UPDATE Mail SET Read=1 WHERE ID={$messageID}");[/code] The SQL ID Field is a smallint …

I'm having this issue displaying the results I need. The issue is that I cannot condense my results and end up with extra. The code I currently have is below. [CODE] SELECT category.*, content.* FROM `category` LEFT JOIN `content` ON category.categoryid = content.parentid WHERE category.parentid = 1 ORDER BY category.title …

Hi Everyone. I have problems with solving a sql question. There is an assumption: The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) Ships …

Hello everybody! I am starting to work on a web page for a medical firm. This webpage will include about ten different questionnaires for Patients. The longest questionnaire has 160 questions, most of them having a yes/no answer. I am not sure what the best way to go about this …

I have this very weird project that my boss gave me. Given my cws.sql file inside "C:/", i need to create a batch file wherein it will automatically create database cws; and use cws; in MySQL Server. Hope Someone can help me. :'(

I have been given a report that is generated by running the following query from a macro ( slightly edited to simplify )and I have not had a great deal of experience with Access. The report is grouped by Data.Type and sorted be Data.Date [ICODE][COLOR="Green"] SELECT DISTINCTROW Data.Type, Data.Date, Data.Code, …

Hi all... I am a developing a website using a joomla. I need to display a content but the should filter according to the date. I need only display content which are in between current date and before 30 days. my current mysql quary is SELECT * FROM events WHERE …

Please, try to help with this. I use case statement but for 2 arguments. Down here is the idea of what i want to get: select x case x when x = 'AB' and y like 'CD%' then x= 'CD' when x = 'ZZ' and y like 'CC%' then x= …

hi, i have one problem ,table values are not displaying.i wana which used in the table.

I have read other threads on this topic, but I haven't found anything that works for me. I have a table that stores comments for orders. There are many notes for each order and I want to select the newest comment for each order so I can have a list …

Hello all, I have to design an ERD Diagram and a data flow model for a project assignment. I just want to know if I am on the right track. The question is as follows: "The short course institute runs computing courses for members of the public and IT professionals. …

i am a new to php, am trying to get the code below to work - i am getting it is returning resource id#14 Please bail me out file 1 [code] <table> <tr> <td width="245" class="style8"><?php echo "<b>".$database->getLastPoems()."</b>"; // Echoes: string echo $result; ?></td> </tr> </table> [/code] file 2 [code] …

hi, iwant select query

i have a regular expression that's supposed to match any string containing certain words in no particular order. the pattern is in PHP: [CODE]var $pattern = /^(?=.*\bword1\b)(?=.*\bword2\b)(?=.*\bword3\b).*$/gmi[/CODE] this pattern works well both in javascript and php but in SQL, it does not work. I searched and found out that some …

hi, please help this problem , iwill used query after while condition this will not run the program.

Trying to get results from 5 tables where the userId is the same. I am getting like 8k rows for where there should be about 20-30 or so. Here is my statement: [CODE]mysql_query("SELECT * FROM userrating, postratings, blogCommentRatings, commentratings, gamecommentratings WHERE userrating.userId = '$this->userId' AND postratings.userId = '$this->userId' AND blogCommentRatings.userId …

[HTML] i am having four combo boxes.the item in the combo box is taken from the database.we select the data whatever we want and clicking the submit button report want to be displayed. While selection in the combo boxes, they may select all the fields sometimes they may select one …

Hi, This should be a simple query but I am not able to figure out how to get the result I want. I have two tables A and B and want A left Join B however, I do not want all of table A. I want to restrict table A …

Hello, U just started using acces and I need to make a query using multiple tables. I read some tutorials and watched videos but I can't seem to do it right. I have 2 tables: the first one is Login, the second one is Group. Login contains Username, Name, Group …

Hi Guys, I have a problem connecting to a SQL Server from Windows 7 - this particular server I can only connect to by using the named instance from Win XP - I can connect to other servers that does not require you to connect to the named instance eg: …

I've designed database structure for a system I'm building. Currently I chose to use a forum style (forum, thread, post) for a section which gives user content. I'm stuck on name / naming conventions since it is not a forum. I want to use basic name principals. I thought at …

Hi Guys! Am revising for my upcoming exam. I was trying a question in the past papers. It read: [INDENT]A power-tool hire company requires an object-relational (e.g. Oracle) database to record details of their tools and rentals. Customer details, including their name, address and telephone number, must be recorded for …

Hey everybody, My company decided to improve the management of some data contained in csv files by loading their content in a mysql database. I heard that this is part of the process called ETL. Is that right? If that's so, which tool can I use in order to do …

i use vb with Access. I have 2 tables table1 & table2 i create a data report showing the data from table1. [B]My aim is to display the data from table2 on the same report in its next page(s). [/B]any kind of help, suggestions will be highly appreciated. with regards …

[B]-- Table structure for table `attractions`[/B] [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double(5,2) NOT NULL, `childPrice` double(5,2) NOT NULL, `referenceID` varchar(255) NOT NULL, PRIMARY KEY (`attID`) ) ENGINE=InnoDB;[/CODE] [B]-- Table structure for table `packages`[/B] [CODE]CREATE TABLE IF NOT EXISTS …