I am using a recordset to retrieve values from a sql server database that I would want to display on an classic ASP page. It however seems that I cannot get a string value from the recordset. It just shows a blank space on the page that I want that value to appear. I have marked as bold the value that is supposed to have a string value in the code below. Please help me out and let me know what I could be missing. I am working with VBScript.
...
20 results in 0.0048 seconds.
-
Problems in getting a string value from a recordset
-
Converting vba(excel macro) to vbscript
Hi All,
Copying code from vba to vbscript did not quite work. I was hoping if anyone could give me a hand. The purpose of the code is to sort the selection so that the smallest value is on the top. I was wondering if there is a way to make this work. Thanks!
This is the original vba code.
...Code:Range("F1").Select Application.CutCopyMode = False ActiveWorkbook.Worksheets("Sheet3").Sort.SortFields.Clear -
Syntax error 800a03ea in vbscript for sub function
I'm running Logon Script and it is in VBScript.
when I'm calling Sub function it givving me this error
...Code:If InStr(strGroups, ADFS1_GROUP) Then MapDrive "G:", "\\xxx-xxx-ADFS-1\GROUP" Else MapDrive "H:", "\\xxx-xx-ADFS\HOME" End If Sub MapDrive(strDrive, strShare) On Error Resume Next -
How to format a date from a form for SQL server
I have retrieved a date from a form and the
Request.form("D OB") gives me the format of: 12/04/1976.
When I try to use SQL to add the record to the database, I get the error below.
Microsoft OLE DB Provider for SQL Server error '80004005'
Arithmetic overflow error converting expression to data type datetime.
The code generating the error is below:
oRs.Open "MailList",... -
Problem returning values from a function written in vbscript
When I use this code, it works fine:
<% Function RandomNumber(in tHighestNumber)
Randomize
RandomNumber = Int(Rnd * intHighestNumbe r) + 1
End Function
SEEDNMBR=(Rando mNumber(16))
Response.Write SEEDNMBR %>
However, with the code below I get this error code:Microsoft VBScript compilation error '800a03ea'
Syntax error
/seed_modify_bat ch.asp, line 20
Function RandomNumber(in tHighestNumber)... -
Why does script side code seems to be executing at client in IE9?
Using IE9 on Windows Server 2008R2, I'm stepping through code with the built-in debugger. The debugger always flags the Server.Execute call as an error saying that 'Server' is not an object. The server side is Windows 2003 R2 Standard Edition with SP2. It is running IIS v6.0.
I'm using RUNAT=Server, so why would this not work? Why is the debugger even seeing this at the client side?
...Code:***Goresdb.asp -- gets
-
Ho to make listbox expandable using javascript?
Hi,
Code Explanation:
I have one text box for name,and one dropdown when I enter 'bo' then dropdown filled from database.Values in listbox are 1)bob 2)bobby 3)Bony etc exists in db. Now my requirement is given below.
I want the name listbox field expand automatically to show all my matches to what has been entered in the name textbox field. e.g. If I am entering just ‘bo’ in the name field actually...Last edited by Dormilich; Oct 12 '11, 05:37 AM. Reason: please use [CODE] [/CODE] tags when posting code -
Remove admin rights from local users
THIS IS A VBSCRIPT (.VBS)
Below is code that i created. The connection to the dB works perfect. I have tested it with insert statements and it has been established.
...Code:Set Conn = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") Set rs = CreateObject("ADODB.Recordset") Conn.Open "Provider=sqloledb;" -
VBScript - Digital Signature ?
Hi,
I have an HTML input <form> with several input fields.
When the user enters appropriate data in the input fields, and clicks "Submit", the input field data must be digitally signed with one of his digital certificates, installed in his Internet Explorer.
The signing must be done from VBScript (if possible), by calling standard functions from the standard MS Windows installation (no additional ActiveX,... -
VBScript for IE navigation
Good Day All,
I'm attempting to write a VB script to download the latest version of the Adobe Flash Player from the www.adobe.com website with no user interaction. Is there any way this can be done? If so, can someone please provide me some tips or directions? Thanks in advance.
M -
Saving excel with VB
Hi,
I have a java code that populates data on my XLSM file, the problem is, the java code can't handle the execution of Macro, so what I'm just doing is to populate the excel file with java and then open the excel and save it manually and then the macro will be invoked.
I wanted to do it automatically, so I created a VB script that will open the file and will save it as well but the problem is, even though it saves and... -
Why is interstitial page not loading when VB function is called?
I'm currently running a set of pages structured something like this:
1. QUERY FORM: user enters data and clicks 'Go'
2. DATA from FORM is stored in DB, then redirects to INTERSTITIAL page
3. INTERSTITIAL PAGE is loaded and calls VB function
VB function spits out data at intervals onto INTERSTITIAL page (progress bar)
4. When VB function is finished, it redirects to RESULTS page
5. RESULTS page appears... -
Random Wallpaper Script
I created this VBScript to randomize my wallpaper. It also uses subfolders for sequential images. It chooses from one of the files or folders in the specified parent folder at random. If it chooses a file, it waits 10 minutes to change it. If it chooses a folder, it will step through the pictures in order every 5 seconds.
To use it, copy and save the code to a .vbs file and put it in your startup folder if you want it to start automatically.... -
How can I translate the following lines from ASP VBScript to JavaScript?
I have a small page with ASP. In one part of the program, when the user clicks on a button, I use the following code to call a VBScript Subroutine with the name of SubmitForm:
Code:<input type="button" language="vbscript" onclick="Submitform(<%=I%>)">
The code that creates the Subroutine SubmitForm is found at the HEAD section of the page. Here's the code that generates... -
vbscript and xcacls
Hello
I am trying to adjust the folder permissions using vbscript and xcacls.
The folder path that is getting its permissions modified is stored in a variable called strName.
My script works correct like this:
However when trying to use my variable instead of the full path it does not work.Code:xcacls.vbs "c:\home\Test, User" /g Domain\user:F
...Code:"xcacls.vbs
