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

  • Users: webmigit
  • Content: Threads
  • Order by date
  1. webmigit

    Can a trigger on a table fire itself on the same table?

    I have a categories table, and it has a trigger on it. When a change is made to a category, the trigger fires a change on the parent category. By design, the change to the parent should fire a change to the parent of the parent, and so on and so forth... but its not. Is there a way to make sql...
  2. webmigit

    Select...Where tb1.field in tb2.field

    I have a query that I'm trying to run... InvImages has two fields ImageFile and AutoID. Products has Name, CatID and Images. The current design is that products can have multiple images.. so in my query I wanted to run this query.. Images is filled with Image IDs.. One product's Images field...
  3. webmigit

    Finding PK Gaps

    Is there a way, without modifying a table, to find gaps in the primary key... IE... where rows have been deleted, and to select the two rows surrounding it? So In this table.. ID | Name --------- 1 | John 2 | Jim 4 | Suzi 5 | Donald 7 | Jeffrey 10 | Zach 11 | Kimmy 12 | Bobby I would...
  4. webmigit

    Consume a web service in VB

    I have a Cold Fusion web service (CFC) that I wrotefor flash but have been able to deploy in Flash, CF, and PHP, so I know it works.. The data is returned as a cf struct.. and I haven't been able to figure out how to return this struct to VB.. All other languages work fine but I just don't know...
  5. webmigit

    Resolution Adjuster

    This is aggravating.. I have a sony vaio laptop with crystal clear display.. but the display is a little small... I have an external monitor, keyboard, and mouse.. So I basically want to close the lid on it and use it as a tower. The trouble is that no resolution shows up perfectly on the...
  6. webmigit

    Multiple Monitors: How to view the same area?

    I have an old VAIO that I'm placing in an office as just a general workhorse... Basically I want to just place it as a tower.. I have the external keyboard mouse and monitor.. and yesterday, everything worked perfect.. but when I restarted, the second monitor stretched the display from the...
  7. webmigit

    Trigger causing an error...

    I have a trigger that is causing an error when multiple items are inserted to the db (I use cold fusion, each query is in a seperate <cfquery> tag.) CREATE TRIGGER InsertBalance ON [dbo].[Credits] FOR INSERT, UPDATE AS DECLARE @CreditUserID INT SELECT @CreditUserID = (SELECT CreditUserID FROM...
  8. webmigit

    Log File Viewer

    How can I view an LDF file... I can't open or copy it because its in use by 'another application' (duh). And what is the best log viewer by popular opinion? ALFII.com http://www.alfii.com --------------------- If this post answered or helped to answer your question, please reply with such so...
  9. webmigit

    Rule Seniority Questions

    Some of you may have seen my question about users and roles in SQL Server Programming. It was a confusing question now that I read it and shamefully uneducated. I'm trying to create a restricted user that I will use to connect to the db from my code with... My question is... There are three...
  10. webmigit

    I can't add a user

    I'm trying to add a user to my database... A user and a role. I can't do it for some reason... I get the error "Error 15007: The Login 'WhateverUsernameHere' does not exist.".. This is ignorant because I'm trying to create the user via "New User...". Is it that I don't have enough access to...
  11. webmigit

    On Error, Roll Back

    Is there a way, in a stored procedure that if an insert/update fails that all previous transactions in that stored procedure are rolled back? (Removed?). And if so, does this apply be default to sps called from inside the sp? Or is there a way to make it apply? ALFII.com http://www.alfii.com...
  12. webmigit

    My non internet program attempting to access DNS Server??

    I've got Norton '06 and today its telling me that my program is attempting to connect to a dns server.. Why would this be... my program has a few urls in it but they're only as strings or as comments in the code... it does launch the default browser with some of these urls but only if the user...
  13. webmigit

    Problem with the weather.gov feed

    Alright, the weather.gov feed is the worst feed I've ever seen.. When there's no data for a field, it just doesn't include that field. The structure for temperatures is that each is in an array. From my learning, it seems that High = Temp[2] Low = Temp[1] Apparent = Temp[3] But last night...
  14. webmigit

    MS Ergo Keyboard/KVM issues

    (A) = Apple Mac Mini (L) = Linux (Linspire) (W) = Windows (XP Home) I've got a setup in my office that looks like this Generic Keyboard & Mouse --- KVM --- (W) +-----(L) +-----PS/2 -> USB Adapter---(A) This setup has worked fine...
  15. webmigit

    Dynamically populating a menu

    I'm trying to migrate my application from vb 6 to .NET and so far, it hasn't been good... the built in tool doesn't work well... It doesn't migrate the big changes. How do I hand dynamically creating a menu (I used a control array previously, but control arrays are no longer a feature). Why...
  16. webmigit

    Duplicate contents of current frame in movie clip

    Can I duplicate the contents of a current frame into a movie clip? And if those objects have had values set in code, would they retain those values when duplicated or would I have to re-set them in the "clone"? ALFII.com http://www.alfii.com --------------------- If this post answered or helped...
  17. webmigit

    Printjob Scalability Issues

    Alright... I built most of my movie in Flash 7.. But for some reason, there is a bug between Flash Player and firefox causes certain portions of some movies not to work. One point in my movie prints two copies of the document on the screen... One is a regular copy and the other is a receipt...
  18. webmigit

    Actionscript function help, needed badly

    _root.Labeler.PickStatus = function() { _root.Labeler.rectype = _root.Labeler.rectype.toLowerCase() _root.Labeler.lblPrinted._visible = false; _root.Labeler.lblReceipt._visible = false; _root.Labeler.lblCleared._visible = false; _root.Labeler.lblVoid._visible = false; if...
  19. webmigit

    Populated flash field from html

    IS there a way, when invoking flash, to populate a field in the flash file I have a field in my flash called DMONumber and am trying to pass a numeric value to that... I thought the <param> tag would do it, like java, but it doesn't and I'm at a loss. The flash is a form that gneerally users...
  20. webmigit

    Symbol Boundaries

    I've got a symbol I've made that I fill with dynamic content... is there a way I can set it so that if the content overflows a certain range (rectangular) that it just doesn't show it? ALFII.com http://www.alfii.com --------------------- If this post answered or helped to answer your question...

Part and Inventory Search

Back
Top