|
using ASP.NET (C#.NET) ,try to get a result from two table s using below quary,
SELECT Sum(tbl_user_earned.point_awarded) AS SumOfpoint_awarded, Sum(tbl_transaction_history.points_chash_exchange) AS SumOfpoints_chash_exchange
FROM tbl_transaction_history INNER JOIN tbl_user_earned ON tbl_transaction_history.uid = tbl_user_earned.uid
GROUP BY tbl_transaction_history.uid
HAVING (((tbl_transaction_history.uid)=1));
i tryied to execute this using PHPMYADMIN but this not working ,i got below error
#1054 - Unknown column 'tbl_transaction_history.uid' in 'having clause'
-RAJITH ALWIS
RAJITH ALWIS
|
|
|
|
|
Ok guys,
I'm trying to figure out what mathmatical function is necessary to create an average of these numbers, THEY ARE VARIABLE so basically week by week they change, i.e. so this week is 01 and a year from now will be 52. There are mulitiple transactions a week and I need to separate each by the week number. then I need to list this in a dropdownlist in C#, so to recap:
The following is an output from the DB:
Shift_Number
16,16,16,16,1,1,1,16,16,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,1
at any given time I need to beable to have only one #16 and one #1, and one #2 (and so on and so on week by week.) show in a dropdown list. it seems it would be simple enough to just have the ddlist show xx number of shifts but that is going to be impossible 5 years from now. so any ideas
Dim Beautiful As String
Beautiful = "ignorant"
Label1.Text = "The world is full of " & Beautiful & " people."
Why is common sense such an un-common comodity?
|
|
|
|
|
|
Sorry it didn't make sense, I read back over it and you're right, sorry.
ok, so lets try this again. I am trying to create a dropdownlist that is databound to sql db, the shift_number(which stays the same until closed out) is recorded everytime a user creates a transaction, and so there are always more than one record of the same shift_number in the database.
For example, if a machine is operating on shift 1, every time the transaction occurs, it registers a 1. So, if I have 19 transactions that occurred,then I am shown 19 1's in a row in the dropdown box. (1,1,1,1, etc. 19 times) However, all I need to see shown in the actual dropdown box is 1 instance of number one. All I really need to access is the shift number, and not the number of transactions. The problem is when I attempt to do so, I am given every instance on that shift that a transaction occurred. How do I query the db to do this? what query that would take each instance of the same number and average them so I am only left with that one number in my drop down box and not 19 of the same number?
basicaly i parse the db to find the shift_number i'm looking for then sum the tranaction_amount to create the total shift_value.
so i may have 23 instances(transactions) of shift_number 16, 5 instances of shift 15, 19 instances of shift 1, etc, etc.(depending on the number of transactions that week) which when I pull the data from the db it will return with 23 different options for shift_number 16 and 5 options for 15, etc,etc,
I only need to see the single <option> for shift 16, a single <option> for 15, etc,etc. so my question really boils down to this, (i think) i need a query or a method to take each shift number visible in the db and display only one value of each in the dropdownlist that will then upon selection allow me to sort by machine_id and shift_number...
what i was saying about the varible week number was that these shifts are only good for a week, the shift gets closed out once a week,(not allways on the same day, but at least once a week) and I need to be able to see the total number of shifts that have closed up to today(when ever today may be)and not have to look at multiple instances of the same shift.
Dim Beautiful As String
Beautiful = "ignorant"
Label1.Text = "The world is full of " & Beautiful & " people."
Why is common sense such an un-common comodity?
|
|
|
|
|
wetrivrrat wrote:
All I really need to access is the shift number, and not the number of transactions. The problem is when I attempt to do so, I am given every instance on that shift that a transaction occurred. How do I query the db to do this?
use SELECT DISTINCT ShiftNumber ...
wetrivrrat wrote:
what query that would take each instance of the same number and average them so I am only left with that one number in my drop down box and not 19 of the same number?
You don't want to average them. You just want distinct values (see above)
Does this help?
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Why is it you get so far into a thought process that you forget to keep in mind the simple things?
THANKS!!!
Dim Beautiful As String
Beautiful = "ignorant"
Label1.Text = "The world is full of " & Beautiful & " people."
Why is common sense such an un-common comodity?
|
|
|
|
|
wetrivrrat wrote:
Why is it you get so far into a thought process that you forget to keep in mind the simple things?
It happens... Sometimes you just need to try and step back and look at it from a different perspective. If you can't manage that then often getting someone else to look at the problem will bring the different perspective.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
I am working on an application, in which I need to transfer the data from excel file to the access. but I don't know how to read the header row in excel file, for help, with thanks.
qqworm
|
|
|
|
|
Hello,
Can you help me!
1. I used dial-up connection (Windows 2000) to connect RAS server (Windows 2000 advanced server, stand alone, not belong to LAN or other network).
2. At RAS server computer, I installed MS SQL server 2000. RAS server configuration: Static address pool(192.168.61.21 --> 192.168.61.30)
3. I connected to RAS server successfull, but I can not login to MS SQL server 2000 with ConnectionString (...,data source = 192.168.61.21,...) unless I stop and restart MS SQL 2000 service!
Can you help me! Thank you very much!
dhtuan
|
|
|
|
|
1.)is it Windows Authentication mode ?
2.)SQL SERVER Authentication mode ?
Rajith Alwis
|
|
|
|
|
Hello.
I connect to my Microsoft Access DataBase (.mdb) easily.
But when i set a password for my database i can't connect to it.
The "Data Link Properties" window give error to me !!!
Why ?
|
|
|
|
|
user : Admin ; Password :************, one that u set
|
|
|
|
|
I have two tables, one having only 4 records the other many.
The first called Speelzalen is indexed on Speelzaalnummer.
The second one called Groepen has at least one column called Speelzaalnummer but is not indexed on that Column. I retrieve data from boyh by:
sqlCommand = New SqlCommand("Select * from Speelzalen INNER JOIN Groepen ON Speelzalen.Speelzaalnummer = Groepen.Speelzaalnummer", sqlConnection)
After this i bind the result to two datalist and use them like this:
<td width="125"><asp:listbox id="DataList3" runat="server" Rows="1" DataTextField="SpeelzaalNaam" DataValueField="SpeelzaalNaam" /></td>
and
<td><asp:listbox id="DataList2" runat="server" Rows="1" DataTextField="Groep" DataValueField="Groep" /></td>
It all works fine with one exception: for all the records in Groepen there is alse a entry in the SpeelzaalNaam listbox, but there should only be four.
The question is two folded, one; is there a Select construction to be used to undouble the exces records, or second; is there a way to show only those records from the group database that are connected to the row in the Speelzalen table.
|
|
|
|
|
if you want to avoid multiple lines with the same datas, replace select with select distinct
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
No success, this is the SQL Line i use:
sqlCommand = New SqlCommand("SELECT DISTINCT Speelzalen.SpeelzaalNaam, Groepen.Groep, Groepen.Dagdelen FROM Speelzalen INNER JOIN Groepen ON Speelzalen.Speelzaalnummer = Groepen.Speelzaalnummer", sqlConnection)
|
|
|
|
|
I should mention that in the table Groepen there is more than one Row that contains a same PeuterzaalNummer
|
|
|
|
|
Hi there,
I have selected a single row from a database and put it in a DataList.
One column has a Integer and i cant display that on a form so i want to change it to certain string value first. It looks like:
If DataList.Column("Gender") = 1 Then
Gender = "Boy"
ElseIf DataList.Column("Gender") = 2 Then
Gender = "Girl"
Else
Gender = "Unknown"
End If
But this doenst work. Can anyone tell me why.
|
|
|
|
|
Does VB not test equality with == ?
Try putting DataList.Column("Gender") into an object, and looking at it in the debugger. I'd have thought you'd need to wrap it in Convert.ToInt16. I'd also use a switch here, rather than if/else. Only because it's nicer code.
And for future reference, 'it doesn't work' is useless. How doesn't it work ? What's happening ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote:
Does VB not test equality with == ?
No, when i put in that extra = i get the error expression expected.
Now the compiler output. I must be doing something wrong, and i am more used programming things in PHP than .NET  ). I am a old guy that has to learn some new tricks.
Compiler Error Message: BC30456: 'Column' is not a member of 'System.Web.UI.WebControls.DataList'.
Source Error:
Line 50: DataList1.DataBind()
Line 51:
Line 52: If DataList1.Column("Geslacht") = 1 Then
Line 53: Geslacht = "Jongen"
Line 54: 'ElseIf DataList1.Column("Geslacht") = 2 Then
|
|
|
|
|
gharryh wrote:
Compiler Error Message: BC30456: 'Column' is not a member of 'System.Web.UI.WebControls.DataList'.
Gosh - well, where did you get DataList1.Column from ? The error appears to be telling you it's not valid code. DataList1.Items will give you the rows in the datalist.
However, as you were supposed to be going through a data source, I wonder if you've got the wrong variable ? A DataListItem or a Row on a table seem more likely to be the place you'd look for this sort of info. I think they both have an indexer for column names, so MyDataItem("Geslacht") would be what you want.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote:
Gosh - well, where did you get DataList1.Column from ? The error appears to be telling you it's not valid code. DataList1.Items will give you the rows in the datalist.
Well thinking that DataList1.Rows.Count is a valid statement there should be something similair to check on a Column value.
|
|
|
|
|
OK - is your intellisense broken ? The IDE should show you what is available in a list when you hit the '.'. In any case, I think the indexer solution I suggested would work, have you tried it ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian thanksfor the answer.
But i thinki wil stop programming. Something that can be done simple in PHP looks like hell in .NET if one is not used to it. And for me as a old 47 year old dog learning a new trick  I hoped to find more direct answers and not something like Indexer and have you tryed it. Dont even know wat the indexer is.
But anyhow thanks for all the help
|
|
|
|
|
Sorry, I didn't mean to confuse, I gave you the code, the indexer works like this : MyDataRow("columnName").
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote:
Does VB not test equality with == ?
nop, this operator doesn't exist in vb...
the assign operator is the same as the equality one...
you so understand that you cannot assign in an if statement as we could do in C/C++ with : if ((var1 = var2) == 3) ...
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
