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 Rhinorhino 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: *

  1. jimmythegeek

    Group by aggragate issue

    I have done many group bys, and I think this is doable, but the depth is messing me up. 2 Tables: RUN --- SAMP_SITE_ID RESULT ------ CON_ID VALUE_RPTD DEPTH I want to find the maximum value reported for each sampling site/constituent combination. No problem when I group by the samp_site_id...
  2. jimmythegeek

    Dynamic From Statement?

    What is the best way to handle referring to dev and production servers without "re-referencing" all your code? I am just starting this project, so I want to do it right. Currently we get a nightly dump of data to another server and database and here is the reference to the method table in it's...
  3. jimmythegeek

    Common Dialog version issue

    I have an inherited .mdb with a browse button (common dialog active x) that works on my box, but doesn't on a co-workers new box (it worked on his old one). We are both using XP Professional SP2, and we both have the same version of MDAC. His box simply will not recognize the control (it...
  4. jimmythegeek

    Passing in a where string for "in" statement

    The following returns this error (Syntax error converting the varchar value '10, 12, 15' to a column of data type int). The variables are actually input parameters in a function, and the '10, 12, 15' string is passed in: ---------- declare @appID int declare @qID varchar(100) set @appID = 113...
  5. jimmythegeek

    Restart Issue

    We had a power failure a couple weeks ago, and ever since we have had this problem. Our SQL Server is scheduled to reboot itself once a week. It reboots fine, but after it reboots, the MSSQLSERVER service won't start even though it's set to automatic. If we go into the service and RE-TYPE our...
  6. jimmythegeek

    Stone Texture

    Forgive me if this is an easy question. I am fairly advanced in Photoshop, but a rookie at Illustrator. Here is my problem. I am working on a logo for a friend in which I need to make a stone block with two letters on the face of the front 2 sides. I was able to use the 3d filter in Illustrator...
  7. jimmythegeek

    Defaults Collection

    You can create a default in SQL Server using the following line: create default rowAdministration as 2 I believe this is retrievable through the defaults collection, but I can't find any examples that show you how to retrieve that value once you have created the default? Is this possible, if...
  8. jimmythegeek

    Installation Error

    I added a new (secondary) hard drive, and my drive letters got switched all around in the process. So when I tried to open Outlook, I got some funky error saying the application had to be installed from the same location ... So, I tried to re-install from every drive under the sun and that...
  9. jimmythegeek

    Insert Trigger Question

    I need an insert trigger that checks a value in one field and if it is a certain string, then change it to another value. I need to change the string "Required Selection" to a corresponding foreign key value. So here is the pseudo-code (the name of the field is "answer"). If inserted.answer =...
  10. jimmythegeek

    DSN-less communication with SQL Server tables

    I have looked everywhere and not been able to find an answer to this question. Is there a way to communicate with a SQL Server database WITHOUT a DSN (linking), and loop through the tables in a particular database, pulling the information you need (field names, datatype, length, etc.) from...
  11. jimmythegeek

    Blending 2 images

    I have run into this countless times, so I figured I would ask the experts. If I have 2 images that are touching, and I want to blend them together, how can I do this and make it look seemless. Using the gradient tool on a different layer doesn't work because it is solid colors. The blur tool...
  12. jimmythegeek

    Looping through parameters

    Here is what I need to do. First I need a developer to pass me about 30 ID/Value pairs on which I need to loop through and add a new row (insert statement) for each pair. What is the most efficient way to do this? I do not know how to loop through input parameters, or if it is possible, and I...
  13. jimmythegeek

    Support for Classic ASP (how long?)

    To make a case for ASP.Net to my boss, I need to know how long Microsoft is planning on supporting classic ASP. Does anyone have an idea? I have searched the web, but been unsuccessful. The reason I am asking this in the ASP.Net forum is because someone who is contemplating, or has already...
  14. jimmythegeek

    Function always returns true

    This may be elementary, or a stupid question, but why would the following function always return true even if cboOfferResult_? = acc? numOfOffers and acc are variables set earlier in the code (numOfOffers = 2, and acc = 1) ==================================== function acceptedOffers () { var...
  15. jimmythegeek

    File Download Problem

    I found some code to download files through asp, and it seems to work correctly. However, when I download any kind of text file (txt, asp, htm, etc), the file is blank when it gets to my hard drive. I checked the file on the server and it is fine, but it basically erases everything on the...
  16. jimmythegeek

    Response.Flush problem

    I have a dowload page that is called from another page. On the dowload page, I get the file I need to download, and download it (which works great). At the end of the code, I need to redirect back to my calling page, but it is not working. I assume it's because of the response.flush. If I take...
  17. jimmythegeek

    Backup questions

    Our proposed backup plan is to Backup the db every night with 1 hour trans log backups (the 1 hour increments are warranted, we have taken some time to determine this). That said, If I backup the db at 11:00 PM and my trans logs backup on the hour from 12:00 AM to 10:00 PM, should I use...
  18. jimmythegeek

    Syntax concatenation problem

    I am sure this is an easy syntax thing, but I can't seem to get it. This works fine: function checkAll() { for(var i=0; i<document.frm.chk1.length; i++) { document.frm.chk1[i].checked=true; } } However, I have sevaral check box control arrays (chk1, chk2, chk3, etc.), and want to...
  19. jimmythegeek

    Your Opinions

    I have been programming in VB/VBA for many years, and ASP for nearly 3 years. Our company is always behind the curve when it comes to new technology. We do a large amount of internal, intranet web apps (19,000 employees). I recently attended a great class on ASP.Net, and was impressed by the...
  20. jimmythegeek

    Change the Next Value in a Sequence

    I want to be able to update the last value in a sequence to the maximum value from a table. If it were a table, I would use this: Update table1 set lastvalue = (Select Max(ID) from table2) However my book says to use Alter Sequence, so I tried this: alter sequence test_seq minvalue (Select...

Part and Inventory Search

Back
Top