Search results for query: *

I am trying to perform a regular expression to yield the following results: would return: company1.com wwwcompany2.org are the companies using Oracle's regexp_replace function, but I'm struggling with the pattern syntax. Can anyone get me on the right track? I've been tackling this for quite a...

Thanks! I have connection piling up in a pool, so onto other research on when connections are not being closed properly. regards, Brian http://www.newleaftechinc.com

Thanks Jason, I did review your FAQ. Very nice. Closing the connection through the command object seems to be closing the connection (by reference) though, even though it might not be best practice? As a result, should I be calling iCon.Dispose() afterward? regards, Brian...

I have a function which I open a connection object and assign to a command object. Does the connection object need to also be closed in addition to the command object's connection or is the iCon closing by reference of closing the iCmd.Connection.Close() method? Thanks (see below) Public...

Yes, was making it generic for example purposes. I just ended up using a VLOOKUP to get what I wanted. =vlookup($B23,log_datasheet,35,false) Thanks regards, Brian http://www.newleaftechinc.com

Log Sheet A2: Brian A3: John A4: Tim Live Results (unsorted) A2: Brian A3: John A4: Tim Looks fine, but when... Live Results (sorted) A2: Tim A3: John A4: Brian My formulas are still looking at Log!a2, but that sheet is sorted differently, so the name does not match up any longer on my...

...be nice to link > totCol1 (col b) Formula: countif(Log!b2:d2,"x") totCol2 (col c) Formula: countif(Log!e2:g2,"x") total miles (col b) Formula: (b2*2.28)+(c2*0.5) What I would like totCol1 to be is: if (col a = logsheet!name) then count the number of #'s and keep this logic when sorting on...

My extreme apologies for the locked down file. I made a copy and thought permissions carried over. Sorry again. http://spreadsheets.google.com/ccc?key=ruYIANMmIKrrevnVRX8ECKg&hl=en regards, Brian http://www.newleaftechinc.com

I am trying to create a formula that will allow me to sort a live results page I would like to sort the Live Results tab based on the Total Mileage. I have another tab ("Log tab") that I enter the details for. The Log sheet has a list of names, then based on the number of "x" I enter aside...

Is there a work around for using the ALTER TABLE command to add a column that is "NOT NULL"? for instance, can we add a NULL column, then change it to be NOT NULL in a two-step process? Thanks regards, Brian http://www.newleaftechinc.com

Thank you for the quick response. I'll give that a try. regards, Brian http://www.newleaftechinc.com

...a RecordAction of [insert] in our deployment queue table to the live tables' select @queueSql = 'insert into ' + @tableName + '_LIVE select cms.* from ' + @tableName + ' cms, DeploymentQueue q where q.KeyNameValue = cms.' + @keyName select @queueSql = @queueSql + ' and q.JobName = '''...

Thank you for the posts. 1. Yes, I have used her photos that she is working with and had success sizing it down further. 2. When I'm given the file that she saved for web, it's 15kb, when I save for web it's < 2kb. We're more concerned with the final file size. regards, Brian...

I have a client on a Mac using Photoshop that would like to know what the exact steps to resize an image in photoshop to give it the exact pixel dimensions 50X50 and have the total document size be less than 2k and saved for web? She is creating a photo gallery and needs to create thumbnails...

When I FTP'ed the images folder to the server, even though my SmartFTP client showed that the files were on the server, they were in fact, NOT. I had to copy them directly and then they appeared. Anyone know why SmartFTP would show that they're on the server, but not really be? Thanks regards...

I have a question pertaining to an ASP website running on Windows 2003 Server and IIS 6. I created website that is publically accessible on a port for development purposes. You can access it here: http://ds1098.activeserve.com:9000 to see the issue I'm having. When the site renders, the image...

Thanks, i just resolved the issue and it was the fact that my column size was incompatible with what I was allowing to be updated. All better now, thanks regards, Brian http://www.newleaftechinc.com

...tblBidStudyDate bsd, tblBids_bak_07112006 b where upper(b.BidStatus) not in ('CONVERTED TO JOB','CANCELLED','EXPIRED') and b.BidId *= bsd.BidId group by b.BidId, b.ProjectName, b.FacilityRate, b.GroupNum, b.BidDate, b.RecruitNum, b.HoldStatus...

Can you elaborate on the "Replace MIN()/MAX() subqueries with derived table and left outer join." I'm not sure I follow what you're saying here. Thanks regards, Brian http://www.newleaftechinc.com

Thanks, I did that and also removed the date formatting as well. I think this would slow things down as well. Again my tblBooking table has upwards of 26K records in it. Any ideas about some of my other questions listed above? declare @tblStudyDt table ( ReservationID int primary key...