Not working... It just show 2 rows only.
GPL: I still trying on your solution ;) It quite new to me. I trying on it. Thx lots
User Profile
Collapse
-
Sorry for that. You can ignore the orderid.
Foodid is the food type.
Yes. The quantity always will be 1.
Yes. The purpose of this query to find instances where cooks prepared more than 3 servings at a timeLeave a comment:
-
this method i had tried. Couldn't help.
The reason quantity set to 3 is because i limit the chief to cook the food limit to 3 quantities only...Leave a comment:
-
select sort and group by
My database record is as below:-
Can it be arrange into this form?Code:cartid foodid qty 92 5 1 93 5 1 94 5 1 95 11 1 96 5 1 97 5 1
Assume that the max sum(qty)=3
Code:foodid sum(qty) 5 3 11 1 5 2
-
real time filtering
Is there anyway to keep the grid view updated without refresh the page if there any new record insert into database? It is just like facebook. Once people comment, without refresh the page, we will notice the comment inserted. -
OPppss... Nop. Actualli just purpose to save the consumer logs only.Leave a comment:
-
Yes. I get the solution already. It is as what you mention; benwizzle
Code:<SelectParameters><asp:SessionParameter Name="stallid" SessionField="stallid" DefaultValue="" /></SelectParameters>
Leave a comment:
-
Query error?
...Code:<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:foodcourtConnectionString %>" SelectCommand="SELECT [foodname], [foodimg], [price], [stallid] FROM [foodtbl] WHERE ([stallid] = @stallid)"> <SelectParameters> -
Yaya. Same network also can. I can't get the correct coding... Currently, I just can get IPv6 address only... Preferable get MAC address ;)Leave a comment:
-
How bout detecting the physical address? izzit same as mac addresss?Leave a comment:
-
hmm... thx for the solution. it work. but... i found out, if others user in same network login to my localhost, the mac address is the same... any thing can represent the computer details?Leave a comment:
-
detect mac address
Is there any way to detect mac address in website?
I'm using c# -
Hi Frinny,
Thanks lots. It solve my problem!!!
Easy to use compare cookies ;)Leave a comment:
-
So far, I trying on cookies.
As I holding much data, thus... I still figuring out which is the better way for the implementation. Trying search on the session implementation way. You have any sample on that?
Eg.
If I add a food into shopping cart, it will hold few values such as food name and price. If I add second food, it will go into the list too.
Foodname: Fried rice Price: $4.00
Foodname: Noodles...Leave a comment:
-
Currently, I had added the value in the linked list. By the way, once I refresh my page, all the variable gone. Can I know hold to hold the value?Leave a comment:
-
shopping cart
Hi,
I having problem in adding the variable into linkedlist. Can anyone guide me?
...Code:<div id="one" style="display: block; "> <asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1" GroupItemCount="3" OnItemCommand="ListView1_OnItemCommand"> -
insertion data into mssql
I had build a mobile application. I'm using simulator to test the application. All the data is recorded in the desktop database.
Once I run the application, I can retrieve the data from the database. But, the problem I facing is I couldn't insert the data into the desktop database.
In the phone database I can see the record.
What should I do in order the record can directly insert into desktop database? -
-
Hmmm... I figuring out another way. But seem like couldn't get the result...
...Code:using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication4 { class Program { class mydatatype { public string foodname; public int quantity; }Leave a comment:
-
Great. Can be used too. I have a try first den I let u know my result. Thx bro ;)Leave a comment:
No activity results to display
Show More
Leave a comment: