Recent content by tklear

bummer. Thanks!

I'm having a similar problem with an Excel 2000 cell that contains lengthy text data. It should import into a memo datatype field but access will not allow be to adjust the datatype for that column when importing. Is there any way to adjust the datatype (other than the dummy record)? I will...

I need to be able to tell if the system_user is a member of a certain role (db_owner). So I set up a stored procedure that returns me a boolean indicating if he is in the role: CREATE Procedure roleGrabber @systemUser varchar(200), @roleName varchar(200), @isMember bit out as SET @isMember =...

I would like to be able to detect any database object that has been modified since a certain date. Is there a way I can accomplish this. It would help a lot with moving schema changes from development to test environment. I see a crdate and a refdate but the values seem to be the same in...

I'm trying to detect a whether a field is nullable from an ASP page using an ADODB recordset field. I'm getting an error because the ASP doesn't recognize the constant. Is there a value I can use instead? Thanks.

Thanks everyone for your help. I've been successful in determining if I have multiple recordsets. There doesn't seem to be a property that can be called, however, the error trapping ideas provided allow me to count the occurrences while suppressing the error. Thanks again!

Thanks for trying but this is basically what I've already tried except to add: On Error Resume 0 at the end to turn off error trapping. The result is the same. Regardless of why the password can't be updated the error is trapped but no information is provided as to the reason. I can give...

Shaddow, Don't suppose you have time to look at this post of mine: thread333-714340 has to do with ADSI.changePassword You are good so I thought I'd ask. Thanks again for the solution on this one! Terry

OK, this time I get the following error: 1!record record record record record record record record record 2!record record record record record record record record record 3! Microsoft VBScript runtime error '800a01a8' Object required /list/sortList.asp...

George, that is close to what I need but I'm getting an error no matter how many recordsets I have. Here's my test code: dim intRecordsetCount intRecordsetCount =0 ' ASP did not recognize adStateClosed variable While Not rst.State = 0 intRecordsetCount = intRecordsetCount + 1...

I have a stored procedure that returns multiple recordsets for example: select employeeId from employee select termID from term The number of records can vary depending on which stored procedure is called (sp name is passed as a parameter into the ASP page). In my ASP page I would like to...

I'm using the ASP script below to change a user's password by calling ADSI. This works fine as long as the user follows all the enforced rules for password creation. If they don't I get a very general error that I'm displaying with err.description. The error states: 450, Microsoft VBScript...

var a = this.getField("fieldName"); // create your own color by getting true RGB values and dividing each number by 255 color.myColor = new Array("RGB",1,1,.62); a.fillColor = color.myColor; // you can also use standard colors like this a.fillColor = color.red Hope that...

If you are talking about using JavaScript in an Acrobat PDF form to find out which version of Acrobat the user has this would be how: if (typeof(app.viewerType) != "undefined") { app.alert(app.viewerType); app.alert(app.viewerVersion); } Good Luck!

I have a table with 5 columns that each contain a value from 1-13. I want to find those records where the same value occurs in more than one of the 5 columns. Is there a function that will handle this? So far I have this idea but am looking for an easier/faster way: select fooID from foo...