Recent content by HectorShuckle

You have to either a) catch it before inserting, by doing a "SELECT Count(*) FROM tableX WHERE [filename]=" & sFilename b) add your own error handling on error resume next 'do the insert stuff if err.count>0 then 'Report the error end if on error goto 0 'turn off the error handling

Be sure you've DIMmed with an actual number, rather than a variable. Dim arrX(theNumber) 'doesn't work Dim arrX(77) 'should work

Dim strArray(1) 'Just a starting point Dim lngCount 'It's a number Dim lngTeller 'It's a counter so it's a number lngCount=23 for lngTeller=0 to lngCount redim preserve strArray(lngTeller + 1) strArray(lngTeller) = "This is number " + lngTeller next It's better...

Session_OnEnd is known for it's unreliability. How about if you use some javascript on your pages, to open a popunder window "onUnload", the popunder window, can update the time that this user left, then close itself. If you do it on every page, then the last page he/she visits of...

Don't forget to close your connection and set it to nothing conn.Close Set conn=Nothing

How about..... response.write replace(objRS("attribute"),""","&qu ot;") without the space between 'u' and 'o', when I previewed this, the &quo t; disappeared, which is probably what happened to mwolf00's

In SQL server those 16 bytes hold a pointer to the REAL data. You insert your "novel", and SQL stores it on as many pages, as necessary. So your insert statement would be like..... INSERT INTO tblWhatever (ArticleID, ArticleTitle,ArticleDetail,ArticleDate) VALUES (100,'The title...

It's limitation is 5 concurrent users. However, it's not "real" users, but the equivalent of 5 users' load. If you open and close your connections quickly, you can use it quite well. Bear in mind, that if you have enough traffic that your users aren't being served, you should use a...

I don't see where cnn is being set to nothing..... Set cnn=nothing If you don't do that, then you have to wait for IIS to drop the object. You could be running out of ado connections, which would give you the error, waiting a few minutes gives IIS a chance to drop the object. Usually if you...

Sorry, I mustn't have been clear. A text field takes as much or as little space as necessary. So you have a table like this...... ID int identity theData text 16 The field called theData could contain "hi there" or it could contain the contents of a novel. SQL stores the...

Easiest solution.....Upgrade to XP Professional, as it includes IIS 5.1 As long as asp runs, and you have the appropriate version of ADO, then you can connect to your access/excel databases http://www.aspfaq.com/show.asp?id=2079

The other way is to use an ADO Shape.

You likely ran a security analyzer, or Check front page extensions (and let it tighten security) As you suspected, the file must have write permissions, as you are trying to write to the file -- ts.WriteLine(EndInt)

You can use ADSI There's a lot of good information at http://www.4guysfromrolla.com/webtech/LearnMore/adsi.asp note: You have to have permission to use it. So, you either have to set your site to 1) use NT Authentication or Basic authentication 2) Give IUSR_machinename permission to access...

Many start with Access and upgrade to SQL when the time comes (as BDC2 said) However, the MSDE is an easier upgrade route as it's 100% compatible with SQL, and essentially free. MSDE=Microsoft Database Engine