Posts by debasisdas

Which is the PRICE column, in which table ?

No.

You can use select * --- for select all the columns.

If you want selected list of columns only, you need to mention the list in your SQL.

So what better day to start then Today.

please post the table structure only, not all the data in it.

No, if you do not want all the columns you need to specify the list of columns.

If it a table or a view you can create a view on the source object using only the desired columns.

this may help

SELECT DISTINCT
    producten.artnr,
    productlines.prod_id,
    producten.id,
    producten.naam,
    producten.land,
    producten.type,
    producten.kort_omschrijving,
    producten.omschrijving,
    producten.front,
    producten.fles,
    producten.doos,
    producten.metadesc,
    producten.metakey,
    producten.title,
    producten.afbeelding,
    productlines.bedrag
    FROM producten 
    WHERE producten.id IN (SELECT prod_id FROM productlines WHERE price= (select price from productlines)group by prod_id)
    ORDER BY productlines.bedrag

why not select the product with min(price) from second table and fetch that product record from 1st table.

Sorry, we do not solve assignment / home work questions here.

Show some effort to get help.

try this

SELECT * FROM ProfilesWebsites LEFT JOIN ProfilesAccounts 
ON ProfilesWebsites.ProfileWebsiteName = ProfilesAccounts.ProfileWebsiteName

database should always be in centralized server.

I think the length of the field is the problem.

i.e.---VARCHAR(50)

change it to VARCHAR(500) and check.

you need to store only the following

http://www.daniweb.com/web-development/databases/mysql/threads/368668

Yes, you can go with the above approach.

Hi Radu,

Welcome to Daniweb.

Hope you have a nice time here.

with the information provided by you it is not possible to guess anything.

if you check, both of the follwing points to the same page.

[url]http://www.daniweb.com/web-development/databases/mysql/threads/368668[/url]
or
[url]http://www.daniweb.com/web-development/databases/126/threads/368668[/url]

so you can use either of them.

that sounds appropriate.

and all forums on web may not follow the same naming conventions.

Hi David,

Welcome to Daniweb.

Please find it here.

mysql ---- forum name
126 ---- forum id

only forum name is included in the thread URL not the forum id.

Take this thread as example

Daniweb Mysql forum URL --- http://www.daniweb.com/web-development/databases/mysql/126

This thread URL --- http://www.daniweb.com/web-development/databases/mysql/threads/368668

have you tried as suggested by urtrivedi ?

What you have tried so far ?

I cannot understand why you are having a problem with my posts.

that is because you are not posting here what the exact requirement is.

I have written a program in VB6 that requires certain information to be entered and saved. The information has to be like the following example. Harry.E

As you can see Harry.E has no spaces. When I try to enter Harry.E the program will not accept an upper case letter immediately following a period so it changes the entry to Harry.e which is not what I want.

If the code is designed to accept the information is a certain way , why it will not accept.

Lets see your code.

Please find it here and here.

lets see the code that you are working on.

can't you find the base tables of the view from SQL(in the TEXT column of above mentioned dictionary object) ?

and once you have the SQL, that can be modified for any new requirement.

try this

select * from user_views

rownum is not useful bcoz rownum not coming sequentially it will b come like for first rownum 4 then 2 then 10 like.

have you ever user ROWNUM, or that is just an assumption.

Hi,

Welcome to Daniweb.

you need to use ROWNUM.

what is the source of the data ?

is it from any database ?

You granted from which schema system or HR ?

dont have a pc and no resources (books,internet) ...

I am really sorry for you, can't do much about that.

please post some sample data for input with expected output.

please check this and this.

if name is already followed by a period and an uppercase letter, what is the problem then ?

that will depend on how the image is stored in the database
1. if you are storing only the file path

You need to retrieve the path from Db and point to the same from Picture Box.

2. if the image is stored as a binary stream.

retrieve the stream
recreate the image from stream
display in Picture Box.

You need to update the data not the application, right ?

You need to use a centralized database and all the branches should access the single instance.

You need to update the data not the application, right ?

You need to use a centralized database and all the branches should access the single instance.

Simply you can try to ping the system using its IP or system name over LAN.

Can you please post your database table structures.

Welcome to Daniweb.

that should be feature of application not oracle database.

try this

SELECT  * from empl 
  where  LOWER(REPLACE(replace(replace(replace(replace(drug_name,'.',' '),'_',' '),'-',''),',',' '),' ','')) = 'govindraj'

that is what i said in my post.

it is a sample code so i said check for MySQL syntax.

NOTE :-- the code is in Oracle syntax.

.... i have no pc at home i dont have much time

what you don't have is will to learn and the problem is you are also too lazy to use search engine.

pray that u cahnge ur mind for me

We don't bend our rules.

try this sample code

select * from empl 
where lower(replace(translate(ename,'., _-','     '),' ',''))= 'govindraj'

you need to modify the above query to suit your requirements.
also check for MySQL syntax.

what is the query that you are working on.

Have you started with anything yet ?