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 derfloh 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. ethorn10

    response redirect path problem

    I think when you dim a variable like that, it is by default "false." And since you have: Else validaionOK=true you'll notice the variable is misspelled and therefore the check will never see validationOK as true. So you'll always end up at the error page.
  2. ethorn10

    response redirect path problem

    You've set a variable here: EMailAddress = Trim(Request.Form("Email")) And then tested it here using a different variable name: ElseIf (Trim(Email)="") Then I'd suggest trying: ElseIf (Trim(EMailAddress)="") Then See if that helps the validation process.
  3. ethorn10

    Data Not Displaying with Update Statement

    In your create table statement for #finalnumbers you never defined fields called TempsThirteenWeekAvg or BudgetTempsThirteenWeekAvg.
  4. ethorn10

    CMS vendor

    Might be worth your while to ask in the CMS Forum
  5. ethorn10

    'select as' and 'WHERE'

    Fire off the real example, if you can and I'm sure somebody can help make it work.
  6. ethorn10

    'select as' and 'WHERE'

    Pretty sure you can't use the alias in your where clause. Try: select field1 AS test FROM tbl_test WHERE field1 > 5;
  7. ethorn10

    embed a query in a query?

    Try removing the word 'table' from your query... update requests set listid = (select listid from lists where listname = 'blacklisted') WHERE requestid = 89;
  8. ethorn10

    login page response.redirect fails

    What does the error page say? Does "anotherpage.asp" exist? Also, I'd recommend checking for valid user and changing strTargetURL if it fails. Then you can clean up your recordsets and connections before redirecting. Example: strTargetURL = Session("strTargetURL") strUserId =...
  9. ethorn10

    Help with programming code.

    It's free. Just show appreciation for help by marking a post "valuable." (see that little link below each post?)
  10. ethorn10

    Two table join query

    What about: SELECT team_id, SUM(goals + behinds) AS 'Scoring Shots', SUM(kicks + handballs) AS 'Disposals' FROM AFLScore INNER JOIN AFLPlayerStats ON AFLPlayerStats.aflgame_id=AFLScore.aflgame_id AND AFLPlayerStats.team_id=AFLScore.team_id GROUP BY team_id If this doesn't give...
  11. ethorn10

    MySQL Query Help Needed * Please Help

    The only way I can think to accomplish this is with a FULL OUTER JOIN. Somebody can probably make this better/faster/more_efficient: select case when a.ip_addr = b.ip_addr then concat_ws('-', cast(a.ip_addr as char), 'BOTH') else '' end as BOTH, case when a.ip_addr is null then...
  12. ethorn10

    MySQL Query Help Needed * Please Help

    'a' in that case is an alias for table1. You'll notice in the from clause I said 'table1 as a' and 'table2 as b'. Feel free to make it whatever you like, or remove the alias altogether. Did either of those work for you? Which one were you preferring?
  13. ethorn10

    MySQL Query Help Needed * Please Help

    select a.IP_Addr , concat_ws(' ', a.Tool, b.Tool) as Tool from table1 as a inner join table2 as b on a.IP_Addr = b.IP_Addr Or if you want 3 columns select a.IP_Addr , a.Tool as Tool1 , b.Tool as Tool2 from table1 as a inner join table2 as b on a.IP_Addr = b.IP_Addr
  14. ethorn10

    MySQL Query Help Needed * Please Help

    Will it always be EITHER Tool#1 or Tool#2? Meaning, if Tool#2 has a value, then Tool#1 in that same table won't have a value? Or could both tables have both Tool#1 and Tool#2 values? So if your data was: Table 1 IP_Addr Tool#1 Tool#2 xx.xx.11 XY P Table 2 IP_Addr...
  15. ethorn10

    Form Input

    See if this fixes it for you. <asp:RangeValidator ID="rentRangeValidator1" runat="server" ControlToValidate="rentTextBox" ErrorMessage="Enter rent between $100 & $2500" MaximumValue="2500" MinimumValue="100" Type="Currency">*</asp:RangeValidator>
  16. ethorn10

    ForeignKeyConstraint issues

    Well...see this is where I wasn't sure how to word the "question" (more like a scenario). I was under the impression the DataRow.Delete() doesn't actually delete from the database, but rather flags the items in the dataset for deletion. So the code calls the DataRow.Delete() and then begins...
  17. ethorn10

    ForeignKeyConstraint issues

    Unfortunately, I don't have any code at hand to post (it's on the dev system) but I have a question for you experts. First things first, c# and a strongly-typed dataset to an Access database. Anyway, I'm getting the error: ForeignKeyConstraint <Name_of_constraint> requires the child key...
  18. ethorn10

    Update field based on join

    Glad I could help.
  19. ethorn10

    Update field based on join

    Move that last where clause inside the parens. UPDATE message_recipient SET is_email_sent = '1' WHERE EXISTS ( SELECT * FROM user_message INNER JOIN message_recipient ON message_recipient.message_guid = user_message.guid WHERE user_message.date_sent < '8/3/2008' )
  20. ethorn10

    update record if field is null, else insert

    INSTEAD OF trigger. ousoonerjoe provided a link.

Part and Inventory Search

Back
Top