ASP/VBScript ADO Recordset Requery

I am using DWMX on IIS 5.1 (WinXP Pro) with ASP/VBScript on an Access 2000 Database.

I'm not much on ADO yet so I let DWMX write my Database Recordsets. I noticed one of the lines of code as:

objRecordset.CursorType = 0

Later in my code, I cycle through this recordset to it's end. And then later on in the code some more I need to REcycle through it again, but I get an EOF/BOF error.

I tried:

objRecordset.MoveFirst

and

objRecordset.Requery

but am still gettin same errors.

I think I heard that CursorType 0 is forward only. So I change it to 1, 2 and 3 and still have problems. Can someone shed light on what I need to do in order to re-go through my recordset?

View Replies

ADVERTISEMENT

Requery Recordset

I have a RecordSet executed , can i execute another query in this recordset (not in the DB table) .

View Replies View Related

Vbscript Recordset

I have a form with a couple of dropdown fields. the dropdown fields get the value from one table which is a reference table. The table consists of 3 columns - type, id, name. An example would look like this:

type id name
fruits AP apple
fruits GRA grapes
chocolate SNI snickers
chocolate MM m&m's

Currently, I have multiple sql statements to query the db for each dropdown (Select * from tablename where type='fruits') using vbscript (ms sql server database). My first question is, can i just use one sql statement to grab everthing in the table and group them together,how?

View Replies View Related

Vbscript Classes & A Recordset (ASP)

I've written two classes in ASP (vbscript). Basically I am attempting a form of data encapsulation. The classes are a "master" class and an "address" class. The address class basically wraps a recordset. I've attached the file. whenever I call the "move" method the recordset should be EOF since there is only 1 record in my streetaddress table. If I write out the value of of p_oRs.eof inside of the "move" method it returns true.

I have declared p_oRs as a public variable. But if I access it from a different method (or a property get/let) then the p_oRs recordset is no longer EOF the pointer is on the first and only record.

View Replies View Related

Recordset Error :: Microsoft VBScript Compilation Error '800a03ea'

I'm trying to send an email with a list of people in the body of the email but when i ty to send the mail i get the error

Microsoft VBScript compilation error '800a03ea'

Syntax error

/admin/tr1.asp, line 124 do while not rsp.eofwmail is the body of the email.I'm completely stumped here. Code:

View Replies View Related

Error Type: ADODB.Recordset (0x800A0BADODB.Recordset (0x800A0BCD)

Last week, my shopping cart was still working well until I began getting the following errors 2days ago..

Error Type:

ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157

Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
GET /main/saveorder.asp

Could you check my code below and let me know what possibly the error is?

View Replies View Related

Recordset Controlled By Another Recordset Within A Loop

I have created a forum, in which I have 3 tables:

1: Table_Forum
2: Threads
3: Replies

I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.

I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:

View Replies View Related

How To Use SSL With Asp/vbscript

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.

View Replies View Related

VBScript To ASP

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?

View Replies View Related

Using VBscript In Asp.net?

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

View Replies View Related

VBScript And VS.NET

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?

View Replies View Related

VBScript

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.

View Replies View Related

Vbscript

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

View Replies View Related

ASP VBscript

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.

View Replies View Related

VBSCRIPT

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

View Replies View Related

Using Vbscript

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 ?

View Replies View Related

VBScript From

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.

View Replies View Related

C# And VBScript

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.

View Replies View Related

Vbscript

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?

View Replies View Related

Vbscript

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?

View Replies View Related

Vbscript Cannot Run

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 Related

PPT To JPG Using VBSCRIPT

i 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 ...

View Replies View Related

Vbscript & Sql

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.

View Replies View Related

Asp, Vbscript

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.

View Replies View Related

VB To VBScript

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.

View Replies View Related

VBScript In ASP

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 Related

JPG Using VBSCRIPT

i 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.

View Replies View Related

ASP-VBSCRIPT

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.

View Replies View Related

Vbscript To Javascript

is it possible to convert a server-side vbscript variable to a server-side javascript variable?

View Replies View Related

VBScript RegEx

I 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

View Replies View Related

VBScript Runtime

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?

View Replies View Related

Vbscript RegExp

I am trying to write an asp(vbscript) parser for wiki-style pseudo code, and
can't get my head round regexp.

I am hoping if somebody could give me an example to work on for one, I could
sort the others.

e.g. how do you turn (from within a large string, with varying occurences)
.......[image:/mydir/pics/my portrait.jpg | A picture of me]......
into
......<img src="/mydir/pics/my%20portrait.jpg " alt="A picture of me">.....

View Replies View Related

VBScript Version

I think the ASP that I wish to run needs a later version of VBScript
than is installed.

How do you find the VBScript version (server of course)?

What needs to be done to update this on a win2000 box?

View Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved