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

log sheet: columns: name (col a) col1_1 (col b) col1_2 (col c) col1_3 (col d) col2_1 (col e) col2_2 (col f) col2_3 (col g) live results sheet: columns: name (col a) < currently static, but would be nice to link > totCol1 (col b) Formula: countif(Log!b2:d2,"x") totCol2 (col c) Formula...

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

I need help with my SQL script and how it performs transaction rollbacks if I get an error in my cursor. Does the data commit after each fetch or something? It appears that if something breaks in my routine that the updates performed do not get rolled back. Can anyone see a problem with how I...

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

I was wondering if someone could help me figure out how to fix my SQL as a result of this error message I'm getting with the following SQL below. Thanks Error Message: Server: Msg 8152, Level 16, State 9, Line 24 String or binary data would be truncated. Warning: Null value is eliminated by an...

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