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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fergy1

  1. fergy1

    Converting a string to a decimal point

    Hello- I have an acreage field that has decimals and some with null values. How can i create a search between a value and value without it displaying incorrectly? For example i do a search between .5 acres and 1 acres I dont want 10 acres showing up as well as it does now. So I have this now...
  2. fergy1

    Showing unique columns + Number of rows matching

    You are a stud! Thanks man!
  3. fergy1

    Showing unique columns + Number of rows matching

    George- One more question. should have had this originally but forgot about the merge. I get a Column 'N.CityId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. How can i fix this? <select name="City"><% set cityRst =...
  4. fergy1

    Showing unique columns + Number of rows matching

    that one did it...Thanks!
  5. fergy1

    Showing unique columns + Number of rows matching

    So if i wanted to include city in your example not just listing it would look like this? Select City, ListingID, Count(1) as ListCount from tblListings Group By ListingID Order By City
  6. fergy1

    Showing unique columns + Number of rows matching

    Hello- I want to have a drop down that shows the cities in a listing database and the # of listings for that city in parenthesis next to it. So it would show "New York (5,000)" etc... I have a table called Listings to pull from with a column named city. So how can I do that?
  7. fergy1

    Highlight required fields in variable

    Thanks Guys. My bigger file was checking for 3 different variables not just a value of x. This switched the color for me and stopped on each one as I had a different alert for that. The comment from Dan is good as well. Thanks!
  8. fergy1

    Highlight required fields in variable

    Here is an example simply for testing purposes. <HEAD> <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function verify() { var themessage = "You are required to complete the following fields: "; if (document.form.first.value=="") { themessage = themessage + " - First Name"...
  9. fergy1

    Highlight required fields in variable

    Hello- I had posted something like this prior. However the iteration for each field to be highlighted wont work as in the code it only highlights the first field that was required. How can I put each element into a variable and have the form highlight all of the fields that were required at...
  10. fergy1

    Highlight required fields

    My apologies. the return fasle was in the wrong spot: if (theForm.pr_ny_estimate.value.length < 1) { themessage = themessage + " - Payroll Next year estimate"; theForm.pr_ny_estimate.style.backgroundColor = "#ffff00"; } //alert if fields are empty and cancel form submit if...
  11. fergy1

    Highlight required fields

    Now if I wanted to keep that value through a series of checks and then send them all at once would that be necessary or just leave it like that? For example rather than cal the alert after each one i would compile the fields that needs attention then call the alert. So if...
  12. fergy1

    Highlight required fields

    Hello- What can I add to this to tell the script to highlight the input box in a different color? So it will alert them and change the color of the input box to red if not filled out? if (theForm.pr_ny_estimate.value.length < 1) { alert("Please enter at least 1 characters in the...
  13. fergy1

    Select Number from a possible of 3 columns

    Yes, in asp or php not SQL at least that I have seen. If I had I would have used it...
  14. fergy1

    Select Number from a possible of 3 columns

    It worked. I'm just surprised. I have not seen an OR statement used like that before. Thanks!
  15. fergy1

    Select Number from a possible of 3 columns

    SQL allows for or statements like that on the where clause?
See more

Part and Inventory Search

Back
Top