Re: Disappearing Single-Quote

Thank you, everyone, for the helpful advice. Ultimately, the solution was to escape every single-quote in the code snippet, as was suggested early on. And this should've been easy enough except that I attempted the REPLACE() inside of the query. Doh! Now, all is good: UPDATE Table SE

Re: Disappearing Single-Quote

and replace every occurence of two > single-quotes. I'm afraid that's just too much to expect of my users. > > > But thank you for the recommendation! > > >Have you tried using the Chr() function and passing in the code for > th

Re: Disappearing Single-Quote

function and passing in the code for them? > >-Jeff > >David Delbridge wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242006 Archives: http://www.houseoffusion.com/cf_lists/t

Re: Disappearing Single-Quote

Nope. Already tried that. No change either way. >PreserveSingleQuotes() > >-- >Jeff > >-Original Message- >From: David Delbridge [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 01, 2006 5:01 PM >To: CF-Talk >Subject: Disappearing Single-Quote >

Disappearing Single-Quote

Hi all, How do I keep CF from interpreting two single-quotes as escaped? I'm storing code snippets into a database and all occurences of "''" are becoming "'" (e.g., "" becomes ""> UPDATE Table SET Field = '#Var#' When queried, the value of Field in Table is "" Any advice is apprecia

Re: Disable CGI Variables?

Thank you, Ian! I'll check out the IIS forums. Dave ps. I see you're in Sac. Next time you're in Tahoe, give me a holler! > CGI variables are generated and provided by the web server not the > ColdFusion server. It would be in IIS and/or Apache or whatever one > is using that this kind of

Re: Disable CGI Variables?

king >skills... Girls only want boyfriends who have great skills." >- Napoleon Dynamite >-Original Message- >From: David Delbridge [mailto:[EMAIL PROTECTED] >Sent: Tuesday, May 30, 2006 2:17 PM >To: CF-Talk >Subject: Disable CGI Variables? > >Hi all, > >Is

Disable CGI Variables?

Hi all, Is there any way to disable or obfuscate the CGI variables on an MX server? More importantly, can this be done PER SITE on a multi-homed MS IIS server? Any advice is greatly appreciated. Dave ~| Message: http://www.ho

Re: Mail Merge Conundrum

>Another approach (not quite so slick I admit) would be for the users to >create the required email (the one to be main merged) as a separate html >file and attach it to the trigger email. That's not a bad idea. I thought about maybe sending the raw SMTP data via CFX_TCP, but this is a little de

Mail Merge Conundrum

Hi all, I'm having difficulties creating a simple mail merge application for a non-profit org. The concept is very simple: - Send an e-mail message from my mail client of choice - Receive message at ColdFusion server (e.g., CFPOP) - Query subscriber database for merge field data - Search-an

Re: need help testing...

Ken, Unless we're talking about cfmail, this is off-topic. That said, it is very likely that your mail server has been blacklisted by AOL. This is very common, even among the most innocent of mail servers. If you've been blacklisted, your mail server's logs will contain a message with a link

Re: New DNS

Assuming Windows, you can use CFExecute and DNSCMD.EXE from the Windows 2000/20003 Support Tools. For example, this code snippet creates a new zone: and this one creates A records: where "Host" is "www", "ftp", etc. I hope this is helpful. Dave Chad McCue wrote: > Does anyon

Re: Server names

You might conclude that Windows has made me cynical: HAL, Terminator, Proteus, Locutious, Vaal, Box Dave Jim Davis wrote: >>- Original Message - >>From: "Kay Smoljak" <[EMAIL PROTECTED]> >>To: "CF-Talk" >>Sent: Tuesday, June 28, 2005 7:02 PM >>Subject: Re: Server names >> >> >> >>>

Re: OT: Podcasting..

On the Windows side of things, I'd recommend Sony Sound Forge. They've released a trimmed down version with price and features probably more in line with podcasting and Internet audio in general. If you need additional audio help on Windows, drop me a private note. Dave Mark A Kruger wrote:

Re: Sandbox vs. CFX

example, it would appear that CFX_Image and CFX_POP3 require access to \lib\. Does this present a new security issue? Dave David Delbridge wrote: > Hi all, > > I've discovered that a couple of CFX tags aren't working on my new MX 7 > server; they produce a "500

Re: Anyone ever heard of not allowing FTP?

Why not simply restrict inbound FTP to trusted IPs at the firewall? You have a static IP, right? Dave Brian Meloche wrote: > I have run into FTP being blocked this several times, including where I am > working now. One unscrupulous developer (someone I used to see post on > CF-Community a lo

Re: CFX_JpegResize caching problem

Do you by any chance have sandbox security enabled? I ask because I too am seeing some problems with image-manipulating CFX tags on MX 7. I noticed that my problems disappear when sandbox security is turned off. ...not that this is a solution; just an observation. I'm still digging. Dave S

Sandbox vs. CFX

Hi all, I've discovered that a couple of CFX tags aren't working on my new MX 7 server; they produce a "500 null" error. If I disable sandbox security outright, the problem disappears. With sandbox security enabled, no combination of file/directory permissions will work. I've even tried "C:

Re: Security Issue?

ted in any way? > > Kevin > > -Original Message----- > From: David Delbridge [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 24, 2005 1:52 PM > To: CF-Talk > Subject: Re: Security Issue? > > > I'm afraid not. The offending characters arrived un

Re: Security Issue?

I'm afraid not. The offending characters arrived unpromted in the URL. Dave Kevin Aebig wrote: > My guess is that you're using CFencrypt on a variable before you pass it > through a query param. Is this the case? > > Kevin > > -Original Message- > From:

Re: Security Issue?

Good point. I do, but then there's a small matter of a few hundred hosting customers Dave Damien McKenna wrote: > Please tell me you are using cfqueryparam? > -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (247-2235) Outside U.S: +1.775-832-2445

Security Issue?

Hi all, Does anybody recognize this URL string pattern (%C2%A0%C2%A0It) as a security exploit? For example: http://www.mywebsite.com/form.cfm?ID=89%C2%A0%C2%A0It It produces the following error in CF: Incorrect syntax near 'Â'. SQL = "select * from DbName where (ID = 89Â Â It)" I've receive

Re: CFX_Zip and Empty Directories

Egads. I didn't realize this limitation of zips. Looks like WinRAR does the trick. I'm off to the races. Thank you!!! Dave Claude Schneegans wrote: > >>Although I haven't verified, it shouldn't have any problem zipping empty > > >>>directories. > > > Since the missing empty directory pr

CFX_Zip and Empty Directories

Hi all, Does anybody know if CFX_Zip can zip empty directories in a recursive operation? I wrote a small application around the tag, only to find that empty directories are all missing from my archives. I hate to redo this thing with cfexecute and command-line zip, but will if I must. Any al

Web Server Configuration Tool

Hi all, Does MX7's "Web Server Configuration Tool" do anything (in IIS) beyond what we used to do manually? I've got scripts that take care of this already and don't know if there is something special going on here in MX 7 that will give me cause to modify or dump them. To my knowledge, all t

Identifying Piggish CF Templates w/ Perfmon

Hi all, Can a JRun thread instance (Win2K PerfMon) be translated to a CF template (or even an IIS virtual server instance)? I am trying to identify a CPU hog, but the usual indicators aren't there (e.g., application.log template timeouts, IIS counters, etc.). Of course, I have isolated the pr

Re: RDS Sandboxing on MX 7?

Rats. Thank you, though. Dave Watts wrote: >>Does MX 7 fix the RDS security issue, whereby RDS users on MX >>6 servers could not be sandboxed? > > > No, I don't think so. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vend

RDS Sandboxing on MX 7?

Does MX 7 fix the RDS security issue, whereby RDS users on MX 6 servers could not be sandboxed? Thanks ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/bann

CF_HappyHolidays

Hi all, Merry Christmas! Happy Hanukkah! Happy Kwanzaa! Happy Bodhi Day (belated, sorry)! Yuletide Greetings! Happy Holidays! Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (247-2235) Outs

Re: mysql and cold fusion WAS: web hosting, sql 2000

Doh!  Timewarp.  Just got your note re change of plans.  Please ignore my previous post.  The Client Tools download is a chubby 332 megabytes anyways.  Don't do it if you don't have to. Enjoy MySQL. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (

Re: SQL 2000 Enterprise Manager WAS: web hosting, sql 2000

Gil, it is freely downloadable.  Check out this FAQ on our website: http://www.circa3k.com/FAQAnswer.cfm?ID=89  It briefly describes the SQL 2000 Client Tools, and provides a link to the download. Enjoy! -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (2

Re: Question regarding CFMX 6.2

> I should maybe get in that program and see if I can get some of these > issues addressed, if they have not been yet. An excellent idea, though participation isn't guaranteed.  I had to raise a fuss in order to get in on the MX beta, despite being a Macromedia Partner and having participated i

Re: Security - Tag restrictions

Rick, Managing Advanced Security on ColdFusion prior to MX is a dismal undertaking.  If I had only one reason to upgrade, security sandboxing would probably be it. That said, I have something that may be helpful to you.  I wrote a document, "ColdFusion 5.0 Advanced Security Field Guide," which

Re: Purchase CFMX?

MVLP = "Macromedia Volume License Program."  Only volume buyers qualify to purchase this item.  Not what you had in mind, I'm guessing. Details here:  http://www.macromedia.com/buy/volume_license/ Frankly, I wish online shops would put all those volume licenses in a special place as they tend t

Re: OT:Anyone ever see this?? SteelArrow?

Yeah.  Why call it "SteelArrow" when they could've instead called the thing "CrustyFriend," "CreepFest," "CanardFoil," etc., etc. and saved us some work? Too obtuse?  How 'bout "ChillyFission?" Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (247-2

Re: CF/Windows question - SYSTEM USER ACCOUNTS?

Yes, I have used it.  Aforementioned security issues aside, it works great.  Simply use CFExecute to call vbscript.exe. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (247-2235) Outside U.S: +1.775-832-2445 James Blaha wrote: > Jochem, > > Thanks

Re: Slightly OT: Hosting AV Files

Unless you also need help with initiating a streaming download from , this is very much off-topic, so I'll throw you some quick pointers and, if you'd like any additional advice, please feel free to drop me a private note. To reach the largest audience, choose one of these AV file formats: Rea

Re: Fancy a ColdFusion Challenge?

Yeah, me too.  ...and I can prove it, because my solution will likely come in dead last if the rest are all influenced by MIT.EDU.  But, it's done and it'll be fun to see how well it measures up.   Hey, guys!  This is a TEST.  Put up or shut up!  ;-> Dave -- David M. Delbridge Circa 3000 Col

Re: CF Hosting

Hi John, >From my perspective, your requirements seem to demand a dedicated server.  As has already been stated, a shared server will not provide access to all CF tags.  [Or, at least, SHOULDN'T.]  A co-located server will typically not be managed, meaning that you are left entirely responsible fo

Re: Access to IIS objects from CFML?

Well, see if I compliment YOU anymore!  ;-> Actually, I suppose I earn the "Doh!" award for the day.  I could have sworn we created that mkwebdir.vbs script from scratch, but apparently modified said sample.  My bad! Thank you for the correction. Dave -- David M. Delbridge Circa 3000 ColdFusi

Re: Access to IIS objects from CFML?

You're absolutely right, Dave.  The hosting customer would need not only access to CFExecute, but would also need to publish a mkwebdir.vbs or similar script as this is NOT included in the Microsoft-provided samples. I suspect that any such custom VBS scripts could be run from the hosting customer

Re: Access to IIS objects from CFML?

Of course, that depends on your host, but typically no, not on a shared hosting server because CFExecute is (should be) secured.  Dedicated servers are typically a different story. I must confess that I am probably misunderstanding your question, because I don't see the need for virtual directorie

Re: Access to IIS objects from CFML?

Hi Vitaly, You can manipulate the IIS metabase by invoking a VBScript with CFExecute, a la: arguments="C:\InetPub\AdminScripts\Circa3000\mkwebdir.vbs -c ""#Arg1#"" -w ""#Arg2#"" -v ""#Arg3#"",""#Arg4#""" timeout="30"> For more help, check out the VBScript samples included with IIS. I hope t

Spaces in MS Access DSNs

Hi all, Has anybody else noticed that MS Access data sources with a space in the name will not function after the MX 6.1 update?  I was surprised by this, having already run the update many, many times.  Meanwhile, MS SQL Server DSNs function perfectly with a space. A search for discussions of th

Re: Subscription verification emails..counted as junk mail?

credit for having a correct IP address in your DNS MX records.  So, your final score was a whopping "-4."  Can't beat it. I hope this is helpful. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 David Delbridge wrote: > > David

Re: Subscription verification emails..counted as junk mail?

David, If you'll send a copy of your confirmation note to my address, I'll tell you which spam tests fail at our mail server.  Please contact me off-list with message title and sender address to look for. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2

Re: Access Windows accounts through CF

Hi Dirk, There are some custom tags available for managing Windows users -- CFX_User (company defunct?), CF_NT_UserDB, CFX_NTUserManager, etc.; all available for download in the Developer's Exchange. If you prefer to roll your own, you can call a VBScript with CFExecute. I hope this is helpful.

Re: Which Authorize.net tag/CFX?

Hi Stas, We have had good experiences with an updated version (see below) of CF_Authorize_Net_3 by Frank Banks, available in the Developer's Exchange.  Tried and true, this includes the collective experience of our staff and hosting customers over several years. Granted, in that time, we have dis

Re: Deleteing a directory

Brob, Look for a custom tag in the Developer's Exchange, called "CF_DeleteDirectory."  Does exactly what Mosh describes, recursively through all files and subs. If you can't find it, give me a holler off-list and I'll send you a copy of the original distribution. Dave -- David M. Delbridge Ci

Re: Previous Row in a table

Does this work for ya? SELECT MAX(ID) FROM XYZ WHERE (ID < #PullInfo.XYZ_ID#) AND (XYZ_SENT = 1) Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 "[EMAIL PROTECTED] [EMAIL PROTECTED]" wrote: > > Hi, > > I'm running a query with a specific row ID. 

Re: SOT: HSphere Control Panel & CF DSN Creation

Hi Hatton, I am sorry to hear about your hosting dilemma. > They can easily create them with the CF Administrator > panel but obviously that's not something they'll open > up to the public. Are you saying that your host refuses to create a DSN for you manually, merely because their choice of con

Re: Directory tag

Check out CF_DirectoryTree or CF_DirectoryExplorer, available in the Developer's Exchange. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 brob wrote: > > Hey guys is there a coldfusion tag that displays the Directory of the > server, that looks li

Re: Mapped drives on server not displaying...why?

Here's an Active Directory approach (and, actually, the non-AD approach is almost identical): Create a domain user, "ColdFusion."   Add 'Domain\ColdFusion' user to your CF server's 'Administrators' group.  Assign this user to the 'ColdFusion Application Server Service' service a la "Log On as:" an

Re: Book to learn MS SQL 2000

For administering a SQL 2000 server, check out "Designing SQL Server 2000 Databases for .net Enterprise Servers."  The title is very misleading, as this book spends far less time on database design as it does on administration.  ...and in that capacity, it covers lots. For SQL programming chops, k

Re: EXECUTING EXTERNAL PROGRAM

Gunny, CFEXECUTE is available in CF 4.5.1.  [Was this a free upgrade for 4.0 users?]  If an upgrade to MX is out of the question right now, perhaps a minor upgrade to 4.5.1 will get you there? I hope this is helpful. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.

Re: 6.1 install causes uername/password prompt

Check out this Macromedia Forum thread: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&threadid=674943 I hope this is helpful. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Lee Ramsey wrote: > > After installing ColdFusio

Re: OT: Comprehensive CGI.http_user_agent values listing?

I particularly like this one: http://www.zytrax.com/tech/web/browser_ids.htm Good organization and documentation. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Pete Ruckelshaus wrote: > > I'm trying to find a fairly comprehensive of browser use

Re: debugging turning itself off

Hi Chris, Yes, I have seen this intermittently after server restarts and have heard from at least three others who have experienced the same thing. Admittedly, I have not dug into this one yet and don't know the specific requirements to duplicate the event on command.  If you nail anything down,

Re: Sorting IP Addresses

@Oct2 > > SET @pos1 = @pos2 + 1 > SET @pos2 = charIndex('.',@test,@pos1) > SET @Oct3 = substring(@test, @pos1,@[EMAIL PROTECTED]) > SET @Oct3 = replicate('0',3-len(@Oct3)) + @Oct3 > > SET @pos1 = @pos2 + 1 > SET @pos2 = len(@test)+1 > SET @Oct4 = sub

Re: Sorting IP Addresses

Thanks, guys.  Unfortunately, everything must happen in the query itself (or at the SQL server) because I'm using a custom tag which takes a raw SQL query as input and spits out the results in a particularly-formatted (and quite attractive) table.  Hence, there is not a place for me to manipulate t

Re: Sorting IP Addresses

SQL 2000 Server. Thanks. Jochem van Dieten wrote: > > David Delbridge wrote: > > > > I have some lengthy tables filled with IP addresses.  Given that the > IP > > addresses are contained in a single text field (and not four > individual > > octet fields), wh

Sorting IP Addresses

Hi all, I have some lengthy tables filled with IP addresses.  Given that the IP addresses are contained in a single text field (and not four individual octet fields), what would be the SIMPLEST way to sort those IPs in a SQL query? For example, 'SELECT IP FROM IP_TABLE ORDER BY IP' produces the f

Re: WAP & CF

Hi Randell, If you're developing a site for PDAs, you might save yourself lots of work by avoiding WAP.  Afterall, a PDA can use a wireless web browser, which is entirely HTML-compliant (minus the usual browser-specific glitches).  You need only produce a web site optimized for those slow connecti

'Enable Debugging' Option Turns Itself Off?

Hi all, Has anybody noticed CF Admin's 'Enable Debugging' option being turned off automatically by a server restart or other action?  I've had a couple of mysterious instances here that I cannot explain, ever since updating to MX 6.1. Any feedback is appreciated. Dave -- David M. Delbridge Ci

Re: IIS Settings from one server to another

Check out Microsoft's IIS Metabase Backup Utility.Dave-- David M. DelbridgeCirca 3000ColdFusion Hostinghttp://www.circa3k.com775-832-2445Eric Dawson wrote:> > Is there a quick way to transfer IIS settings from one server to> another?> (transferring all websites from one box to another.)> > Eric> > 

Re: Retrieving Active Directory User Passwords

To my knowledge, the only way to retrieve passwords from the SAM are with a brute-force tool, like L0phtCrack. No doubt, not what you had in mind. Resetting passwords is, OTOH, quite simple and can be performed from a CF page. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://ww

Re: Change NT password

Hi Jim, To do this, we call a VBScript with CFEXECUTE. If you're interested, I can mail you a copy of our SetUserPassword.vbs script. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 775-832-2445 Jim McAtee wrote: > > Does anyone have a means of allowing a

Re: Running Batch Script

Hi Shahzad, I'm sorry that I didn't see your post sooner -- we use PSEXEC in this manner frequently. The only thing I would add that might be helpful to you is that you might be able to elliminate the batch script altogether: This example presumes that psexec.exe and WLBS (WLBS.exe?) are in C

Re: setting default page for 404 error

Hi Benjamin, If your custom "not found" message comes from a web page, make certain that your HTTP Error message type is "URL," not "File." For example: my 'Error Mapping Properties' for 404 look like this: Error Code: 404 Default Text: Not Found Message Type: URL URL: /404.cfm The Error M

Security Advisory for MS Access Users

Hi all, Security advisories are circulating regarding two newly-discovered security threats to users of Microsoft Access (and other MS apps). ColdFusion developers who regularly exchange MS Access files with their clients or subs should probably install the prescribed patches (and forward this re

Re: How do your ISPs handle CF mappings?

Hi Mauricio, Just to give you another ISP's perspective, we have offerred self-service setup of ColdFusion mappings through our control panel for years. The only "security" limitations enforced by the application are largely common-sense: 1.) Restrict the target of a mapping to the customer's r

Re: OT: NEED HELP WITH SELLING CF TO MAJOR COMPANY

Could a little name-dropping help your sales pitch? Visit Ben Forta's website for an exhaustive list of "Who's Using ColdFusion?" -- BMW, Ford, Sanyo, etc. -- at http://www.forta.com/cf/using/ Best of luck! -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Sean A Cor

Re: Host Headers vs. CGI vars (was "IIS Domain Naming Question")

> >> > >> -Original Message- > >> From: Peter Theobald [mailto:[EMAIL PROTECTED] > >> Sent: Thursday, July 31, 2003 10:48 PM > >> To: CF-Talk > >> Subject: Re: Host Headers vs. CGI vars (was "IIS Domain Naming > >

Re: Host Headers vs. CGI vars (was "IIS Domain Naming Question")

I'm sorry. In rereading my post, I see now that I really wasn't very clear at all. By "host headers vs. CGI vars" I really meant to compare IIS' host header handling to that of a CF script. Are you aware of any voodoo inside IIS that does a better job in directing incoming traffic by host header

Host Headers vs. CGI vars (was "IIS Domain Naming Question")

that does not have a host header will be directed to the > Virtual Server with the Blank Host header. > > Rick > > -Original Message- > From: David Delbridge [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 12:55 AM > To: CF-Talk > Subject: Re: OT: IIS Do

Re: OT: IIS Domain Naming Question

he intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to [EMAIL PROTECTED] > ***

Re: OT: IIS Domain Naming Question

Hi Joshua, Setting up fully-qualified domain names and subdomains is a function of DNS exclusively, not IIS. Are you running your own DNS server? If not, and you need more help, what is the actual domain name? Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com

Dreamweaver MX RDS Backward-Compatibility

Hi all, Is Dreamweaver MX backward-compatible with CF 4.5? A user of mine is reporting failure connecting to a CF 4.5.1 server via RDS. The response is, "Unable to authenticate on RDS server using current security information!" I have verified the connection with Studio 4.5. Unfortunately, be

Re: How to secure CF directories without moving them from wwwroot

Why not simply secure the directory with NTFS permissions? Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com larry wrote: > > Folks: > > I have MX but dont want these visible from the web. How can you secure > them without > moving them to another director

Re: CF and wireless applications

Hi Mike, A couple of months ago, our company released a wireless version of our hosting control panel. Actually, mobile.circa3k.com is a mobile-optimized mirror of our entire website, but the control panel stands out as the most useful feature in that it allows admins to manage their websites, e-

Re: OT: Style sheets & Browsers...

Hi Che, I sometimes use by Chris Sgaraglino (www.ilgm.com) to determine the visitor's browser, version and OS. Create separate style sheets for each specific configuration (AOL.css, MSIE.css, NS.css, etc.) and then call those with the ColdFusion variable returned by . For example:

Re: Need mail app advice

Which mail server software do you employ? Ipswitch's IMail, for example, includes scripting/filtering to do the kinds of things you describe. Would save you quite a bit of effort if your mail server supports this function natively. I don't know if this will fulfill your statistics-gathering requ

Re: CF And Quick Books

Are you merely interested in creating IIF files for import to QuickBooks? I have written a few ColdFusion templates for importing website transactions -- sales, refunds, etc. -- to QuickBooks and will be happy to share if it might help. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting h

Re: trouble with single quotes

Should be: insert into tab_#tabName# #cols# values (#preserveSingleQuotes(vals)#) Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Ray Regno wrote: > > if i do this: > > insert into tab_#tabName# #cols# values (preserveSingleQuotes(#vals#)) > > i get this:

Re: trouble with single quotes

What happens if you double up your single quotes? For example: vals="sq_pat.nextval,#mcn_id#,#foundry#,#package#,#dieconfig#,#productid#,#project_alias#,#technology#,#sirev#,''#comment#'',1,0"> Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Ray Regno wrote:

Re: Table help

Add "width=1" to columns #2 and #3. Remove the width= parameter from column #4. Mind you, a column width of "1" will force line wrapping at every single word, so you might adjust from 1 to something greater as needed by your application. Dave -- David M. Delbridge Circa 3000 ColdFusion Hostin

Re: Emails no longer sent through site

Are you specifying a mail server in your CFMAIL tags? This could explain why your site behaves differently from others on a shared server. If you are in a shared hosting environment, it could also explain why your site's mail stopped working while others kept going -- because the administrator re

Cybercash - Test Mode?

Hi Tony, If you need them, the CFX_CyberCash tag instructions are still posted on our website, at http://www.circa3k.com/CustomTag.cfm?ID=1. According to those docs, these are the values to use for testing: CCPS_HOST = "http://cr.cybercash.com/cgi-bin/"; CYBERCASH_ID = "test-mck" HASH_SECRET =