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 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: *

  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?
  16. fergy1

    Select Number from a possible of 3 columns

    Hello- I have an owners table where they have a list of 3 different companies in 3 columns (cnumber, cnumber2, cnumber3). I want my query to search on all 3 columns to find the match for the company they logged in under. How can I do this? So example would be: Select * from owners where...
  17. fergy1

    Math addition

    What happens if ther are null? Will i ignore those? Because not all those fields have to be completed. Just whaatever the do have has to equal 100
  18. fergy1

    Math addition

    I have 6 fields for company ownership. They are decimal fields since an owner can have a fractional ownership of a company. However all 6 fields need to add up to 100 if they dont i need to alert them with my validate script. I have included some alert script i am using already so you can see...
  19. fergy1

    IF and statement

    Even with the bracket no go. It ignores it. The own_auto field is a radio button but it should still see it right? Own_Auto is a text field
  20. fergy1

    IF and statement

    How can I make this statement work? I can get auto count or Own_auto by themselves to work but when i check for both conditions it wont work. I dont get errors just nothing happens? <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function verify() { var themessage = "You are required to complete the...

Part and Inventory Search

Back
Top