Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mbowles
  • Order by date
  1. mbowles

    Query excel numbers with leading 0 creates null

    Yes reading from excel. yes the numbers are like so 14574 14749 '00475 '01258 I did not create the excel, but forced to use it. I would be happy with bringin them over to sql as char(15) or whatever. Thanks. I will see if I can append the excel with aditional single quote at end. If you...
  2. mbowles

    Query excel numbers with leading 0 creates null

    I have an OpenRowSet calling an excle spreadsheet and it works fine except one column has numbers as a General format and the numbers that start with 0 have been preceded by an apostrophe in excle show they show. WHen the sql query runs, they come back as null. I have tried casting to no...
  3. mbowles

    VB6 Sql query - no records

    I have the following code: Dim result As String Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Dim var As String cn.Open "Provider=sqloledb;" & _ "Data Source=server;" & _...
  4. mbowles

    Select table twice in join

    Thanks...brain freeze kept me from use the same table twice with a different dot notation!! Worked like a charm.
  5. mbowles

    Select table twice in join

    I have 2 tables, and table1 has 2 fields that point to records in table2, one to many. I need to do a query to get one record back but populated with the data from 2 records in table2 and the single record in table1. Any thoughts?
  6. mbowles

    IMage in PowerPoint 2003 not showing in 2000

    Anyone know of compatibility issues with viewing a 2003 PP doc with an image in 2000? I have 2000 and was sent a 2003 PP and the image is a broken link. (x in corner) Is there a backward issue here?
  7. mbowles

    Inexperienced VBA coder and netowrk files

    Thanks. Just wanted to get another opinion. Was not happy when I found out that a sales guy is tinkering when he has admitted he has no clue what he is doing.
  8. mbowles

    Inexperienced VBA coder and netowrk files

    I am not the greatest at VBA, but we have some guys in our company tinkering with VBA in excel. These are sales guys and not tech's. What are the chances of them ding something stupid and causing big problems if another user uses that excel file. Assume the sales guy will not purposely write...
  9. mbowles

    Edit mobile of Active Directory user with code

    Can you edit an AD users mobile field thru a web page?
  10. mbowles

    ASP, IIS6 and Requested Resource is in use

    I have an ASP (old classice asp) that runs on a Win 2003 server box. I have set IIS6 to run in IIS5 isolated mode and have "allowed" asp to run in the web services area of IIS. When I use a browser to access any .asp's in that virtual dir, I get "requested resource is in use" and no other...
  11. mbowles

    User modify his own active directory object

    In C#, a DirectoryServices gives you access to ldap thingys. I have the O'Reilly Active Directory Cookbook with a lot of VBScript code for viewing, editing, maintaining users, groups, topology, security etc...and I find the C# ports for that VBScript code.
  12. mbowles

    User modify his own active directory object

    Yeah, I have some C# .NET stuff that allows query and editing, but my network team would rather lock fields vs. relying on me to only provide access to said attributes.
  13. mbowles

    User modify his own active directory object

    Is there a way to set perms on the AD object of a user so he/she can modify there own telephone number, cell phone, etc..., but not any other attributes?
  14. mbowles

    Query SMS Asset Management

    Thanks, we looked at that and ended up with Magic Help Desk. I have no opinions on this either, except that now the powers that be dont like it and want to buld something that integrates seemlessly with out portal product. I discovered yesterday in my research taht I could write a .NET web app...
  15. mbowles

    Query SMS Asset Management

    Anyone written a c# web app taht queries SMS Asset Management? If so, difficult? Point me in the right direction? Thanks
  16. mbowles

    Choose download location on client

    Our company has mandated a spcific folder be present on all machines. Is it possible to set a web based file download to go to this location? ie, all downloads from the company web site automatically go to said folder, or at least autofill the download popup with the location.
  17. mbowles

    Table and query opinons

    Thanks. I just finished reviewing some open source versions and do things very similarly. There are times when the sp can recurese through one parent, with 10-15 subs, and each sub have 10-15 for about 4-5 levels deep. Each with a handful of files. I will review it some more.
  18. mbowles

    Table and query opinons

    I have written my own docuemtn management system with c# and sql. I have a folder table (folderid, parentid, name, etc..) and a file table (file id, folderid, name, etc...). I then have foldersecurity table (folderid, userid, accesslevel) and well as one for filesecurity(similar to...
  19. mbowles

    User Logon Name Active Directory

    Thanks. Yeah, I need the user logon name on the network, which is the part before the @ symbol. M
  20. mbowles

    User Logon Name Active Directory

    In AD, you have a cn which usually is the user's username(it appears to actually be the object name). There is also the userPrincipalName which is the email-like name. In AS there is an account tab in which there is a field: user logon name. Does anyone know what the programmatic name for...

Part and Inventory Search

Back
Top