Databases
Member Avatar

The following SQL query would return 1 record with a min(unit_cm):

select id, name, category, min(unit_cm), unit_Cost, unit_price, unit_costPerc from (

SELECT a.id, b.name, e.name as 'category', (d.unit_price - d.unit_cost) …
Databases
Member Avatar

The following SQL query would return 1 record with a min(unit_cm):

select id, name, category, min(unit_cm), unit_Cost, unit_price, unit_costPerc from (

SELECT a.id, b.name, e.name as 'category', (d.unit_price - d.unit_cost) …
Topic by solomon_13000

ORDER BY unit_cm DESC LIMIT 3 will actually give you the 3 records with the highest values of unit_cm

To get the smallest values use `ORDER BY unit_cm ASC LIMIT …

Databases
Member Avatar

Hi! I am facing problems with sql server 2008.
I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features …

Databases
Member Avatar

Hi! I am facing problems with sql server 2008.
I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features …

Topic by Saboor Siddique

You might have more luck posting under the "MS SQL" forum (this is the MySQL forum).

First advice I can offer is to check your Services applet and see if …

Software Development
Member Avatar

I need to identify how the code identifies that a file is at the "eof" (end of file). Here's why:

On Monday's, I'm having to combine text files created over …

Topic by doncwilson_1

I can't see anything specifically wrong with the code you have posted. My suggestion would be to try using a StreamWriter, take a look at File.AppendText - this method opens …

Software Development
Member Avatar

I need to identify how the code identifies that a file is at the "eof" (end of file). Here's why:

On Monday's, I'm having to combine text files created over …

Software Development
Member Avatar

I need to identify how the code identifies that a file is at the "eof" (end of file). Here's why:

On Monday's, I'm having to combine text files created over …

Topic by doncwilson_1

It sounds like a file pointer still pointing to the first file, while you are trying to move it further through the second file (possibly before it is appended to …

Software Development
Member Avatar

How we can create word document that is atemplate (contains paceholder to data ) and fill this template from xml document that contains data from serialized object

Mapping Word 2007 …

Software Development
Member Avatar

How we can create word document that is atemplate (contains paceholder to data ) and fill this template from xml document that contains data from serialized object

Mapping Word 2007 …

Topic by IsmailMBakr

You can instantiate an instance of the MS Word application via C# and programatically access all of the functions you would via the graphical interface. Your project needs to reference …

Web Development
Member Avatar

How to pass link data from one page to another page using querystring in asp net

This link would be set up something like this:

http://.mywebsite.com/site/TR?fr_id=1131&pg=entry?utm_source=______&utm_medium=_______&utm_campaign=ABCD2015

When it is clicked, …

Web Development
Member Avatar

How to pass link data from one page to another page using querystring in asp net

This link would be set up something like this:

http://.mywebsite.com/site/TR?fr_id=1131&pg=entry?utm_source=______&utm_medium=_______&utm_campaign=ABCD2015

When it is clicked, …

Topic by jelly46

You need to concatenate the values into the URL string of your link. This is a general example, but if you provide more context about the code you are using …

Web Development
Member Avatar

I'm trying to use html onclick in java servlets like this;

ShoppingCart cart = new ShoppingCart();
out.println("  <h1><button type=\"button\" onclick=\"cart.addBook(b.getIsbn())\">add</button> </h1>");

addBook is a method in ShoppingCart class, and I'm …

Web Development
Member Avatar

I'm trying to use html onclick in java servlets like this;

ShoppingCart cart = new ShoppingCart();
out.println("  <h1><button type=\"button\" onclick=\"cart.addBook(b.getIsbn())\">add</button> </h1>");

addBook is a method in ShoppingCart class, and I'm …

Topic by theGrinch

the onclick event on a standard HTML button invokes javascript, not Java. So your code is looking for a javascript function called addBook on a javascript object called cart.

I …

Software Development
Member Avatar

hi i am creating a program that needed an excel app., and i already do it, at first no error, but after a sudden, an error appeal, here is a …

Software Development
Member Avatar

hi i am creating a program that needed an excel app., and i already do it, at first no error, but after a sudden, an error appeal, here is a …

Topic by Grazel

Can you post some code? looks like you have a object type where it expects a defined variable.

Web Development
Member Avatar

Hello all,

I am having an issue learning some things in visual studio 2013 asp.net using vb. I am following a fellows instruction on doing a report with a parameter. …

Web Development
Member Avatar

Hello all,

I am having an issue learning some things in visual studio 2013 asp.net using vb. I am following a fellows instruction on doing a report with a parameter. …

Topic by 2jewel

You could try casting the datasource table you are passing in as an object (it could be just a resolution issue with the constructor definition expecting an object type, even …

Software Development
Member Avatar

i want to develop a simple download manager..i have seen download managers downloading a file..but they have multiple download points
e.g. suppose i have a file like this on a …