What's wrong with this code?
objRS.Open "InvLists", objConn, adOpenStatic, adLockOptimistic, adCmdTable
With objRS
.AddNew
.Fields("Name") = strName
.Fields("DateAdded") = Now
.Update
End With
iListID = objRS("ListID")
ListID is an autoNumer field in...
I don't believe that there is anyway to do this specifically, a component could do this easily though. If by any chance you are trying to benchmark to get an accurate time, I'd recommend Microsoft's Web Application Stress Tool that is a free download from microsoft.com
Jeremy Lowery
Does anyone know how to expose component constants written in VB6 so they can be used by ASP Pages? Mainly, like msado15.dll that can be used in a <!--METADATA--> tag. I read somewhere that you could add a module to your VB component and add "Public Const" declarations and they would...
I'm currently hosted on http://www.brinkster.com/ . They have free general memberships, which includes ASP, SSI, and Microsoft Access Database support. For free you don't get to use Global.asa or any components, and you have to use web based file upload. But, for 10$ a month you get Global.asa...
the reason you get the subscript out of range error is because you have your subscripts out of order. I personal use constants for the column names so I don't have to remember numbers and such. <br><br>const strcolumnname = 1<br><br>For rowcounter = 0 to Ubound(AryData,2)<br>Resoponse.Write...
As palbano said, your Conn variable is null unless you have a definition for it elsewhere. It's the connection string that's either a DSN, Driver UID Pwd, or Provider UID Pwd.<br>Another small problem I see comes right after the Open Method call.<br>if RSKid.EOF...
I wrote a message board that used the same kind of technique your describing. in a Hierarchal structure display. basically what you can do is put your recordset into a 2 dimensional array using objRs.getrows for speed. I used two functions, both of them looped through the array. the first...
Does anyone know the best way to create a tree like web site? For exampe: Amazon.com Like<br><br>Books > Horror > Authors, A-Z > ( K ) > King, Stephen > Riding the Bullet <br><br>and being able to click the subheadings back up to the main page? <br><br>I have been able to create...
Anyone know why I get this error? (IIS 5, win2k)<br><br>ADODB.Recordset error '800a0cb3'<br>Object or provider is not capable of performing requested operation.<br><br>from the following snip:<br><br>iPageNum = 1<br><br>objRs.AbsolutePage = iPageNum<br><br><br><br>and also, I can only set...
I personally agree with jaspr, HomeSite is a wonderful ASP development program if you like work from the code up. It's color coding is good and you can easily make your own wizards to do common tasks (like making DNS or DNSless ADODB connections and recordsets for example.) <br><br><br>Jeremy Lowery
I'm not sure. I just got win2k the other day, and I"m still learning it. I think that is User Access to the database (like people that login to the computer). For what I'm talking about, you can do it two ways. Goto control panel, admin tools >> Internet Services manager or goto the...
I have had a similar problem and the easiest (probably not the most efficient) way to solve the problem is to have another seperate window that's sole purpose is to end the session (because there is no Client>>Server mechanism in ASP, only Server>>Client). use onunload event handler...
Elab on Write Permissions<br><br>If you are using winnt/2k use the MMC IIS snap in to set the permission for your database folder. Just right click>>properties and the options will be right there. If you're on a Win 98 system using PWS Click the Advanced button, select your database folder...
As far as links go, there are plenty of them here! If you want to get some hardcopy material, Wrox has put out some excellent ASP books. <br><br>Beginning Active Server Pages 3.0 (Professional too)<br> ISBN# 1-861003-38-2<br><br>Beginning Components for Active Server...
Is there a way to overload a VBScript function? Take the following example:<br><br>definition:<br><br>Function MakeConn(strSql, x, y)<br>Dim ConnTemp, RsTemp<br><br>Set ConnTemp = Server.CreateObject("ADODB.Connection")<br>Set RsTemp =...
I am not sure what "usertype" is, if it is a form field. then you can do what you want without ASP, just ole JavaScript. Just Make the Form have no ACTION attrib.<br>like <form name='myform' method='POST' onSubmit='pagesender()'><br><br>and then javascript like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.