[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Web Applications

14K

Solutions

14K

Contributors

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello

I am trying to connect Zapier on an MS SQL 2014 instance I am running on one of our servers.

I can connect fine using heidisql.

When connecting from Zapier I get an authentication error:

(pyodbc.ProgrammingError) ('42000', "[42000] [unixODBC][FreeTDS][SQL Server]Login failed for user 'someuser'. (18456) (SQLDriverConnect)")

Open in new window


So this means that the network connexion itself is working but somehow their Python based connector doesn't manage to authenticate.

We used mixed mode authentication on said sever and I have tried both SQL user and domain user to no avail... Using a complex password as per their suggestions.

Any suggestion / info most welcome (as their support is not too helpful on this one).
0
Become a Microsoft Certified Solutions Expert
LVL 12
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

I have Elasticsearch 6.4.3 and Kibana 6.4.3 installed on Debian 8 Jessie.

I've looked into X-Pack and Shield, which both seem to be mostly concerned with security within Elasticsearch, and how to control security BETWEEN Elasticsearch and Kibana.

I don't really need security on the backend between Kibana and ES. However we would like the Kibana web page to be world accessible with a login page.

Is it possible to implement ONLY a login page for the Kibana site?
0
Hi,
I have a Table called game with 4 columns:
clock_first_goal, clock_last_goal, clock_first_penalty, clock_last_penalty

and a second Table called tickets_one with 5 columns:
clock_one, clock_two, clock_three, clock_four, clock_five
where I've imported random clock times between 0 and 20:00 minutes that of a NHL period.
There are 1200 total times (60 seconds x 20 minutes) in 5 columns so there are 240 records in this Table.

In my application I have a page called enter_games.php. What I want is when the admin submits the times for First Goal, Last Goal, First Penalty and Last Penalty, I want to check if any of these values match the values in the tickets_one Table. If they do I just want to echo "we have a match!", if not I want to echo "no match".

I'm not sure the best way to do this if it should be a Join, if statement or loop etc... I think it can be done with an if statement.
I'm somewhat new to php and mysql. This is the section of the code I'm trying to get to work:

// find matching results
// query the database with client ID
$query = "SELECT * FROM tickets_one";
$result = mysqli_query( $conn, $query );

// if result is returned
if( mysqli_num_rows($result) > 0 ) {

    // we have data!
    // set some variables
    while( $row = mysqli_fetch_assoc($result) ) {
        $time1    = $row['time_one'];
        $time2    = $row['time_two'];
        $time3    = $row['time_three'];
        $time4    = $row['time_four'];
        $time5    = 

Open in new window

0
we are looking for 800 phone no with api. meaning when someone call 800 phone no. we want api to be called immedately to www.myweb.com/phone no
then redirect to 310.222.2222

do you know which provider can. do it? just like something out of the box without too much coding involved
0
Dear experts

Our company would like to setup open source OT management system that allows us to do following:

1. When employ wants to do OT, Start time must be submitted first and then it will only be reflected to system once administrator approved.
2. Later when employee finish job, he or she can set the end time, and there should be something that allows emplyee to upload service report that contains start and end time signed by our customers.
3. After setting end time, it should show total OT - hours and we should be able to generate monthly OT for each employee.

Plz advise something that is opensource or even if need to pay, it should be something not very expensive.
0
Hi,
I'd like to find matching results between 4 columns in one table and 5 columns in another table.
I have one table called game with 4 columns:
clock_first_goal, clock_last_goal, clock_first_penalty, clock_last_penalty

and a table called participants with 5 columns:
clock_one, clock_two, clock_three, clock_four, clock_five

Everything in these columns are numbers like 4:16, 8:47, 13:02 etc clock times of a period of an NHL hockey game. I think I should be using an Inner Join for this however, it's not working, it's just displaying all of the times in the database instead of just the matching results within those columns.

Please take a look at the screen shot attached to see what I mean.

Here is the code I have so far:


$query = "SELECT * FROM participants AS p INNER JOIN game AS a ON p.game_date = a.game_date WHERE a.user_ID='$userID'";

 

$result = mysqli_query( $conn, $query );

 

                    ?>

                                                               

                                                                                <?php

                                                                                if( mysqli_num_rows($result) > 0 ) {

 

                                                                                                // we have data!

                                                                                                // output the data

 

                                             

Open in new window

0
i have multiple ms accounts and I always use visual studio community 2015 IDE as well as TFS Online.
My issue is: sometime MS Visual Studio keeps remember my first ms account for e.g. client A. When I try to sign out and sign in another MS account for client B - TFS online
It does not allow me to connect client B - TFS online. Seem like the cache issue but have no idea how to fix it
0
I am using visual studio 2010 for a  web application with gridview populated by dataview source of which is a datatable.
One of the fields diffimt is numeric field defined as follows:
 DataColumn diffimt = new DataColumn("diffimt", typeof(int));
I wanted the dataview and hence the gridview to be sorted in the ascending order of the field
dView.Sort = "diffimt ASC";
After the sort command, gridview is source to dataview and then databound with the following commands
dView.Sort = "diffimt ASC";

                GridViewVa.DataSource = dView;
               GridViewVa.DataBind();

But it is sorting as if it is a text field.  Screeshot is depicted in the attached file.  As for my requirement, the sorting should be
12,13,102,102,107…….. Not 102,102, 107 …
Can anyone help in fixing the problem
20181020_GridView_Screenshot.jpg
0
I manage a bunch of websites that mostly use Coldfusion. Each website is located in its own directory on the server and they all use the same version of the code and they each have their own database. I am trying to figure out what is the best way to update all of the sites when I make a change to the code. Right now I have created a directory on the server that contains the changed files and then I use directoryCopy to copy over the new files. My code looks something like the following:
<cfset temp = directoryCopy("_UpgradeCode","website_to_update_directory/",true,"*.*")>

Open in new window


One issue that I have is that I don't know if there were any problems copying over the code.

Can anyone suggest a better way to update websites? I am hoping that this can be done in an automated way so that I can just call a function or something and then it automatically updates all of the sites. I have created a list of sites to update that can be passed to the function.

Thank you for any help that you can provide about this.
0
I need to change a gridview datasource/connectionstring based on session parameter/login.

Just a little background, we have an in-house software that generates an .mdb database file and then uploads it to our hosted database-driven website via FTP. Each of our customers get their own .mdb file and a login to the website. The website is designed to show only their assigned .mdb. But the website has limited capabilities.

So I was tasked to update the website and found out that it uses .asp, but I am not well versed in VB script and found that creating an .aspx web application is easier.

Now I'm developing a web application in Visual Studio that utilizes the same database but with added features such as sorting, paging, and filtering based on keyword searches.

I've finished creating the login part (with sessions), and I've been able to create a page that displays data on a gridview. My problem now is that I don't really know how to change the gridview datasource based on login/session.

By the way, the database for login information is also an .mdb and is also uploaded by our in-house software. If we need to add new users, we use the in-house software to update the .mdb and then upload it to the website. There are 3 columns in the database table, username, password, and client code. I would like to use the client code to pull the correct database file because each of the database files contain a specific client code already.

Please assist. Thanks!
0
OWASP: Avoiding Hacker Tricks
LVL 12
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Hi,

I went through https://www.callicoder.com/reactive-rest-apis-spring-webflux-reactive-mongo/ and need clarifications on the below

In previous version we have to specify as below to return the output as Json

@RequestMapping(value = "/getString", method = RequestMethod.GET, produces = "application/json")

How to return the response as Json in new Spring 5 ?

In earlier version we can return a stream directly to the browser to process to the front end. either stream or base64 url. How to return a stream in the current spring 5 version

Where i can find out the syntax differences between spring earlier and spring 5 version

Thanks.
0
I am working to create a login prompt and I do not want the browser to offer the remember username and password option for the user. I am using a text box for the username field and a password box for the password field. Anytime I use a password box the browser prompts the option whether to remember username and password or not. I would like my users to type in those information each time they login. Is there any way I could use a text box to accept password and mask the characters in that textbox as a password character so that the browser does not prompt the remember username and password option?
0
Hi , I need an advise .
Do anybody know , what is the most popular architecture for .Net WEB application?
I mean before 2008 I use
ASP.NET 3.5  + Adjust  Toolkit cl [b]- front end ( view)
Typed DataSet  + Busies Logic CS classes middle tier ( model)
Public generic  cs class injected into Code Behind of every page was responsible  for binding / back binding
ASP.NET controls  to Typed Dataset  ( controles)
Public generic  cs class was responsible  to fill out Typed Datset data from SQL Server ( DAL)
Back end is always was SQL Server
Export / Import of the data was always via WEB Services  or sql jobs  which were run  from the last data received identity  (for performance point)
Right now so many Framework.

Do you   how use them  the most optimal way?
I mean what is the best way  to  implement
1)Most  efficient front end
2) Middle Tier with Business logic
3) Data  Access Layer
4) Data Exchange (Export/ Import) with   different clients
 
Please advice
0
why does experts-exchange.com use tracking cookies?
0
We are working on an e-commerce application. We are at the point of integrating Elasticsearch for the product search engine with Spring boot application with Spring data. We have tried different tutorials online (check links below) but they all doesn't run well. No indexes are added to the Elasticsearch.  We are using ES 6.3.1 and the maven dependency is as follows.

               
 <dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-elasticsearch</artifactId>
		</dependency>

Open in new window


Product Entity

@Entity
@Document(indexName = "product", type="default")
public class Product {

    @javax.persistence.Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long Id;
    private String Name;
    @Lob
    @Type(type = "text")
    private String Description;
    private String ShortDescript;
    private String Model;
    private String Brand;
    private String Sku;
    private String Isbn;
    private Integer Shipping;
    private BigDecimal SalePrice;
    private BigDecimal RegularPrice;
    private Integer Quantity;
    private Double Weight;

//other code here
}

Open in new window


Product Repository

@Repository
public interface ProductRepository extends ElasticsearchCrudRepository<Product, Long> {

    @Query("select p from Product p where p.supplier.id = ?1")
    public Iterable<Product> GetAllProductsBySupplier(Long id);
   
}

Open in new window


We have installed kibana locally and have tested with test data and it works. But not with the Spring Boot application. Need your help. Thanks

1. https://www.baeldung.com/spring-data-elasticsearch-tutorial
2.https://www.mkyong.com/spring-boot/spring-boot-spring-data-elasticsearch-example/
0
I'm able to pass the query parameter successfully to the field however when the item is saved the record is not being saved to the list. What's interesting is that if I manually override the passed value by typing into the field on the form and then clicking save, the record is saved to the list .

We have a working example of this on the same site for a different list that we created about a year ago and does not have this issue.


Original Code Provided when a new form was created for the list in SPD:
<SharePoint:FormField runat="server" id="ff1{$Pos}" ControlMode="New" FieldName="AttachmentsID" __designer:bind="{ddwrt:DataBind('i',concat('ff1',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@AttachmentsID')}"/>
<SharePoint:FieldDescription runat="server" id="ff1description{$Pos}" FieldName="AttachmentsID" ControlMode="New"/>


Removed the above code and replaced with the following:                                                            
<asp:TextBox runat="server" id="ff1{$Pos}" Name="FileName" Text="{$AttachmentsID}" Value="{@AttachmentsID}" __designer:bind="{ddwrt:DataBind('i',concat('ff1',$Pos),'Text','TextChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@AttachmentsID')}" Width="100px" Height="20px" BorderWidth="0" />
0
Hi Expert,

I'm getting below Oracle Web-logic application error could anybody please guide me how to fix it!

subsystem is initializing on Server WebWORKS6.>
####<Aug 2, 2018 1:09:38 PM GMT> <Info> <Store> <trpridrps1app6> <WebWORKS6> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1533215378092> <BEA-280008> <Opening the persistent file store "WLS_DIAGNOSTICS" for recovery: directory=D:\Manu\IDRPPSA\srvr6\config\JDADomain\servers\WebWORKS6\data\store\diagnostics requestedWritePolicy="Disabled" fileLockingEnabled=true driver="wlfileio3".>
####<Aug 2, 2018 1:09:38 PM GMT> <Critical> <WebLogicServer> <trpridrps1app6> <WebWORKS6> <Main Thread> <<WLS Kernel>> <> <> <1533215378108> <BEA-000386> <Server subsystem failed. Reason: java.lang.NullPointerException
java.lang.NullPointerException
       at weblogic.store.io.file.StoreFile.close(StoreFile.java:440)
       at weblogic.store.io.file.Heap.open(Heap.java:320)
       at weblogic.store.io.file.FileStoreIO.open(FileStoreIO.java:104)
       at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:431)
       at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:422)
       at weblogic.store.xa.PersistentStoreManagerXA.createFileStore(PersistentStoreManagerXA.java:117)
       at weblogic.diagnostics.archive.DiagnosticStoreRepository.getStore(DiagnosticStoreRepository.java:91)
       at …
0
ImageHello Experts,

I have an Article Content Type that I'd like to display all of the Articles, on separate pages based on a Choice Field Item.  Any help on how I can achieve this is very much appreciative.
Using SharePoint 2013 On-Prem.  I don't need help on creating the content type, only on how to get them to display on their own pages that are page-able.  To also include the Title, an image, and part of the Body.
 
0
Hi, After logging into a site I select the page required it then goes through a load process in which several pages appear before the end page completes, however I would like to access the 2nd page that is part of the loading as it has more search facilities. Is there a way to allow me to step page by page through the loading process. If I am quick enough clicking with the mouse I can sometimes access the page but it is very random. I am using Chrome, the same load proces does'nt occur under MS Edge.
0
Starting with Angular 5
LVL 12
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Hello!

We have an intranet that's behind a username/password page and one of our biggest struggles is search. We've implemented a basic search tool and it does okay at best. If searching for the word book, it'll return pages with the word book in it. However, it runs into issues when using multiple words, quotations, and does not rank the results for the user. Our intranet is using php and CodeIgniter. I looked around at codecanyon.net for php search engine scripts, but nothing really stuck out to me. Does an expert have a suggestion on what a good search solution might be for an intranet?
0
How to get currency exchange rate in ASP.NET C#  webform .
I've using the following answer but doesn't work.
Expert Exchange Solution

Maybe google currency converter not exist. is there any other way.
aaa.PNG
0
im getting this error message in my ruby on rails blog app and i have no idea why

this is my controller file:

class PostsController < ApplicationController
  def index
    @posts=Post.all.order("created_at DESC")
  end

  def new
    @post=Post.new
  end

  def show
    @post=Post.find(params[:id])
  end

  def create
    @post=Post.new(post_params)
    if @post.save
      redirect_to @post
    else
      render "new"
    end
  end

  def edit
    @post=Post.find(params[:id])
  end

  def update
    @post=Post.find(params[:id])
    if @post.update(params[:post].permit(:title, :body))
      redirect_to @post
    else
      render "edit"
    end
  end

  def destroy
    @post=Post.find(params[:id])
    @post.destroy
    redirect_to posts_path
  end

  private

  def post_params
    params.require(:post).permit(:title, :body)
  end

end

Open in new window


and this is my edit file: (i get the error when trying to delete a post and the link to the destroy path is on my edit page)

<font color="#BD004B">
    <h1 class="smallBorder">Edit Post</h1>
</font>
<br/>
<hr size="10" width="auto" color="#BD004B">

<%=render "form"%>

<ul>
  <li>
    <%=link_to "Delete", posts_path(@post), method: :destroy, data:{confirm:"Are you sure you want to delete this post?"}%>
  </li>
</ul>

Open in new window

0
Dear Experts,

I have an asp.net website that uses identity 2.1 (I'm pretty sure > 2.0 anyways as near as I can tell). It is written in visual basic. I ran into a weird issue the other day where people were logging in and getting this viewstate error:

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

So I followed the advice I found in the microsoft article and added a machine key to the web.config file so that no matter what it (hopefully) shouldn't get that error again.

Once the machine key was changed to one that I set now we had issues with anyone with an already existant authorization cookie on their computer, they were unable to login. I believe it's because the machine key that I set no longer matched the one that was used in their cookie. I'm not entirely clear how, but apparently it's part of how it's encrypted. If they clear their cookies, all is well - then they could login.

So one bit of advice I found searching on the web sounded super simple and super-easy. They recommended that you have some sort of set key in your web.config, like a guid or something and then you add it to your cookie also. Then, when you load the cookie, you can check the key and if it doesn't match your server key, somehow you invalidate the cookie.

I basically spent all day trying to figure out …
0
try
            {
                string folder = ConfigurationManager.AppSettings["Path"];
                string readline;
                if (Directory.Exists(folder))
                {
                    using (var sr = new StreamReader(folder))
                    {
                        readline = sr.ReadLine();
                        while (readline != null)
                        {
                            if (Directory.Exists(folder))
                            {
                                //DirectoryInfo d = new DirectoryInfo(folder);
                                foreach (var file in d.GetFiles("*.*"))
                                {
                                    File.Delete(file.FullName);
                                }
                                Logger.DebugFormat("Folder Path : " + folder);

                                foreach (var subDir in new DirectoryInfo(folder).GetDirectories())
                                {
                                    subDir.Delete(true);
                                }
                            }
                        }
                    }
                }
                Logger.DebugFormat("Folder Path : " + folder);
            }
            catch (IOException ex)
            {
                Console.WriteLine(ex.Message);
                return;
            }
0
In my Magento there is an exception message "The requested Payment Method is not available." from Mage_Core_Exception class happening on a few pages:
  • /checkout/onepage/saveShippingMethod/
  • /checkout/onepage/

This is the stacktrace:
stacktrace
The version is Magento CE 1.9.3.3
What is the issue and how to fix this?
0

Web Applications

14K

Solutions

14K

Contributors

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.