Search results for query: *

P.S. - In the 51 rows record, I already have the location values (ZipCode, City, State, etc.) so I figured there's got to be an easier way to categorize (or group by) with the provided location value like "State = 'Florida'" for example.

It's no problem. I knew I didn't go into detail on the 1st posting when I read your replay. >>I don't think you should be embarrassed by the code. It's complex code to solve a complex problem. Not a all. Yes, it's a complex code to solve a complex problem. The reason I posted it is I knew it...

Hmm.. I'll take a look at UNION ALL. The purpose of the query is to collect the cost or values (several category of them) on 1 vehicle. If not exists then fall back to wider location to get them. So, zipcode then city then state then national. The sample question I posted is just for...

Hi! I wrote this sql-query script the best I could and I couldn't figure out a way to minimize the script. The script is way overkill. I'm using too many query for locations and I only need the 1st record result. I'm not proud of it. I wonder is there a way to fetch the 1st record...

Appearantly, there's a folder name "support" that stored the exe files. So, it conflict w/ the routeUrl. The workaround to the problem is to add this to the script... routes.RouteExistingFiles = true;

ASP.NET does not like the use of routeUrl "support".

I noticed trying to route the url to a physical webpage does not work. routes.MapPageRoute("route1","support","~/Support.aspx") but works when others is used... routes.MapPageRoute("route1","contact","~/ContactUs.aspx") routes.MapPageRoute("route1","about","~/AboutUs.aspx")...

I can make do w/ partition and row_number. I'm not too familar w/ PIVOT, so I'll have to study it some more. Thanks for the replay.

With this script... No problem... Update tblDealership SET tblDealership.Address1 = tblDms.Address1, tblDealership.Address2 = tblDms.Address2, tblDealership.Address3 = tblDms.Address3 FROM tblDms INNER JOIN tblDealership ON tblDms.Id = tblDealership.Id But if I have mutliple...

Oh wow! That's work great! You know the regular expression, I only can do the basic but not as advance as this one. Thanks a million! I'm gonna be saving this sql-query for future reference. Wow!

P.S. - The space seperator is the key here...

Hmm... Inner Join. Not bad, that will do. It's only an one time update. Thanks... Also, w/ the "%" wildcard, what if it returned a false positive result. That is a very small change so I'm not gonna sweat it but I'm curious. I'm gonna save a copy of this for future reference. For...

It had gotten more complicated than I thought it on writing a sql-query script. I have a "manufacturer's make" table that need to match against the "dealership's company name" table to get a matching hit. Let's say I have "dealership's company name" table, example below. --snip--...

Yes, it's set to false. The webpage get redirected too soon to allow AJAX to finish.

I noticed that when calling ASP.NET's "Response.Redirect()" script effectively prevent the "Sys.WebForms.PageRequestManager.getInstance().add_endRequest()" from firing. Since Response.Redirect is ASP.NET server-side event while add_endRequest() is ASP.NET Ajax client-send event, so that make...

Never mind!! I'm going to have to hardcode the string instead and hope the website don't break down the road. string sTxtEmailId = "mt100$RenderBody$" + txtEmail.ClientID

In ASP.NET CodeBehind, how do I get ContentPlaceHolder ID? So I can write the CodeBehind script.

How to get ContentPlaceHolder ID in CodeBehind script. Then I'll able to build the ID string to pass on to JavaScript. --snip-- mtl00$RenderBody$txtEmail --snip-- Master - mt100 ContentPlaceHolder - $RenderBody Client WebControl - txtEmail I'm able to build the Master and...

I'm getting a bit miffed over this... I'm using the Master Page and Content Page. I need to pass WebControl ID from Content Page to JavaScript caller in the Master Page. For this, I need to build a string variable, that way JavaScript can use getElementById to find this WebControl. (I'm...

I'm moving everything over to new website, problem is full-file path for downloadable files from the old website does not exist in new website as they are put in different directory path. So, how do I use the mvc route to catch the browser's requested file and redirect so the downloadable file...