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 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!
-
Email Validation
This works really well for me in a similar situation. <cfif REFindNoCase("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a-z]{2,3})|(aero|coop|info|museum|name))$", #form.email#) neq 1 > Please enter a valid email address.<br> <a href="javascript:window.close()">Close Window</a>... -
3 related selects using javascript and CF
I'm ready to tear my hair out! Can anybody find why the data in the third dropdown list is not correct? When I dump it, everything is correct. But in the dropdown, it's all wrong. <cfquery name="getAuto" datasource="thisSource"> SELECT TFAutoMake.ID, TFAutoMake.Make, TFAutoModel.MakeID... -
Grouping and adding columns in same table
Don't know why I never got a response on this, but I solved it by doing a query of queries to get just the brand fields, then looped the columnlist and got the values with evaluate(columnlist). Now I just need figure out how to group the values in order to add them to the pre existing values. -
-
Grouping and adding columns in same table
I have scoured the forms but can't quite find an answer to what I need to do. I have a table with 8 brand columns along with the ID and date and closed/open value. I have to add the values in each column (int,1-4) to the results of another pre-existing grouped/ordered table query. I have managed...
