Re: dedicated coldfusion hosting solutions
take a look at intermedia - Original Message - From: Chris Hamer [EMAIL PROTECTED] To: HoF [EMAIL PROTECTED] Sent: Saturday, July 08, 2000 3:22 AM Subject: dedicated coldfusion hosting solutions Does anyone know of inexpensive, reliable dedicated hosting solutions for coldfusion and ms sql server? I know about fusionfx and virtualscape, not interested in interland, but need to stay under $1500 per month Chris Hamer Web Development ImageServe, Inc. http://www.imageserve.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
First and last day of Month
cfset Startdate=#DateFormat(CreateDate(Year(Now()),Month(Now())-1,01),"dd mm yy")# will give me the first day of June ie the first day of last month. I am struggling to get syntax for the last day of the month. I had thought that getting the first day of this Month then minus one day would be the most obvious but can not seem to get the syntax correct. I have tried using days in month but can not seem to get the syntax correct there. I also need to work in European date format dd mm yy. If you have a date as a variable how do you add or subtract a variable number of days? Any help appreciated. Gordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: First and last day of Month
cfset EndDate = DateFormat(StartDate + DaysInMonth(StartDate) - 1, "dd mm yy") Jim -Original Message- From: Gordon Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Sunday, July 09, 2000 1:48 AM Subject: First and last day of Month cfset Startdate=#DateFormat(CreateDate(Year(Now()),Month(Now())-1,01),"dd mm yy")# will give me the first day of June ie the first day of last month. I am struggling to get syntax for the last day of the month. I had thought that getting the first day of this Month then minus one day would be the most obvious but can not seem to get the syntax correct. I have tried using days in month but can not seem to get the syntax correct there. I also need to work in European date format dd mm yy. If you have a date as a variable how do you add or subtract a variable number of days? Any help appreciated. Gordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Querying a distant Sybase server
Hello, I am trying to send a SQL query from my coldfusion (NT 4) server to a distant server (NT 4)hosting Sybase 11. Is it possible, or does the ColdFusion server have to be on the same machine than the SybaseSQL server ? If it is, how will the code look like ? Is there any declaration to make in the ODBC connections on the cold fusion server machine ? Thanks a lot ! Olivier. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: First and last day of Month
On 7/9/00, Gordon Burns penned:
cfset
Startdate=#DateFormat(CreateDate(Year(Now()),Month(Now())-1,01),"dd mm yy")#
will give me the first day of June ie the first day of last month.
I am struggling to get syntax for the last day of the month.
Try (once startdate is set).
cfset enddate = dateformat(dateadd('D', daysinmonth(startdate) - 1,
startdate),"dd mm yy")
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Please Help me for my interview
Hi! Every one out there I have 6 months experience on ColdFusion4.0. I have made a site like monsterboard.com for job placement. and am preparing for an interview which is my first interview on ColdFusion. I know there are great programmers here on this site . PLEASE TELL ME WHAT TYPE OF QUESTIONS ARE ASKED IN THE INTERVIEW IT WOULD BE GREAT HELP TO ME IF YOU CAN SEND ME SOME QUESTIONS AND IF POSSIBLE WITH ANSWERS. THANKS IN ADVANCE Shally --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Search on Allaire Site
Man, I sent this message on FRIDAY early afternoon. Here it comes again! - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 07, 2000 1:23 PM Subject: Search on Allaire Site Has anybody tried to search the Allaire site lately. It's not a pretty site .. . . . == Error Occurred While Processing Request Error Diagnostic Information Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100 The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESEARCH.CFM. Date/Time: 07/07/00 13:21:29 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 132.235.8.189 HTTP Referer: http://www.allaire.com/search/index.cfm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: LessWhiteSpace
Thanks, I know, but it's not what I asked. At 05:44 PM 07/07/2000 +0100, you wrote: Erm, why not do it the proper way and remove your blank lines from the code? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Using ReplaceNoCase with a quote in the string
Hi All, I am trying to replace some text that has a quote already in it. ReplaceNoCase trips up on the quote and throws an error. I've tried escaping the quote, or placing a "\" in front of it, but I must have the syntax wrong. Can this be done? My code is below. Thanks in advance for you help! CFSET PAGE= REPLACENOCASE(CFHTTP.FILECONTENT, "A HREF="http://www.blah.com", "go to A HREF="http://www.blah.com", "all") Regards, Andrew __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Please Help me for my interview
I have made a site like monsterboard.com for job placement. What's the URL for the site? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HTML in MSSQL
Dear All, I have some data in a HTML Table I want to insert this information into MS SQL Server. What is the best way of doing this ? From Rif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Please Help me for my interview
http://www.teamallaire.com/hal/cfquiz.cfm This exact quiz has been asked on almost every single interview I've ever been on. Fred - Original Message - From: "Shally Kon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 09, 2000 7:23 AM Subject: Please Help me for my interview Hi! Every one out there I have 6 months experience on ColdFusion4.0. I have made a site like monsterboard.com for job placement. and am preparing for an interview which is my first interview on ColdFusion. I know there are great programmers here on this site . PLEASE TELL ME WHAT TYPE OF QUESTIONS ARE ASKED IN THE INTERVIEW IT WOULD BE GREAT HELP TO ME IF YOU CAN SEND ME SOME QUESTIONS AND IF POSSIBLE WITH ANSWERS. THANKS IN ADVANCE Shally --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: LessWhiteSpace
Please excuse me, but I missed the original post here... I'm going to presume you were asking about all the white space in the CFML pages... and how to reduce it... if not, then I'm sorry!! If you are using CF Server 4.5, then you can use the CFSETTING Tag, and set the ENABLECFOUTPUTONLY parameter (at least that's what I think it is, from memory).. if you put this around code in the page, it will only output stuff that is between the CFOUTPUT tags.. can be quite handy in loops to reduce all the white space. This is a way of controlling the white space for individual pages, I believe there is a similar setting in the CF administrator for setting the option globally. Have a play with it, but it can significantly reduce the amount of whitespace. Please forgive me for butting in if I am way off the mark from the original post! Nick From: stäs [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 09 Jul 2000 09:07:25 -0400 To: [EMAIL PROTECTED] Subject: RE: LessWhiteSpace Thanks, I know, but it's not what I asked. At 05:44 PM 07/07/2000 +0100, you wrote: Erm, why not do it the proper way and remove your blank lines from the code? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IIS 5 problem can anybody help
Executive summary: installing CF on Win2K breaks ASP's ADO, and sometimes* only a disk reformat will cure it. The problem with executive summaries is that they don't have enough information to act upon. So here's a little more information. Installing any version of CF prior to 4.5.1 on Win2K replaces components in MDAC 2.5 with components from MDAC 2.1. On NT, you can upgrade MDAC separately from the operating system, but in Win2K, MDAC is an integrated OS component. You can fix Win2K by simply reinserting the Win2K install CD, and selecting "Upgrade your operating system", after which you'll have to reinstall any third-party device drivers you're using. You can check your version of MDAC by downloading the Component Checker from http://www.microsoft.com/data/. You can use this to make sure that everything worked out OK. If you only installed CF 4.5.1, that shouldn't break your MDAC. Again, though, you can use Component Checker to find out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Using ReplaceNoCase with a quote in the string
I am trying to replace some text that has a quote
already in it. ReplaceNoCase trips up on the quote and
throws an error. I've tried escaping the quote, or
placing a "\" in front of it, but I must have the
syntax wrong.
In CF you escape special characters (" and #) by doubling them up.
Try
CFSET PAGE=
REPLACENOCASE(CFHTTP.FILECONTENT,
"A HREF=""http://www.blah.com"",
"go to A HREF=""http://www.blah.com"",
"all")
Regards,
Seth Petry-Johnson
Argo Enterprise and Associates
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: First and last day of Month
take the first day of the next month and subtract one day. From: Gordon Burns [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: First and last day of Month Date: Sun, 09 Jul 2000 08:07:19 +0100 cfset Startdate=#DateFormat(CreateDate(Year(Now()),Month(Now())-1,01),"dd mm yy")# will give me the first day of June ie the first day of last month. I am struggling to get syntax for the last day of the month. I had thought that getting the first day of this Month then minus one day would be the most obvious but can not seem to get the syntax correct. I have tried using days in month but can not seem to get the syntax correct there. I also need to work in European date format dd mm yy. If you have a date as a variable how do you add or subtract a variable number of days? Any help appreciated. Gordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(Admin) Re: List wierdness ... again
We had a really bad series of bouncebacks that caused some routing issues with the list. Rather than let the problem persist, I removed all the email from the spool and let it run 'fresh'. Last night I returned all the removed email so it wouldn't lose anything. The result was a few duplicate messages for some people and a delay for the messages in question. It's all fixed and working well now. Sorry for the inconvenience. I just love my e-mail program's feature: 'Kill duplicates' Wednesday, June 14, 2000, 2:43:20 PM, you wrote: I am starting to randomly recieve multiple copies of postings ... sometimes days apart. I have looked at the headers in all cases and the messages are exactly the same ... content, sender, date/time sent, everything. What the heck is going on? Is Mike running a 'proper' listserver or some homegrown CF app? Steve -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using ReplaceNoCase with a quote in the string
try this CFSET PAGE= REPLACENOCASE(CFHTTP.FILECONTENT, 'A HREF="http://www.blah.com', 'go to A HREF="http://www.blah.com', "all") Kalyan Vemula Web Developer STONEAGE.COM Voice: (800)786-6324 x149 Email: [EMAIL PROTECTED] http://www.stoneage.com -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 9:31 AM To: [EMAIL PROTECTED] Subject: Using ReplaceNoCase with a quote in the string Hi All, I am trying to replace some text that has a quote already in it. ReplaceNoCase trips up on the quote and throws an error. I've tried escaping the quote, or placing a "\" in front of it, but I must have the syntax wrong. Can this be done? My code is below. Thanks in advance for you help! CFSET PAGE= REPLACENOCASE(CFHTTP.FILECONTENT, "A HREF="http://www.blah.com", "go to A HREF="http://www.blah.com", "all") Regards, Andrew __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Please Help me for my interview
hi! Ken The site is still underconstruction Shally --Original Message-- From: "Ken Wilson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: July 9, 2000 1:51:35 PM GMT Subject: RE: Please Help me for my interview I have made a site like monsterboard.com for job placement. What's the URL for the site? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to Initialize a Cookie in an A tag
This is a multi-part message in MIME format. --=_NextPart_000_0009_01BFE9C0.CAD96260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, What is the syntax for initializing and cookie in an A tag? In the = following instruction "Cookie.Type_Ins" is a cookie, obviously. But does = not contain the contents of "Ins=3DType" when it gets to P07. Any = suggestions? TIA. A HREF=3D"CVS3WP07.cfm?#Cookie.Type_Ins#=3D#Ins_Type#"#Ins_Type#/A = #Agent_Name# #Comp_Name# #POC_Name# #Comp_PH# #comp_Fax# Regards, Paige --=_NextPart_000_0009_01BFE9C0.CAD96260 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2What is the syntax for initializing and = cookie in=20 an A tag? In the following instruction "Cookie.Type_Ins" is a cookie, = obviously.=20 But does not contain the contents of "Ins=3DType" when it gets to = P07.nbsp;Any=20 suggestions? TIA./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial=20 size=3D2Anbsp;nbsp;HREF=3D"CVS3WP07.cfm?#Cookie.Type_Ins#=3D#Ins_Type#= "gt;#Ins_Type#lt;/Agt;nbsp;nbsp;nbsp;nbsp;=20 nbsp;#Agent_Name# #Comp_Name# #POC_Name# #Comp_PH# = #comp_Fax#/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Paige/FONT/DIV/BODY/HTML --=_NextPart_000_0009_01BFE9C0.CAD96260-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (Admin) Re: List wierdness ... again
Hello Michael, I like to take the opportunity and thank you for your great work keeping this list up and running for the CF-Community. For my part I am really glad that this list exists and haven't really encountered a bit inconvenience. I hardly noticed that there are troubles now and then;-)) This comes with the enormous traffic this list has, and it is running, and running and running. Thanks to you! Birgit Sunday, July 09, 2000, 12:04:46 PM, you wrote: We had a really bad series of bouncebacks that caused some routing issues with the list. Rather than let the problem persist, I removed all the email from the spool and let it run 'fresh'. Last night I returned all the removed email so it wouldn't lose anything. The result was a few duplicate messages for some people and a delay for the messages in question. It's all fixed and working well now. Sorry for the inconvenience. I just love my e-mail program's feature: 'Kill duplicates' Wednesday, June 14, 2000, 2:43:20 PM, you wrote: I am starting to randomly recieve multiple copies of postings ... sometimes days apart. I have looked at the headers in all cases and the messages are exactly the same ... content, sender, date/time sent, everything. What the heck is going on? Is Mike running a 'proper' listserver or some homegrown CF app? Steve -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire Certification Program
Having been in Data Processing for over 23 years, I have found that certification programs are basically a management CYA. Generally if the project manager (or other person doing the hiring) was not technical he would use a certification as his first level (and probably only) level of screening. If the person did not work out, you could not blame the manager ... after all the person was "Certified". Just a MS certification is becoming a "screening tool" and also a easy revenue generator for MS at 100 dollars a pop, so Has Allaire followed suit. For contract work I guess I will just have to buckle down and Memorize some tags. Hank West eDataShare [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML in MSSQL
There are many ways to do this but you must first be able to pass the info which is usually done with a form then run a simple insert statement in a cfquery tag. You must also be sure to have an ODBC connection to the database. This is very high level, would need a little more specifics to help further. Thanks, Robert Filipovich - Original Message - From: "Rif Kiamil" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 09, 2000 9:40 AM Subject: HTML in MSSQL Dear All, I have some data in a HTML Table I want to insert this information into MS SQL Server. What is the best way of doing this ? From Rif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Querying a distant Sybase server
You will need to be able to connect tot he distant machine via ODBC DSN. Once you have this you can go to the CF administrator and verify the connection. Cold Fusion just requires an ODBC connection to pass the SQL command to the database. If you need help creating an ODBC connection that's a different discussion, but I would be happy to help. I hope this helps, if you need more assistance just let me know. Thanks, Robert Filipovich - Original Message - From: "CFTALK" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 09, 2000 4:36 AM Subject: Querying a distant Sybase server Hello, I am trying to send a SQL query from my coldfusion (NT 4) server to a distant server (NT 4)hosting Sybase 11. Is it possible, or does the ColdFusion server have to be on the same machine than the SybaseSQL server ? If it is, how will the code look like ? Is there any declaration to make in the ODBC connections on the cold fusion server machine ? Thanks a lot ! Olivier. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spaces
TA! Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 July 2000 10:11:PM To: [EMAIL PROTECTED] Subject: RE: Spaces Kevin; I believe that you have to type all inside your last pair of quotes in order to replace ALL of the spaces. Your code should like this: #Replace(CompanyName, " ", "ALL")# Hope this helps H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:36 PM To: CF Talk (E-mail) Subject: Spaces I'm trying to strip blank spaces from inside a string but am having no luck. I tried this but no joy. #Replace(CompanyName, " ", "")# Any clues please? Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Need to take several row query and make into one row.
Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need to take several row query and make into one row.
I'm not 100% sure what you're asking, but how about this: cfquery name="getseminars" select * from MyTable where MyVar='SeminarsFor' /cfquery cfoutput The name of your seminar is: #valuelist(getseminars.MyValue)br /cfoutput This will return all the seminars as a comma delimited list. David Cummins Systems Developer Ubiquity Software Ltd Rick Moon wrote: Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RDS password
I'm working locally and all of a sudden I keep getting asked for the RDS password. I've restarted the PC but it still keeps happening. Any clues please? Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need to take several row query and make into one row.
David, Thank you for the attempt to understand the challenge at hand. ValueList is a clever attempted work around, except I won't be able to use a "where" statement in the query. Every MyVar needs to be available at once. Questions attempting clarification of the problem are encouraged and so are solutions :-) Rick - Original Message - From: "David Cummins" [EMAIL PROTECTED] cfquery name="getseminars" select * from MyTable where MyVar='SeminarsFor' /cfquery cfoutput The name of your seminar is: #valuelist(getseminars.MyValue)br /cfoutput This will return all the seminars as a comma delimited list. David Cummins Systems Developer Ubiquity Software Ltd Rick Moon wrote: Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Search on Allaire Site
It has been down all week. I think is a hold over from the Allaire Corporate Move. Thanks, David Sparkman -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 12:23 PM To: CF-Talk Subject: Search on Allaire Site Has anybody tried to search the Allaire site lately. It's not a pretty site . . . . == Error Occurred While Processing Request Error Diagnostic Information Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100 The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESEARCH.CFM. Date/Time: 07/07/00 13:21:29 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 132.235.8.189 HTTP Referer: http://www.allaire.com/search/index.cfm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Search on Allaire Site
Do they really have their website in the corporate offices? I didn't think too many people did that. Maybe I'm just spoiled, but all of the companies I've worked at since 96 have had their sites off site. Even so, how would a move affect the search capabilities?! -Original Message- From: David Sparkman [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 11:14 PM To: [EMAIL PROTECTED] Subject: RE: Search on Allaire Site It has been down all week. I think is a hold over from the Allaire Corporate Move. Thanks, David Sparkman -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 12:23 PM To: CF-Talk Subject: Search on Allaire Site Has anybody tried to search the Allaire site lately. It's not a pretty site . . . . == Error Occurred While Processing Request Error Diagnostic Information Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100 The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (28:1) to (31:57) in the template file D:\WWWROOT\ALLAIREWEB65\CUSTOMTAGSV65\ALLAIREWEB\SITESEARCH\SITESEARCH.CFM. Date/Time: 07/07/00 13:21:29 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT) Remote Address: 132.235.8.189 HTTP Referer: http://www.allaire.com/search/index.cfm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (Admin) Re: List wierdness ... again
Hi Michael, I would also like to add my thanks for your great efforts with the cf-talk list. It has been an invaluable resource to me over the last six months, and I'm sure to many others for much longer than that. Thanks also to everyone who spends even a small amount their time answering the questions posed by us newbies, I know your time is valuable and I certainly appreciate it. What small problems there have been are *more* than compensated for by the value of the list; the service, the content and what seems to me to be a great sense of community and tolerance. Well done. Many many thanks. Brett Payne-Rhodes B) Michael Dinowitz wrote: We had a really bad series of bouncebacks that caused some routing issues with the list. Rather than let the problem persist, I removed all the email from the spool and let it run 'fresh'. Last night I returned all the removed email so it wouldn't lose anything. The result was a few duplicate messages for some people and a delay for the messages in question. It's all fixed and working well now. Sorry for the inconvenience. I just love my e-mail program's feature: 'Kill duplicates' Wednesday, June 14, 2000, 2:43:20 PM, you wrote: I am starting to randomly recieve multiple copies of postings ... sometimes days apart. I have looked at the headers in all cases and the messages are exactly the same ... content, sender, date/time sent, everything. What the heck is going on? Is Mike running a 'proper' listserver or some homegrown CF app? Steve -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Allaire Dev Exchange Problems
Sorry if this is out-of-normal-list range, but is anyone else having problems logging into Allaire's Developer Exchange? I can't get a reply back from them. Joshua P Starr President Creative Director, Ælana Evenings (719) 268-1588 Day (719) 310-3030 Email: [EMAIL PROTECTED] Please visit us on the web at http://www.aelana.com or contact me on AOL Instant Messenger at AelanaWeb -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: JavaScript and CF
script language="javascript"
var x = "Superman";
document.write("cfset y = "+x+"");
/script
This won't actually do anything in CF. If you need to pass a variable from
the browser (including from JavaScript), you'll have to send it back in an
HTTP request. You can do that with JavaScript using the location object or
by programmatically submitting a form.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Sessions Count
This is a multi-part message in MIME format. --=_NextPart_000_0005_01BFEA6F.84B3AB60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, Is there a way to count the number of current active sessions in CF 4.5? Thank you and regards David --=_NextPart_000_0005_01BFEA6F.84B3AB60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Is there a way to count the number of = current=20 active sessions in CF 4.5?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thank you and regards/FONT/DIV DIVFONT face=3DArial size=3D2David/FONT/DIV/BODY/HTML --=_NextPart_000_0005_01BFEA6F.84B3AB60-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Sessions Count
--F50DDADF3BBE17F1586915AF Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit David, Have a look in the developer exchange (tag gallery) for a tagset called sessionmagic, its very very good. Jared Clinton. ObjectMastery. David wrote: This is a multi-part message in MIME format. --=_NextPart_000_0005_01BFEA6F.84B3AB60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, Is there a way to count the number of current active sessions in CF 4.5? Thank you and regards David --=_NextPart_000_0005_01BFEA6F.84B3AB60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Is there a way to count the number of = current=20 active sessions in CF 4.5?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thank you and regards/FONT/DIV DIVFONT face=3DArial size=3D2David/FONT/DIV/BODY/HTML --=_NextPart_000_0005_01BFEA6F.84B3AB60-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --F50DDADF3BBE17F1586915AF Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html David, pHave a look in the developer exchange (tag gallery) for a tagset called sessionmagic, its very very good. pJared Clinton. brObjectMastery. pDavid wrote: blockquote TYPE=CITEThis is a multi-part message in MIME format. p--=_NextPart_000_0005_01BFEA6F.84B3AB60 brContent-Type: text/plain; brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; charset="iso-8859-1" brContent-Transfer-Encoding: quoted-printable pHi all, pIs there a way to count the number of current active sessions in CF 4.5? pThank you and regards brDavid p--=_NextPart_000_0005_01BFEA6F.84B3AB60 brContent-Type: text/html; brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; charset="iso-8859-1" brContent-Transfer-Encoding: quoted-printable plt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" brlt;HTMLlt;HEAD brlt;META content=3D"text/html; charset=3Diso-8859-1" = brhttp-equiv=3DContent-Type brlt;META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR brlt;STYLElt;/STYLE brlt;/HEAD brlt;BODY bgColor=3D#ff brlt;DIVlt;FONT face=3DArial size=3D2Hi all,lt;/FONTlt;/DIV brlt;DIVamp;nbsp;lt;/DIV brlt;DIVlt;FONT face=3DArial size=3D2Is there a way to count the number of = brcurrent=20 bractive sessions in CF 4.5?lt;/FONTlt;/DIV brlt;DIVamp;nbsp;lt;/DIV brlt;DIVlt;FONT face=3DArial size=3D2Thank you and regardslt;/FONTlt;/DIV brlt;DIVlt;FONT face=3DArial size=3D2Davidlt;/FONTlt;/DIVlt;/BODYlt;/HTML p--=_NextPart_000_0005_01BFEA6F.84B3AB60-- p-- brArchives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://www.mail-archive.com/cf-talk@houseoffusion.com//a brTo Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body./blockquote /html --F50DDADF3BBE17F1586915AF-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: escaping apostrophes for database insertion.
it works fine on my pc.
Pavan Kumar Puli
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au
- Original Message -
From: Sean Renet [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 07, 2000 11:18 AM
Subject: escaping apostrophes for database insertion.
Lets say I have a variable called message.
Message looks like:
cfset message = "I can't make it today"
I want to input it into a database:
cfquery name="myquery" ...
insert into mytable(MESSAGE_MEM)
values('#trim(Message)#')
/cfquery
Because CF thinks the apostrophe in "can't" is closing the inserting
variable I get this error.
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax
near 't'.
What is the trick for escaping the apostrophe?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Browser Header Strings
Does anyone know where there's a good complete list of browser header strings? I need to restrict access, as reliably as possible, to Win95/98/2000/NT4+ browsers. I don't know where there's a list of these, but all of the ones I've seen include information about the operating system, and you can find that info by just looking for "Win" and 95/98/NT. Here are some examples from my machine: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Mozilla/4.7 [en] (WinNT; U) Mozilla/3.04 (WinNT; I) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: verity and meta tags
Is there a way to index META tags with CFindex? If you're indexing static pages, and those pages contain META tags, then you're indexing META tags. If you're dynamically generating the contents of META tags from a database query, you can index the contents of the pertinent database tables by building a query to retrieve all the tags, and indexing that query. If you want to ONLY index META tags, that's probably the route you'd take. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OLEDB Date type
Im trying to convert some existing access apps from using ODBC
to OLEDB, only theres an issue with the ODBC date format ( {ts
'2000-07-06 14:34:00} ). How do I properly escape/format a date/time
value in an OLEDB query?
OLEDB doesn't use ODBC date formats, as you've discovered. I think you'll
have to use the format native to the specific database you're using. I don't
know the native Access format, but I think it's something like this:
'18-Oct-1999 14:23:32'
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Browser Header Strings
--7EA253C76501B2C6A73DA6EE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How about inspecting the browscaps.ini file on your IIS installation? Dave Watts wrote: Does anyone know where there's a good complete list of browser header strings? I need to restrict access, as reliably as possible, to Win95/98/2000/NT4+ browsers. I don't know where there's a list of these, but all of the ones I've seen include information about the operating system, and you can find that info by just looking for "Win" and 95/98/NT. Here are some examples from my machine: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Mozilla/4.7 [en] (WinNT; U) Mozilla/3.04 (WinNT; I) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --7EA253C76501B2C6A73DA6EE Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html How about inspecting the browscaps.ini file on your IIS installation? pDave Watts wrote: blockquote TYPE=CITE Does anyone know where there's a good complete list of br browser header strings? br br I need to restrict access, as reliably as possible, to br Win95/98/2000/NT4+ browsers. pI don't know where there's a list of these, but all of the ones I've seen brinclude information about the operating system, and you can find that info brby just looking for "Win" and 95/98/NT. Here are some examples from my brmachine: pMozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) brMozilla/4.7 [en] (WinNT; U) brMozilla/3.04 (WinNT; I) pDave Watts, CTO, Fig Leaf Software bra href="http://www.figleaf.com/"http://www.figleaf.com//a brvoice: (202) 797-5496 brfax: (202) 797-5444 p-- brArchives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://www.mail-archive.com/cf-talk@houseoffusion.com//a brTo Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body./blockquote /html --7EA253C76501B2C6A73DA6EE-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: oracle timestamps
Try wrapping the NOW() variable with a CREATEODBCDATETIME function. You don't have to do this - Now() returns an ODBC timestamp value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT:Single Server vs. Cluster Comparison
Anyone ever implement a SQL Server cluster that's controlled by CF? That is, CF can determine if a SQL Server is down and direct queries away from the failed server. I don't think you'd want to do this. The purpose of clustering servers is to provide a single unified resource from an external viewpoint. For example, with clustered web servers, a user doesn't pick one cluster member specifically, he just type in "www.whatever.com" and the cluster figures out how to direct him. Likewise, with a database cluster, the fact that there are actually multiple database servers should be unimportant to the application server using that database cluster. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Browser Header Strings
How about inspecting the browscaps.ini file on your IIS installation? Yes, that'd be fine. I didn't even think of that. Of course, in the end, I'd still just search for "Win", etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
