I have been working on a csv file on Rstudio for some time now and have taken a month off. I came back today to work on it but when I attempt to do so, I am given a pop-up saying the file is too large as it is 6.4 mb and I can only access a file up to 5mb in size. I never had this issue before and this is the same file I previously worked with so I'm unsure as to how to deal with this.
Forum: Programming

There are a ton of CORS questions like this and I think I've been through most of them. I'm only asking because none of those solutions have worked. I am running into the following: Access to fetch at 'https://myapi.azurewebsites.net/email' from origin 'https://myfrontend.net' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Contro
Forum: Programming

I'm trying to validate an array inside a custom Request. The rule evaluates to required if two conditions are met: attribute3 is true another column from the same array is true Here's what I'm doing: public function rules() { return [ 'attribute1' => 'required', 'attribute2' => 'required', 'attribute3' => 'required', ...
Forum: Programming

I have a list of lists, where in each list, there are tickers and their values. These tickers stay the same for each list but the values differ. Now, I want to see what is the average value of each of these tickers. The issue is that I don't know how to specify to look into a specific ticker in each list and extract the value. For instance, I want the mean value of "jpm" within this 3 l
Forum: Programming

With Python re, I'm trying to capture a phrase, plus the word before and word after in a single return. I.e. From the sentence... We want to see this phrase here and then again! Return see this phrase here The closest I have gotten is ... >>> s = 'We want to see this phrase here and then again!' >>> re.search("\w*\sthis phrase\w*\s",s) <_sre.SRE_Match
Forum: Programming

I want to be able to look up fields values from a secondary table that stores the secondary table field names as strings in a primary table. I am trying to both query the primary table itself to get the field names I want from the secondary table: How can I use that string that contains the field name to select data from table2, given the id of a specific row. The use case here, is that
Forum: Programming

I need to delete 90% of a table. I am executing this statement in a loop (to keep the transactions small) DELETE TOP(1000) FROM Events WHERE EventID IN (SELECT EventId FROM EventsToDelete) Both tables have about 50 million rows. Query plan for this statement is two index scans and this is not fast. What strategies could I employ to make this whole process faster ? Other table
Forum: Programming

When I try to Insert data to my table I got following error. Msg 8115, Level 16, State 2, Procedure trig_stockUpdate, Line 6 Arithmetic overflow error converting expression to data type int. When I insert data to my table stock will be automatically updated. as you can see here my trigger for updating stock. USE GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALT
Forum: Programming

I have an employee list; each employee is assigned to a manager. The manager will change at any time for the employees. I am using a recursive CTE to get the manager's employee. I am getting this error The maximum recursion 100 has been exhausted before statement completion when hierarchy is like this: x => y y => z z => x x => y I want to skip the circular r
Forum: Programming

(SQL) Need assistance writing a statement for the below: Provide a list of all revenue accounts in the Fact table. Click here to view table Click here to view table
Forum: Programming

I have a SQL Server 2014 Express (v12) where items are added to stock using a receipt module and quantities are added in multiple receipts over time. Now, when these items are consumed, the stock needs to be updated for each receipt (oldest receipt first), not at the sum level. As of now, I am using a cursor to iterate through the receipts where stock is available in the chronological order an
Forum: Programming

I'm looking to 'unpivot' a table, though I'm not sure what the best way of going about it, is. Additionally, the values are separated by a ';'. I've listed a sample of what I'm looking at: ​ Column_A Column_B Column_C Column_D 000 A;B;C;D 01;02;03;04 X;Y;D;E 001 A;B S;T 002 C 07 S ​ From that, I'm looking for a way to unpivot it, but also to keep the relations it's currently
Forum: Programming

I need to build a connection string for an application, but first I tried connecting from inside SSMS using the same configurations with a connection string, but it's not working. Here are the keywords I set on the Additional Connection Parameters panel, under Connect to Server: Server=tcp:FLÉK\MSSQLSERVER02,1433;Database=Medical;Trusted_Connection = yes; This string will give me the fol
Forum: Programming

http://www.certificationpoint.org/tutorials/MSExcel_Charts_2010.pdf http://www.certificationpoint.org/tutorials/Microsoft_Excel_Charts.pdf http://www.certificationpoint.org/tutorials/Excel_2016_Charts_Graphs.pdf http://www.certificationpoint.org/tutorials/excel_charts_tutorial.pdf - We can all use an excellent learning tutorial to assist with closing gaps in learning & experience! -
Forum: PDF Help Tutorials and Courses

<!DOCTYPE html> <html> <% dim cars cars=Request.Form("cars" %> <body> <form action="demo_radiob.asp" method="post"> <p>Please select your favorite car:</p> <input type="radio" name="cars" <%if cars="Volvo" then Response.Write("checked"%> value="Volvo">Vo
Forum: Programming

<!DOCTYPE html> <html> <body> <p>ASP can output plain text:</p> <%response.write("Hello World!"%> </body> </html>
Forum: Programming

<% dim numvisits response.cookies("NumVisits".Expires=date+365 numvisits=request.cookies("NumVisits" if numvisits="" then response.cookies("NumVisits"=1 response.write("Welcome! This is the first time you are visiting this Web page." else response.cookies("NumVisits"=numvisits+1 response.write("You have visited
Forum: Programming

Snippet Commands Description or Example out <%=Variable or Some String%> for For i = Value To Value in ... Next forin For item in object ... Next if If Condition Then ... End if while While Condition ... Loop dowhile Do While Condition ... Loop dountil Do Until Condition ... Loop sel Select Case Variable ... End Select case Case Value: sub Sub Subname ... End Sub
Forum: Programming

Add the following code to the top of your ASP page to prevent it from being cached by the browser or any intermediate proxy or caching server. This will force the browser to retrieve a new copy of the page, everytime it needs to display it. <% Response.ExpiresAbsolute = #1/1/1980# Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-control&
Forum: Programming

Use this snippet to check whether a given number (passed in as numberToCheck is even or odd. Function IsEven(ByVal numberToCheck) If numberToCheck Mod 2 = 0 Then IsEven = True Else IsEven = False End if End Function
Forum: Programming

The following code shows you how to execute a Stored Procedure (called MyStoredProcedure) in ASP without creating an explicit ADO Command object. The Stored Procedure expects two parameters: @FirstParam (of datatype int) and @SecondParam (of datatype varchar). Modify the parameter list to suit your requirements The Stored Procedure should look similar to this: CREATE PROCEDURE MyStored
Forum: Programming

The following block of code will display the properties of ALL tables in a MicrosoftAccess database. For the code to run successfully, the variable MyConnectionString needs to contain avalid connection string pointing to the Access database. Withthis code, all tables, including system tables are displayed. If you want tolimit the list, use myTable.Type todetermine the type of the table and skip
Forum: Programming

This snippet will allow you to check whether a certain column exists in a database table or not. Useful when you're coding against a database which schema you don't fully know. Just change the name of the column you're looking for (nameToCheck), the Connection String and the SQL SELECT statement, the bold items in this snippet. <% Dim oField ' As ADODB.Field Dim oRecordset ' As ADODB
Forum: Programming

Apache::OutputChain was written as a way of exploring the possibilities of stacked handlers in mod_perl. It ties STDOUT to an object which catches the output and makes it easy to build a chain of modules that work on output data stream. Examples of modules that are build on this idea are Apache:SIChain, Apache::GzipChain and Apache::EmbperlChain -- the first processes the SSI's in the stream,
Forum: Programming

Apache::RegistryNG is the same as Apache::Registry, aside from using filenames instead of URIs for namespaces. This feature ensures that if the same CGI script is requested from different URIs (e.g. different hostnames) it'll be compiled and cached only once, thus saving memory. Apache::RegistryNG uses an Object Oriented interface. PerlModule Apache::RegistryNG <Location /perl>
Forum: Programming

This module provides the Apache/mod_perl user with a mechanism for storing persistent user data in a global hash, which is independent of the underlying storage mechanism. Currently you can choose from these storage mechanisms Apache:ession:BI, Apache:ession::Win32, Apache:ession::File, Apache:ession::IPC. Read the man page of the mechanism you want to use for a complete reference. Apache:essi
Forum: Programming

META: should be annotated at some point. use strict; use DBI; use Apache:ession:BI; use CGI; # [...] # Initiate a session ID my $session = (); my $opts = { autocommit => 0, lifetime => 3600 }; # 3600 is one hour # Read in the cookie if this is an old session my $r = Apache->request; my $no_cookie = ''; my $cookie
Forum: Programming

There is nothing special about sending email from mod_perl, it's just that we do it a lot. There are a few important issues. The most widely used approach is starting a sendmail process and piping the headers and the body to it. The problem is that sendmail is a very heavy process and it makes mod_perl processes less efficient. If you don't want your process to wait until delivery is complete,
Forum: Programming

Just like $ENV{MODPERL} is checked to see whether the code is run under mod_perl, $ENV{HTTPS} is set by ssl modules and therefore can be used to check whether a request is running over SSL connection. For example: print "SSL" if $ENV{HTTPS}; If PerlSetupEnv Off setting is in effect, $ENV{HTTPS} won't be available, and then: print "SSL" if $r->subprocess_env('https'
Forum: Programming

This is a simple example of passing environment variables between handlers: Having a configuration: PerlAccessHandler My::Access PerlLogHandler My::Log and in startup.pl: sub My::Access::handler { my $r = shift; $r->subprocess_env(TICKET => $$); $r->notes(TICKET => $$); } sub My::Log::handler { my $r = shift; my $env = $r->subproces
Forum: Programming