Recent content by mbeth6

Hello, I am trying to query LDAP to pull only those accounts that were created in the last 24 hours. Now is know that the whenCreated looks like "20071023222129.0Z" but I don't know how to convert that to a variable to pull the information I need. Any help would be appreciated. Mary Beth

George, I actually do understand just could not figure out the correct way to code it. It has been a long time since I did much SQL and am trying to dust the cobwebs off.

George- Thank you so much. This works great.

I am looking for the PrimaryOnCall. weekDay validTime PrimaryOnCall Monday 12:05:00 PM John Doe Monday 3:00:00 PM Jane Doe Monday 7:05:00 PM Jon Public The current time is 1:35:00 PM and I need to find out who the PrimaryOnCall is to assign them a repair ticket...

Hello All. I have a table that has entries for specific times of the day. I want to compare the current time to that table and process records based on whether the current time is between the min and max times for a day. There can be multiple entries and I am not sure of how to do this...

Thank you for the information. I will follow up on your suggestion. Sorry about the cross post. I am still fairly new at these threads and did realize until later that I had done that.

Does anyone know if it is possible to connect to an sftp site using port 22 using SQL2005 SSIS? I am trying to build a package that will go out to the secured ftp site, save it to a local folder and do a bulk insert. So far all attempts have failed. I know I am using the correct credentials...

Does anyone know if it is possible to connect to an sftp site using port 22 using SQL2005 SSIS? I am trying to build a package that will go out to the secured ftp site, save it to a local folder and do a bulk insert. So far all attempts have failed. Thank you in advance for your help. Mary Beth

Thank you for your response. I tried that however it made every row a hyperlink. What I need is for only the column header to contain the link.

I have a vb.net datagrid that I want to add a hyperlink in the column header only. I have created this in VS.Net 2003 and I do not want the link in each row of the datagrid. Any help would be appreciated.

Good Morning, I have an Access 2000 Database that is the backend for a VB.Net application. The scenario is this, that I have users that fill out an Excel 2003 spreadsheet of their daily calls and that spreadsheet automatically calculates a series of totals. Those totals are now manually...

Riverguy, I know this post is a couple of years old, but it just saved my bacon. Thanks, MBeth6

I am sorry I left that out. It is VB.NET web app. I have checked the links you gave and unfortunately they didn't help with this problem. I think I may have found the answer that there is only the DHTML viewer for .net web apps. Not sure about why you can't get a print or export icon. Thanks...

Good afternoon, I have a report that was created in Cr ver.9 and is being called from VS.Net 2003 application. The CrystalReportViewer does not have a printer or export icon, and I can't seem to find anything on how to add it to the viewer. Is there somewhere I can change the default viewer, I...

Thanks for your timely reply. I did try that, and you are so right just the tip... I was able to do it through VBScript and ADO.