ADO Record Object - Test For Last Iteration (VBScript)
I have a record object (for instance, named record). I record.MoveFirst, then I set up a simple little loop:
For Each ofield in record.Fields
...
Next
Within my loop, I want to test to see if it is the last iteration. That is, with a simple If...Then, I want to be able to complete something the last time through.
Is this possible, either with some sort of record.EOF type property, or some sort of record.Count type property (and then using a simple counter during iteration to count down until the last one)?
I'd like to try to be at least a little elegant... I understand its possible to iterate through the whole record twice, the first time to count, but that would obviously be a poor choice if any other method is available.
View Replies
ADVERTISEMENT
The current code (see below) works. But, I wonder if there's better way to test if a node object has something or not.
<%
...
' want to find if /Root/Node's id attribute is 1,
' if yes: get its child node <num>
Dim nodeA : Set nodeA = xmlDoc.selectSingleNode("/Root/Node[@id='1']/num")
' test if nodeA have something
If TypeName(nodeA) = "Nothing" Then
' -- NO: nodeA has nothing
Else
' -- TypeName is "IXMLDOMElement"
' -- YES: nodeA has something
End If
...
%>
I have tried other functions, such as IsEmpty(), IsNull(), IsObject(): none can
get the result I wanted.
View Replies
View Related
I have certain fields in my DB that are empty.
(In asp)
Code:
groupName=rsGroup("Namn")
if groupName="" then
groupName="(Missing name)"
End If
How do I test if the current field/record in the recordset is empty?
View Replies
View Related
I am building a shopping cart where orders are send by email. Even though it says it's sent, I receive nothing. So I did a test script to send an email using CDO since we are using an exchange server for email and it's on the same network as the site. Code:
View Replies
View Related
Can I loop through a recordset and with each record, see if the value of a field is higher than 5. If it higher than 5, just delete that record, not the whole record set and continue the loop.
I am accustomed to using a sql statement to selecting an entire recordset based on similar criteria and deleting the whole recordset in one swoop, but not this time. Code:
View Replies
View Related
in javascript attempting to get a string from somewhere sometimes will give you a string reading "undefined" or "object" now i know that this sort of thing happens in vbscript too, if i'm writing a universal "convert anything to a string" function what do i need to check for so that anything like "undefined" or "null" (or NULL) get's converted into ""?
View Replies
View Related
I am trying to use the following code to refer to a form and control on my
form. I am supposed to be using VBSCRIPT for this code.
I always get an "object required: 'document' " error:
<%
Dim Myform
Set Myform = document.forms.thisform
Myform.textbox1.value = "fish" %>
None of this code will work. Always get an error.
Using Visual Interdev, plain ole ASP, and vbscript, and Win XP Pro with IIS
5.1
What am I missing or doing wrong???
View Replies
View Related
can SO tell me why the following script :
dim oShell
set oShell=WScript.CreateObject("WScript.shell")
oShell.run ("C:WINNTsystem32cmd.exe /c C:WINNTsystem32
otepad.exe")
set oShell=nothing
works as expected in the context of a .vbs script and doesn't work (with the following changes made...) when inserted in a .asp web page under IIS ?
dim oShell
set oShell=Server.CreateObject("WScript.Shell")
'
intReturn = oShell.run ("C:WINNTsystem32cmd.exe /c C:WINNTsystem32
otepad.exe")
response.write(intReturn)
set oShell=nothing
the Shell object is well created (i can check some of its properties) but the oShell.run command doesn't seem to execute the given command line.
View Replies
View Related
I've discovered an insidious bug with the VBScript Regular Expression
object.I set the pattern to consist of the set of invalid filename
characters plus comma. I set global property to true then do a replace on a
SID. The Replace does nothing. However, if I attach the C++ (dev studio
2003) debugger to the IIS host process (dllhost.exe), every time I call
RegExp.Replace, the stack for one of the process's threads gets scrambled.
It ends up with the value 0x00000001 at the top of the stack! If your
debugger is set to stop on access violations, it always catches one (invalid
read trying to delete). The problem is insidious because, without the
debugger running, you would never know this is happening. ASP returns no
error. Potentially this could wreak havoc on your web application and cause
bizarre failures later on. Has anyone else run into this one? It seems to
happen only with the Replace method.
View Replies
View Related
I'm getting a
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/remove/addnow.asp, line 18
I can't seem to see what wrong here's my code.
Code:
View Replies
View Related
I have almost completed tweaking vbscript to run on mysql rather than the Access database it was designed for. Trial and error, luck and a bit of detective work have got me this far, however I am getting the following error when tryinf to update existing records in the database.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'RS.Find'
/faq/admin/edit2.asp, line 7
The piece of script looks like this in Dweaver
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "Questions", Conn, 2, 2
RS.Find "ID='" & Request("ID") & "'"
The .Find text is black whereas all other "methods"(?) like the .Open are pink. Is it that the .Find method works with access and not mysql and if so waht is the equivalent or am I barking up the wrong tree?
View Replies
View Related
My clients have 4.0 and I can't seem to get 6.0 off of my W2K machine. Any suggestions?
View Replies
View Related
I have:
Dim foo
Set foo = Nothing
If foo = Nothing Then
response.write "foo is nothing"
Else
response.write"foo is something"
End If
I get an error in the line "If foo = Nothing Then". It says:
"Object variable not set"
How then do I test if something has been previously set to Nothing?
View Replies
View Related
I have always used this in ASP to test if the client is accepting cookies:
<%@language="VBScript"%>
<%
Session ("nc") = 1
If Len(Session("nc")) = 0 Then
'Cookies Off
Else
'Cookies On
End If
%>
But I only ever tested it in Microsoft Internet Explorer 6 though not sure. Anyway with Microsoft Internet Explorer 5.5 SP2 Len(Session("nc")) <> 0 always whether cookies are on or off. Can anyone suggest a better cookie test that will work in most browsers?
View Replies
View Related
I have a PC running Win XP Home and want to learn how to write ASPs.
In order to test them I think I need a web server installed on my PC. Since
I don't believe IIS can be run under Win XP Home I downloaded and
installed the Apache web server. I'm stuck at this point and would appreciate
opinions on whether I am on the right track, and, if so, advice on the following.
1. Having written a test asp page how do I use Apache to test it?
2. Can Apache handle VBScript on an ASP page? From the info on the
Apache web site I don't think it can.
View Replies
View Related
iam making asp test engin and i dont want the user to use the keyboard
so is there a way to disable the keyboard of the computer that have the
exam on ? its not a website world wide. i will make it on my room computers.
is it possible ?
View Replies
View Related
What I have is a ASP test script that can grade online tests and give the test results at the bottom of the test page itself. What I need is the test results to be passed on to a test results page with the score of the test that was taken. I have a problem getting the test results intact over to the test results page.
View Replies
View Related
how do i test for SQL injection ?
sdo i do a SELECT statement in my username login?
View Replies
View Related
I have an asp script which is posted to by a form. On the script I need to know if cookies are enabled.
Therefore I need to make the form post to a different script which sets a cookie and does a response.redirect to the main script. However, how to I make the request object get forwarded to the second script with the response.redirect?
You cannot use server.transfer as the test for cookies will not work properly.
View Replies
View Related
In ASP VBScript,is there a way to programmatically test if a SQL Server database server is alive?
I want to use a connection string to a mirrored DB server in case the primary DB server fails. This failover is easy in ASP.NET, which supports DB mirroring and a the specification of a secondary server in its data provider.I want to hack together the same thing for my classic ASP apps.
View Replies
View Related
How to get test.doc from following string Using VBscript
"Files uploaded:test.doc (54326B)"
File size and file name may vary dynamically,and I have to pick file name with ext from them.
View Replies
View Related
anyone know some good ASP code to go through a page and test the hyperlinks to make sure that they are valid. Couldn't find anything good yet, but if someone knows of anthing.
View Replies
View Related
How to I test a varable to see if it contains a number and not a text value?I want to use this to detect if people have edited my get strings in the URL field of the browser, before it gets send to the next page.
I am sure it is simple just forgot, had a search on yahoo and could not find anything.
View Replies
View Related
Well i use Timer to test ASP scripts how much time is needed for rendering. But how much time, approximately a heavy asp project like CMS or FORUM should do?
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
I am creating an application for online test in ASP.While taking test i want functionality as on brainbench when we take any test there. Only difference i want is that there will be 5 questions in my test to be solved in 10 minutes.And all 5 will appear on one page.
I am done with other parts.but i am unable to find the logic for restricting time.And dont know what logic should i implement so that timer should not start again even when he goes back and returns to the page again.I have used javascript timer.
View Replies
View Related
I am using this code below to count the number of variables after the comma:
jumvar = 43352352,325324452,235234452,24523454
jumvarsplt = split(jumvar,",")
valnum = CInt(ubound(jumvarsplt))
But i would like to know how to test if the variable has a comma before running the above code.
View Replies
View Related
I'm trying to make a little 2 question test using ASP. What i've got so far.
*database connection code and other stuff*
Now the radio buttons (Q1.asp)
<input type="radio" name="jim" value="Answer1" >
<input type="radio" name="jim" value="Answer2" >
But i want the answer value to be a value from a database. Is that possible? value="request.querystring("Answer2") Where Answer2 is the field name? Is that wrong?
And for the code to check if it's right i want it to be able to compare it to a value in the database. (CHECK.ASP) Code:
View Replies
View Related
A client wants to include a news page on his site . This would change basically weekly. I have tried to explain basic HTML ie headers etc but he cannot or does not want to understand.
Is there a way to say for him to create a word file or equivalent with nicely Bolded coloured headers etc. There will only be three or four news items a week.
View Replies
View Related
I need to dynamically generate some submit buttons = the easy part . But i'm not sure how i can test which button has been used to submit the form and what it's value is .
Anyone know this?
View Replies
View Related
I made a small javaScript that checks and see if the user has .NET installed on his computer... but the problem is that I HAVE .NET, so I can not check that it works when you do not have .NET.
can someone that does not have .NET installed on his computer, go to the following URL and let me know that he gets a correct reply? (that he does not have .NET).
View Replies
View Related
I have a left menu that is accessed and displayed via XMLHTTP (it resides on the same server). Some sections of the web site don't have a "menu.asp", so a "Page Not Found" page is returned, which doesn't look great in the menu column.. Is there a way to know if a page exists before using xml.responseText to pull it?
View Replies
View Related
I have a company web site which has asp pages and html pages. We have build
a new site and I am doing QA for that. How can I test that web site to check
if all the links work fine. there are so many links and I can not click each
and every one. Is there good automation tool.
View Replies
View Related