FW: How do you concatanate two table fields in CFQUERY with MS Access

Well Sandy...I tried that initially but it just didn't work. So I thought I was doing something totally wrong and that Access SQL uses something beside the +. But! Good news! I tried that code in an SQL Statement with nothing else but Select atfname + ' ' + atlname AS Agentname FROM tblagent A

cfmx admin question

Hi All,   After I install the cfmx dev copy on my win98 (yes, it is an old PC), I try to goto cfadmin with no success. I get a 'page can't be displayed'. I do have cfstart.bat running. Is there some xml file which I need to change. I did this before, but no success today. TIA, Patrick Whitti

RE: How do you concatanate two table fields in CFQUERY with MS Access

tblJobSeekers.pverify,tblJobSeekers.jsphone1 [atfname] + " " + [atlname] AS AgentName Looks like you are missing a comma after .jsphone]   _   From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Saturday, May 15, 2004 6:15 AM To: CF-Talk Subject: FW: How do you concatanate two table fields

OT: Need to have a javascript that selectively validates

I have a web form that I need _javascript_ validation for if Session1 is "yes" then field2 and field3 are required.   If session 1 is "no" then field 2 and field3 are not required. Can someone point me in the right direction.  I want to use javascipt because the rest of the form validation is us

Re: cfmx admin question

DO you have a web server running on your system? JIm Louis > Hi All, >    > After I install the cfmx dev copy on my win98 (yes, it is an old PC), > I try to goto cfadmin with no success. I get a 'page can't be > displayed'. I do have > cfstart.bat running. > Is there some xml file which I

Strip multiple words from string

Any suggestions how to strip multiple occurances of a short list (4-8) of words from a string. The first occurance of each word must be preserved at its position. Using CF5. Thanks, Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: OT: Need to have a javascript that selectively validates

Jim, > I have a web form that I need _javascript_ validation for if > Session1 is "yes" then field2 and field3 are required.   > If session 1 is "no" then field 2 and field3 are not required. > > Can someone point me in the right direction.  I want to use javascipt > because the rest of the fo

Re: Strip multiple words from string

H, I think I would use the replace function to first replace the first occurrence of the word by some string unlikely to be found in the text,  like say "%*%*%*", then replace all remaining words by nothing, using "all" , then but back the word at the place %*%*%* is. If you don't have too man