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

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

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

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

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

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

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

I need help optimizing this query. I know there are many table joins, but unfortunately, we need the data from these tables. If it's not smart to join this many tables, what alternatives do I have? What can I do to make this run faster. Right now, it's slow as a slug returning any results. I...

I have a cross-tab report that will likely spread across multiple pages and was wondering how to display the data on all pages instead of just the first page. I noticed that my cross-tab object resides in the Report Header section of the report so I suppose that is the reason, but I did...

Has anyone integrated ASP.NET and SQL Server with Quickbooks? I'm wondering what resources are available to learn more about the technical sides of how to do develop and integrate with it. Thanks regards, Brian http://www.gainesconsulting.com The problem with doing something right the first...

If possible, how do I change the internal browser to something other than Internet Explorer if I want to preview/debug my pages from the IDE? I would like to use FireFox or Netscape for instance. Thanks regards, Brian http://www.gainesconsulting.com The problem with doing something right the...

Is there a way to programmatically close the browser with javascript if the visitor manually comes to that page without it being opened from script? I can't seem to find anything that permits me to simulate a "self.close();" routine. Thanks regards, Brian http://www.gainesconsulting.com The...

I have a table with a column designated for ordering page content. I was wondering what SQL I could use to auto-increment/auto-decrement order numbers in a column. For example if my columns looked like this: PageId PageOrder ------ ---------- 1 1 2 2 3 3 4 4 5 5 6...

Is there a direction someone can point me in that will get me started on replicating similar functionality with javascript/dhtml as seen with this gallery/portfolio section of http://www.rsteenphoto.com. You can see what I mean when you click on any one of the thumbnail images on the right side...

Is it possible to sort a dictionary object by a class property value? I've seen examples where I can sort by index or item of the object, but I am storing, for example, multiple user class object in a dictionary object and would like to sort the dictionary based on user's last name, first name...

Is there a VB.NET equivalent (More of a work-around) to the C# using keyword in the ability to return execution to the original routine. I know that VB.NET does not have this ability, but wondering what is recommended for VB.NET. For example if I want to return a DataReader and once I'm done...

I am having real troubles trying to compare my original values and the changed values in a DataTable. I use the DataViewRowState enumeration to filter the appropriate values. I do see that the values are different (when comparing the before/after) in their respective DataView, but when I try to...

Since CR is part of the VS.NET 2003 installation, we want to install only the CR runtime (we don't want to install the complete VS.NET install on the production server) on our production server so that many web/win apps can reference CR from the respective projects. Our administrators want us...

I am wondering what I am doing wrong in order to use the OracleDataAdapter to grab data from the database, make changes to it in my data table, then update the database with those changes using the code I have below. Can anyone shed some light on the matter? Thanks Dim conn As...