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...
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...
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...
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 =...
What would be the easiest way at going about making a web page display an entire calendar month in a table? This needs to be real/time and not premade. perhaps make a case select for each month and use left(Date, 2) to figure out which month? and then the case decides how many days and in the...
Does anyone know how to make Access Store WhiteSpace from a textarea? I have made a message board that stores the Message in a DB,however not carriage returns or linefeeds are displayed when the message is viewed. If it is not possible, any reasonable alternatives?
Does anyone know how to make Access Store WhiteSpace from a textarea? I have made a message board that stores the Message in a DB,however not carriage returns or linefeeds are displayed when the message is viewed. If it is not possible, any reasonable alternatives?
Is there anyway to simulate hidden radio buttons? Here is my delima.<br>
<br>
I have a site administration page with all of the memebers listed. There are 2 security levels that a memeber can have, 1 and 2. If it is 1, then the member is an administrator. If 2, only a member(not access to...
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.