Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

(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...

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...

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...

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...

_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...

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...

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...