Advertise Here

ASP

80K

Solutions

Content

31K

Contributors

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

store HTML Code in database

I want to store HTML code in database.
is it possible? If yes then how?

7 Comments

LVL 5

Question by

Abiel de Groot

4d agoSolved

Javascript function confirm submit, not working

Hello all,

The following function is being called by a button ‘onclick’. However, it submit the ‘Form’ even if cancel is clicked!!!
What is the problem?

Kind regards

Abiel M de Groot

<button class="Part_SubmitBUTT" onclick="SubmitPArtesForm()">Are you sure you want to do this?</button>

-------------------------------------------------

function SubmitPArtesForm() {
if(confirm("Are you sure you want to do this?"))
document.getElementById("PartesPendingXX").submit();
else
return false;
}

5 Comments

LVL 1

Question by

kf4ape

6d ago

Custom ASP error page and IIS

I am working on a generic VB ASP page for all our sites that will toss up the status code and error message, works great in testing directly to it or redirecting to it...however if I leverage the page as a file, it doesnt execute any of the asp vb code

I wrote it generically so that it could be placed on any of our corporate sites and offer redirection to that applications home root or our corp status page...it uses the following in the code
Response.Status
Response.Write
Request.ServerVariables("SERVER_NAME")

Code snips

      <meta http-equiv="refresh" content="500;url=https://<%Response.Write(Request.ServerVariables("SERVER_NAME"))%>"/>

      Dim StatusCode
      Dim StatusMessage
      StatusCode=split(response.status," ")(0)
      StatusMessage=Right(response.status,(len(response.status)-len(StatusCode)))%>
      <h1 style="font-size: 170px;"><%Response.Write(StatusCode)%></h1>
<h2><%response.write(StatusMessage)%></h2>
<p style="width: 400px; margin-left: auto; margin-right: auto; margin-top: 15px;">
Sorry, but the page you are looking for has not been found. Try checking the URL for an error, then hit the refresh button on your browser. Click the button below to navigate to the <%Response.Write(Request.ServerVariables("SERVER_NAME"))%>:
</p>
<a class="btn btn-primary m-t" href="https://<%Response.Write(Request.ServerVariables("SERVER_NAME"))%>">Home</a>
      <p> Error Code: <%Response.Write(Response.Status)%></P>

12 Comments

Hi there, just curious if you can use this query or something similar on a remote site?

I have images from my website stored on other webspace

If fs.fileexists("w:\images\stand-"&Stand("stand_type")&".jpg") Then

Open in new window

6 Comments

Question by

ullenulle

7d agoSolved

Issue with global.asa file...

Hi.

I tried saving a global.asa in the root of the webserver folder:

<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
Sub Application_OnStart
    Dim cnnDem, cnnString
    Set cnnDem = Server.CreateObject("ADODB.Connection")
    cnnDem.CommandTimeout = 60
    cnnString = "Driver={SQL Server};Server=servername\SQLEXPRESS;Database=mcd;Uid=username;Pwd=password"
    Application("conString")=cnnString
    Application("cnn")=cnnString
    Call cnnDem.Open(cnnString)
End Sub
</SCRIPT>

Open in new window

Of course I replaced servername, username and password with the real values. But then no page on my website will show up. I just get the Server 500 error. If I move the global.asa away from the root, then the webfiles works again. What am I doing wrong? And how should I handle the global.asa file correctly to have sql server connection available in my web application?

Best regards

Ulrich

12 Comments

Hi there.

I have some trouble with the connection string on my Windows 2016 Server with SQL Express server. I'm used to a connection string like this on a standard web hotel:
"Driver={SQL Server};Server=webhotel.com\MSSQL2005;Database=database_name;Uid=db_username;Pwd=db_password"

Since I run web and SQL on the same Windows Server I'm a little confused how to write the connection string to make it work AND to be safe. I'm hesitant to write username and password in the connection string.
I hope some of you with a similar setup can give me a useful hint. My web app is classic asp/aspx/VB.

Best regards

Ulrich

11 Comments

Question by

robrodp

2017-08-09

js variable to asp

I have a js that produces a result , say data.

<script>
some code
gives data
</script>

Now I need to manupulate data in asp
like say

<%response.write left(dataasp,100)%>
where dataasp=data

Any ideas ?

7 Comments

Question by

robrodp

2017-08-09Solved

Action take form a form with get

There is a form with "post" that in the action it says:

(I run it with get and the line reads http://domain.com/test/?(variables))

http://domain.com/test

It doesn't specify the script that takes the form data to process and returns a result

I dont know in what language it is programmed in

I tried index.php (domain.com/test/index.php

the same for index.asp, default.php and default.asp but those scripts dont exist in the server.

I use chrome developers tools but it only returns (index) which could be anything

Any ideas?

14 Comments

Free Tool: Subnet Calculator

LVL 9

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question by

Graeme

2017-08-09Solved

How to idenitfy the largest number

Hello all, I have struggling to think of a way to produce this outcome...

in the column - itin_day there is many values, eg:
1
2
2
3
3
4
4
5

How do I select the '5', and if there is multiple of 5, I just need 1x 5, not both

Any help is appreciated :)

7 Comments

Hi EE,

How do I make the lines highlighted in the attached picture (pic 1) begin at the left of the respective cell? Code below:

<td class="infocell" onclick="uOutcome(4,1);">
			<li>Permanent harm unrelated to the natural course of the illness, loss of function and differing from the expected outcome of patient management or as a result of the incident:</li>
			<ul>
				- Significant disfigurement<br>
				- Patient at significant risk due to self discharge against medical advice<br>
				- Increased LOS  &gt; 6 days<br>
			<li>Long term high level care expected</li>
			<li>Immediate emergency treatment for life threatening event unrelated to the natural course of the illness</li>
			<li>Any matter with major harm and could potentially result in a claim</li>
			
			<ul><b>Serious Harm or Significant Events</b> include:
			<ul>
				<li>Inpatient fall resulting in a fracture (confirmed on x-ray)</li>
				<li>Inpatient fall resulting in a closed head injury (confirmed on CT)</li>
				<li>3rd degree perineal tear with anal sphincter involvement or 4th degree perineal tear</li>
				<li>Post partum haemorrhage &lt; 1500ml requiring massive blood transfusion or hysterectomy</li>
				<li>Hysterectomy post partum</li>
				<li>Neonatal birth trauma</li>  
			<ul>
				- Fracture<br>
				- Closed Head Injury / Brain trauma<br>
				- Haemorrhage<br>
				- Subcutaneous fat necrosis<br>
				- Organ trauma including any trauma to the eye<br>
				- Nerve trauma including

Open in new window

…

6 Comments

Hi there.

I have an MS SQL database with a classic asp interface spiced up with Javascript, jquery, VB etc.. I have to create a procedure like this:
User download an Excel spreadsheet, enter some data in predefined columns and upload it to my server via a web interface. Here the data must be imported to a MS SQL database and in the same process be validated against some validation rules like:
only numbers to number fields, values in a certain range etc..
I know it's possible. It doesn't have to be classic asp. It can also be aspx. I'm just not so familiar with aspx yet. My server is a pure Microsoft server with web and database. Anyone who has got a useful guide or can assist with the vital codes to perform this procedure? I have all on a dedicated server.
I look forward to some input. :-)

Best regards

Ulrich

4 Comments

Hi there!

I have created a "Live modal" as explained in the following link:

http://getbootstrap.com/javascript/#modals

I do not have only one button, though. There are many, everyone with exactly the structure below:

<button class="btn btn-deluge btn-sm" data-toggle="modal" data-target="#myModal" type="submit" name="hiddHorarioID" id="hiddHorario31"  value="315_<%= ThisDay(3)%>">Qua, 7h30min</button>

Open in new window

where the id and value properties have, of course, different values in each button.

Question: how should I change the "modal receptacle" (below), so that the text in bold comes correctly from the button chosen?

-----------------------

<!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title" id="myModalLabel">Modal title</h4>
      </div>
      <div class="modal-body">
[b]        You have chosen the following "value button":   315_<%= ThisDay(3)%>[/b]
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        <button type="button" class="btn btn-primary">Save changes</button>
      </div>
    </div>
  </div>
</div>

Open in new window

-----------------------

Of course what I need is not EXACTLY that, but if you tell me how to solve this, my problem is solved.

Explaining a bit better, I hope: I have many buttons, just one "modal receptacle". I need the "modal receptacle" to know from which of the buttons it was called, so that I can use the "value" property of THAT button to put messages inside the "modal receptacle" body...

Thanks!
fskilnik.

12 Comments

Question by

Daniele Cosenza

2017-07-28Solved

IIS classic asp hangs

Hi, i'm really desperate, facing a problem that is obsessing me.
I'm managing a legacy web-application entirely wrote in classic asp 3.0, connected to a mysql database.
I'm experiencing hangs, like, someone sometimes go on a page and it takes FOREVER to reply, without any apparent reason. If i later try to launch that same page, it loads without problems, so it's NOTHING related to code cause it's not repeatable at all.
In this attached screen took at Worker Process monitor on IIS u can see quite the example situation.
At this point, to start, would be enough for me to tell IIS "PLease, if a process takes more than 2 minutes, TERMINATE IT!". Using "Idle time-out" from application pool settings seems to not work (it's set to 1 minutes and you can see here there are process waiting forever).
Server.scriptTimeout doesn't work either (it's set to 3 minutes).
These process get terminated only when i recycle the appPool, but i can't recycle it cause it will disconnect all users that are current logged in.
Another thing that i noticed, is that if a user start a long-time operation (for example an inventory), he cannot interrupt it till it ends, in few words even if i rethink about it and wanna do other things, he have to wait that page to reply before he can open another page on the same domain with the same browser.
I have tons of things to say but at least this is a starting point. Anybody can point me to the right direction to face this problem?

34 Comments

Question by

Pooja Solanki

2017-07-27

out of string space error

i have changed an old windows application made in VB to website in c#.Both are referring a same vb dll code.for that particular dll code, Both the applications show sometimes the out of string space error and we are fine with that. But the freqency of out of string space error is very high for website comparatively of windows application. This code generates a report. so it first write the data from database into an xml file and then generates a word file. while writing that xml,this error comes.
I have checked for the same object ,in windows application it took 6-7hours but finally it gives the report. While in website in around 1 hour it gives out of string space error.
What cold be the reason ?

8 Comments

Im totally lost and also not sure how to provide any information for help on this problem.
I have a classic asp page that has been happily working for 10+ years.
Now it is randomly causing browsers to issue "Site can't be reached ERR_CONNECTION_RESET"
Locally, remotely - its the same.
Its not even consistent depending on the data I ask it to return
I have checked the contents of all the rows in the database relating to the page and there is nothing wrong - that was my first port of call
Everything else using the information still works.
I have also checked the server logs and can find no reference to any error at all.
I know this is a long shot but does anyone else have any idea where to start to look?
There is just nothing useable to try to find the problem anywhere
windows Server 2008 R2
Help much appreciated

4 Comments

Failed to install web server service IIS windows authentication & ASP due to error "Attempt to install ASP failed with error code 0x8007007E. The specified module could not be found & "Attempt to install windows authentication failed with error code 0x8007007E. The specified module could not be found

8 Comments

Hi all and hope you can help

I want to create an IF statement for:
When a user visits my site if creates I record the 'main' entry into the DB. eg user demographic details, cookie assigned, sessionID recorded, etc.
When a user revisits my site, if would also create another 'main' entry and record new user demographic details (most likely same as before, unless they have traveled), same cookie (as it has been already assigned, NEW sessionID, etc.

The above INSERT statements are already working, so dont need any work here

The issue Im having is... how to figure out the IF statement, so that the above is not created every time the user goes to a different page within the same sessionID

3 Comments

Question by

amucinobluedot

2017-07-24Solved

iframe not being displayed on website

I have a website that has an iframe which displays a vimeo video.
When I see it locally the iframe is displayed correctly and i can watch the video, but on the server it only shows a blank space.

Is there an IIS setting that could be blocking iframes? what else should I consider?

5 Comments

Oh men,
Im wondering it is a free plugin or some calendar for an consulting room apointment
its any idea or recomendation if its for free or open source better
regards

4 Comments

Question by

APD_Toronto

2017-07-21Solved

Boolean Value Changes after Refresh

Hello Experts,

I inherited an ASP application, that is very messy, across multiple of domains, virtual directories, etc... I'm not even able to create a test environment, so I'm making all changes live.

Anyways, here's the situation...

On MSSQL i have a fldEnabled bit set to False

In one common.asp include, I have

Session("bolNightSeason")   = (.Fields("fldEnabled"))

Open in new window

I also tried

Session("bolNightSeason")   = CBool(.Fields("fldEnabled"))

Open in new window

Then, after including common.asp in another file,, I have

bolNightSeason = Session("bolNightSeason")
Response.Write("night = " & bolNightSeason)

Open in new window

Now the issue is in the output...

When I first start the browser, I see
night=
...
expected as i set it to False

Then, if i hit Refresh I see
night=True
...
How is this possible, when the field value in the db is still set it to False?

Refreshing remains True, but closing and re-opening the browser goes back to ""

Can any one spot why the value is changing, or advise on how I can trace the issue?

Any help will be greatly appreciated.

Thank you.

2 Comments

Hello,

I want to add a csv file to database. There is a column in csv file called as merchant_id same as column in SQL database. I want to update the row in database if the "merchantid" exists in database or if it doesn't exist , we need to add that row from csv file .

Here

"rs" contains all the columns of the CSV file and its values.

"rsAdd" contains all the columns of Database table(Merchants) and its values.

Set rs = GetRecordSet("C:\upload\new\" & TheNewFileName2)
    'Response.Write "No Errors"
    Set cn = Server.CreateObject("ADODB.Connection")
    cn.ConnectionString="DSN=REWC"
    cn.Open
    i = 0
		TheSql = "SELECT * FROM Merchants"
        Set rsAdd = Server.CreateObject("ADODB.RecordSet")
        rsAdd.CursorType=1
        rsAdd.LockType=3
        rsAdd.Open TheSql, cn
        
    While not rs.EOF
				
			rsAdd.AddNew            
            For Each col in rs.Fields				
                rsAdd(Replace(col.Name,"_","")) = col.Value
            Next		
			
        rsAdd.Update
        rsAdd.Move 0        
        rs.MoveNext
        i = i + 1
        If (i mod 100)=0 Or i=1 Then
            Response.Write i & ","
            If (i mod 2500) = 0 Then
                Response.Write "<br />"
            End If
        End If
    WEND
	
    rsAdd.Close
    Set rsAdd = Nothing	
	End If

Open in new window

8 Comments

Question by

fskilnik

2017-07-17Solved

extracting from a string - Classic ASP

Hi there,

My form has the structure shown below:
---------------------------------------------------------------------------------------------------------------------------
<form id="form1" name="form1" method="POST" action="../../Codes_my/confirmScheduling.asp">
      <table class="table table-striped">
<tr>
<th>Day/Time</th>
<th>Mo </th>
<th>Tue </th>
<th>Wed </th>
<th>Thu </th>
<th>Fri </th>
<th>Sat </th>
</tr>
<tr>
<th>7h30min - 8h20min</th>
<td><% If ... Then %>
<input name="hiddHorarioID" type="hidden" id="hiddHorario47" value="475_<%= ThisDay(4)%>" size="5" />
              <button class="btn btn-primary btn-sm" type="submit">five credits</button>
<% Else %>
              <% If ... Then %>
              <button class="btn btn-info btn-xs disabled" type="submit">reserved</button>
              <% Else %>
              <button class="btn btn-primary btn-xs disabled" type="submit">reserved</button>
              <% End If %>
              <% End If %>
              </td>
<td><% If ... Then %>
<input name="hiddHorarioID" type="hidden" id="hiddHorario57" value="575_<%= ThisDay(5)%>" size="5" />
              <button class="btn btn-primary …

3 Comments

Question by

amucinobluedot

2017-07-14Solved

replace syntax

I want to remove the '-' character and any spaces ' ' from a string. I am trying to do a double replace but my syntax seems icnorrect.
This seems to work for replacing the '-' but I am not sure what the syntax will be to also remove the spaces

(Replace(a.fieldname,'-','') AS fieldnameclear)

Open in new window

3 Comments

First
Prev
1
2
3
4
5
6
7
Next
Last

ASP

80K

Solutions

Content

31K

Contributors

COURSE of the MONTH

ASP

Related Topics

ASP

Related Topics