|
Thank you so much!!! It works beautifully!!!
Very Greatful Programmer,
Elizma
|
|
|
|
|
i want to generate a unique primary key, something similar to the auto increment feature, but i do not want it to be auto increment.
The reasoning for this is: this table will have rows deleted by the hundreds every day, and maybe even thousands in a few years (I hope!), All the while having more rows replace the ones that were erased. Is there a way to have mysql create a unique key that is just randomly generated?
Thanks in advance!
|
|
|
|
|
Why do you think that an auto icrementing key would be a problem?
If you create 10000 new records each day, it will take more than 500 years until it reaches it's maximum value. If that seems too little, just use a 64 bit integer as key, and you can create a billion records every day for 25 million years.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi to All,
Hoow Can I access Pay pal return values.
I did find that the PayPal Sandbox works OK to do some testing without a real account. It took a little bit to understand what all I needed to create.
I am still not sure how to get the amount parameter sent back via a querystring or if that is not possible, how to read in the POST info that should be posted.
It's very urgent
Thank you
-- modified at 7:21 Saturday 14th April, 2007
|
|
|
|
|
|
hi friends
I have need javascript to enter only numerics value in textbox on text change events not on Submit button events.
Plz give me some link
Thanks in adavance
Pathan
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|
|
Server Side -
protected void Page_Load(object sender, EventArgs e)
{
TextBox1.Attributes.Add("onkeydown", "return checkvalid()");// Call Javascrip
}
Client Side -
function checkvalid()
{
var sTxt = event.srcElement.value;
var i = event.keyCode;
//alert(i);
if((i<47 || i>58) && i!=8 && i!=16 && i!=20)
{
alert("Not allowed");
event.srcElement.value="";
return false;
}
}
But remind when you are adding attributes to this control requirefield validator will not work.
Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India
|
|
|
|
|
You can check for event.keyCode on onKeyUp eventhandler. If it is not number, you can NULL it.
|
|
|
|
|
Hi there,
I am using .NET 2.0 with C#.
I have a website project. I also have a master page in the root directory called Website.master. In the “code behind” of this master file I have the following namespace MyNamespace.Master. When I view the object browser I don’t see this namespace there. Why is this?? Visual Studio only seems to add the namespaces that are in the Bin and App_Code folders. I don’t know if I’m not viewing it correctly, but I can not see it there.
Please can some one help me?
Regards
ma se
|
|
|
|
|
Hi everybody
The formview modechange events are not fired, when i try to change the modes to insert,edit,readonly.
Thanks in advance
|
|
|
|
|
Hi in sqlserver stored procedure i am doing some calculations...,
See the below procedure:
select a.empid,b.empName,c.Whrs,c.srg,case when srg=0 then @Outsunday else @Insunday end as days,c.Bassalary,
(Bassalary/(days*Whrs)) as onehour,
sum(AppWHours) as TWhrs,Sum(AppOtHours) as TOThrs
from tblMonthHourDetails a,tblemployeemaster b,tblsalarydetails c where
a.empid=b.empid and a.empid=c.empid and
b.projectid=@projectid and datepart(mm,[SDate])=@months and datepart(yy,[SDate])=@Years group by a.empid,b.empName,c.Whrs,c.srg,c.Bassalary
In that above procedure using case condition i am getting one column "days" like...,
That days value i want to use to calculate for onehour column,
if i give there days(highlighted in above procedure) value its telling error msg like invalid column days like...,
but i want to use that value there how to use...,
Plz any one solve my probs.....,
Magi
|
|
|
|
|
Please don't spam the site. The SQL forum is the right place for this ( although I have answered it in the C# forum )
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
HI Gurus,
How can I format 50000 integer to this format 50,000?
I tried using string.format("{0:#,#}", variable) but the result always come with a decimal value 50,000.00
Thanks
dom
|
|
|
|
|
I think it's string.format("0:f2") ( for two points after the decimal )
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
int i=50000;
i=i.ToString("##,###");
Please try this...
|
|
|
|
|
Hi,
The format is
String.Format("{0:#,###}", 50000)
Regards,
Raghu
|
|
|
|
|
Thanks Raghu this one nail it!
you rock!
|
|
|
|
|
This might be a stupid question, but I'm not sure how to search for this info because I don't know the terminology for what this is called, but this is what I want to do.
Say I have the following value in a database text field:
"Hello <%# user.name %>, today is <%# date.today() %> and you are logged into <%# MyCustomObj.AppName %>!"
Now I want to take that text, insert it into a user control, custom control, or object of some soft, and then have ASP.Net evaluate it as if it was written in the page (or user control) content and evaluated during DataBind().
I want the end result to be something like:
"Hello ceeez, today is Friday April 13, 2007 and you are logged into SuperSite!"
________
Actual code or a link to full example would be the most helpful, but any help with proper terminology of what this is called or the technology necessary would be great.
Thank you so much in advance!!!
Cesar
|
|
|
|
|
I have a table tbUsers and I selected a row now it has three fields. I want value of first field in txtbox1, second field value in textbox2 and third field value in textbox3. where textbox1, textbox2 and textbox3 are the textboxes in my ASP page.
How can I do that.
Thanks,
|
|
|
|
|
IMO, you first should know how to get data thru ADO.NET...do a search from uncle Google for ADO.NET tutorial...
<< >>
|
|
|
|
|
I have a web service I have been working on. I added a new method to the service, got it all working on my machine and copied it to a Windows 2000 server for some more testing. It is now throwing null reference exceptions any time my client code calls the methods in it through the object proxies.
This service was running fine on the server until this elevation and still runs fine on my machine. I have checked the event log and its got nothing, and I can view the service through IE, browse the WSDL, etc. so IIS is serving it fine. Since the input and output are complex types I can't call it through IE, though. I have tried the usual web reference update, iisreset, so forth. So far nothing is making this thing work.
This is a new one to me. Anyone come across this one before?
Here is the stack trace:
Object reference not set to an instance of an object. ---> Object reference not set to an instance of an object.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at WebserviceTester.CASE2SOAP.Service.SubmitAlchemistRequest(AlchemistRequestObject Request)
at WebserviceTester.Form1.btnTestCreateAlcReqWS_Click(Object sender, EventArgs e)
|
|
|
|
|
I needed to implement a custom MembershipProvider cuz we already have a database with user information in it; also I need to get a list of users. In my DAL I have a method that I can call which will populate the business entity and returh a List<>. However since I am using MembershipProvider I thought I should use the Memebership.GetAllUsers() method to do the same.
Do you think that the following implementation is acceptable or is it a programming NO NO...?
<font size="2"><FONT size=2> public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)</FONT>
{
<FONT size=2> List<UsersEntity> users = DAL.GetUsers();</FONT>
<FONT size=2> foreach(UserEntity user in users)</FONT>
{
<FONT color=#008080 size=2> MembershipUser</FONT><FONT size=2> members = </FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2> </FONT><FONT color=#008080 size=2>MembershipUser(</FONT><FONT size=2><SPAN style="COLOR: blue">this</SPAN>.Name,
user.username,
user.providerUserKey,<FONT color=#008080 size=2></FONT>
user.email,
user.passwordQuestion,
user.comment,<FONT color=#008080 size=2></FONT>
user.isApproved,<FONT color=#008080 size=2></FONT>
user.isLockedOut,
user.creationDate,
user.lastLoginDate,
user.lastActivityDate,
user.lastPasswordChangedDate,
user.lastLockedOutDate<FONT color=#008080 size=2></FONT>);
</FONT><FONT size=2></font>
}
} Can you tell me what I need to to do about the fields that I donot have in my database? Do I need to update the database? or should I just pass in a null or String.Empty or something like that? Please help.
|
|
|
|
|
Hi,
you can provide any value to the fields to the Fields that u dont have in your database or you can leave them blank by assigning null or string.empty or any default value.
But be sure that you r not going to use these fields anywhere in your application.
I hope this will help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
i have problem, I want to add control at runtime like two checkBox . when i checked first then enable false of second checkedbox. if any friend have answer then send me mail or post message.
Thanks
sujitvns4u@gmail.com
Sujit
|
|
|
|
|
Hi,
Add the controns in design view and hide the second. On the firsts, activate the AutoPostBack property and on the Page_Load change the visibility of the second checking the checked value of the first.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
