|
any one help me,
i am developing an application in asp.net having Mysql as backend.my problem is that my .aspx pages are present in iis in one computer and my mysql database runing in linux machine. i am passing a query like
SELECT * INTO OUTFILE 'd/temp/backup.sql' FIELDS TERMINATED BY ',' FROM cris_cdr WHERE DATE_FORMAT(myDate,'%Y-%m-%d') >= '2007-06-24' and DATE_FORMAT(myDate,'%Y-%m-%d') <= '2007-12-06'
but it is throwing error as
Error Code : 1
Can't create/write to file 'd\temp\backup.sql' (Errcode: 2)
(78 ms taken)
i kwnow that the above query try to writting in the same machine(linux).
can you help me how i can write .sql file in iis machine.
thanks
manoj kumar
|
|
|
|
|
Seems to me that you're just asking for grief. Why not install MySQL on the Windows machine ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi i am using vs2003...,
I like to know how to create our own assemblies for our project...,
And i like to know custom controls for asp.net,
I have searched in google but i didnt get some good articles abt that,
Plz u guys if u know, suggest me some good sites with sample codes..,
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
|
|
|
|
|
|
Hai Guys
In my hosting site SSL is enabled. I am able to access login page in secure(https)mode. After this page i need to convert the url from https mode to http. How to do it?
If you have any suggestions or coding, please reply.
Thanks
Jith
|
|
|
|
|
|
Hi....
I want to Create drive on own server..Just Like Gmail Drive
|
|
|
|
|
What do you mean by "creating a drive"? Virtual partition or ??
GMail Drive is the same as GMail (but with filter). So, All files that you store in GDrive is actually stored in GMail Mail Server. So, If you want to do that, just host the Email server with larger maximum attachment size. then write another client application like GDrive that fake users not to know whether they are sending a mail or transferring the file.
Anyway, I don't think this is a good idea.
|
|
|
|
|
hi,
i have a dagrid..in that checkboxes are there with ids of 1,2,3;
i am passing the ids to that grid are 2,1..accordig to my logic those checkeboxes(1,2) has to be checked =true
for ids 1,2 it is working
if i pass the 3,2 then only 2nd checkbox is checking
if i pass the 3...then no checkbox is checked...
last checkbox is not checking for the last id..
i wrote the code like this in the databound event
strScheduleIds=strScheduleId.Split(',');(here the values i am getting which i passed from the otherpage .)
for(i=0;i<strScheduleIds.Length;i++)
{
foreach(DataGridItem dg in dglist.Items) {
if(dg.Cells[9].Text.ToString()==strScheduleIds[i].ToString()
) {
((CheckBox)dg.FindControl("chk1")).Checked=true; }
}
}
|
|
|
|
|
Have you tried to debug your code? strScheduleIds.Length - 1 in first for-loop?
Are dg.Cells[9].Text.ToString() and strScheduleIds[i].ToString() the same if you pass "3"?
|
|
|
|
|
hi...
iam not able to retrive session data in the next page...but i am able to retrive in same page what may be the problem.....plz tell me if any settings has to be change
i have used this code:
in first page in buttun click
Session["uid"]=txtuid.Text;
in next page
lblsessionview.Text=(string)Session["uid"];
plz tell me where iam doing wrong
|
|
|
|
|
1. Does the next page in the same domain and same protocol?
2. Does your browser enable the cookie?
|
|
|
|
|
hi Michael...
i have checked the cookies and the settings are enabled....and iam doing
in the same domine....cookies r stroring when iam doing cookies program...query string and sessions are not working....plz help me michael
|
|
|
|
|
thanx Michael i got it.........thanks 4 u r advise
|
|
|
|
|
cool...  what did you do?
|
|
|
|
|
//Getting the UnitId
public string GetUnitId(string UserId)
{
string sqlstatement;
try
{
sqlstatement = "SELECT UnitId FROM department_Members WHERE UserId='"+UserId+"'";
return dbtObj.GetColumnValue(sqlstatement, "UnitId").ToString();
}
finally
{
}
}
//Checking The Unitid
protected void BindRblDftUnit()
{
MembershipUser MU;
string UserId;
MU = Membership.GetUser();
UserId = MU.ProviderUserKey.ToString();
string dUnitId = asObj.GetUnitId(UserId);
string dRoleId = asObj.GetRoleId(UserId);
if (dUnitId != null && dRoleId != null)
{
RblDefaultUnit.Items.Add(new ListItem("Sreejith", "Sreejith"));
RblDefaultUnit.Items.Add(new ListItem("Alex", "Alex"));
}
}
Yesterday i post this query.First of all sorry to post it agin.
The above code is to get the unit id checking with the userid.That means if the user login had the particular unitid.I want to chk that.If the use had login had no unit id thn an exception in sql is displayed.The exception is object reference is not set.How i overcome it..Laos i attach the checking functinality itself with this mail.Please help me to overcome the pbm....Thanks
|
|
|
|
|
change your logic, if your GetUnitId method doesn't have any record then it should send something which shows that it return null.
Push your brain and it will work out for you
|
|
|
|
|
Hi
I am trying to create a page that when I access it using the Internet Explorer, the page will not load, and in the Internet Explorer's status bar, the status will be "Loading".
(I need it to create tests for my systems)
I tried to add Thread.Sleep(1000000) on Load_Page event, but then the IE froze and the status was "Connected"
I also tried to add the frame tag. and in it i called another page, but for some reason it didn't get stack at all.
Can anyone help me?
thank you in advanced,
Daniel
ASP page that stacks on status loading
|
|
|
|
|
Am trying to access a file from remote machine(IIS)
Response.Redirect(~/SalarySheets/" + OffID + ".xls"; ) will work only when the SalarySheets also are locally present on a folder in my app.
But what I have to do is to pick the xls from remote IIS.
I should be able to access file from remote path
@"\\prod-sal\Salary\SO-WEBDIST-XLS\" + OffID + ".xls";
I cant use Response.Redirect(@"\\prod-sal\Salary\SO-WEBDIST-XLS\" + OffID + ".xls")
Can you suggest something else please?
------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates
|
|
|
|
|
Tried Page.ResolveUrl but the remote machine has a user id and pwd.
I should supply credentials on my .net page and fetch the ms excel data.
------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates
|
|
|
|
|
i have to show a message when the entered value is not having length greter than 6.for that i am writing following javascript.
I call this javascript on onblur of text,but i cant get focous back to desired textbox.
it goes to another control.I am using server control.
Javascript Function
-------------------------
function lengthCheck(obj)
{
if(obj.value.length<6){
alert("wrong name");
obj.value="";
obj.focus();
}
}
-------------------------
here i use it
<asp:textbox id="TextBox1" runat="server" onblur="return lengthCheck(TextBox1);"></asp:textbox>
can one help to me,so that i will fix my problem.
thanking U
|
|
|
|
|
The following CodeProject[^] article has the information you require.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I am using server control.
also it not woking on any other browser other windows internet explorer
|
|
|
|
|
Hi,
I am using MultiView / View controls which change by MenuItem clicks. Each view has a GridView on it with Edit and Insert features.
The problem is: 1) when the edit button is clicked, the GridView disappears and you need to click on the MenuItem again to see it (it happens evrytime you click edit, update, cancel or insert buttons on the GridView)
2) When you click a MenuItem, the page is posted back and displays from the top again, but I want it to stay at the height where it left so that the users dont have to scroll down again to see the GridView. I can probably use javascript, but I was wondering if there is any asp .net way to fix it?
All ideas are welcome.
Thanx for your help.
Ekjon
|
|
|
|
|
hi guys i am new to asp.net, i have created a class on a webform and want to use the class on another webform, can someone please tell me how to accomplish this? i am using vs2005 with c# thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
