You searched for the word(s): userid:776187

More Search Options

RSS Available

• Nested SQL Query Problem

  I'm making a simple forum with subforums in categories (similar to how this forum works) and it is to be written out like this: CATEGORY - forum - forum CATEGORY - forum Which is easy but I don't want to include categories that do not contain any subforums. I have tried using this sql query: SELECT category_id, category_name, (SELECT COUNT(forums.category_id) FROM forums WHERE forums.category_id = categories.category_id) AS countforums FROM categories WHERE NOT countforums = 0 but I get Unknown

  Posted to MySQL (Forum) by Saturday3AM on 11/10/2009

• Re: Nested SQL Query Problem

  What do you mean by "set countforums". Isn't it set to the value of that SQL query? Hmm yes but I'd rather not use two queries. One should be possible.

  Posted to MySQL (Forum) by Saturday3AM on 11/10/2009

• Re: Nested SQL Query Problem

  That is it. Thank you!

  Posted to MySQL (Forum) by Saturday3AM on 11/10/2009

• Re: Accordion "Expanded" event

  I am also looking for exactly this.

  Posted to ASP.NET AJAX Control Toolkit (Forum) by Saturday3AM on 5/24/2009

• casting mysqldbtype

  I use a datareader to fetch some data from a mysql db. Until now I have used the Convert.To AnyType () methods without thinking much about that.. but.. isn't the MySqlDbType's actually derived from the .NET types since the mysql connector is made in .NET? I tried casting instead, which should be better from a performance perspective because it's only treating it as a certain type instead of doing a whole conversion, correct? I mean for example I should be able to cast MySqlDbType.UInt64

  Posted to MySQL (Forum) by Saturday3AM on 5/16/2009

• Session timeout

  I need to use Sessions for two things. One is storing the member ID when logged in and the other is storing the text from a CAPTCHA image. I want the member ID Session to be 120 minutes so I have set web.config up like this: <sessionState cookieless="UseCookies" timeout="120" /> < authentication mode= "Forms" > < forms cookieless= "UseCookies" timeout= "120" /> </ authentication > but the session that stores the CAPTCHA text

  Posted to State Management (Forum) by Saturday3AM on 3/10/2009

• Re: CommandArgument = ID

  Does anyone know this for sure?

  Posted to Data Presentation Controls (Forum) by Saturday3AM on 3/2/2009

• Markup code compression and UpdatePanel

  I've read this article and I'm now using that code on my site to compress the markup (html) of my pages. That itself works really nicely but it gave me a problem. The content in UpdatePanels do not update async anymore. Nothing appears to happen when I for example click a LinkButton in inside an UpdatePanel. I've been trying to figure this out and I think it could be two possible things going wrong. 1. I don't know how it updates the markup async but maybe the content needs to be

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by Saturday3AM on 3/2/2009

• Re: CommandArgument = ID

  Bump. It's obviously stored somewhere... and I highly doubt it's serverside. Is anyone sure?

  Posted to Data Presentation Controls (Forum) by Saturday3AM on 2/21/2009

• Re: CommandArgument = ID

  1. The page loads and the posts are all put into the Repeater control where there is a LinkButton (for removing posts) in the template that will have the post ID as CommandArgument. 2. The client is looking at the list and then clicks one of the LinkButtons to remove a post. 3. The server receives the request to remove a post and the ID of the post to remove ... BUT where does it get the ID from? 4. Post is removed from database. Are you saying it stores the CommandArgument serverside? For how long

  Posted to Data Presentation Controls (Forum) by Saturday3AM on 2/20/2009