Recent content by ethorn10

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.

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.

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

Might be worth your while to ask in the CMS Forum

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

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

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

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

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

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

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

'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?

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

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

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>