ASP Help & Support | Experts Exchange

Hello, all.

OK, working with SQL Server 2019, and it works wonderfully with accented characters.

Dvořák Hall

It displays to the page just fine.
However, when I try to read from a URL QueryString, it's not working.
I get

Dvo

Instead of the full name.

I have at the top of my main page.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
Response.ContentType = "text/html"
Response.CodePage = 65001
Response.CharSet = "UTF-8"
%>

Open in new window

But it still will not get the URL: /Page/Dvořák_Hall
And display it correctly to the page, to use against the database query.

Any suggestions?
Wayne

7 Comments

how do I load an old asp program to VS and run it with debug?

ASP
ASP.NET

4 Comments

LVL 31

Question by

Wayne Barron

2020-02-16Solved

apostrophe in a URL name.(Trying not to encode it)

Hello, All.

I am trying my best to NOT have to encode the apostrophe in a URL name to this: Nothin%27_to_Lose.
I have tried to replace the apostrophe with a * or a Period, and when I do a Request.QueryString("Title") on this
Nothin*_to_Lose
It is replaced with
Nothin

What am I missing here?
Does the Request.QueryString() not work with these types of characters?

Wayne

3 Comments

Hello,
I have an asp net page with separate VB code behind page.
The aspx page is about 2000 px long. There are is a top, middle, and lower sections.
I need to be able to jump to each section based on various events in my code behind.
I was thinking of putting a heading label for each section. I would like a command that I could insert as needed in my code behind to jump to specific labels. It will need to work across desktop and mobile platforms.
Thanks,
WillieCg

9 Comments

I'm moving an application from a dedicated Windows Server / IIS to Azure with SQL Database and App Service. The existing application runs on MS Access "server" with Classic ASP pages and it is pretty speedy.

The following query on existing server for example returns all records in about 3 seconds. There are 36,720 records in the "loads" table.

Now that I've moved the DB to Azure SQL the records are returned in about 35 seconds to the Azure App. My current Azure config is Serverless Gen5, 2-8 vCores, 6GB-24GB memory. After increasing the compute power I noticed the results returned faster, so I suspected poor query design.

Question: Can the following query be optimized further? I expected much better performance on SQL Server vs. MS Access "Server"

SELECT dbo.loads.ID, dbo.loads.CustomerID, dbo.loads.CustomerContactID, dbo.loads.RequestDate, dbo.loads.Equipment, dbo.loads.Commodity, dbo.loads.Stops, dbo.loads.Miles, dbo.loads.CommentsPublic, dbo.loads.GrossQuoted,
dbo.loads.Weight, dbo.loads.Length, dbo.loads.Width, dbo.loads.Height, dbo.loads.CargoValue, dbo.loads.CommentsPrivate, dbo.loads.UserID, dbo.loads.Created, dbo.loads.forfeitload, dbo.loads.voidload, dbo.loads.shipperid,
dbo.loads.shippercontactid, dbo.loads.shippercomments, dbo.loads.consigneeid, dbo.loads.consigneecontactid, dbo.loads.consigneecomments, dbo.loads.usforwarderid, dbo.loads.usforwardercontactid,
…

7 Comments

Hello All;

In the following statement, I need to know how to place the ? for the parameterized Query.
The part we are looking at is
(CHARINDEX('/?/', '/' + Tracks.LID) > 0)
When run in SSMS, this is the way it will look
(CHARINDEX('/1/', '/' + Tracks.LID) > 0)
(Replacing the ? with a number)

sqlctLabel.commandtext="SELECT COUNT(DISTINCT Tracks.AlbumID) AS Albums FROM Tracks INNER JOIN Albums ON Tracks.AlbumID = Albums.AlbumID INNER JOIN Artists ON Albums.ArtistID = Artists.ArtistID WHERE (CHARINDEX('/?/', '/' + Tracks.LID) > 0) GROUP BY Artists.ArtistName, Artists.ArtistID"
sqlctLabel.Parameters.Append sqlctLabel.CreateParameter("@LID", adInteger, adParamInput, , strLabelID)

Open in new window

4 Comments

I am new to AWS. I have done a great deal of background reading/research which always helps when you are trying to resolve a problem.
That being said, I have a problem which I do not understand.
We have an ASP legacy system which will remain in ASP indefinitely.
We have stored pdfs with images – S3 in the AWS cloud.
The images and pdfs are “public”.
Part of the URL is dynamically constructed each time based on the “user” that logins (tagged onto the AWS info) We have a newer system – codeigniter/php – which will display the pdfs and image just fine with the dynamically created URL.
But will not do so in our ASP legacy system.
I understand that by the simple use of a URL, I should be able to access the pdf etc., and particularly since the pdfs and images are “public”.
I develop using localhost, (PHP-Wampserver) but can also develop ASP.
SO my question is two fold.
Do we need to install a something on our ASP server to enable us to view the images as well??
And what SDK must I install on my localhost (I am thinking the JavaScript and PHP)
I thought maybe it might be a security/permission issue with the ASP server accessing the cloud but that doesn’t make sense because on the ASP side, it will display the pdf but not the image.
This is becoming urgent and any help/advice/pointers would really be appreciated. Thank you.

7 Comments

Ok I know this sounds bizarre but I have a web page that I access on my phone. It has a "submit" button that I need to be very sensitive to the touch, so that the instant I press it, it responds. Sometimes I have to do it multiple times to get it to submit. I assume an app would be better but for now my only option is a web page. Is there any way that I can make this a more "responsive to pressing" submit button than it is now? It is big enough that it is hard to miss.

Thank you!

4 Comments

I am a little inexperienced with console error messages. How can I resolve "You have 3 errors on your page uncaught SyntaxError: Unexpected token '<'" on this page: https://www.gopherstateevents.com/results/cc_rslts/relay_rslts.asp?meet_id=637&race_id=3175

Thank you!

2 Comments

Our ASP VBscript programs that send out an email (like from a contact form) have worked perfectly for years. Suddenly, the .Send function is generating an error 80040211.

Again, nothing to our knowledge has changed.

Is there a way to see what the specific error may be?

28 Comments

Can someone please help me to understand why I am getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Lab@xyz.org'.

/trainingSessions/SQLRuns2.asp, line 58

strSQL3 = "UPDATE _Employees SET Pager = e.LName + ""Lab@xyz.org"" FROM _Employees e INNER JOIN _Department d ON e.reportsto = d.DeptHead WHERE e.isactive = 1 AND e.isScientific= 1 AND e.reportsto = " & Session("strPIID")
set rsEMP = oConn.Execute(strSQL3)

This is the result in SQL Server Profiler:

UPDATE _Employees SET Pager = e.LName + "Lab@xyz.org" FROM _Employees e INNER JOIN _Department d ON e.reportsto = d.DeptHead WHERE e.isactive = 1 AND e.isScientific= 1 AND e.reportsto = 7165

5 Comments

I use data tables to display results of races that we time on a classic asp website (https://www.gopherstateevents.com/results/fitness_events/results.asp?event_type=5&event_id=883&race_id=1516). This weekend the results of one of our bigger races showed a Data Table error until I figured out that one person's name was incorrectly entered, with a "/" inserted (ie: Johns/on). There were no issues in the way the results were calculated and displayed everywhere except in our data tables.

Here is my question: Are there other characters that will prevent JQuery data tables rendering? Also, should I build some error trapping in to prevent these characters (ie: Replace(FirstName, "/", ""). Seems like a lot of processing for something that is so unlikely to happen?

Thanks in advance.

ASP
jQuery

4 Comments

I am trying to send race results to race finishers in classic asp and my script keeps timing out. I have my Server.ScriptTimeOut set plenty high. (note that I just added the xmlhttp.SetTimeOuts) Not sure if I have the other timeout set correctly. Can someone look at the following code and let me know what changes might help please? Thans!

Set cdoConfig = CreateObject("CDO.Configuration")
With cdoConfig.Fields
    .Item(cdoSendUsingMethod) = cdoSendUsingPort
    .Item(cdoSMTPServer) = "smtp.mandrillapp.com"
    .Item(cdoSMTPAuthenticate) = 1
    .Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587
    .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic
    .Item(cdoSendUsername) = "username"
    .Item(cdoSendPassword) = "pwd"
    .Update
End With

    bSentBCC = False

	For j = 0 To UBound(SendTo) - 1
		'get email address
		sMyEmail = vbNullString
				
		If DontSend(SendTo(j)) = False Then sMyEmail = SendTo(j)

		If Not sMyEmail = vbNullString Then
			If ValidEmail(sMyEmail) = True Then
                            
                sPageToSend = "http://www.gopherstateevents.com/misc/pix-vids_notif.asp?event_id=" & lEventID 

                Set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
	                xmlhttp.open "GET", sPageToSend, false
                    xmlHttp.SetTimeouts 0, 60000, 300000, 300000
	                xmlhttp.send ""
	                EmailContents = xmlhttp.responseText

Open in new window

…

3 Comments

Hi there, I was trying to work out the length of a Request.QueryString

I have been looking around, however I can only find this, which doesnt give me the result I like:

Len(CStr(String))

Open in new window

This gives a value of 6 or what ever the length the text is...

What I would like is...

http://domain.com/?i=AUGPA <- the bold part, how can I determine the length of this?

3 Comments

Hi there, I have just migrated across to a 2016 Server and having some issues running a site, have no idea why this is happening, as I can see the settings are the same in IIS

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("core/allcore.mdb")

Open in new window

Any help would be amazing!

3 Comments

I need to tap into the Session_OnEnd event in the session object. and call a stored procedure in MS SQL

My site is built in ASP Classic I want to perform a database clean up when the users session ends or they log out

the logout is handled, but i need a way to cover the user just leaving the site without logging out..

Can anyone help me with this please..

15 Comments

I have developed a web application that i want to make available for people to try out and have a look at.

in my mind i see it loading the database into a session, so the user can log in, try things out test what they want to do make changes to the data that doesnt get saved back to the original data base, and when they log out or the session expires the dummy database no longer exists,.

i am using ms sql 2017, asp classic on a windows server

is what i want to do possible, and how would i start

thank you

24 Comments

this was working, i change the call to the database to use the Parameters element of ADO as just passing the values failed when passing HTML to database..

i have obviously done something wrong but been looking at this now for 4 days and not got any closer to a solution..

your help would be a god send
Thank you

DIM cmd, DbStr
DbStr = "User ID=xxxx;Password=xxxx;Initial Catalog=CMMS;Data Source=MYCMMS;Provider=SQLOLEDB"

Set cmd = Server.CreateObject("ADODB.Command")
set cmd.ActiveConnection=DbStr
cmd.ActiveConnection.open


'Prepare the stored procedure
        cmd.CommandText = "ConfUpdate"
        cmd.CommandType = adCmdStoredProc
	cmd.Parameters("@Company") = MyCompany
	cmd.Parameters("@address1") = Myaddress1
	cmd.Parameters("@address2") = Myaddress2
	cmd.Parameters("@city") = Mycity
	cmd.Parameters("@county") = Mycounty
	cmd.Parameters("@postcode") = Mypostcode
	cmd.Parameters("@phone") = Myphone
	cmd.Parameters("@WorkorderEmailTPL") = MyWorkorderEmailTPL
	cmd.Parameters("@VendorEmailtpl") = MyVendorEmailtpl
	cmd.Parameters("@InstanceID") = MyInstanceID
	cmd.Parameters("@VersionNo") = MyVersionNo
	cmd.Parameters("@updatedBy") = MyupdatedBy
	cmd.Parameters("@IssueDate") = MyIssueDate
	cmd.Parameters("@IssuedBy") = MyIssuedBy
	cmd.Parameters("@LiveDate") = MyLiveDate
	cmd.Parameters("@emailfooter") = Myemailfooter
	cmd.Parameters("@emailDisclaimer") = MyemailDisclaimer
	cmd.Parameters("@action") = Myaction
	cmd.Parameters("@confID") = MyconfID

Open in new window

…

9 Comments

I run the code below thru PhoneGap, http://192.168.1.7:3000 but I've found out that the Asp on server computer ignored the request. Here, I would like to know if the PhoneGap has a capacity to allow the server accept the request from the clients via phonegap apps? The code below is working if i used iis. Any help please.. Thanks!

    <script>
    function GetSerialDrive()
    {
    	if (window.XMLHttpRequest)
    	  {// code for IE7+, Firefox, Chrome, Opera, Safari
    	  xmlhttp = new XMLHttpRequest();
    	  }
    	else
    	  {// code for IE6, IE5
    	  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
    	  }
    	xmlhttp.onreadystatechange=function()
    	  {
    	  if (this.readyState==4 && this.status==200)
    	    {
                alert(this.responseText);
    	    }
    	  }                                             
    		xmlhttp.open("GET","MyDrive.asp?a=" + "x", true);
    		xmlhttp.send();	
    }
    </script>

Open in new window

Server side

<%
dim fs,d
set fs=Server.CreateObject("Scripting.FileSystemObject")
set d=fs.GetDrive("c:")
   response.write("The serialnumber is " & d.SerialNumber)
   response.end()
set d=nothing
set fs=nothing
%>

Open in new window

ASP
phonegap

4 Comments

Thanks to help from this site I am ready to add "Remember Me" functionality to http://www.gtraxc.com/login.asp. I believe I know how to set and retrieve cookies. I also know not to use cookies to populate user name and password fields. I just need some assistance putting this together on a classic asp page. Here are my assumptions and questions. Please correct as necessary, and thank you in advance!

1) I assume that I collect the cookies if "Remember Me" is selected from the form submission using the following process:

            If Request.Form.Item("remember-me") = "on" Then
                Response.Cookies("user_name") = sUserName
                Response.Cookies("password") = sPassword
                Response.Cookies("password").Expires=#March 1, 2020#
            End If

Open in new window

2) I assume I could have the expiry be Date + 180 since it seems like its a good practice to keep them for 6 months?

3) I know that when I check for cookies, if I find that they exist and have not expired I use that to log the user in and redirect them to the necessary page. I assume that I do that at the very beginning of the asp code using code something like:

        sUserName = Request.Cookies("user_name")
       sPassword = Request.Cookies("password")
      'check for existence in the db and if found redirect to the appropriate page

Open in new window

9 Comments

What is the best way to convert milliseconds from 1/1/1970 to current date/time in classic asp?

Here is what I want to convert: 1572891578547 (I really only need hours:minutes:seconds)

Thank you!!!!

11 Comments

I am trying to get the exact time a classic asp form submit is clicked. I want to get the time on the client side so that, if there is a delay getting to the server, the time is already stored. Below is what someone on this forum gave me. I closed the post before I implemented it. Can someone tell me why it is not submitting the "time" value please? Thanks so much!

                <hr>
                <form role="form" class="form-inline" name="set_start" method="post" 
                action="set_time.asp?software=<%=sSoftware%>&amp;event_id=<%=lEventID%>&race_id=<%=lRaceID%>">
                <input type="hidden" id="time" name="time">
                <input type="hidden" name="submit_start" id="submit_start" value="submit_start">
                <input type="submit" class="form-control bg-success" name="get_start" id="get_start" value="Set Time Now!"
                style="height:150px;font-weight:bold;font-size:1.5em;">
                </form>
            <%End If%>
        <%End If%>
    <%End If%>
</div>
<script>
    document.getElementsByTagName("form")[0].onsubmit = function() {
          document.getElementById("time").value = new Date().getTime(); // number of millisecond from 01/01/1970
    }
</script>
</body>

Open in new window

Here is the server side code:

    dDateTime = Request.Form.Item("time")

Open in new window

It returns nothing. Can someone tell me what I can do to resolve this please?

7 Comments

Hello Experts.....

I have a file called myinventory.csv in the downloads directory of my website.
I would like to display a hyperlink on a webpage that says download inventory.
When the link is clicked, I would like the user to be able to select a folder on his local machine,
and download the file.

Can anyone give me code to display "Download Inventory" as a hyperlink and to perform this function? The relative path of the file would be \downloads\myinventory.csv

This is what I have so far:

<a href='\downloads\myinventory.csv'>Download Inventory</a>

4 Comments

Hi,

I am new to web development and c# and java script in particular. I have a problem I have been stuck on for a few days. I have a ASP Core project. I have a button on a page that calls some javascript code to pass in a serial number and I want it to return some data from my controller. There are several fields in my model data, but to keep it simple i will just try and show 2. The problem is it is showing the serial number but any other field it shows the value as undefined when i load the page and press the button.

The java script I have is:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
<script>

    $(document).ready(function () {
        $("#abc").click(function (e) {
            if ($("#SerialNumber").val() == "")
                alert("SerialNumber cannot be empty");
            else if ($("#Comments").val() == "")
                alert("Comments cannot be empty");
            else {
                $.ajax({
                    type: "POST",
                    url: "/Home/GetSecuredData",
                    data: {"serialNumber": + $("#SerialNumber").val() },
                    success: function (result, status, xhr)
                    {
                        var html1 = ""
                         $.each(result, function (items, OperationsData)
                        {
                
                                html1 += `

Open in new window

…

6 Comments

Hi guys
I use classic ASP
Is there a way to find out if user's JavaScript is enabled or disabled and store the answer in a Boolean variable (True or false)
Thanks
Dory

20 Comments

ASP

Related Topics

ASP

Related Topics