Or a toFU

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

So sorry to hear that, and I hope things have a positive outcome.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

Check here if you want to call the API server-side (e.g. from within an MVC controller). If you want to consume it on the client side, you could use AJAX or similar with the API URL.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

Right. It can be a bit tedious. I've been working on a project for a few months, an existing application. The new enhancements/features required that we split some existing tables out (moving a field from one table to a new table). When setting up the deployment, I had to alter the generated diff scripts quite a bit.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

We use them where I work to version stored procedures, permissions and other objects in source control. We also use the generated script(s) to deploy changes. The build process includes a task to compile the db project(s) and generate a diff script for the target environment, and then all the application files, SQL scripts, etc, are pushed to a staging folder on the network, ready for deployment. I personally alter the generated scripts when I come across the warnings of existing data being lost. However, I don't know if that's standard/best practice or not - that's just how I've always done it.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

Ah, wonderful! Thanks! I'll read over them today or tomorrow.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

I encounter this issue fairly regularly at work, and I'm interested in learning about how others handle it. Basically, when you have a Web app and you make some changes to a JavaScript file, how do you ensure that the correct script is loaded when users navigate to the updated Web app? We're using ASP.NET MVC, IIS 7. I've done some digging online and a common solution seems to be appending some sort of identifier to script files in the markup, like this:

Where 'v' is maybe a version number or something along those lines, updated with each deployment. I came across a StackOverflow post in which someone provided a custom HtmlHelper method to append the file's 'LastWriteTime'. But I was wondering how you all handle this. Thanks in advance!

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

We have one called "EstimatedYearlyCreditOpportunityImportDataSaver"

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

I started tinkering with computers a while ago - maybe around '95 or '96. I've only been in professional developer roles for about 5 years though.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

I agree. I worked as a contractor for my first few gigs ('13-'14), but I've been on company payroll here since April '15. I don't see being a contractor any differently; I still take the job very seriously and I put in the same effort. I've also seen other contractors' work where they didn't seem to care a bit, however. "Younger generation" being how young? I'm 29. :~

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

:laugh:

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

The project I'm currently working on has been developed by four people, including myself, over the course of the past two years. While looking through some code yesterday, I saw many instances like this:

var someInt = model.SomeIntProperty;

SomeMethod(param1, param2, someInt != null && someInt.HasValue ? someInt.Value : (int?)null);

Why? Is that really necessary, to check the value, pass the Value if it has one, and otherwise pass 'null' cast as a nullable int? This project also utilizes Entity Framework for the data access layer. The same contractor (contract was not renewed, for several obvious reasons) also wrote some data access code at one point. No, he didn't use EF with LINQ - he called "context.Database.ExecuteSqlQuery" methods, using const string variables for the queries. The majority of them are pretty basic select statements.

private const string SomeSqlQuery = "select * from table1 where field1 = {0} and field2 = {1}";

// Somewhere in the Repository class:
var field1 = model.SomeField;
var field2 = model.SomeOtherField;

context.Database.ExecuteSqlQuery(SomeSqlQuery, field1, field2);

The problem? We discovered, by chance that the "format string" construct for the SQL query is supported - until SQL Server 2008 R2. If the target DB is ever upgraded from SQL Server '08 to '08 R2, this application would not work in several cases. We had to convert all of these so that they take "@field1" type parameters, and then pass SqlParameter objects to the ExecuteSqlQuery methods. But I don't understand why he didn't use EF with LINQ queries, as the rest of the data access code does?

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

I enable ads via AdBlock Plus for certain sites, including CodeProject. Any site with intrusive ads, they are blocked. YouTube and such. I don't mind ads either, depending on how they're used. Sometimes they cover a site, sometimes not.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

My dad did this all the time. He did it for as long as I can remember, but I always assumed on first glance that it was "laugh out loud". Because I guess that's what I'm used to. "Your sister is at the hospital to have the baby, blood pressure is high right now. LOL Dad" "I saw the doc today and have to start treatment next week. LOL Dad"

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

This line:

var listitm = $("#li.report active");

You're referencing "active" as if it's a tag. Add the "." before it, like so: "#li.report.active". You can chain the tag + classes. Also, to read an attribute, you use jQuery's "attr()" method:

var title = listitm.find("span.title").text(); // This is the text inside the SPAN tag
var url = listitm.find("span.title").attr("report-url"); // Reads the attribute "report-url"

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

The column it's referring to isn't referenced in the line of code you provided. May need more code in order to help. Something is referencing the ApplicationName column, and it doesn't exist in the database.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

:laugh: :laugh:

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

byte me;

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

:laugh:

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

I knew it was only a matter of time before they showed up again.

djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.