Databases Forum

Its providing me error................................ [code] insert into products_information values(1,to_timestamp(current_timestamp,'DD-MON-YYYY HH24:MI:SS'),1200,10,1000,12,1100,10) / ERROR: date format picture end before converting entire input string.... [/code] This is making me nuts... Please Help a bit....

Whats the use of super keys and candidate keys when primary key can handle the entire thing in database?????

Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes …

hi. I need to create a table, but I want to set three forgein key each one of different tables. Is that posible to do with oracle?

[CODE]select CS.Ref, CS.C, DT.ID, DT.Init, DT.Surname, 'C' [P], 'C' [A], 100 [M], case when Convert(Varchar(10),CA.A,120) is null then Convert(Varchar(10),CS.DC,120) else Convert(Varchar(10),CA.A,120) end, C.R, Convert(Varchar(10),C.CDate,120), Do.Outcome, CT.PhysicalOwner, Convert(Varchar(10),CS.CDate,120), Convert(decimal(8,2),CS.B, Convert(decimal(8,2),CS.CB), Convert(decimal(8,2),CS.IB), Convert(decimal(8,2),CS.Calance), Convert(money,SUM(dd.C)), Convert(money,SUM(cl.C)), CT.CID[Cust_ID], Convert(varchar(10),CS.JDate,120), CS.JCN, CO.C, Convert(varchar(10),CS.OD,120), CS.OCN, CO2.C from table1 CS inner join table2 DT on DT.DID = …

hey how to answer to these questions Table: Sales(CustomerID , RepID , Area , SaleDate , ProductNo , Quantity , UnitPrice , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write a SQL statement to create the above table (you must use the above …

Guys, I have records from table 1. the objective is to get the date from Table 2. when i try to use select statement to obtain the records it pull all itemnumber with the same item number in TABLE 2. is there any idea to to this using the result …

i have two products , product one has 5 entries of date and product 2 has 4 entries. I want to select max date entries of both... [code] select max(entrydate) from products,products_information where products_information.pno = products.pno [/code] It return a single max date of one product.... Please Help ..............

I have around 20 tables in my database. I want to count every row of every table using COUNT and get a total. I have tried doing a separate select statement for each table then using UNION but I cannot find a way to join the results to get just …

I have this code for mysql, and in my table i have date entries in my date field from my date table ....i want to make use with between clause ...below is my sql statement..but it displays nothing even there are dates in between... SELECT * FROM date WHERE date …

I have been so stupid to hit go at the bottom after I added a new user, deleting all users including root. I have re-installed xampp twice, tried to change the password via the xampp security, still with no success. xAmpp loads perfect on [url]http://localhost[/url], phpMyAdmin though shows the following …

Guys, I have a Date string. My objective is how to get the Datename. I got this Receivedate as string when I used the Bulk insert. i make the receiptdate as nvarchar because i got an error when i used the bulk insert. [CODE] Select ItemNumber, PurchasePrice, ReceivingPO, Cast(ReceivedDate as …

How do i change the name of a table in my sql server 2005 express edition database using visual studio server explorer?

Hi, I am currently studying the database. I came across the concept of 'Keys'. I am very much confused in all of them. Can anyone help me by giving comparison between them along with some example?

Hi all, In my table i have duplicate rows. i want to get distinct rows. select distinct * from table1 does not work. select distinct col1,col2,col3,col4 from table1 does not work. both say: The text data type cannot be selected as DISTINCT because it is not comparable. select distinct(col1) col2,col3,col4 …

Hi all, I want to know how to assin a return value to a variable when calling a regex function. it always returns a bit type of value(its ok). i want that bit type of value tobe cheked whether it is '0' or '1' this is my C# code in …

In the below query,the "Account has been successfully approved" message dispayed. But in the database still approved_status remains '0'. [CODE] <?php $connect=mysql_connect('localhost','root',''); mysql_select_db('bank',$connect); if(isset($_POST['account_number'])) $account_number=$_POST['account_number']; else $account_number=''; $query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number'"; $result= mysql_query($query) or die(mysql_error()); if ($result) { echo "Account has been successfully approved"; } ?> …

hello guys...i have a class table in which there are two fields [B]class_id[/B] and [B]class_name[/B] and a student form in which there is a text field in which user will mention the student class and then hit add.this will retrieve class_id from class table instead of class name into student …

I have written a mysql database using PHP which uses a multi-field form to collect descriptive information about archaeological finds/features etc. Some of the fields are text or medium text in length. It is common when describing things to include references, which frequently now take the form of a url. …

I'm still pretty new to this and I need some help. Here's the situation. First the user opens a form to select which database (one of 3) they are working in. Then they will be using several forms. The same set of forms are always used no matter which database …

This is my 2 tables. [B]account_details[/B] (account_number, nic, full_name, phone_number, address, gender, date_of_birth,__) [B]account[/B] (account_number, name_with_initials,account_type, fd_period,__) I want to select records in both the tables. This is my SQL line. [CODE] $query ="SELECT account_details. nic,full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period". "FROM account_details,account". "WHERE account_details.account_number=account.account_number"; [/CODE] The following error occurs. You have an error in …

without 'joining'

Hi, I have a select statement and I need to find a way to apply a filter to it: [CODE] select * from my_table where my_table.field_1 like :filter_item [/CODE] The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can …

Hi Guys, How do i obtain the nearest shipdate prior to Returndate. here is my sample script. thanks. kindly check my script. the result should be 2011-02-23 [CODE] Table1 ESN--DateReturn 123--2011-03-08 TABLE2 ESN---ShipDate 123---2010-09-28 123---2011-02-23 Select a.DateReturn max(b.shipdate) from Table1 as a left outer join table2 as b on a.esn=b.esn …

Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …

Hello there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any …

Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …

Hello, I have a table that looks like this: [CODE] +----+-------------+-------+-------+-----+ | ID | Player Name | Col 1 | Col 2 | ... | +----+-------------+-------+-------+-----+ | 01 | Some Guy | 2 | 3 | ... | +----+-------------+-------+-------+-----+ [/CODE] the ... represents a (technically) unknown amount of columns. What …

Hello Everyone, I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL, after performing this query: Collapse | Copy Code IIf(IsNull(EventSummary.[Event Information - Event Status]),"ACTIVE",EventSummary.[Event Information - Event Status]) AS [Event Status], I get this error …

Hi, Actually I don't know if my question belongs in this topic or in the VB.net topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I …

I am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. …

I have encountered ORA 00604 Error, while i was accessing database from my app over Vista system over network, it runs ok on database system... Can any one help me please finding out the solution.

Hi, I can't figure out how to write this query, I'm sure it's something silly, but I just can't figure it out!! I have a table with student's grades in different classes they took, example- studId, classId, yearClassTaken, grade 1, 11, 2008, 90 1, 12, 2008, 78 [B]1, 13, 2007, …

What is mysql injection and how is it done? Please help me with an example

Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find …

Update spot_price set location = ‘PATAN’ where symbol = ‘CASTORP’ and polling_date between ‘20110730’ and ‘20110806’ Giving sql syntax error. Same query i am using to update another table in sqlserver its working but not in mysql

I'm missing something stupid so I need another set of eyes. I have a session value set that's a group concat of a few ids and I want to check to see if an id found by a query is in that group concat. The group concat variable is $session_unitidgrouping …

[CODE] insert into AUDIT_TABLE( "TIMESTAMP", AUDITCATEGORY, USERID, AUDIT_XML, "AUDITID", "SOURCE", "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION) select CURRENT_TIMESTAMP, AUDITCATEGORY, USERID, AUDIT_XML, (SELECT MAX(AUDITID)+1 FROM AUDIT_TABLE), dummyNumber||i, "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION from AUDIT_TABLE where "SOURCE"='1312171509321'; [/CODE] Hi, Above is a part of my stored procedure , I'm trying to create test data for …

I was asked a question a few days ago that I cannot easily answer. "Why don't we put all of our small application databases into a single database?" Well, There's nothing really stopping us. All of our small apps were developed in house so we don't have any problems with …

[CODE] set datefirst 6 datepart(wk,'2011-01-12') [/CODE] yields 2. I would like to derive 2011-01-08 from this number. please help.thanks in advance.

I restart a project of mine which use mysql, I used xampp in the past to test the code on the mysql server so I update to lasted version but a piece of code that is identical and was working, I now get an error in [U]the class check in …

Hi, I have 20 rows in a table and I want to update 10 of them only. I am using MS SQL. Any ideas please. Cheers

Hi folks I have several JPEG thumbnail images in a database and need to select particular ones, stitch them together and post them into single cell in the table on a website. I've created the following query: [CODE]SELECT s.Set_Code, t.Mimetype, GROUP_CONCAT(t.Image SEPARATOR '<&nbsp\;>') AS 'Image' FROM Thumbnails t INNER JOIN …

Hi, I have a table with more than 3000 records. I need to replace a particular string of all the rows wid some other string But when i am using replace function Its only replacing half of the rows of the table while the other half are not getting replaced. …

Hi Guys, I have created a manual SSRS Report. when i click the layout tab it display report layout then i drag the fields from report datasets. i want to set my fields into Table details and i want to insert group but this function is missing or hide. i …

Hi, I want to implement a voting system in my web page. What I want to do is give a user 1 point per day so they can give that point to other users but after they give their point they have to wait until the next day to have …

I'm trying to formulate the proper SQL query to pull a roster up on this database I was asked to produce for my kids' HS band. Arrghh. Any help would be great. I have 3 tables. [CODE][U]student[/U] student_ID {PK} first_name last_name email family_ID {FK} [U]family[/U] family_ID {PK} family_phone [U]adult[/U] adult_ID …

I need to know whether there is a performance issue when dealing with the database(database operations)depending on the datatype size of a particular field of a table. I have a table with a SMALLINT size primary key. But there is a chance of having a big data range than this …

I have connected java with oracle over lan, in connection string i have provided the IP address, now the startup is very slow, how can i make it fast, i have already asked the same question in java forum but no responce, so i thought oracle expertise can answer this …

Is this code correct? It is supposed to get input from SMS messaging API and save it to database. Mysql database is created with Table inbox and 2 columns called ID & Msg. I want to know if this code is going to do the job? Else help me in …