Community Member
Member Avatar
|-|x 126 Began Watching min - return more than 1 record
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) as 'unit_cm', d.unit_cost, d.unit_price, ((d.unit_cost/d.unit_price)*100) as 'unit_costPerc'
FROM menu_items a, item b, menu c, price d, categories e
where a.item_id_fk … Topic by solomon_13000 in Databases
Member Avatar
|-|x 126 Replied To a Post in min - return more than 1 record
Topic by solomon_13000 in Databases
`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 3` in the subquery. Reply by |-|x
Member Avatar
|-|x 126 Began Watching sql server 2008 problem
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 were displaying
1- sql server configuration manager
2- send errors and reports
3- sql server installation center.

But other features … Topic by Saboor Siddique in Databases
Member Avatar
|-|x 126 Replied To a Post in sql server 2008 problem
Topic by Saboor Siddique in Databases
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 the Microsoft SQL Server service is listed and running etc. Reply by |-|x
Member Avatar
Featured |-|x 126 Replied To a Post in What constitutes the "End of File"
Topic by doncwilson_1 in Software Development
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](https://msdn.microsoft.com/en-us/library/system.io.file.appendtext(v=vs.110).aspx) - this method opens the file once and closes it at the end, rather than open-closing for each line written. The excessive file handling … Reply by |-|x
Member Avatar
Featured |-|x 126 Began Watching What constitutes the "End of File"
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 the weekend that will eventually be read and pulled into an Excel spreadsheet (generally there are three files). Using VB.net, … Topic by doncwilson_1 in Software Development
Member Avatar
Featured |-|x 126 Replied To a Post in What constitutes the "End of File"
Topic by doncwilson_1 in Software Development
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 the first). If you are able to post code I could probably be more specific? Reply by |-|x
Member Avatar
|-|x 126 Began Watching create Report using microsoft word
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 Content Controls to Custom XML Using the XMLMapping Object c# Topic by IsmailMBakr in Software Development
Member Avatar
|-|x 126 Replied To a Post in create Report using microsoft word
Topic by IsmailMBakr in Software Development
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 `Microsoft.Office.Interop.Word` and you must have word installed on the machine this will run on (ie; if it will be deployed … Reply by |-|x
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, the code implemented needs to pass the source and medium info (facebook /social) into the gaps (_____) in link url. … Topic by jelly46 in Web Development
Member Avatar
Topic by jelly46 in Web Development
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 (such as if it is databound, produced in code behind etc.) I can give you more specific pointers.

<asp:HyperLink ID="HyperLink1" … Reply by |-|x
Member Avatar
|-|x 126 Began Watching Using html onclick in java servlets
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 calling it when the button is clicked, but it's not getting called. Please help. Topic by theGrinch in Web Development
Member Avatar
|-|x 126 Replied To a Post in Using html onclick in java servlets
Topic by theGrinch in Web Development
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 believe you need to have the form `POST` to your servlet in order for the Java code to execute on … Reply by |-|x
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 error. **Microsoft.Office.Interop.Excel.Application' is not defined.**
i am still new and still exploring in vb.net. thank you in advance!
Any help … Topic by Grazel in Software Development
Member Avatar
Topic by Grazel in Software Development
Can you post some code? looks like you have a object type where it expects a defined variable. Reply by |-|x
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. In this part of the code: Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click


Protected Sub Button1_Click(sender As … Topic by 2jewel in Web Development
Member Avatar
Topic by 2jewel in Web Development
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 though theoretically anything is an object).

Dim datasource As New ReportDataSource("USACity_mCity", CType(DS, Object)) Reply by |-|x
Member Avatar
|-|x 126 Began Watching download manager
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 web server


|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
download points : 1 2 3 4 5


they are downloading from all the points 1,2,3,4,5 simultaneously..i'm … Topic by cool_zephyr in Software Development