Show all posts by user
Page 1 of 15
Pages: 12345
Results 1 - 30 of 445
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.
by
adcertpoint
-
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
by
adcertpoint
-
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',
...
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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! -
by
adcertpoint
-
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
by
adcertpoint
-
Programming <!DOCTYPE html>
<html>
<body>
<p>ASP can output plain text:</p>
<%response.write("Hello World!"%>
</body>
</html>
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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&
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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,
by
adcertpoint
-
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>
by
adcertpoint
-
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
by
adcertpoint
-
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
by
adcertpoint
-
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,
by
adcertpoint
-
ProgrammingPERL- - 4 years ago
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'
by
adcertpoint
-
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
by
adcertpoint
-
ProgrammingPage 1 of 15
Pages: 12345