|
Hi, imagine the following example:
select [o].[ID] , [r].[quantity],[r].[price]<br />
from <br />
[Order] o,<br />
[OrderRow] r<br />
where <br />
(r.OrderID = o.ID)
if i would like to apply a filter on the sum of quantity*price for all rows ontop of that and still return each orderrow just like before. how can this be done?
currently i have :
select [o].[ID] , [r].[quantity],[r].[price]<br />
from <br />
[Order] o,<br />
[OrderRow] r<br />
where <br />
(r.OrderID = o.ID) and<br />
o.id in (<br />
select [o].[ID] <br />
from <br />
[Order] o,<br />
[OrderRow] r<br />
where <br />
(r.OrderID = o.ID)<br />
group by [o].[id]<br />
having <br />
sum (r.quantity * r.price) >= 100<br />
)
so this query will still give me each orderrow , but filter out orders where the order sum is less than 100
is it really not possible to accomplish this w/o a subquery?
//Roger
|
|
|
|
|
hello forum,
Not sure if this is the most suitable place in codeproject to put a thread related to Active Directory... sorry, if does not.
I have got a problem while searching directory through ADSI.
I want to search those organizational Units which contains a specific substring in its distinguishedName attribute. The filter expression is as follow:
(&(objectClass=organizationalUnit)(distinguishedName=*mysubstring*))
where mysubstring is the specific substring.
The problem is I get always nothing.
Could u give me any idea what is the problem and how to solve it?
thanks in advance!
|
|
|
|
|
Can anybody explain the reason for getting this error.
Snapshot of sql server error log:
2005-02-07 05:38:58.48 spid63 Error: 17805, Severity: 20, State: 3
2005-02-07 05:38:58.48 spid63 Invalid buffer received from client..
2005-02-07 05:54:49.29 spid75 Error: 17805, Severity: 20, State: 3
2005-02-07 05:54:49.29 spid75 Invalid buffer received from client..
The application fails when it tries to update a row in table. The table has a column of type text.
Sabya
|
|
|
|
|
Im making an access db, that is accessed through my VB 6.0 software.
How would a clever way be to store this array in my database without making 500 rows in the table for it.
Its 500 double values from a testsystem, that is used to draw a curve.
|
|
|
|
|
Save the array seperated by ",", like "array1,array2,array3,..... "
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
|
Hi all,
I intend to use the Firebird database engine as the embedded
database engine of our desktop window application written in C#.
Have anyone used it before and is it good enough ? How is it compared
to the Microsoft MSDE data engine in performance, in ease of installation, maintainability....etc.. ?
Thanks
|
|
|
|
|
pyhtang1 wrote:
I intend to use the Firebird database engine
Why would you ask if you have already made a decision?
How did you come to that decision if you have not already made this comparison?
Anger is the most impotent of passions. It effects nothing it goes about, and hurts the one who is possessed by it more than the one against whom it is directed.
Carl Sandburg
|
|
|
|
|
hi all,
Jsut a quick question, I have a product database with a productcost field, when i enter a cost into the field i use for exemple £100 or £0.50. When I run my website in asp.net it shows a dollar sign $ instead of a pound sign.
Any ideas on how to correct this?
I have checked the help files in SQL server 2000 and also in visual studio.net...cant find anything related....its gotta be something easy??
Thanks in advance!
|
|
|
|
|
Is your website hosted in the same machne where you edit the database?
If not, your machine probably is configured (in Control Panel, Regional settings) to format the currency values like British (pounds). And probably the ASP.NET server is configured for an english-US culture.
Do something like this in your ASP.NET code:
CultureInfo ci = new CultureInfo("en-br");
decimal dMyMoney = 12.99m;
string strMoneyInPounds = dMyMoney.ToString("c", ci);I'm not exactly sure of the syntax, but that should format your decimal value as currency (the "c" parameter) using the English (UK variant) culture.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Thanks for your help....I've sorted it out now..Knew it would be something simple!
Cheers
Jetset
|
|
|
|
|
Could someone please be so kind to tell my: How can I debug the SQLCE Database form a Pocket PC. There must be a possibility to see what's in the tables of the database???
Thank's very much
Stefan
(Austria, sorry for my English)
|
|
|
|
|
I've saved an image (converting in byte[]) inside a field of my database, now i would read the database getting these bytes[] and convertering into the original image...
I use this code:
OleDbDataReader myReader;
....
.. instance myReader here...
....
myCommand.ExecuteReader();
MemoryStream myStream;
int buffersize = 300000; // doubt n°2 = but if my image is bigger of 300000 ???
Byte[] outbyte = new Byte[299999];
myStream = new MemoryStream(outbyte, 0, 300000, true);
myReader.GetBytes(5, 0, outbyte, 0, buffersize);
myStream.Flush(); // am i just deleting all bytes unused?
pictureBox1.Image = Image.FromStream(myStream);
myStream.Close();
but this code doesn't work, where do i wrong?
|
|
|
|
|
I've tried to change the code in this way:
MemoryStream myStream;
Byte[] outbyte = (Byte[])myReader["Image"];
myStream = new MemoryStream(outbyte);
pictureBox1.Image = Image.FromStream(myStream);
myStream.Close();
but this doesn't work too.
|
|
|
|
|
|
Yes i did, but when i use (Byte[])cmd.ExexuteScalar() i get only 18 byte at the place of 17322 that is my image, why?
|
|
|
|
|
I'm having much problems working with my .mdb database.
Yes there are objects in VISUAL STUDIO (c#) .NET that make easyer the work but i would to write all it needs by code.
What i've to do for the moment is add a row to my database with 4 columns of which one is byte conteiner (image bitmap).
Ok i've tryied much code from google c-charpcorner codeproject msdn end so on... but all that give me some error, the forums user told me to set insertcomand updatecomand fill fillschema set a primarykey but all half informations i can't manage...
Please someone can show me a full code to connect to a simple database .mdb with a Table and insert just a row inside?
This is the schema:
Table 'myTable'
Name: text 20 (primary key)
Surname: text 20
Image: OLEOB byte[]
REALLY THANKS.
|
|
|
|
|
|
Hi everybody,
I'm using ASP .NET with MS SQL Server 2000 Personal Edition. They work well in Windows XP SP 1, but when I set up Window XP SP2, an error occurs:
<br />
SQL Server does not exist or access denied. <br />
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br />
<br />
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied<br />
Then I thought it is an trouble with the MS SQL Server, so I reinstalled MS SQL Server several times, but this error still occurs. Please help me!!!
Thank you very much!
Ich liebe .NET 
|
|
|
|
|
Hi
check this Article[^] about SQL server and XP SP2
I wish it can help.
|
|
|
|
|
Thank you very much! I can fix the problem now!
Ich liebe .NET
|
|
|
|
|
Hi
I use SQL Server personal edition SP3
In the Event log..SQL servee adds many events for the all databases like this :
3455 :Analysis of database 'DATABASENAME' (DATABASEID) is 100% complete (approximately 0 more seconds)
an event record is added about 20 times for each database and i realize that the overall performance of the server degrades.
How to prevent SQL Server from making this analysis too frequently ?
|
|
|
|
|
ok
seems that enabling the Auto close option for some databases made this problem.
|
|
|
|
|
Hello,
Here's a good question for all you SQL gurus here in CP.
I have a Customers table with PK ID_customer and other customer information such as name, birth date, etc.
I have an Addresses table which contains all the information for an address, such as street, exterior number and so on. The primary key is ID_address, and contains ID_customer field for relating it to the customer. This table contains a foreign key ID_city. Each address has a date indicating since when it is valid (one starting 1/1/2000 and another from 1/1/2001 for example.)
My Cities table contains a PK ID_city for each of the cities that are allowed in an address, and another field CityName.
So, I developed a stored procedure to find all the records matching certain criteria (all fields in the Customer table) using IF NOT @param = NULL to check the different criteria (I can search by name or by customer ID, for example) and performing a SELECT query.
My problem is that this SELECT query must return only one record for each customer matching, and that record must contain the CityName for the latest address for that customer (or blank if no address registerd). I can do the JOIN, and with a GROUP BY but it returns one record for each different city each customer has.
So, any ideas?
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
I don`t get it, you mean each customer has many cities?
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
