SelectCommand, Variables, & SQL.

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
davidshq Members Profile Find Members Posts Senior Member Joined: 29 July 2003 Location: United States Status: Offline Points: 299	Post Options Post Reply Quote davidshq Report Post Thanks(0) Quote Reply Topic: SelectCommand, Variables, & SQL. Posted: 31 May 2005 at 2:04pm
	Here is a working SQL Statement: "Select TOP 5 * from Games" But I want the 5 to be replaced by a variable. Here is my now non-working code: "Select TOP " & Profile.GamesConfig.NumOfGames & " * from Games" What am I doing wrong? David.
	- Dave Mackey - Virtual Home.

dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply Posted: 31 May 2005 at 2:16pm
	Make sure Profile.GamesConfig.NumOfGames is a number gamenumber = CINT(Profile.GamesConfig.NumOfGames) "Select TOP " & CINT(Profile.GamesConfig.NumOfGames) & " * from Games" Just taking a stab at it.

Mart Members Profile Find Members Posts Senior Member Joined: 30 November 2002 Status: Offline Points: 2304	Post Options Post Reply Quote Mart Report Post Thanks(0) Quote Reply Posted: 31 May 2005 at 2:22pm
	The chances are that Profile.GamesConfig.NumOfGames is an Integer any way... and if not you need to use "Select TOP " & CInt(Profile.GamesConfig.NumOfGames).ToString() & " * from Games" What is the actual error that you get?

davidshq Members Profile Find Members Posts Senior Member Joined: 29 July 2003 Location: United States Status: Offline Points: 299	Post Options Post Reply Quote davidshq Report Post Thanks(0) Quote Reply Posted: 31 May 2005 at 2:38pm
	Here is the full SqlDataSource code I am now using: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:gamesConnectionString %>" SelectCommand="SELECT TOP " & Cint(Profile.GamesConfig.NumofGames).ToString() & " * FROM Game"></asp:SqlDataSource> And I receive the following message under the design window: Error Creating Control - SqlDataSource1 The server tag is not well formed. David.
	- Dave Mackey - Virtual Home.

Mart Members Profile Find Members Posts Senior Member Joined: 30 November 2002 Status: Offline Points: 2304	Post Options Post Reply Quote Mart Report Post Thanks(0) Quote Reply Posted: 31 May 2005 at 4:21pm
	Ah, you can't do that in the designer... Just remove the SelectCommand ="xx" part from the designer, then in code view just go SqlDataSource1.SelectCommand = "SELECT TOP " & Cint(Profile.GamesConfig.NumofGames).ToString() & " * FROM Game" (in Page_Load)

davidshq Members Profile Find Members Posts Senior Member Joined: 29 July 2003 Location: United States Status: Offline Points: 299	Post Options Post Reply Quote davidshq Report Post Thanks(0) Quote Reply Posted: 01 June 2005 at 9:44am
	Mart - What would I do without you? Thanks. It works great now. :-) David.
	- Dave Mackey - Virtual Home.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.