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: gmmastros
  • Content: Threads
  • Order by date
  1. gmmastros

    VB6 Post to webservice with MSXML2 error

    I have code in VB6 that sends a web request to my server to pass and get data. Once upon a time it was working, but now it's not. To be clear, this is used in a VB6 app that is distributed to my customers. It passes a webrequest to a web server that I fully control. I mention this because I...
  2. gmmastros

    Internationalization problems

    I am trying to convert my VB6 application to spanish. It's still in development, so it's not installed on many computers. When I install it on one computer in my office, it won't display accented characters. On several other computers, it displays fine. I've checked everything I could think...
  3. gmmastros

    Intermittent email problems

    My application allows users to send emails. Before anyone thinks it's a spamming application, it's not. This email functionality allows transportation directors to notify students about delays with their school bus routes. Because of this, there are times when many emails get sent...
  4. gmmastros

    Advice for making resource dll

    I have approximately 800 icons I use in my app. I am trying to consolidate them in to a single dll so that I do not have slightly different versions of the icon all over the place. I tried several things, none of which are working out well for me. Originally, I had several forms (for...
  5. gmmastros

    Convert C++ header for use in VB6

    I'm trying to print to a Zebra printer (p430i) from within VB6. I also need to encode mifare cards with this printer. All of the documentation and sample code for the mifare functionality is written in C++. I am trying to convert this code to VB6. typedef struct S_CARD_AND_TIMEOUT {...
  6. gmmastros

    Configuring failover with multiple connections

    Please forgive me, I'm an accidental network admin. My primarily role is DBA and occasional programmer. Unfortunately, we don't have a network admin, so I am stuck in very unfamiliar territory. Small company with 2 internet connections (separate providers). Each internet connection has a...
  7. gmmastros

    Trusted or disabled foreign keys

    I'm working on a blog article, and I am curious to know how prevalent a particular "problem" is. Can you kind folks run the following query and tell me how many rows are returned? SELECT name FROM sys.foreign_keys Where is_disabled = 1 or is_not_trusted = 1 I don't need to see the...
  8. gmmastros

    SQL 2008 Alias Table - Left Join - Not getting Unique record

    Try this: select epn.EntityID ID, Max(BPh.AreaCode+' '+ BPh.Number) as BusPhone, Max(BFx.areacode+' '+ BFx.Number) as BusFax from EntityPhoneNumbers epn left join PhoneNumbers BPh on BPh.PhoneNumberID = epn.PhoneNumberID and BPh.TypeID = 71...
  9. gmmastros

    Am I missing something here? Query works in SSMS, not inside function.

    The parameter is varchar(20). Is it possible you are calling this with a userid longer than 20 characters? -George Microsoft SQL Server MVP My Blogs SQLCop "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
  10. gmmastros

    Why Is This Query Complaining About Group Function?

    You need to use a GROUP BY anytime you use an aggregate function. The HAVING clause allows you to put a filter condition on the aggregate. The simplest thing to try is to reproduce the entire select clause in the group by with the exception of the aggregate function. SELECT Distinct...
  11. gmmastros

    SQL Server Denali CTP1 available for download

    At the SQL Server PASS summit today, Microsoft announced it's next version of SQL Server (code name Denali). This version is available for download now. Details can be found here...
  12. gmmastros

    Memory used by array?

    I am trying to determine the amount of memory used by an array. Specifically if it's an array of user defined types containing strings. Using this code as an example... Option Explicit Private Type Person Id As Long EyeColor As String ShoeSize As Single Name As String End...
  13. gmmastros

    Click vs Double Click timing

    I've created a user control that is causing me some problems. If you start a new VB project and put a standard picture box, image box, text box, etc.... on the form, and then put debug.print statements in the click and DblClick event handlers, it appears as though the click event always fires...
  14. gmmastros

    ftp problem

    I am trying to automate an ftp process and I am having a problem. I want to download 3 files from another companies ftp server. They have given me a username and password that I use to access their ftp server. Since I want to automate this process, many (if not all) of the 3rd party ftp...
  15. gmmastros

    Save as different projection

    I have a customer that is trying to send me some map files. She is using ESRI tools (arc something or other) version 9 (I think). She has data in one of the State Plane projections, and I need the data in WGS84 projection. Since I am not familiar with any of the ESRI tools, I don't know how...
  16. gmmastros

    IntersectRect API call problem

    I "modified" the API call slightly, and it seems to work. Basically, I am trying to use this API with a map (latitude/longitude). I got tired of getting confused about the top/bottom, min/max weirdness, so I created an alias for the API call and a 'different' rect structure to suit my needs a...
  17. gmmastros

    3rd monitor

    I recently bought a new computer. My old one had 2 dual video cards, and I had 3 monitors connected to it. (spoiled, I know). My new computer has 1 dual monitor video card, so it was super easy to connect 2 of my monitors to it. The 3rd is giving me problems. I removed one of the video...
  18. gmmastros

    Common Controls 6 Error In Loading DLL

    I've been having a problem loading my VB6 project lately. I'm hoping someone recognizes the problem and can help me out. When I attempt to load one of my projects, I get an error. It says, "Errors during load. Refer to 'C:\folder\frmWhatever.log' for details. When I look at the log file, it...
  19. gmmastros

    SQL Teaser

    Without running these queries, predict the output. If 1/0 = 10 And 1/1 = 0 Select 'True' As Query1 Else Select 'False' As Query1 If 1/0 = 10 And sqrt(1)=0 Select 'True' As Query2 Else Select 'False' As Query2 -George "The great things about standards is that there are so many to...
  20. gmmastros

    SQL Teaser

    I was just experimenting with the ParseName function and discovered something a bit unexpected. I thought I would share (but in the form of a teaser). Without running the code, what do you expect the output to be? Create Table #Temp(Data VarChar(50)) Insert Into #Temp Values('Easy Answer')...

Part and Inventory Search

Back
Top