|
Somebody tell me that SELECT * FROM users LIMIT 0, 10 i could get the firsts ten registers, later i could use the sentence SELECT * FROM users LIMIT 11, 20, in order to get the 11 to 20 users data.
But i doesnt work, 
did you get the idea???
keep Learning and you never will be out of date...
|
|
|
|
|
Since SQL Server does not have a limit clause, I'm assuming that you are using another backend database. What DB are you using?
|
|
|
|
|
It may also help to have a general database schema (don't include specific business data for security reasons) or a mock DB schema. I'm getting the feeling that your solution would be solved by an inner join with a TOP clause on the right side table.
|
|
|
|
|
You could try a stored procedure like the following:
CREATE PROCEDURE [dbo].[usp_GetnRecordsForEachUser]
(
@userID int,
@maximumRows int
)
AS
SET ROWCOUNT @maximumRows
SELECT u.*
FROM users u
WHERE userid = @userID
ORDER BY u.userID
SET ROWCOUNT 0
GO
|
|
|
|
|
hi
i have two textboxes which have the validation controls for validation.These validations should perform when i click a submit button.Upto this it's ok.I have a datagrid in the same page.iam populating the grid in the pageload event. when iam clicking the update link(updatecommand event) in my datagrid these validations are also performing.How to solve this?If it is a button we can simply make the cause validation property false.But for datagrid i didn't find any property like this?How to solve this?
thanks
vijay
|
|
|
|
|
Which column are you using to create the "update link"? Basically, for the button colums you can set the CausesValidation to false either declaratively in the web form or programmatically in the ItemCreated event handler. In addition, in the ASP.NET you can use the ValidationGroup property to work around this issue.
|
|
|
|
|
Hai Everyone
I am making my page as ajax page using magicajax.dll,It is working fine in my pc but when i install it in server it is not working Can any one help me
and tell me what type of setting i have to do in IIS or In server For it
Mahammadhusen
|
|
|
|
|
Because you are asking about a specific component, so their[^] support forum might be a better place.
|
|
|
|
|
I need a Regular Expression to validate a date
in dd-mm-yyyy in java script
Thanks in advance
|
|
|
|
|
Instead of writing your own script to validate the date value, you may use the CompareValidator with the Operator=DataTypeCheck and Type="Date" to validate the input element. Also because you want the dd-mm-yyyy format, you need to take in account the current cultureinfo when the validator gets rendered. If you still want to do on your own, you can view source the web page and have a look at the script of the validator for your reference.
|
|
|
|
|
“Can not access closed file” problem will solved by adding property requestLengthDiskThreshold to httpRuntime
<httpruntime
executiontimeout="1200"
="" maxrequestlength="8192" usefullyqualifiedredirecturl="false" minfreethreads="8" minlocalrequestfreethreads="4" apprequestqueuelimit="100" requestlengthdiskthreshold="8192">
|
|
|
|
|
i want to pass a string array from c# to javascript function, and want to get values from that array, plz help me
|
|
|
|
|
|
Simlplest method would be to JSONify the array, slap it into a hidden field then eval() it at the js end...
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Sir,
What is the difference between managed and unmanaged code.Please give a simple example that demonstrates the difference between them.
thanks
|
|
|
|
|
|
hai friends
im developing one web application using c#(2005).i will maintain huge record of username and password and its details. some one create a new account and he didnt use that account. so i will remove unused useraccount after 20 days. can u any one help me.
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
Sure. What have you tried so far?
|
|
|
|
|
im a fresher.im not have a idea.please teach me step by step.
-- modified at 10:12 Tuesday 10th October, 2006
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
dhatchu wrote: please teach me step by step.
That's not how it works[^] here. If you have a specific question about a problem you're having, post it.
Otherwise, start with Google[^]
|
|
|
|
|
sorry for inconvinent.im waiting,please teach me step by step.
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
This is not a college or university. Most here are happy to help you as you learn how to do it yourself, by answering specific questions that come up as you try to solve the problem yourself.
I'm sure you did not intend it to be, but the manner in which you are asking these questions is very insulting to those who spend their free time away from work helping people here. You are asking people who probably already spend way too much time working programming as their day job to spend hours of time teaching you how to do something that you apparently are unwilling to even try on your own.
Do you understand?
|
|
|
|
|
Hi All,
I have a one question related to Internet Marketing. Does any one know how to get the Pay-Per-Click Bid values for a keyword? I know all the theory but seeking for the api,webservice which will allow to access the database for Pay-per-click information?
Thanks in Advance.
The secret of life is not enjoyment
but education through experience.
- Swami Vivekananda.
|
|
|
|
|
First of all, this is not an ASP .NET question.
But second of all the information you seek is not broadly available. The best you can get without paying for anything is finding out how many times a term was searched for in a given month. Yahoo/Overture has a keyword tool that allows you to see how many times a particular keyword is searched for. You can see it here: http://inventory.overture.com/d/searchinventory/suggestion/[^].
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
Thank You very much perlmunger. Means there is no any freeweb service to get the Pay-per-click value for the keyword.
The secret of life is not enjoyment
but education through experience.
- Swami Vivekananda.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
