Databases Forum

Is there a workaround to this as decode does not seem to allow the use of greater than equal sign I am trying to show the comment for any days beyond 4 days, not just 4 days. [CODE] decode(shipdate-orderdate,'4','This is unsatisfactory!') comments from orders [/CODE] Thanks in advance! :)

[CODE]Hi Forumer's kindly please optimize my query. I need to separate the colums for statusissue = 0 and statusissue =1 my query create double entry. ]--Sample Table Create Table #Table1 (Itemid nvarchar(10), Datephysical datetime, Statusissue int, Qty numeric(28,12)) --Sanple Data Insert into #table1 (Itemid, Datephysical, Statusissue, Qty) values ('HTC1175','2012-02-14',1,50) Insert …

How do i change date format in the database

Hey Guys, Must be "a case of the MONDAYS" =) I'm trying count the results of a query of two tables. The following gives me: Column 'id' in field list is ambiguous Which I can understand as MYSQL is not sure which result I am asking for. [CODE] $query = …

Good Morning. Could someone tell me how you would go about doing a query to just get records that have an email account with(hotmail.com or msn.com or live.com) I'm sure I could do it by selecting the entire DB and sorting them in PHP based on exploding the email field, …

There is a sqi vulnerability in my client website. I cant give you the links but can you guys suggest how to avoid it.

Hi , I have 2 columns named 1. Tel_H 2. Tel_H_Code How can i merge these two columns to make them one ?? I am clueless here...The best i can do is to view them as one [code] SELECT Tel_H_Code + Tel_H AS 'Tel_H' FROM Detailed_List [/code]

Hey I have to make statistics to call from base I have for example one line of [CODE]<p>Mesna zajednica <select name="mesto"> <option value="donji_grad">Donji Grad</option> <option value="karadjordjev_dud">Karadjordjev Dud</option> <option value="plavinac">Plavinac</option> <option value="seone">Seone</option> <option value="ladna_voda">Ladna Voda</option> <option value="lestar">Lestar</option> <option value="zlatno_brdo">Zlatno Brdo</option> <option value="slavija">Slavija</option> <option value="papazovac">Papazovac</option> <option value="carina">Carina</option> <option value="sveti_sava">Sveti Sava</option> <option value="25maj">25. …

Hi, i recently found an sql injection vulnerability on a server, In the db, there's a table named users and inside there's the username: admin and password : ******* Is knowing this password enough to hack the server ? Thanks

Hi I tried to insert russian language to mysql db but after inserting ,I am getting some strange things in database INSERT INTO table(adtex) VALUES('1с бухгалтерия 7 Cкидка 42% на 1С:Предприятие 8 базовые версии!'); Output adtex | +----------------------------------------------------+ | 1? ??????????? 7 C????? 42% ?? 1?:??????????? 8 ?? Plz guide …

For a couple of months now I've been working on a community website; however I haven't got past the registaration because MYSQL can't connect to my HTML and PHP codes.Also my laptop treats .PHP documents as text documents and I can't open them, is this related? Thanks in advance :D.

Can anybody tell me how many storage engines are there in MySQL and which engine is the default engine in MySQL? Kindly post answer if know it

[B] I will do an artifical intellegent project which is knowledge base system My question is Can I use [COLOR="Red"]ORACLE[/COLOR] database as knowledge base?[/B]

I was browsing a MySql database using phpMyAdmin and I have probably inadverdently changed a setting. I have a field which contains quite large text entries. Before this problem arose the display showed just a few words of the text entry followed by a "...". Now the display shows the …

Hi Its in fact easy to handle special characters like "%" in query, with just a bit of research one can found solution for this. Today when i checked events for my server i found that one error message and that was because a user searched for " l'atelier " …

hi friends.. I need an alternate query without using UNION for below query.. [CODE]select DIST_NO from acquired_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched'[/CODE]

I have 2 tables: 1. users - user_id(PK), firstname, middlename, lastname 2. user_shift_schedule - shift_code(PK), user_id(FK), effectivity_date I want to get all rows with the latest effectivity_date for each user_id. This is what I've got so far: [CODE]SELECT users.user_id ,users.firstname ,users.middlename ,users.lastname ,user_shift_schedule.shift_id ,MAX(user_shift_schedule.effectivity_date) FROM users JOIN user_shift_schedule ON users.user_id=user_shift_schedule.user_id …

Hi Forumer's, I have 3 tables, my objective is to compare the returndate from receiptdate and trandate and get the most recent receiptdate or trandate based on returndate. [CODE] Create Table #USPRODUCT (ESN Nvarchar(35), returndate datetime) Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-04-21') Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-08-08') …

Good day, I want to delete a record from a single table but some of the filed on sigle record is related to other table on my database. how would i delete it.. i used this script delete from faculty deptid = (select deptCode from dept) all i want is …

Dear All, I have a database with two columns, to keep several files of text with lots of text lines in each text: ----------------------- |---name -|- Text---| ----------------------- I want the column |-name-| to be a primary key, and to upload the text file I'm using the command: [CODE] LOAD …

HI There This is the error I am receiving when trying to register on the site: Column count doesn't match value count at row 1 error: failed to execute query INSERT INTO users (uname,uteln,umail,ustre,usubu,ucity,uprov,ucode,uuser,upass,uc_dt) VALUES This is the regi.php coding. I cannot figure out the problem <?php if (isset($_POST['register'])) { …

Hi everyone, [CODE]select sql_calc_found_rows DIST_NO from acquired WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' LIMIT 0, 5; [/CODE] The above query takes more than 4.5secs if i run the query without sql_calc_found_rows the execution time is 0.7 secs [CODE]select DIST_NO …

I have a database that continually receives information from outside sources. I then use SQL code to take this data and move to different databases based on the information received. As it stands right now, if I receive a '1', '2', '3', from an outside source, we manually move it. …

hello ! i have experience in VB.net,C# and MSSQL2000,2005,2008r2 .but today my boss assign me a task to connect mssql server 2008 by using JS or JSON ,both are unknown for me ,:( i dont have any knowledge about JSON and JS , can any one help me how to …

[CODE]IF OBJECT_ID('tempdb..#Table', 'U') IS NOT NULL DROP TABLE #Table GO Create Table #Table ( CorrectionDate datetime, Origdesc nvarchar(50), Newdesc nvarchar(50), Total int ) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','RMAWAR','NTF',193) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','NTF','RMAWAR',108) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','RMAWAR','Sub Abuse',86) Insert Into …

Hi everybody, I found an error-based sql injection in my webserver.My database doesn't contain any private info. I want to know if its possible to own my server just by using the info in information_shema. Please tell me because i want to know if i have to fix it.I don't …

Hi All i am getting the below error pls help me to solve the issue datbase erre:ORA-20220: ORA-06502 PL/SQL: nemeric or value error: number precision too large in sp_watm_per_adj ORA-06512 at sp_watm_per_adj line 375 ORA-06512 at line 1 create or replace PROCEDURE sp_watm_per_adj ( in_per_adj_cd in per_adj.per_adj_cd%type, in_per_dt in per_adj.per_dt%type, …

[CODE] <?php // Duplicate entries remover from database // task :: load url check if more than 2 entries exists replace it with new entry session_start(); // no time limit set_time_limit(0); // connect to db include ("config.php"); // select data from database target woth and domain table $result = mysql_query( …

Hey guys...I have a MySql table like this. and [B]Grade [/B]column is a derived attribute. and it is based on [B]Marks[/B]. u know the basic thing. [CODE]create table Enrolled( student_id char(14), subject_code varchar(10), marks int, grade char(2) );[/CODE] I want to fill the [B]Grade[/B] column based on each student's marks. …

I am new to mySQL and is not sure where to start from. I have a database of username, password, date of creation, active/inactive (1 and 0), name and etc... I would like to know how I can add a field that involves with counting down the days. Say for …

in the diagram provided in the attachment.i have created a table for the entity loan and now i am facing difficulty in creating a table for payment.i know that payment is the dependent entity.is the following way of creating a table correct???? create table payment( payment_number int, payment_date date, payment_amount …

Hi, Can anyone please tell me how to log all activity of my mysql database. Also do you know if there any tripwire services/products that are available ? Thanks,

Hi guys. I have a table as follows: [ICODE] ID | Data ---------------------- 1 | A 1 | B 1 | C[/ICODE] It is possible to make like this one. [ICODE]ID | Data1 | Data2 | Data3 ------------------------------------------------------- 1 | A | B | C[/ICODE] Thanks.

Hi everyone, I'm new to mySQL. I have a table like this one: [ICODE]+-------+-------+-------+ | date | plant | value | +-------+-------+-------+ | date1 | 1 | 10 | | date2 | 1 | 12 | | date3 | 1 | 15 | | date4 | 2 | 30 | …

how can i select all records from a table where a future date column is less than 14 days away within a php table. somthing similar to? [CODE]SELECT DISTINCT FROM table WHERE 'Date_Column' <14 days [/CODE] Thanx In Advance KeeF

Good Morning Lladies and Gentlemen: . I need some help in my app... I am using Access 2007 (from MS Office 2007 Pro). I have an attachment field in my customer table that holds multiple attachments. I need to preserve this data so transferring to from a spreadsheet DOES NOT …

I need to select data available between 20:00 and 08:00 (8 PM to 8 AM). How do I achieve this? The column is of type TIME.

Hi, I have a table called BookTitle that holds book information. I have an SQL statement that lists all books that have the same value of a book called 'Northern Lights'. The code works but what I want to do is to exclude 'Northern Lights' from the result. This is …

Hello all, I have a .zip file which is stored within a BLOB file. Using SQL Developer, how can I extract the .zip file from the BLOB in order to either open the file or store it on my local drive? I've never dealt with Zip files in BLOBS prior …

*********************************************** select * from table_name where RIGHT_CODE IN (SELECT GROUP_CONCAT(''',`RIGHT_CODE',''')as right_code FROM table_name GROUP BY `GRP_CODE` , `ROOT_DESC` HAVING count( `RIGHT_CODE` ) >=2 **************************************************** Actually the above query returns empty result. But the query Inside IN cluase which returns ('1','28').. If i directly pass the value inside IN clause means …

I just tried to install IIg on my laptop. It seems to have worked, but there were issues. The program couldn't find several files during the install process, but still seems to have worked. What did not was the config part where it looked for a template file. I had …

Hi, All i want to show is the 'fr_players' to have two categories of 'fr_nations' and 'fr_clubs' and fetch the names from the foreign id... Here what i have done so far but it doesnt shows any error or return any tables either: [CODE]SELECT a.id as club_id, a.fr_name as club_name, …

I have a table in my database and i would like to bring up all the details where the datafield "votes" is the largest. i cannot get the fuctionality i desire. i would like a user to make a choice from the selection then have all the datafield where "votes" …

Hi Guys. I'm having an error "Error No. 2003. Can't connect to MySQL server on 'localhost' (10061)". I am using windows XP in my laptop. Before, I have no problem in using MySQL. I also tried to connect using MySQL Administrator, but I got the same error. Sometimes I can …

Hi I am trying to design db to coupon site my problem: item can be in several areas. like : chair in South and North for that I have created the extra categorytoarea table but i dont know how the relationship should be with other tables

Hello everybody, My question is simple. I wish to develop a web site and I have been looking for web hosts and most offer MySql. At my job we use oracle, but after some searching I haven't found any great differences between them and any real reasons why I should …

I'm trying to create a table in oracle here's the code [code] drop table class; create table class (schedule_num integer primary key not null, semester varchar(10), course_name varchar(14), credit int, department varchar(15), /* meeting_time time,*/ meeting_place varchar(20), enrollment_limit int); [/code] I don't how to initiate the 'time' data-type, can someone …

i want to find records between two dates IN ORCALE but the table field values is in "mm/dd/yy hh:mm::ss" and data type is varchar2 The query which i was trying was: [CODE] SELECT * FROM NEW_OUTPUT_UPLOAD_TSN WHERE OUTPUT_UPLOAD_DATE BETWEEN TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') AND TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') [/CODE]

Hello Friends. Im having a problem in identifying the Provider for my MSSQL Server 2008. Can anyone address me the location of this information because I have to initialize it in my VB.et. As I understand for Ms Access it is something like [CODE]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="[/CODE] Can I know where to …

My table has these info T123 T153 T174 Basic SQL count works fine which results to (3).. but when I use this function needed for my query the output is 4. [CODE] COUNT(DISTINCT CASE WHEN id LIKE '%T%' THEN RIGHT(ID, 3) ELSE 0 END) AS Count [/CODE] what's wrong with …