Recent content by jiggyg

It does have something to do with SQL, as I'm setting a value to '1' in the database if the checkbox is checked: if (Request("validException")) <> "" then set cn = server.CreateObject("ADODB.Connection") cn.Open Application("DataConn") sql = "UPDATE Locations SET LocAllowMultOcc =...

<span ID="MainPage"> <br><a href="LocsMultOccs.asp?results=true&type=x&nav=Mozilla%2F4%2E0+ %28compatible%3B+MSIE+7%2E0%3B+Windows+NT+5%2E1%3B+%2ENET+CLR+1%2E1% 2E4322%3B+%2ENET+CLR+2%2E0%2E50727%29&CostCenterID=-99&LocationID=-99& showValidExceptions=1" target="_blank"><img...

kaht- 1) I didn't even think about that...but, you're right, I should have did that -- and will add it to this. 2) Sorry about not posting back on those last two, I honestly don't know why I didn't do that. I usually DO conciously try to do that, as I spend lots of hours searching the web and...

Hello List! I need to post this in two posts because of it's size, so please bear with me... I have some questions regarding how to implement a checkbox on my asp page... I have a checkbox on records on a list indicating if it is a 'Valid Exception' -- if the user checks it, it is hidden on...

Hmmm...When I spell it out, I get 10/01/07 returned as my TOP 1. SELECT top 1 RunDate FROM ( SELECT distinct top 100 percent CONVERT(varchar,runDate,1) AS RunDate ,RunDate as Dateorder FROM areaEval ORDER BY Dateorder DESC )sub Returns: 10/01/07 But, the Inner select is working correctly...

Got it.... SELECT top 1 RunDate FROM ( SELECT distinct top 2147483647 CONVERT(varchar,runDate,1) AS RunDate ,RunDate as Dateorder FROM areaEval ORDER BY Dateorder DESC )sub Apparently in MS SQL Server 2005, since you can't use 'TOP 100%', you need to use that crazy number (max number of...

If I want to get the top 1 from the list, how can I do that? SELECT distinct CONVERT(varchar,runDate,1) AS RunDate ,RunDate as Dateorder FROM areaEval ORDER BY Dateorder DESC Returns: 01/01/08 2008-01-01 00:00:00.000 12/01/07 2007-12-01 00:00:00.000 11/01/07 2007-11-01 00:00:00.000 10/01/07...

Thanks for all the replies and help!!! You guys are awesome! SELECT DISTINCT CONVERT(varchar,runDate,1) AS RunDate ,RunDate as Dateorder FROM areaEval ORDER BY Dateorder DESC Works like a charm! Thanks again! -jiggyg

Hello List! I have a question on how to sort a list of dates after using the convert function on it.... Here's my list of dates: SELECT DISTINCT runDate FROM areaEval returns: 2007-11-01 00:00:00.000 2007-10-01 00:00:00.000 2007-09-05 00:00:00.000 2008-01-01 00:00:00.000 2000-01-01...

Hello List! First post in this forum as I'm expanding my skillset! I have a problem that I'm looking for help on... I currently have a submit button that's located on the bottom of my page: if request("type") <> "x" then Response.Write "<tr>" Response.Write "<td colspan=""4""...

Hi gmmastros, Yes; for example, Denver CO, has 4 locations -- At: zoom level 3, I only want to show 1 icon (because they're all on top of each other!); zoom level 5, still probably only 1 icon; zoom level 6, 1, 2, or 3 icons, depending on how close they are; zoom level 8, probably 2 or 3...

Thanks, gmmastros! I'm going to use these values for a new Latitude depending on the zoom level used by the user; if they zoom to level 5, only show the address at the nearest half Latitude, level 3, quarter Latitude, etc. -- we have too many points on the map and are trying to clean them up a...

Hello List! I have a question... I want to round a number to the nearest half -- I tried this: select addID, addLat, dec(round(addLat * 2, 0)/2,11,1) as Nearest_Half from Addresses But, am getting an error msg: Msg 195, Level 15, State 10, Line 2 'dec' is not a recognized built-in...

After working on this some more, I think my issue is getting it to go to the update page and passing parameters to that page (but, don't have a submit button on the first page or anything)... Here's my updateAddress.asp page: <% conn = application("DataConn") set cn =...

Hello List! I have a question on how to handle something... I have one page that gets data from google maps & I want to get these values and then go to another page (updateAddress.asp) where I will do the update. I'm getting the data correctly, but having issues with getting it to go to the...