|
I have this one Linq2Sql code that is updating a column value. I can see the column updated in the C# code, I can see the PK is correct, but it doesn't update in the DB. When I look at the SQL that Linq2SQL generates, the parameter for the column I'm updating is the old column value. WTF? How can the parameter value be the old value when I see in the C# code the new value???
This isn't an attempt to get help - it's just that I feel like ranting about this. It must be something I'm doing wrong, just haven't figured it out. Driving me nuts. 
|
|
|
|
|
Try to ask about it on Stackoverflow... 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
Never argue with a fool. Onlookers may not be able to tell the difference.
Mark Twain
|
|
|
|
|
Johnny J. wrote: Try to ask about it on Stackoverflow...
Turns out it's something in the query that determines what should be updated, which is flipping state between two records. 
|
|
|
|
|
If any of you are wondering where you should host a website - stay away from Hostinger. Although their prices are competitive their technical expertise is extraordinarily shallow. Their refund policy defies belief.
I've been hosting an organization's website on Hostinger for two years. At the end of May 2022, Hostinger decided to move the website to a new server (supposedly part of some maintenance effort). Apparently the transfer completed and I was told to use a new IP address. I use FileZilla and was able to upload new files to the website on its new server. But this website is also used by a Raspberry Pi to download a set of slides that it (the RPi) would display in the organization's lounge. The RPi home directory contains a number of scripts that, once the slides are uploaded to the website, are executed to prepare the RPi for slideshow display (using feh). Part of that preparation is to copy (using wget) the slides into a local-to-the-RPi directory. feh displays the slides in that directory. This makes the slideshow independent of the Internet. But after the transfer, the wget script was broken. So too were all PHP scripts.
I advised Hostinger of the problem. Their denials sounded like something a junior programmer might espouse. Of course nothing that Hostinger did was wrong - it was entirely an error in my scripts (scripts that had worked flawlessly for almost one year before the transfer). About a month ago, I decided that Hostinger's inability to fix the problem was forcing me to re-host the website. I went to inmotion.
So, Hostinger was unable to fix the problem they caused. Would they refund the two years paid for. No! So I will not use nor recommend Hostinger for any website hosting.
Stay away.
Gus Gustafson
|
|
|
|
|
If you paid this by credit card, call the credit card issuer and dispute the charge. It might get reversed, in which case this outfit will have to pay a charge back fee.
|
|
|
|
|
I will take your suggested course of action. However, I do think that Hostinger should hold itself responsible and make the refund.
Thanks for your thoughts.
Gus Gustafson
|
|
|
|
|
So, did you actually look at your scripts to see what was breaking?
|
|
|
|
|
I gave some thought to getting the scripts to work with Hostinger. However, if you refer to the original post, I stated that the scripts worked to more than a year, without any problems at all. What's worse, after the move to inmotion, without modification, the scripts worked as before.
As I implied earlier, the problem was Hostinger's - not mine.
Gus Gustafson
|
|
|
|
|
If the scripts use a DNS service that wasn't updated with Hostinger moved their servers, this would explain the entire issue.
|
|
|
|
|
As a professional, I don't think that matters. When Hostinger was notified of the problem they should have started the repair. Instead they stood around wringing their hands.
Gus Gustafson
|
|
|
|
|
So, it just broke after the transfer and they can't/won't help you fix it, but you think they should refund the fees for the last two years, even though it worked for those two years? I don't think that's a reasonable demand. And I'd look at my scripts to make sure they aren't still pointing at the old IP.
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
I'm sorry, either I was not clear or you misunderstood me. I had just renewed the account with Hostinger for two more years when the problems were detected. I reported the problem to Hostinger about 45 days after the renewal. I never expected any refund to cover a period when everything worked correctly. It was a refund of the newly renewed account that I desire.
Gus Gustafson
modified 2-Aug-22 0:04am.
|
|
|
|
|
That makes more sense. Do they have an early cancellation policy? If they don't offer to return at least some prorated portion of your prepaid fee then yeah, I'll avoid them.
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
To my knowledge, Hostinger provides a thirty day refund. After that, for any reason even if it's something they've done, there's no refund.
Gus Gustafson
|
|
|
|
|
It's a Ho stinger then?
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
https://www.smarterasp.net/hosting_plans
https://www.hostpoint.ch/en/
https://www.winhost.com/home.aspx?gclid=CjwKCAjwxZqSBhAHEiwASr9n9PB2ZIJS826IaXFSfnv88DRYww_Wyi7n6VKQxk4PefuIZ-_yr-Z0JRoCUo4QAvD_BwE
https://us.ovhcloud.com/vps/
These were some web hosts choices I got from from the lounge (I think). Just an FYI, no endorsement. I have not used them so research them.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
My reason for choosing inmotion was simply that they sponsor updates to FileZilla. I use FileZilla to update the website and I am very comfortable with inmotion's technical support.
Please note that as a wizened developer, my questions usually were about the hosting, not what I was hosting. My websites are HTML, JavaScript, CSS, PHP, and SQL. Many hosting outfits are technically challenged when trying to discuss the contents of these websites.
Thanks for your thoughts.
Gus Gustafson
|
|
|
|
|
Gus Gustafson
|
|
|
|
|
First this is NOT a Programming Question NO CODE is requested
I am the recipient of 3 new arteries to the old ticker and more limitations than I care to mention
Preferably a VB.Net project suggestion. Something with a SQLite Database
What I have written
Password Keeper, Check Book, Code Vault, Card Printer, Label Machine, Diary, Best YouTube Links
GAMES that were no fun Pong & Breakout
Thought about this concept but it seems beyond my ability
Cutlist Optimizer - optiCutter[^]
|
|
|
|
|
It's really difficult to make project suggestions without knowing the person pretty well - we have no idea of your skill level or interests (and a lack of interest in the product makes the project go slowly!).
But ... have you tried here: 40 Side Project Ideas for Software Engineers[^] or here: Awesome Project Ideas for Software and Web Developers | Resume[^]
If nothing else, they may give you ideas for a project you might want to use!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Great Food for thought
Hope your backup situation has a positive outcome
|
|
|
|
|
Part of the "fun" is the research.
https://www.vbforums.com/showthread.php?598418-Cutting-Stock-problem
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
|
Something along those lines would be a box cutter program.
When I go to ship something, a lot of the time I can't find a box that fits I end of creating one.
It would be nice to be able to enter dimensions, type, size, etc. of the box required and it spit out the cut pattern.
The most expensive tool is a cheap tool. Gareth Branwyn
JaxCoder.com
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
