strTOFile = "ServerQuotes" & strDir & "Engineering" & strFile & ".xls"
strQLFile = "ServerQuotes" & strDir & "Engineering" & strFile & ".doc"
if (fsoObject.FileExists(strTOFile))=true Then %>
<open sheet
<% end If%>
this code checks if the file is present in the server quotes or not ,it works with in the server but not in the client(it cannot fine the sever. but if i remove the if statement then if the file is present it connects from the client.
I am trying to execute some script on my server that is currently run on an ASP page.
However, I am finding that it can often take up to 5-10 minutes to run and the user is not needed for this execution anyway. What I am attempting to do is write the script into a .vbs file on the server and execute the script when necessary.
I would like this script to run without the user knowing and therefore I do not want the asp page to wait for a return from the script. I am trying to use:
Set WshShell = Server.CreateObject("WScript.Shell")
ReturnVariable = WshShell.Run("c:connorVBScript1.vbs", 0, FALSE)
The FALSE tells the system to run the code and not wait for a return. The webpage seems to run and returns to the user as it should but the script is not executed.
Anyone have any ideas?
I want to pull data from a number of tables, Categories, SubCategroies
and then place into JavaScript drop downs and have the options in the
second drop down change upon the selection from the 1st drop down. Is
this possible.? How is it done..? Arrays..?
I have data from page 1 that I want to pass to page 2, either in a querystring or a form. I got that part.
Once I'm on page 2, I can retrieve that data with Response.Form or Reponse.Querystring in the vbscript code I have up in the header, but if I write
Document.Form1.Textbox1.value=response.form("passedData"), nothing happens.
So I thought that the code up in the header doesn't "see" the textbox, because as I dimly understand it, the textbox is client-side and the script is server-side. So then I thought I should put the same line down in the html where the form is defined (enclosed in <% tags). But that triggers an error because the code down there doesn't seem to know what response.form is anymore! I tried using a variable as a go-between, but it didn't change the results.
So how in the world do I get my incoming parameter (whether form or query string) to go and live in a textbox in the target page? I need it there (don't I?) so that I can later pass it along to page three (among other reasons).
In short, I can get strings passed from page 1 to page 2, but then page 2 doesn't seem able to put them into controls or pass them along to page 3.
I have scoured google and forums and seen some responses that involve about 30 lines of code (which I don't understand). Surely it can't be that complicated to pass a string from page 1 to page 2 and then have it available to pass along to page 3.
How can I hide VB Script code in the ASP Page? Even though the display.asp includes the script_functions.asp, when I click on View Source from IE, I can still the VB Script code? What can I do to hide the code from the people who use display.asp?
View Replies View RelatedIs there a way to check if a file exist using VBScript in an ASP page.
So the code might go something like this:
If Exists("C:Junk1.txt") then
Do something
Else
Do something else
End If
I have an input box when the user clicks on the button.
var number=prompt("enter journal number");
How is it possible to pass this variable forward but to vbscript? So i could use that variable in an sql procedure?
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables.
I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
I have a Function in VB Script that generates a signature. I assign the result to a variable and then need to do a hidden post to an ASP Page for further processing.
Basic functionality is I have a button upon pressing it -- It does the hidden post.
Code looks like this. Please assist with passing this stringToSign variable to the .asp page via hidden post. Code:
the isp i'm
using has authorized ssl on my site but i dont know how to tell a
particular page that it can only be run as a secure page... Where at the
moment u can view the page as https or http.
I'm assuming i need some code to detect whether its being run as a https
and if not redirect it to https.
I have an ASP page, on the Window_OnLoad event I use VbScript to popup an Inputbox to accept a value from the user and put it into a string called strValue. I then want to be able to go (in asp)
<%Response.Write(strValue)%[color=blue]
> - but if I do that nothing happens.[/color]
How can I access the Vbscript variable in the ASP part of the page?
I tried using some code examples from (URL address blocked: See forum rules) into my defualt.aspx page (in VS2005). I had some errors with this. I thought this might be cause the tutorial at w3schools.com said it was for *.asp files.
For example I had an error ("Statement cannot appear within a method body. End of method assumed) when I tried putting a SUB in the <head>. Like this
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "(URL address blocked: See forum rules)">
<html xmlns="(URL address blocked: See forum rules)" >
<head runat="server">
<%
sub vbproc(num1,num2)
response.write(num1*num2)
end sub
%>
<title>Untitled Page</title>
</head>
By the way if anybody will be available to answer basic questions like this every so often throughout the day (ie: check your email or this forum every couple of hours, until midnight California time December 8), I'd be willing to pay a reasonable amount. I just need help with some of the technical details like this + finding source code
I manipulate MSAgent AcitiveX object using VBScript at client side, I
met a wierd problem when I debugged my ASPX page. when msagent recognize
a phrase and fire event, my vbscript capture the event and do something,
including make the agent do some animation and speech, then open a
browser window using 'window.open "www.google.com", "Google" '. the code
works fine when I view the ASPX page with browser inside VS.NET, when
browse this page in web browser from the localhost, the agent works
fine, but the new window did open up. why?
I have COM+ component installed on my XP. I have problem to create
instance of it inside vbscript. How can I do it? The error I get is :
ActiveX component can't create object.
I use vbscript in an asp file.
How can i take the last string in a variable.
For example:
abc="hello123"
newabc=???(abc)
and i only want the last string, that is "3".
means, if I do...
Response.Write newabc
The output will be : 3
I'm trying to create a simple recordset, and would like to include an and/or option. to do this i set up an option on the previous page,and then sent the selection through to the next page. i was then hoping to simply insert the variable i had created into the code so that whichever of and/or is selected is used in the code. i.e.
where and_or is the variable from the previous page.
Search.Source = "SELECT * FROM dbo.Employee_List where First_Name='"&firstname&"' '"and_or"' Last_Name='" &lastname&"'"
so basically whenever someoned chooses an option its automatically filled in at the indicated location in the code. is it possible to do this and if so what is the correct syntax for using variables within this code?the full search function will have numerous fields so i'd like to avoid using if statements.
I'am running window server 2000 and MS frontpage on my
computer. I created ASP page with the frontpage editor.
The asp code are not running when I am trying to view the
page with my browser (Explorer 5.0). Could you please help
me
Trying to figure out how to do this (querying an access db using vbscript):
select * from comments where " & search & " = " & criteria & "
where " & criteria & " can be both a text and integer value.The above would work for " & search & " = 66 but not " & search & " = smith ?
I have an ASP.NET solution,and the ASPX page I have a form ,I want to copy some of the data from that form to the clipboard,I am using the below script the script works fine when I use a normal anchor tag with the onclick event,but I want to be able to use an actual asp control like the hylperlink or linkbutton.
I have tried the link button but it gives an error saying Compiler Error Message: BC30456: 'VBScript' is not a member of 'ASP.sr_aspx'.
And the hyperlink control doesn't seem to have an option for the onclick. The code is located in the .aspx not in the .vb.
I have absolutely NO knowledge about ASP. Though I've been working with PHP for almost 2 years and decided that I need to take the next step and learn some more languages both to keep me busy and to expand my skills.
Like I said...I have no knowledge or experience with this. From what I read, there are two ways of coding ASP. First using VBScript and then C#. I'm really confused, because for one, I don't know what the difference is, and secondly I'm ot sure which is the best.
I'll be primarily (if not only) be using ASP to build online applications, websites, etc.
a dictionary of terms with definitions, (in a database) how can i hyperlink(automatically) words within the definitions for which a definition also exists.
url structure is like this
www.site.com/glossary?word=someword
Then - in the definition of "someword" there is a word that also has a definition in the database. I'd like to auto hyperlink it to that definition. Also since the data is all coming from a database, what if one of the words to be replaced has not yet come up in the loop? (...or would it be okay since EVERYTHING should be in the recordset?
usually do perl and php. However, I would like to backup my databases with a microsoft sql server and sometimes a simple access database. In other words I would have a perl or php script that would insert data into a mysql database and at the same time post to a vbscript that will deal with the microsoft sql server or access database. I choose not to use perl or php to do the latter because I would like to keep every aspect according to its environment.
Almost every vbscript I've looked at is embedded in the html page. Since I intend to send via a post from a different type script - my question is can you place vbscript on the server as a stand alone? If this is possible - Where can I find references to this?
I have a problem trying to run a vbscript on my desktop. The script runs fine on other desktops. Has it got to do with any security settings in my xp? and how do i enable it?
View Replies View Relatedi have a powerpoint file "somefile.PPT" . now MS-Powerpoint when open allows the file to be saved in JPG format .. this option is present in the SAVE AS.. option .. by this what happens is that the file is stored as an JPG image ...
is it possible to convert a given valid PPT file to JPG file without opening powerpoint and using VBSCRIPT code ...
i'm creating an asp page using vbscript. i create and execute a string as an SQL statement. problem:
strSQL = ..... " ' " & Date() & " ' " .......... <-- this works
strSQL = ..... " ' " & Time() & " ' " .......... <-- this does not
i get a string conversion error. i'm storing the time as the data type TIME in my SQL table.
Want to increase the sytem time: Code:
Dim currentTime
currentTime = Time()
Suppose, current time is : 12:55:50 AM
If i want to add 20 minutes with current time, then it will be 01:15:50 PM . I want the VbScript code or any useful tutorial link.
I have been asked to convert a system-by-system project creator program to a server-based web-interface site. It is currently written in VB 6 and I am going to need to have it in class vbscript.
Is there an easy way to do this? Or do I need to manual go through all the code? I've never programmed in VB but have done some vbscript. But I still don't know whats in VB that translates well into vbscript. Obviously, one is a programming language and the other is a stripped down version.
I had someone tell me that normal VBS is different from that found in ASP, however I cannot find any websites to back up that fact. Can any one tell me if normal VBScript progamming is different from that when used in ASP.
View Replies View Relatedi have a powerpoint file "somefile.PPT" now MS-Powerpoint when open allows the file to be saved in JPG format. this option is
present in the SAVE AS. option. by this what happens is that the file is stored as an
JPG image. is it possible to convert a given valid PPT file to JPG file without opening powerpoint and using VBSCRIPT code.
I need to be able to have various lists with values assigned. and an onchange event to occur for me to make some calculations then display the total value. I need to have some lists
EXAMPLE
<select name="order1" onchange=" ">
<option value="0.69">Eggs</option>
<option value="0.99">Sausages</option>
<option value="1.39">Bacon</option>
</select>
<select name="order2" onchange=" ">
<option value="2.00">ham</option>
<option value="1.00">chicken</option>
<option value="2.20">pork</option>
</select>
I would like items selected added up and displayed as a total value when changing the list.
is it possible to convert a server-side vbscript variable to a server-side javascript variable?
View Replies View RelatedI made a regular expression to match Guitar Chords.
[A-G](#|b)?([a-z]|[0-9])*
This pattern should find any of the following:
1) G
2) Gmaj
3) G7
4) G#
5) Gb
6) G#min
The pattern works for all of these except for #4. For some reason it will only return the 'G' instead of the full 'G#'. I find this very odd because if the chord is 'Gb', the regex will return the full 'Gb'.This pattern works fine in javascript. Is there anything special with the '#' character in RegEx for VBScript? I am using VBscript engine 5.6
I am new to ASPs and I have run into the following error message:
Microsoft VBScript runtime error '800a01a8'
Object required: '[number: 0]'
/development/index.asp, line 17
I know EXACTLY which line is causing it. The following line is the code the is causing the problem.
set fileSystem = Server.CreateObject("Scripting.FileSystemObject")
Is there some setting that must be properly set in order to create a filesystem object? Is there a specific version that must be used?