Comments by wonder-FOOL (Top 73 by date)

The unique id is combination of Company and EmployeeID. There might be same EmployeeID's but Company will make it distinct from one to another.

Thank you very much for your help but I am getting an grouping error on the query.

Hello Matt,

I really appreciate your help. Thank you very much for the descriptive solution you gave. It is the solution that I needed.

Also you are right about "Principal". I typed it wrong since English is not my native language.

Have a great day.

Yeah I have seen that solution earlier while searching for an answer but I couldn't figure out a solution thats why I asked it here.

Hi, Vedat, no I didn't do the deletion of the refeneces and readding them. But I have tried cleaning the project but it didnt help. Anyways Maciej's solution fixed it. Thank you for your time tho.

Hello Maciej thanks for your help that indeed solved my problem but can you tell me why or how? Because with NuGet I did install MySqlData, EF.. but it didn't solve my prolem. By installing this driver what it did? Also when I build and publish my project A to the production environment, do I have to install that MySQL connector to the production environment as well? Again your help is much appreciated.

Thank you.

Thank you.

I have just updated my question. I have already have a post-build event there. Does it allow me to put multiple lines of code? Or should I rewrite the existing one? Thank you very much for the answer.

Both tables are generated the same way but the rows which contains the data differs. So the headers match. So this elimates your concerns on the second paragraph. The link actually solves my problem but I am just curious if there is a better solution. Tho thank you very much for your answer, time and efforts.

Thank you for your valuable help.

Thank you

Thank you.

Thank you sir.

Just saw it. Thanks :) f I can 5+ you again I could but I have already did it :S

Discard my last question:
SELECT SUM(P.ITEMAMOUNT) AS AMOUNT, P.COMPANYID AS COMPANY, SUBSTR(P.ACCOUNTID, 1,5) AS ACCOUNT, (SELECT ACC.ACCOUNTDESC FROM ACCOUNTS ACC WHERE ACC.ACCOUNT = SUBSTR(P.ACCOUNT,1,5)) FROM PRODUCTS P INNER JOIN ACCOUNTS A ON P.COMPANY = A.COMPANY AND P.ACCOUNTID = A.ACCOUNTID WHERE P.ACCOUNTID LIKE '1%' GROUP BY P.COMPANY, SUBSTR(P.ACCOUNTID, 1,5), A.ACCOUNTDESC ORDER BY P.COMPANY, SUBSTR(P.ACCOUNTID, 1,5)

But if you have an more effictive one I would love you to share it. If not still your help is greatly appreciated :) Thanks.

HEre I call again :) If I want to AccountDesc field how should I update the sql query? Because when I changed the query to:
SELECT SUM(P.ITEMAMOUNT) AS AMOUNT, P.COMPANYID AS COMPANY, SUBSTR(P.ACCOUNTID, 1,5) AS ACCOUNT, A.ACCOUNTDESC
FROM PRODUCTS P INNER JOIN ACCOUNTS A ON P.COMPANY = A.COMPANY AND P.ACCOUNTID = A.ACCOUNTID
WHERE P.ACCOUNTID LIKE '1%'
GROUP BY P.COMPANY, SUBSTR(P.ACCOUNTID, 1,5), A.ACCOUNTDESC
ORDER BY P.COMPANY, SUBSTR(P.ACCOUNTID, 1,5)

I have returning results with the sameaccountid but different account description due to
last 3 digits. Like
100-10 DolarAcc (100-10-001), 100-10 EuroAcc (100-10-002)
But in the Accounts table I have a description for 100-10 as Account For ABC Company. I don't know if I am clear but if you can edit the query such that it will be awesome thank you very much for your help.

To be more clear in that Accounts table
100-10 stand for Accounts ABC Company
100-10-001 = Dolar Acc For ABC company
100-10-002 = Euro Acc For ABC company

so in the querys result breakdown can we generalize the accountdes column to Accounts ABC Company like we did on the Accounts column?

Hello Maciej thank you very much for your fast response.

Thank you that helped a lot and you are right about the overload.

Thank you very much. Now I have a better understanding.

Seems like I should use Except method but can you explain me how this method matches the EmployeeID's? Shouldn't I add something like .Select(x => x.EmployeeID) to it? Thank you very much for the answer btw.

Thanks.

THanks.

please see my updates.

Thanks. A bit delayed but rewarded :)

Thanks but I have found it with a much simplier and optimized way. I have provided it as a solution.

Ok I have updated my question. I hope that clears it out.

Thank you for your answer but I have already knew the Except method but I couldnt find a way to remove the items between the list that I want the items to be removed and the items that is intersected.

Thank you!

Thank you!

I have added the columns that table has. I will be working on the same table so there is no need to join external tables.

Thanks.

Sorry for my english. I will try to rectify it again. I have images stored in a database. I want these images to be displayed in my webpagein a time interval. I want to accomplish this by using javascript. I dont know how I should display them meaning even which control I should use to load the images and write a code in javascript which will change the images lets say in every 5 seconds. I dont know if this made it clear.

Actually Sergey I am not asking which development platform I will be more comfortable with? Instead I am trying to find out if there is a platform which helps me develop an application one for all :) Because I am trying to shorten the development time, instead of developing platform specific applications. I don't know if that's makes sense.

in my where statement i might have 6 different filtering options not one as datetime you mentioned.

thanks

Thank you.

You posted the same link with Uday later than 2 mins but I will give you the credit also :) Thanks for the link.

Thank you.

Thanks. AppendDataBoundItems="true" solved it for me.

Hello Sergey, thank you very much for your answer I totally understand and accept your solution. Also I have updated the question can you check it again. I will appreciate it if you have any further suggestions? I have seen that SEVERE: Caught an exception: java.net.SocketException: Connection reset by peer: socket write error

For this particular exception: This usually happens when the connection was reset by the peer -- that is, when the client unexpectedly closed the socket. This happens when the user clicks "stop", or "reload", or "back",
or enters a new URL, or closes his Internet connection, while a resource is still being downloaded (before your server gets to close its socket). To be more specific,
• The browser started a request and the user pressed STOP.
• The browser started an request in one frame and JavaScript on another frame told it to go somewhere else (which has the same effect as a user pressing STOP).
• You have a meta refresh reload someplace that is firing so fast that the previous request hasn't had a chance to complete yet. The five second periodicity makes me pretty suspicious of this.
For precaution I am thinking setting the HTTP session timeout for my application to a shorter interval like 1-2 minutes to resolve this problem. It might be the session which takes up time cleaning up from the server.

:) I know how to accept the answer. At first I have 5ed you because I thought some other people might answer it but seems like noone did it so i went ahead and marked it as an answer now.

I have voted 5+ thank you very much for the detailed answer I really appreciate it and respect your solutions. Thanks.

Hello Abey thank you very much for the answer. I have tried allowing disabling javascript popus, iframe and such stuff from tools -> options menu but I have no idea why I cannot able to view it. It is weird that some people can able to see it and none of my computers cant right now.

with all my respect but your solution is useless. of course i am iterating after binding the gridview. there are other fields that i didnt show there just a bound field for example i can read its value but cant read the itemtemplate.. weird...

Thanks Dylan. what a carelessness of mine.. i hope 2012 wont continue like this :)

I have applied a.rmaStatus.Value = 0. The error message is similar but this time instead of nullable int it is replaced with just int. "Operator '||' cannot be applied to operands of type 'int' and 'int'".

thanks John. I appreciate it.

although it is answered later than the other 2 solutions your solution is correct i will also accept it. thanks

Thank you for the answer and the wonderful links.

Thank you for the answer.

Under your question you can see "Improve question" if you look a little more to its right there you will see a red cross, it delete the question. if you can not do it let me know and i will delete it for you.

Thank you. I have checked the link and tried it. I worked :) Also , the funny thing is, I have also asked the question on the link that you provided lol.

Sara thank you for your answer but still it didnt display the message box that I want :(

Thank you for your answer but your 2 links doesnt address my issue and they are not helping me. In first one basically says that beware of the session expiration. Since I indicated in my question that I have retrieved the value and can see it this means that session havent expired yet. for your second link I have no idea how you come up with msgbox to not display ok button? i didnt ask such a thing like that :) and seems like the link is broken.

It is not a homework. I was just reviewing a code and in the code there is a nullable int so I asked this question because of my curiousity. But your second paragraph explained me the basic idea about it. Thank you for your answer.

I think the link is broken.

No I havent received any exceptions. The code is inside a try-catch block. It is sending the email to the recipients but except the attachments. RMAConfig is a class that I have created. The value of RMAConfig.PdfPath's value is "./Data/Return Documentation/" i dont see any problem with that since I have used the same path to save the file. Do you think it might be something related to the permissions?

So I am assuming you are getting the null reference error in this line " imgProduct.ImageUrl = "/ShoppingCart/ProductPics.ashx?pid" + p.ProductID.ToString() + "&s" + Settings["product_picSize"].ToString();" if so make sure the values are correct and not "NULL" also check if the path exists otherwise there shouldnt be a problem.

Well, first of all thank you very much for your answer I really appreciate it. To be more clear, what I am trying to do, when clicked on this link button, i need to get the date value from that row and compare that value with today's date, and if it is more than X, I need to have a confirm box, if the answer of this confirm box is ok i need more process to be done.

Thank you. Yeah string.Format() solved it.

Thank you very much for your answer.

Thank you I understand it later on with more research but what you have said is corrrect but seems likeit can be possible only in browser which allows the new File API. SO using the readAsDataURL function on the FileReader interface in FileAPI will solve this issue.

Well the file is a custom created file and I am saving the file outside the virtual folder. Somewhere in C: drive. Not the ISS folder. If i understand your answer correct, you are saying that i can not open this file which is under c: and it should be under my ISS folder? If I am wrong or misunderstand it,can you please explain it in a different way? Thanks for your answer though.