Databases Forum

Hey guys need your help here. I will go ahead and describe my problem and what i intend and what i am getting. Platform for SQL Queries : MS Access There are 2 identical table in terms of table structure, they contain information ( RAW Data) about month, money i …

Hi, I want to replace a word based on the positions. input I love programming (ilp) i want to replace lowercase ilp with uppercase ILP I love programming (ILP) how can resolve this issue?

watchinthegame posted the following thread on Mar 14th, 2009 : MYSQL field is Datatype DECIMAL(9,2) When I update the table and set the field to 120.00 it gets populated as 1200.00 What am I doing wrong? Thanks Watchin -------------------------------------------------------------------------------------- It doesn't appear this was every resolved (at least not via …

Dear all, I'm new in php MySQL and I'm wondering on how to maka users add many informations in one table, I'll explain. Now I have a table called users conataining: Username(primary key) - Name - Birthdate - Country and I want the user can add infos in a table …

Hi Experts, I am getting this error message, "Error connecting to mysql" whenever i am running the below scripts: [code=php]<?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'petstore'; mysql_select_db($dbname); ?>[/code] I've just set-up everything and …

I am trying to do this with sql code without using a cursor. I have table A with two cols and no PK ID Data I have table B with three cols the first two make up the PK ID PK SEQ PK Data If I have the following data …

Hi to all keen folks, can you help me to query the first 4 letters and the last 4 letters in one field. example: AAAABBBBCCCCDDDD how to query AAAA and DDDD. thank you.

I have a table with 2 fields category_ID Category_name 1 india 2 china 3 japan 4 africa 5 france I bind these data into grid in aspx page and in that i have given delete command and when i perform delete operation and if i delete china and japan i …

Good morning/afternoon/evening! I'm trying to run a MySQL query, but it seems to be ignoring the "ORDER BY" clause, most likely, I'm believing, because I'm using the "IN" keyword in my query (several times, as a matter of fact, along with a "LIKE"). Is there a way I can structure …

Hi, everyone... I'm using ms access 2003 and i wanna know how to write a code in vba that will take initial days x add y days every end of month and store them as accumulated days. Pleases I don't know wre to start. Thanx in advance

Hi i am wondering if anyone has a solution for sorting by postcode area. I wanted to be able to pick off either the First letter or first two letters and group by this. I have figured out how to group by the first to characters of the postcode using …

hi, how to auto increment the value in database table when the button clicks.i have created a table named register .when the user completes his registration we will generate the receipt based on the registration. so for every receipt we will generate the receipt no on that. when we click …

My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using SQL Server 2008. I know that if I were backing up the database to begin …

Hello everyone. This is quite possibly not the place for this but it is more to do with SQL than the other things included so I apologise if I am wrong. I am looking for some help on a task I have been set. When I say help, what I …

hi, i need to get the column values from the table login.it contais two columns ,userid and password. i want to check the userid and password values when the user logged in.so i have to compare the entered textbox value with the saved value. i am using the code is …

Hello! I'd like to run mssql script (file with extension sql). I installed Microsoft SQL Server 2008 and run in Command Prompt: C:\Documents and Settings\useruser>osql -Usa -Ppassword -i "F:\Data\MyApplication\Scripts\CreateDb.sql" [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQL Server Native Client 10.0]Login …

MYSQL field is Datatype DECIMAL(9,2) When I update the table and set the field to 120.00 it gets populated as 1200.00 What am I doing wrong? Thanks Watchin

Hi people, I have run across this website many times, with the first impression that it was a website to ask a guy named 'Dani' questions about code *snicker*. I haven't introduced myself. Maybe I will. But I have a question. In building a program, I'm running mysql code. In …

I want to store codes in a database i.e title code, status code, etc. I want to do this without affecting the performance of the database. I want u guys to tell me the most advisable way of doing this. I want to retrieve the actual code descriptions using these …

Hi friends I am new to mysql . After Installing mysql-standard-4.1.22-unknown-linux-gnu-x86_64-icc-glibc23 in linux i am getting the error ./mysql_install_db ./mysql_install_db: line 85: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. pl help me how to overcome it Thanks in advance

I have MySQL running such that I can open a client command line and log on and make databases, tables, etc. I wanted to do some AJAX. Doing AJAX with ASP, SQL Server, etc is not advisable since both places where I am hosting my websites do not use the …

Hello, I've the following problem: I need to insert to a table the following customer data: Year No., Month No., CustomerName, CustomerID... The problem is with the Month No. (MonthNo is the table column name). I'm using the following command, in a stored procedure, after the insertion. [code=sql]SET @MonthNo = …

Hi Team! Anybody could help me with this hell query? I got 2 tables: Table: STUDENTS with only 1 field: [name] id1: jose id2: william id3: john id4: sandra Table: COURSES with 2 fields: [name], [course] id1: jose, saxo id2: william, cook id3: john, saxo id4: sandra, garden I wanna …

Hello all I need some tips from people who are familiar with Oracle dba. i m trying to get OCA exam and i just finished reading my first chapter and now i m on chapter 2 and its telling me to download the dba software. so i m very confuse …

i have a thread in my forum. all the replies are by THE SAME USERNAME. the mysql thing looks like this: (that runs when i post a reply) [CODE]mysql_query("UPDATE `replytable` SET `the thing to show if its a mod` = 1 WHERE `by` = '$_SESSION[username]' AND `the thing to show …

I need to derive last 2 numbers after the '-' from the code column. example if the code is 76767-99 then I need a query to return only 99. I am using substr and instr functions but not getting what I want. Please help me correct the below query. code …

All, Have a frustrating report problem. Have code of:[code]Function RAmount() HrsAmt = DLookup("trp_ham", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) MilAmt = DLookup("trp_mam", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) RAmount = HrsAmt + MilAmt End Function Function RCount() RCount = DCount("trp_id", "qryTIMshtS") End Function Function RTotal() HrsTot = DSum("trp_ham", "qryTIMshtS") MilTot = DSum("trp_mam", "qryTIMshtS") RTotal …

Hi my name is Kirk. I just graduated from college with a degree in Computer Science. I have a broad range of knowledge of computers and programming, but not much knowledge specific to databases that will ultimately be used in a project I am working on. I am building a …

Hi guys, I'm new here. I have a problem though. I can perform a bulk insert from .csv file to MS SQL Server 2005. My problem here is that there are foreign tables in the .csv file. What I want to happen is that these data should be replaced with …

Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …

hi folks , I have a Table names A with these fields (Id,Entry_Date,State) I want to fetch the 5 recent records with Unique States And Order them Desc so this is what I did [code=sql]Select * From A Order By Entry_Date Desc Limit 5 [/code] I tried many ways to …

Hey Guys, Some of you know (Tim) that I'm working on a Professional Development and Training Database. I'm about to demo it to HR but I would like to add a feature: If a course is "Mandatory for all employees?" is checked in tblCourse, then check "Mandatory for Employee?" field …

I am writing a sports event result analyse of a database, there are few awards will be given 1. individual prize: suppose getting champion get 5 marks , second runner up get 3 marks , etc 2. the most active athlete award every student in a House participating every event …

Hello! I've got web application created for MSSQL and IIS. There are two directories in this application - Scripts and WebSite. In Script there is file CreateDb.sql. I need to run it so that it can create database. I changed in that file one line into this: CREATE DATABASE [NameOfDb] …

Hi everyone, It's my first time with looping through data in a query. I know there are two ways of doing this and one is using CURSOR (I read it'snot the nicest thing to use). Wouldn't mind hearing your thoughts. I will copy and paste my first attempt at usingCURSOR …

ya i have this site i am working on and at first it was working fine, im not sure what i did but now it says i registered but when i login i get the error saying invalid username. So i went and looked at PhpMyAdmin and it did not …

Hi everyone! I have the following problem I am trying to solve: I have one table with data and need to access the same column twice, everyone with different criteria and then output the results on one table. I tried [code=sql]SELECT e.user, SUM(e.column), SUM(f.column) FROM table AS e INNER JOIN …

I have a huge stored procedure which calls other mini-ones. The problem is that I need a temp table and I'd like to avoid a real table being used as a temp one. You've probably guessed by now, but if you haven't, a table variable is created at the beginning …

Is Powerbuilder a DATABASE?

Hi everyone. I'm relatively new to MS SQL but one of my clients has a site based entirely around it so I am having to get to know it a bit better. While trying to clean out some of the fake emails from the mail list table they all got …

Hi all, I have searched high and low for this answer but turned up nothing concrete. I am using MS SQL Server and ASP. I have a database with a table which includes a field with a TEXT datatype. I have created a simple stored procedure to select all the …

Hello All, I need to generate a simple script according to the following: "Using only one update write query to update a salary by 10% for salaries below 100k and 15% for salaries above 100k" TIA

Hey guys im trying to do a query on our database, the pieces of information i need are in 2 tables within my database. table 1= customers - information i need from this table: customers_id (primary) customers_firstname customers_lastname customers_email_address table 2= orders customers_id orders_id (primary) both tables contain more fields …

hiiii how can I use 2 different select statement to insert 2 different values in same insert statement ????

Hi i have two tables called GeneralTable and SpecializedTable which has Name and State in It LIke 1 .GeneralTable ( GName , State ) 2. SpecializedTable( SName , State ) i want to write an SQL query which display the State from where the majority of Person ( both General …

Hi all I crated a Report in SQL Server Reporting Services. The Report uses 1 parameter. When I exe the Report in my IE it asks me for the parameter and then run fine. When I use Subscriptions' I can put there my email. And sent it to me. (Work …

Hi All: I installed oracle report server 10.1.2.02 I tried the following url and it display the page properly that ask Test run Job: [url]http://xxx/reports/rwwebservice?operation=runJob[/url] When I tried the url: [url]http://xxx/reports/rwservlet/showJobs?server=rep_xxx_oracleas3[/url] It is suppose to redirect me to an url to login. It did the first time. I was able …

i want to ask.......if i have the data in a database of mysql....how can I generate html, chart from the database(mysql)

hi I have a coulumn named Status which can have only three values: 1. Available (Default) 2. Unavailable 3. CheckedOut How can I add this functionality while creating the table? i.e. while creating the table itself how can i specify that the column can hold only these 3 values and …

I have multiple tables, table_a, table_b, table_c. Each having the same structure. i.e ID, title, rating, content. I'm using [code=sql](select * from table_a order by rating DESC) union (select * from table_b order by rating DESC) union (select * from table_c order by rating DESC) [/code]to list all titles from …