Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 5 5 5 4 3 3 3 3 2
Member Avatar
Member Avatar
Hi, In a representative table, I have fields, like, id, mark_id, rep_id rep_name, father name,etc, In this table, rep_id field is empty, And in rep_area table, the fields are like id, rep_id, dist_id,etc, in this table, rep_id has values. While editing the representative form i want to display rep_id from …
by AntonyRayan 15 in Databases ()
Member Avatar
I am using the MySQL C API and having problems defining a stored procedure. MY SQL script works fine in MySQL Workbench but the same script fails in my own software. A test script which shows the problem is: ... The error message I get is: ... I have studied …
by SalmiSoft 102 in Databases ()
Member Avatar
i does not know about store the image in database. what is the datatype of picture in oracle?
by N kamatchi in Databases ()
Member Avatar
I have created a sp little bit confuse about it. how to count result set if data availabe then show it and if not then retun ResultStatus is zero. did not work much with sp. thanks for any help suggestions. ...
by mangel.murti 5 in Databases ()
Member Avatar
hello. I am getting a blank page on localhost/myproject/ i am pretcty sure th.at\ it cant connect to the database because when i am using a simple echo it returns. for example ... THE THING IS THAT I AM USING WOS PORTABLE IS IT POSSIBLE THAT IT DOESNT SUPPORT PHPMYADMIN? …
by SimonIoa 39 in Databases ()
Member Avatar
...
by SimonIoa 39 in Databases ()
Member Avatar
I am trying to insert a set of attribute rows into a table based on the range of a unique key (product_id) and three passed variables. This is on a MySQL database. The three variables are the start_product_id, the end_product_id and the batch_attr_id. The stored procedure does not return an …
by mskat02 in Databases ()
Member Avatar
Ok, here is what I get when I run the query. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near newmessage ... 0 ... companyi' at line 4 Here is what it …
by Sutarusu in Databases ()
Member Avatar
Hi I have a query and I like to see the result until the condition match. I am trying to find if the end date(+1day) is equal to next row start date if so list it. I have the below query does the job but it also list whole table …
by kadriirdak in Databases ()
Member Avatar
Hello everyone! My Access MDB file has "disappeared" from his documents folder. I haven't deleted it, I have checked recycle bin, system restored, searched and so on. No luck! Any suggestions on what else I could do to recover the file?
by Nicko21 in Databases ()
Member Avatar
Hello, Is it possible to join two tables from two different databases. I have the following query whereas the table named "calendar" is in a separate database than the table names history. Any ideas on how to join bottom? ... I appreciate any thoughts on this. Mossa
by mbarandao in Databases ()
Member Avatar
I work for a small company made up of a salesman, a graphic artist, and an engineer. The engineer writes and maintains all of his own software to run a network of interactive kiosks around the globe. As artist, I use his tools to maintain and update the network content. …
by evandrosiqueira in Databases ()
Member Avatar
I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code ... The unique idx is the curcd,code,item. What I wish to achieve is duplicate data of code '80' with a set of code = '82' So, …
by lps 71 in Databases ()
Member Avatar
i want to retrieve a single row from my database i use this and i get nothing ... i found this online but still the same ...
by SimonIoa 39 in Databases ()
Member Avatar
Hi, I am displaying list of jobs that are posted by admin from mysql db. In that Table I used requisition_id (job id) , and the datatype is varchar(255), if we click the job id , it will show the description . My problem is, if it more than one …
by AntonyRayan 15 in Databases ()
Member Avatar
Hello All, I want to write the plsql stored procedure to insert multiple rows in a table. Table t1, table t2. Table t1 column names(c1,c2,c3,c4,c5) table t2 column name (c2,c3,c4) column names c2, c3, c4 are same in both tables. now I want to insert the data into t1 by …
by Azii in Databases ()
Member Avatar
I am in need of help on this one :( i cannot seem to figure out what i have done wrong, i set up my code just like in teh examples i read and i dont really see anything wrong with the logic (as far as i can tell) but …
by berserk 60 in Databases ()
Member Avatar
The database that I'm working for has been suddenly corrupted. Fortunately, I performed a backup on it and save to a backup tape. Therefore, I reinstalled SQL Server and I tried to restore those backup. However, it failed and I suspect that maybe the backup is corrupted too as well. …
by olavbundgaard in Databases ()
Member Avatar
This is the table that gives error ... Here are Contract and Lawfirm Tables ...
by Kubilay Do─čukan in Databases ()
Member Avatar
I am sorta new to MySQL and not 100% sure of what I can and can not do with it yet. I have an xml file with course information such as ReferenceNo. CourseName, CourseType, CourseLocation, and I want to load in into a database table that has column names such …
by donz365 42 in Databases ()
Member Avatar
// this works sql = "SELECT * FROM ... WHERE location='article' AND image_id='7'"; // this works sql = "SELECT * FROM ... WHERE location='article' AND image_id='9'"; // this does not work sql = "SELECT * FROM ... WHERE location='article' AND image_id='7' AND image_id='9'"; // I wonder why?
by davy_yg 16 in Databases ()
Member Avatar
Hi I am working in weekly Newspaper company. There are 15000 subscriber, subscribed for next 3 to 4 years.Per year 52 weeks and I have to generate issue number based on week(1001......3000) for each subscriber and store into data table. I am using mssql 2012. I have written the Store …
by Maideen in Databases ()
Member Avatar
Hello :) I'm trying to create web application. I followed the tutorial given in this site : ... My problem now, after I create a table and the UI. Next step show about stored procedure. What is stored procedure use for? Do I need this even though I had a …
by nimz143 in Databases ()
Member Avatar
Hi All, I want to copy the missing 'data' field from 'tb1' to 'tb2' based on the 'id' value. Please suggest the possible queries. ...
by k_manimuthu 43 in Databases ()
Member Avatar
I want to know how to achieve the following: I want to convert a varchar to a date format but so far I'm not very successfull... My date (varchar) looks something like this: 02-02-2012 11:48 AM And I want to convert it to the following this: dd-mm-yyyy To be able …
by Joemeister in Databases ()
Member Avatar
I am calling data from my database but the result is not what I want. Below is my code: Select distinct concat(ImporterDistributor.name, '/', ID.name) as [Distributor_Importer], case when Product_Delivery.Product=1 then isnull(max(Product_Delivery.Opening),0) end as OpeningPMS, case when Product_Delivery.Product=2 then isnull(max(Product_Delivery.Opening),0) end as OpeningAGO, case when Product_Delivery.Product=3 then isnull(max(Product_Delivery.Opening),0) end as OpeningATK …
by Trench37716 in Databases ()
Member Avatar
I am quite new to SQL but I was wondering how to achieve the following. How do I get specific values that fall in the year 2013 when the date format in the table is looking something like this: ... I also want to use the BETWEEN clause that will …
by Joemeister in Databases ()
Member Avatar
I'm trying to do a simple a database SQL script where I simply need tocreate a database as well as 4 tables within. So far I'm getting a very annoying error that states: There is already an object named 'DEVICE_TYPE' in the database. Why, I don't know? Any help regarding …
by Joemeister in Databases ()
Member Avatar
A question..how can we store our nose and ear in data base?? plz reply.
by Gangotri in Databases ()
Chat Log Latest Posts