Hi,
Im finding the maximum value in a column I have using this sql statment:
Code:
SELECT Nz(Max(TblLeague.rank),0) AS MaxRank FROM TblLeague WHERE (((TblLeague.sportID)=[sID]));
Im also using the Nz command...
Ashlewis
Last Activity: Nov 20 '08, 02:53 PM
Joined: Mar 28 '08
Location:
-
Nz not working in VB.NET
VB.net, Microsoft visual studio, ACCESS 2007
Hi,
Im finding the maximum value in a column I have using this sql statment:
As you can see im using a parameter sID, this just means im looking for the maximum value in that sport.
Im also using the Nz command... -
Please specifiy which button causes this behaviour.
And which control dissapers?
also is there any other code behind? -
Thank you, works a treat.Leave a comment:
-
This sounds like a styling problem to me?
Are you using a stylesheet?
If so this can be sorted using z-index as you stated.
The z-index is the ordering of how somthing appears on your page, a low z-index will be further back that somthing with a higher z-index.and therefore a high z-index "object" will overlap the lower z-indexed one.
I dont really know how you've set up your drop down menu but somthing...Leave a comment:
-
Getting the textfield of a dropdownlist
Ok i have a dropdown list that stored a text field of a username and then the value is a user ID
I need to be able to access the currently selected text field but the only thing i can seem to do is the selectedValue which is actually the userID
how do I get what the selected TextField is so it reutns somthing like "Bob" when Bob is selected.
Thanks, any suggestions welcome -
Confirmation page design question
Hi,
Im currently in the process of creating a few forms.
I originally planned to have two pages, the form page and a reponse page.
However since then ive been able to make use of the validators and the custom validator to do what i need on the actual form page.
So it only leaves the reponse page to confirm the form submission was successful.
Would it be bad design or good design to infact do away with the... -
Thank you very very much!
As helpful as ever.Leave a comment:
-
Please ignore that above post, i was having a moment of madness
Im now using the parameter code to run a similar query but this time the query obviously takes a parameter. This parameter is called selectedUser
This is how ive used it
...Code:Dim DataConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("App_Data/Database.mdb")) DimLeave a comment:
-
Thank you.
(Im coding in VB)
Now I have another problem,
What if i want to do somthing like this
strSQL = "SELECT userName FROM tblUser WHERE userName = ' " & txtUsername.Tex t & " ' "
but obviously doing it the tidy way you showed me.
I mean how do would I use the parameter code, how does it correspond to an SQL statement.Leave a comment:
-
Sorry to double post I cant seem to edit my original one.
Ive further narrowed down the problem to it causes this error, when ever i use a query with GROUP BY in it.
(in this case im using GROUP BY and HAVING)
...Code: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.
Leave a comment:
-
Calling a query in VB
Im currently using a string to store my query in VB.
It seems to work perfectly fine for short queries.
But as my queries become longer and longer, this method just doesnt seem to work.
Im using an access database and when i run my SQL queries in that they work fine its just when i transfer them to the vb code they seem to cause errors.
So is there a way to call saved access queries in vb without actually putting... -
Thank you, its finally working perfectly.Leave a comment:
-
Hi thanks alot! just spent some time getting my headaround it, i think im getting there.
Ive tried using it, i made some changes just to some table names, so it fits my database just simple things such as tblSport to TblSport
Now i have this:
...Code:SELECT TblSport.sportName, TblLeague.leagueName, TblLeague.size AS MaxTeams, z.NumTeams FROMLeave a comment:
-
Ahh great, thank you.
however which dropdown list should I set EnableViewState to true on?
also what is that actually doing?
AshLeave a comment:
-
A DropDownList that populates another
Before you kill me i know theres a million different tutorials out there, but ive been stuck all day on this. (im using VB)
Basically I have a sport list and a league list.
The sports list is populated on_load from a database.
When i select an item from the sports list i want it to populate the league list with the corresponding leagues.
The solution ive attempted is to populate the leagues in the DDLSports_Selec tedIndexChanged... -
Help with a QUERY
Im running an access database.
Which looks like this:
Im struggling to make a query to do exactly what i need.
Firstly i'll put it into context. Im allowing users to sign up to play in a sport, and i want to return a list of all the sports that are available to play in.
therefore...
I need to select all the sportName from TblSport.
However, i have a few other constraints i... -
Thats fantastic. Thank you exactly what I needed.
Infact the links are dynamic, they are created from a table i have in a database called TblSports. but i guess thats no use when i need to be able to tell which one has been clicked, ill go for the query string. Thanks for the examples too.
AshLeave a comment:
-
Passing information between pages
I know this is fairly trivial and i know there are several ways of doing it but i was wondering whats the most appropriate way to do this:
I have a set of links of different sports Football Basketball and Tennis, they all link to a Sports.aspx page.
On the Sports.aspx page I need whatever link was clicked to be the title of the page.
The title will be a label.
The name of the hyperlink is obviously... -
Thank you all.
I thought masterpages were just for the HTML side of things?
Ive never used one, ill try one out after ive tried using user controls, another thing ive never used, any idea on how they would work in my case? any help would be appreciated, thanks.Leave a comment:
-
Inherit a code behind page?
Hi all,
I have two aspx pages:
Default.aspx with its code behind page of Default.aspx.vb
Home.aspx with its code behind page of Home.aspx.vb
The Default page in effect is just a template, the Home page will be the same but with some extra functionailty. I dont want to have to copy the code from the Default.aspx.vb to the Home.aspx.vb page since I assume there is a more efficient way.
Ive tried to...
No activity results to display
Leave a comment: