Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jiggyg
  • Order by date
  1. jiggyg

    Checkboxes - Changing Values??: Part1

    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 =...
  2. jiggyg

    Checkboxes - Changing Values??: Part1

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

    Checkboxes - Changing Values??: Part1

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

    Checkboxes - Changing Values??: Part1

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

    DateTime Convert &amp; OrderBy

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

    DateTime Convert &amp; OrderBy

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

    DateTime Convert &amp; OrderBy

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

    DateTime Convert &amp; OrderBy

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

    DateTime Convert &amp; OrderBy

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

    Setting Button Locations/Functionality

    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""...
  11. jiggyg

    Rounding to Nearest Half, etc.

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

    Rounding to Nearest Half, etc.

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

    Rounding to Nearest Half, etc.

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

    New Page - Parameters/Update DB

    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 =...
  15. jiggyg

    New Page - Parameters/Update DB

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

    If Checkbox Isn't Checked....

    Hi! Got it... one issue was I didn't have parentheses around my condition in my if stmt (duh!) Got it working with this: //if checkbox is not checked, do the capacity check if (document.forms[0].validException.checked == false){ if ( (parseInt(document.forms[0].refurnCapacity.value)) <...
  17. jiggyg

    If Checkbox Isn't Checked....

    Hello List! I have a checkbox on my page; and if the box isn't checked, I want to do a check on my form... Checkbox code: <input type="checkbox" name="validException" value=1 <% if trim(Request.QueryString("validException")) = "YES" then Response.Write " checked" end if %> >...
  18. jiggyg

    2 Combo/Select Boxes

    Hi! I'm wondering how to get two combo boxes to work in conjunction w/ each other.... I have one combo box (filterVal) that IS working correctly; this array has both an id[0] and name[1]: Response.Write "<td>" Response.Write "<select size=""1"" name=""filterVal""...
  19. jiggyg

    2 Combo/Select Boxes

    Hi! I'm wondering how to get two combo boxes to work in conjunction w/ each other.... I have one combo box (filterVal) that IS working correctly; this array has both an id[0] and name[1]: Response.Write "<td>" Response.Write "<select size=""1"" name=""filterVal""...
  20. jiggyg

    Newbie?: Check Value In Dropdown/Select

    hello! I have a question on how to verify the value in select box; if a value isn't selected, I want to do an alert box "Please select count type." I've been told before to post the source, so I hope this is right (apologies if it is not!): <html> <head> <link href='include.css'...

Part and Inventory Search

Back
Top