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!
-
Congratulations strongm 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
- Content: Threads
- Order by date
-
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...- jiggyg
- Thread
- Replies: 6
- Forum: Javascript
-
DateTime Convert & 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...- jiggyg
- Thread
- Replies: 14
- Forum: Microsoft SQL Server: Programming
-
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""...- jiggyg
- Thread
- Replies: 1
- Forum: HTML, XHTML & CSS
-
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...- jiggyg
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
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...- jiggyg
- Thread
- Replies: 2
- Forum: Javascript
-
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 %> >...- jiggyg
- Thread
- Replies: 1
- Forum: Javascript
-
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""...- jiggyg
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
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""...- jiggyg
- Thread
- Replies: 1
- Forum: Javascript
-
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'...- jiggyg
- Thread
- Replies: 2
- Forum: Javascript
-
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: <html> <head> <link href='include.css' type='text/css' rel='stylesheet'/>...- jiggyg
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Adding Increment Counter To Form Elements
Hello List! Newbie to javascript and have a few questions... I want to number my FormElements to make them unique So, I want the one named 'dupmerows_<tableid>' to be: 'dupmerows_<tableid>_<cnt> So, I'll have a dupmerows_6_1, dupmerows_6_2 And, likewise with my other elements...- jiggyg
- Thread
- Replies: 2
- Forum: Javascript
-
Create Function - Using DECLARE?
Hello! Happy Friday! I have a question....I have some SQL that I want to make into a function; I want to only pass in the String to parse, but get an error for using DECLARE when I try to execute it... Could someone please assist me in how to make this code a function and still only passing...- jiggyg
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Checkbox - Refresh Page?
Hello List! I have an ASP page w/ a checkbox on it for showing 'valid exceptions'....problem is, I'm not sure how to refresh the page after the checkbox is checked (if it is checked, show the records w/ valid exceptions, otherwise, don't show them).... There's no buttons on the page, just a...- jiggyg
- Thread
- Replies: 6
- Forum: Javascript
-
How To Check Checkbox When Page Reloads
Hello List! I have an issue I could use some expertise on.... I have a page that allows the user to click a checkbox to distinguish if the entry is a valid exception --> if yes, saves a '1' to the database.... Now, when I reload the page, I want to have the checkbox checked if the user had...- jiggyg
- Thread
- Replies: 7
- Forum: Javascript
-
Copying Data From One Platform/Database To Another?
Hello Again! I need to copy data from our Staging Platform (STAGESQL01) to the Quality Platform (STAGESQL02)...db name in each is "VEG" and table name is AreaEval... I know I need to do: INSERT INTO AreaEval SELECT * FROM AreaEval Just not sure how to do it using two different platforms...- jiggyg
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Trim/Remove Leading Characters
Hello List! I have a question on how to trim chars off the front of data... I added 'zz_' to the front of all my floor #'s in order to get them to import from Excel to SQL; now, in SQL I want to get rid of them -- How can I do that? For example: In the database, the column is named 'Floor *'...- jiggyg
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Combining Results - How To
Hello List! I have a question on how to combine two result sets... I have two queries that return the same ClientName and the number of each invalid records, and want to combine them into one. For Example: SELECT ClientName, count(LocClientID) AS #ofOccurances FROM...- jiggyg
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Newbie ?: Setting second value based on first value
Hello List! I'm new to JavaScript and am hoping someone out there can help me with an issue I'm having setting a value on a form... I have two fields, 'Current Capacity' and 'Support Capacity' -> If the user inputs a value into the 'Current Capacity' field, I want to set the value of 'Support...- jiggyg
- Thread
- Replies: 5
- Forum: Javascript
-
Inserting Using Results From Function??
Hello! I have an INSERT that I'm trying to write that I could use some input on from experts... I run this function: select * from getInvalidBmkAssignments(153) And, as an example, it returns the following: Record1 LocId: 159937 LocClientID: 153 ClientName: MyClient L6: NULL L5: NULL L4...- jiggyg
- Thread
- Replies: 22
- Forum: Microsoft SQL Server: Programming
-
Problem w/ WHERE clause
Hello List! I have a question on why my result sets aren't returning as I expect... If I run: SELECT * FROM [dbo].[ClientIssues](1,1) WHERE usr_full_name = 'myName' OR usr_full_name = 'yourName' I'm getting the results I expect: only results w/ 'myName' or 'yourName' in the usr_full_name...- jiggyg
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
