Search results for query: *

Nice. Three approaches. Thanks a lot.

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

Actually, I have found an option using a udf that parses the two rows into a third table.. The UDF is fired by a trigger. I like it, it works pretty seamlessly. Thanks :) ALFII.com http://www.alfii.com --------------------- If this post answered or helped to answer your question, please reply...

Rudy I would like to see a more efficient query.. That's the best I had and I knew it was suffering. I've learned a lot of sql from you over the years. QofQ's are still so very disappointing, they lack such baseline functions.. Certain string functions for instance and I'd say they've been...

The easiest method here, since this won't affect security is to pass the username they are checking in a url value of the pop up window.

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

The best way, I guess would to be to cycle through the list and add each unique element to a new list. <cfset CountryList = quotedvaluelist(getLocations.Country)> <cfset StatesList = quotedvaluelist(getLocations.State)> <cfset CitiesList = quotedvaluelist(getLocations.City)> <cfset...

Thanks a lot guys! ALFII.com http://www.alfii.com --------------------- If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

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

More on this... Yesterday, when I tried this and had both displaying the same image... the driver for both monitors (in Display Properties >> Settings) was 'Plug N Play on Mobile Intel(R) 915GM/GMS,910 GML Express'. Today, that is #2's driver... #1's is 'Sony Notebook LCD on Mobile Intel(R)...

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

This is the finished product, apparently working, but 'd like some opinion update users set balance = (ISNULL((select sum(creditamount) from credits where creditUserID = users.UserID and left(CreditDate,11) = left(GetDate(),11)),0)) where userid in (Select...

Alright... Thanks for the answers so far.. One more question regarding error handling. @nError = @@ERROR IF @nError <> 0 BEGIN IF @@TRANCOUNT > 0 ROLLBACK -- Roll back the transaction if any EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Your ProfileName'...

Wow guys. Thanks! I have one more question... How would I add simple error catching to this? I can't afford for it to have errors. Can I have it email me, in any way to tell me when the sql fails? ALFII.com http://www.alfii.com --------------------- If this post answered or helped to answer...

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

My question was shamefully uneducated and poorly formed. Thanks MrDenny, you helped clear up some confusion. Thanks jbenson, You, in effect, pointed out that I'm not asking this in the right place... Most of my SQL questions are about the language itself... Its just habit to come here. I...

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