|
Hi Ravi
you rating data base field is int Type so this query give this problem
if do you want to get proper result like 4.30 format you have to change your data type of rating field <big>int to numeric</big> then you will get proper result.
you can use this query.
SELECT Round(AVG(rating),2)FROM table
Cheer
Pavan Pareta
|
|
|
|
|
You get the same data type as the type of the field that you are using the aggregate on. Cast the value to float before you use it:
select avg(cast(rating as float)) from table
---
b { font-weight: normal; }
|
|
|
|
|
hi,
i have to sort the products stored in the database depending on the selection in dropdownlist for ex.Price high to low ,low to high etc.
In this case, how should i identify which type of selection is done by user
i.e. which item is selected by user & On which event i have to write sorting code. Is it DrDwn_SelectedIndexChangedEvent()?
yog
hui gfgh kgdgrt njjn hjgkn
|
|
|
|
|
Hi yogita.
yes , you can do it on dd_selectedIndexChaged events and u have to keep autopostback = true.
Now, when user select item then u can get value of that item and u can change ur query string by this value. it will be easy if ur dropwdown items r fix.
Imran
|
|
|
|
|
Hai,
sorry i forgot to ask one more doubt. Foe my project i am using the MS Access database initially and now planning to change to Sql Express 2005 free version . I am shifting MS Access database as it cant handle more users at a time. So i want to know whether the user capacity for the Sql Express is enough to handle the traffic? Please give me your valuable suggestions.
Thank you,
veerendra
|
|
|
|
|
veerugadde wrote: I am shifting MS Access database as it cant handle more users at a time.
More users than what?
veerugadde wrote: So i want to know whether the user capacity for the Sql Express is enough to handle the traffic?
How much traffic?
---
b { font-weight: normal; }
|
|
|
|
|
Definitely more than Access.
|
|
|
|
|
Haii Everybody,
Learning alot from this community and thanks alot for all those people who are helping me to build my strengths. I got a doubt regarding how i can add data to the dropdown list which is databounded ? For example i got a ddl_schools which gives out the options of the different schhols from the database. I want to add a option like "select one" to the beginning of the option list. How should i add that value? Should i do dynamically or static ? Please help me out with this
Thank you,
Have a nice day.
Veerendra
|
|
|
|
|
After a DataBind add an insert statement
Me.DropDownList1.Items.Insert(0, New ListItem("select one"))
or
Pull the data and items manually before adding the "select one" list item
|
|
|
|
|
I.E. something that can examine the project files and markup and themes, make a list of all the graphics referenced and compare it to all the graphics type files it finds in the web and list the ones not referenced in a file dialog where you could then select and delete them.
I ask because I have an graphics folder with hundreds of images in it that were basically copied from a corresponding winform application and I know I'm not using them all, I'd like to be able to weed out the unused ones without manually going through them one by one.
|
|
|
|
|
John Cardinal wrote: I ask because I have an graphics folder with hundreds of images in it that were basically copied from a corresponding winform application and I know I'm not using them all, I'd like to be able to weed out the unused ones without manually going through them one by one.
ME TOO! ME TOO!!
Don't know of anything ( and REALLY can't be arsed to write something that looks!), but if you do find something, let me know!
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Damn, if only there were some developers around here with some time on their hands.
Seriously, I must see at least 3 posts a month from people asking about ideas for projects to work on and at least 2 posts a month from people looking for something that doesn't exist.
CP should have a wishlist type forum where people can post apps that they would like to see written.
|
|
|
|
|
|
Please try to write in english. Halfway through your post I didn't bother to try to read it any more, due to all strange abbreviations.
---
b { font-weight: normal; }
|
|
|
|
|
There must be some HTML issue.....Please post your HTML here
thanks,
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
|
Hi guys,
How can I get the web site that my web application running on ? Like "Default Web Site" ...
Thanks
|
|
|
|
|
hi
will u explain more ur question ?
as per i getting ur question u'll want ur url name at runtime.if tht is thn try this
string urlname=request.url.tostring();
bst of luck
Njoy the world of programming
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
In one of my applications, we get the "invalid view state" error when users are accessing it from Macintosh machines (OS X).
The question is, is it a known problem with Macintosh machines? Please note that the problem doesn't seem to happen for users with Windows machines.
Thanks.
|
|
|
|
|
http://support.microsoft.com/kb/832183
http://www.west-wind.com/WebLog/posts/2588.aspx
|
|
|
|
|
Thanks, I found these two references too. Looks like it is problem with the Safari browser.
|
|
|
|
|
I have a dropdown list that populates a list of users from one table in my database using a stored proc. I want to be able to pull that users information from another table(address, email, etc) and display that information on my page. how could i go about doing this?
|
|
|
|
|
example of query how should be
select users.*,usersinfo.* <br />
from users,usersinfo<br />
where users.iduser = usersinfo.iduser
this code you execute in SelectedIndexChanged event of DropDownList and then you populate this data in GridView.
for more help give more info
"My advice to you is to get married. If you find a good wife, you will be happy; if not, you will become a philosopher." Socrates
|
|
|
|
|
Alright I get that but say i wanted to populate one user's information from my table on to my web pageafter the selectedIndexChanged event, and I also want to be able to update, edit and delete that info, but I don't want to use a datagridview. How can I do this?
|
|
|
|
|
If you dont want to place a button for the selection, just check the selectedindexchanged event. You can also set it to autopostback.
|
|
|
|