cfloop question

I need to send a personalized letter to a list of recipients. Is there a way to set it up so it can also insert the corresponding 'first name' variable also? cfset recipients_email=[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] cfloop list=#recipients_email# index=recipient

RE: cfloop question

forget, query objects don't have to come from a database. You can build one with querynew() etc if you want to hard-code the addresses like your example shows. ~Brad -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 6:40 PM To: CF-Talk Subject

cf to pdf

For output of cf to pdf what would you recommend? I need to pass form input to 50 different letters and then save them as one pdf file. TIA No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.7/1283 - Release Date: 2/16/2008 2:16 PM

cfmail recommendation

Need to allow visitors to a site the ability to send a unique personalized email to 30 different recipients from one form entry. Can you recommend a method or set of code for sale that can do this? thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 /

SQL 2005 and CF problem suggestion

Anyone have a work around for this problem. Is there a way to write a query different versus doing something on the cf admin side? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is

SOT- SQL Server Management Studio

Need to remotely connect to sql server 2005, any good alternatives to ms management studio? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial

RE: SOT- SQL Server Management Studio

then Object Explorer, put in the sql server address and login. John [EMAIL PROTECTED] -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 1:57 PM To: CF-Talk Subject: SOT- SQL Server Management Studio Need to remotely connect to sql server 2005, any

RE: SOT- SQL Server Management Studio

that is free and works pretty well IMO. Check the MS site. On 7/16/07, Steve Kahn [EMAIL PROTECTED] wrote: Client doesn't have SSMS - need cheap or free way to connect. -Original Message- From: John Mason [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 2:04 PM To: CF-Talk

cfdecrypt - no longer?

Does anyone know where matt's cfdecrypt is set up. I have an old template that I encrypted and now want to open up. Thanks ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial

RE: cfdecrypt - no longer? - solved

search found another tool that will do the job. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  8676 4223 Mobile: 0404 998 273 -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Friday, 8 June 2007 2:22 PM To: CF-Talk Subject

Form Encryption

Good Morning Does anyone have an easy to use 'Form Encryption' app they could recommend? TIA ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2

RE: Form Encryption

Encryption On Wednesday 06 Jun 2007, Steve Kahn wrote: Does anyone have an easy to use 'Form Encryption' app they could recommend? With the aim of doing what ? And since you mention 'encryption' - against what sort of an attacker ? -- Tom Chiverton Helping to heterogeneously disintermediate total

RE: Form Encryption

of the pie you should have! -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 11:59 AM To: CF-Talk Subject: RE: Form Encryption protect credit card and personal info; when the visitor submits form data at site and when the company employee logs

RE: Form Encryption

Very good points across the board. Technically, I do not need to store the credit card info in the db. However I do need to securely send/pass/or make available the credit card info to the receiving company. Maybe there is a better method to do so. Steve -Original Message- From: Matt

SOT - Passing Credit Card info w/o storing in DB

Does anyone know if this can be done or have suggestions to a better method? Securely passing credit card info entered into a form to a recipient without storing it in a database? TIA ~| ColdFusion MX7 by Adobe®

Anyone used Innovative Merchant Gateways Coldfusion API

Does anyone have experience with integrating innovative gateways coldfusion api - please contact me off list. Thanks Steve ~| ColdFusion 8 beta –

We need a reservation application (Buy or Hire)

We are looking to purchase a reservation application (travel based) or hire someone who has had experience making one. Please contact me off list if you can be of assistance. Thanks ~| Introducing the Fusion Authority Quarterly

SiteDirector users

Please contact me off list Thank you ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4

RE: free sql tool

I'll second that, were big fans of red gate too. Thanks Dave -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 10:54 AM To: CF-Talk Subject: RE: free sql tool Holy cow, that tool is awesome! Thanks for the heads up. -Original

RE: CF SMS List broadcasting application suggestions

Nick The prices look better than what I've seen so far - thanks Steve -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 7:55 AM To: CF-Talk Subject: Re: CF SMS List broadcasting application suggestions On 30/05/06, Josh

RE: CF SMS List broadcasting application suggestions

[mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 10:29 AM To: CF-Talk Subject: Re: CF SMS List broadcasting application suggestions Great - glad i can help. On 31/05/06, Steve Kahn [EMAIL PROTECTED] wrote: Nick The prices look better than what I've seen so far - thanks Steve

RE: CF SMS List broadcasting application suggestions

with that but this comes from the aggregaters not from txtconfirmation.com. Shot them an email: info [at] txtconfirmation.com On 31/05/06, Steve Kahn [EMAIL PROTECTED] wrote: I've looked at sms applications such as smsbroadcaster, visualgsm and others, but it sounds like they company your recommending

CF SMS List broadcasting application suggestions

Anyone have any suggestions for doing SMS List broadcasting or anything similar? Thanks Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4

RE: CF SMS List broadcasting application suggestions

: CF SMS List broadcasting application suggestions can you give any more details? On 30/05/06, Steve Kahn [EMAIL PROTECTED] wrote: Anyone have any suggestions for doing SMS List broadcasting or anything similar? Thanks Steve

RE: CF SMS List broadcasting application suggestions

I'm definitely looking to purchase an sms app - your feedback is very helpful, thanks -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 1:36 PM To: CF-Talk Subject: Re: CF SMS List broadcasting application suggestions I

RE: CF SMS List broadcasting application suggestions

Do you know if it can handle 10,000 - 250,000 thousand msg's per broadcast cheaply? -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 1:36 PM To: CF-Talk Subject: Re: CF SMS List broadcasting application suggestions I have

Re: trigger a remote form - RE: Passing a query string as a single url variable -

cfhttp/cfhttpparam doesnt work with SSL -- Original Message -- From: Jochem van Dieten [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sat, 27 May 2006 16:57:24 +0200 Steve Kahn wrote: This is SOT but, I need to trigger a form

trigger a remote form - RE: Passing a query string as a single url variable -

This is SOT but, I need to trigger a form on a different host by calling the response page using the full url i.e http://www.domain.com/subscribeResponse1.cfm?email=emailaddresslistid=1 Is there a way to do this behind the scenes without the user taking direct action or attach it in another

RE: how to trigger a form remotely

I need to pass an form.email to an action page from site one to site two. I want to grab the email from site-A's login and pass it site-B's response page that will check it for duplicates and enter into db. I am trying to trigger a form on a different host by calling the response page using the

RE: how to trigger a form remotely

I need to pass an form.email to an action page from site one to site two. I want to grab the email from site-A's login and pass it site-B's response page that will check it for duplicates and enter into db. I am trying to trigger a form on a different host by calling the response page using the

RE: how to trigger a form remotely

I setup a cfhttp /cfhttpparam but had SSL issues that prevented it from working The site-A form needs to post to itself - so how else can i send the two form variables to site-B. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, May 26, 2006 5:27 PM To: CF-Talk

Re: CF and Quickbooks

If your CF cart can handle auth.net as the payment gateway, you can get QB integration. Rates are reasonable, I have an 800 number if you want to get more info, just contact me offlist. -- Original Message -- From: Mary Jo Sminkey [EMAIL PROTECTED]

JRun JAR Launcher Errors on XP - any ideas whats doing it?

Im running XP Sp2 with CF7 and I keep getting a JRun JAR error thats leading to a crash, Does anyone have insight to what might be causing this? thank you all Steve ~| Message:

RE: shopping cart suggestions

Ray Were using CFwebstore - its fine, gotta like fusebox thou. About to purchase 'Sitedirector' from Quilldesign. Depending on what you need in features really dictates the price. HTH Steve -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, May 04, 2006

RE: I got Advanced !!!

Congrads and just in time for Cinco De Mayo celebration -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 03, 2006 2:12 PM To: CF-Talk Subject: I got Advanced !!! So I just took the test and I got Advanced developer status! I was pretty surprised

Low CC processing recommendations

Anyone have a low rate way of receiving credit card payments, Paypal's around 2.9%? Thanks -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.5.1/328 - Release Date: 5/1/2006

RE: Authorize.net costs question

: Re: Authorize.net costs question We, Katapult Media, are a reseller so the pricing (for people we sign up) is: $149 setup ($1 less) :-) $20 monthly $0.10 per-transaction On 4/27/06, Steve Kahn [EMAIL PROTECTED] wrote: My records might be outdated: I have Authorize.net costs as $150 setup $20

Is there a utility to convert MSSQL BAK to Access?

Is there a utility to convert an MS SQL BAK file to Access without setting it back up on the SQL Server? Thanks -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.5.0/325 - Release Date: 4/26/2006

RE: Is there a utility to convert MSSQL BAK to Access?

Thanks Dave! -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 4:40 PM To: CF-Talk Subject: RE: Is there a utility to convert MSSQL BAK to Access? Is there a utility to convert an MS SQL BAK file to Access without setting it back up on the

Authorize.net costs question

My records might be outdated: I have Authorize.net costs as $150 setup $20 monthly $0.20 per transaction But when I ask for their price they quote $300 setup $20 monthly $0.10 per trans Does anyone have any promotional links for them? Thanks -- No virus found in this outgoing message.

RE: Auction Software.

Emmet Visual Auction (beyond software) Able Commerce had one but I think it was discontinued. There is one more less expensive option available but I don’t have it on hand. Steve -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 2:06 PM

Need Cartweaver Discount Code

We need to offer Cartweaver with the ability to handle discount codes. Anyone have anything for use or sale? Thanks -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.1/310 - Release Date: 4/12/2006

2simplifi Shopping Cart Feedback

We are looking at the 2simplifi shopping cart, does anyone have any feedback on using this product? Thanks -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.0/306 - Release Date: 4/9/2006

Sitedirector vs EzCart recommendations Anyone

Need to deploy a site fast, thinking bout using Sitedirector or EZcart anyone have any first hand experience with them? We need a cart that’s fast to deploy and can offer retail pricing in addition to wholesale discounted pricing codes ( we don’t want to use any fusebox apps ) - any

RE: cfencode question

PROTECTED] wrote: Steve, Interesting question. I would shoot for trial error. Maybe take it out. Maybe replace it with other ASCII characters. My guess is that it has to stay in there, but it's worth a shot. -nathan strutz http://www.dopefly.com/ On 4/4/06, Steve Kahn [EMAIL PROTECTED] wrote

RE: cfencode question

it with other ASCII characters. My guess is that it has to stay in there, but it's worth a shot. -nathan strutz http://www.dopefly.com/ On 4/4/06, Steve Kahn [EMAIL PROTECTED] wrote: Im using cfencode, do I have to leave the 'Allaire Cold Fusion Template' statement at the top for it to work or can I

cfencode question

Im using cfencode, do I have to leave the 'Allaire Cold Fusion Template' statement at the top for it to work or can I delete it? Thanks ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236987 Archives:

Ways to test cfmail tag

Were not getting any mail thru our cfmail tag and want to test it. If I put the following code on a page and call the url will it work, or what would you recommend as a way to test the cfmail tag? Thanks 'cfmailtest.cfm' cfmail from=#form.email# to=[EMAIL PROTECTED]

Suggestions on scrambling code

For interoffice politics I would prefer to scramble (encrypt, encode) some cfml. This is more or less intended for non-technical management peruzing; so true encryption is of no issue. Any suggestions would be helpful and please dont slam the list on encrption validity as this is not about

Re: Suggestions on scrambling code

How do you call up the cfencrypt app to do your templates? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription:

RE: Copyright Attorney

Bud, If you haven’t gotten any references yet, consider this: A) Lawyer specialty = intellectual property combined with commercial contract negotiations. B) Lawyers have to pass a Bar exam administered by the state they practice in. Therefore, contacting your state bar association will usually

Setting db ownership to dbo

How do you set owner to dbo in enterprise manager for mssql? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233723 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription:

CF Host recommendations

We need cf server 5, crytaltech does not offer it. Has anyone dealt with hosttone.com or have a cf 5 server recommendation. Thanks everyone Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233647 Archives:

RE: CF Host recommendations

Were looking for shared -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 12:22 PM To: CF-Talk Subject: Re: CF Host recommendations Shared or full box? We need cf server 5, crytaltech does not offer it. Has anyone dealt with

Can moving from cf server 5 to mx7 cause an app to stop working?

I am moving my sites from coldfusion server 5 / mssql 7 to a new host running mx7 / ms sql 2000. The sites work fine on the original host, but are functionless at the new one. Has anyone else experienced this issue and what do you recommend as a solution. Does it pay to persue finding a host

RE: Can moving from cf server 5 to mx7 cause an app to stop working?

On 2/26/06, Steve Kahn [EMAIL PROTECTED] wrote: I am moving my sites from coldfusion server 5 / mssql 7 to a new host running mx7 / ms sql 2000. The sites work fine on the original host, but are functionless at the new one. Has anyone else experienced this issue and what do you recommend

RE: Can moving from cf server 5 to mx7 cause an app to stop working?

to the database and select one row from one of the tables? On 2/26/06, Steve Kahn [EMAIL PROTECTED] wrote: There is no fusebox code. I am moving my site from cfm-resources to crystaltech hosting. I restored the sql with a .bak file and ran a datacompare with red-gate sql tools. The database looks fine. I

RE: Can moving from cf server 5 to mx7 cause an app to stop working?

to stop working? Steve Kahn wrote: The database looks fine. I set up the site to have identical 'sql, username, and passwords' and yet I will get an error saying a column name doesn’t exist in the database when in fact I can see it in enterprise manager. ... That looks like an database

mssql '.bak' makes tables w/o content, please advise

I am migrating sites from one hosting company to another. I had my MS SQL '.bak' files restored but it only made the tables. All content is missing. Repeated the .bak restore and got same results. Two questions: What am I doing wrong in the .bak restore? and ... If the tables are fine, what

SQL Server 7 VS 2000 code change question

Below is code from my original db in MS SQL 7 followed by how it ported to MS SQL 2000. Should i match the code to the sql 7 or is those collate statements ok? = SQL Server 7 = --

RE: sending mass emails

I use units of 500 with 2 seconds between bursts - haven't had any problems. Send apx 50,000 per week. Hope that helps. Steve -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:56 PM To: CF-Talk Subject: sending mass emails gotta send out

Anyone with CFWebstore Experience ?

Anyone with CFWebstore experience please contact me off list. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message:

upsizing access to sql 2000

Anyone have a good 'how to' for upsizing access 2002 for use as an import data onto SQL server, we keep throwing errors. Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start

Ecom for accepting checks - suggestions

Anyone know of a tag that allows ecommerce for accepting checks, rather than credit cards? I know cc is best, but this is a client based request. Thanks everyone. ~| Logware (www.logware.us): a new and convenient web-based time

Stat app recommendation

Need to buy a stat app any recommendations? Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware

Re: Stat app recommendation

Standard page views, referer, visitors, etc. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message:

Who's using CF recommendations anyone

Anyone have a good recommendation of companies using cf for their sites. I know I saw a Dell site recently but cant remember the link. Also does anyone have a good article on the benefits of cf to other applications. Thanks Steve

anyone have statistex?

Does anyone have a working copy of statistex for site stats? Please contact me off list. Thanks ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

Good Site Stats Tag Recommendation

Anyone have a good site stats tag recommendation? Thanks Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client

Cheap, (not free) cms recommendations

Any one have a cheap (not free) cms recommendation? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware

Re: Cheap, (not free) cms recommendations

. Ray Steve Kahn wrote: Any one have a cheap (not free) cms recommendation? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project

RE: I DID IT!! Shameless Self-promotion

Well done Mike -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:17 PM To: CF-Talk Subject: I DID IT!! Shameless Self-promotion cf_owntrumpet action=blow I finally did it - I sat my Macromedia ColdFusion Developer exam today and not only

Re: CF Certified Print Logos?

Daniel, It sounds like a compression codec typically found on a Mac System. Try decompressing them on a Mac. HTH Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Creating a unique ID from a Query Insert for use in an Update

I have a login that I want to capture user stats with. However, I am having trouble identifing the QUERY INSERT with the UPDATE. In this case I am attempting to identify the userID and pass it to the Update. This is probably not the best method - any suggestions. [Todays Threads] [This Message]

Re: Creating a unique ID from a Query Insert for use in an Update

I have a login that I want to capture user stats with. However, I am having trouble identifing the QUERY INSERT with the UPDATE. In this case I am attempting to identify the userID and pass it to the Update. This is probably not the best method - any suggestions. CFQUERY NAME=getID SELECT

Re: Creating a unique ID from a Query Insert for use in an Update

Yes Microsoft SQL: Is this correct usage? cfquery set nocount on Insert into trackusers(username,pwd) values(#username#,#pwd#); Select scope_identity() as myID Set nocount on /cfquery Then: cfset key = qryName.myID / Would the Update be ... cfquery UPDATE trackusers SET

Re: Creating a unique ID from a Query Insert for use in an Update

Yes UserID is an AutoIncrement, however it threw an error. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'admin' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not

Re: Creating a unique ID from a Query Insert for use in an Update

Scope_identity threw an error. [Microsoft][ODBC SQL Server Driver][SQL Server]'scope_identity' is not a recognized function name. SQL = set nocount on Insert into trackusers (username,pwd) values('admin','admin'); Select scope_identity() as myID Set nocount on [Todays Threads] [This Message]

Re: Creating a unique ID from a Query Insert for use in an Update

Code didnt pass the ID, fields came up with NULL - what was missed? CFQUERY NAME=login SELECT* FROM users Whereusername = '#username#' and pwd = '#pwd#' /cfquery cfset passed=indexblog.cfm cfset failed=failed.cfm cfset login_datetime = createODBCDateTime(now()) cfoutput query=login cfif

Re: Creating a unique ID from a Query Insert for use in an Update

The primary key needed to be set. Thank you Andy, Dave and Paul I owe you all all round of drinks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Problem with CreateODBCDateTime(Now())

I'm trying to set the date when a user logs in, but it keeps showing up in the database as: cfoutput{ts '2004-09-20 13:21:00'}/cfoutput on my action page I have cfset datetime=cfoutput#CreateODBCDateTime(Now())#/cfoutput cfquery datasource=dsn UPDATE trackusers SET Logindate='#datetime#',

User tracking and breadcrumbs

Dear Friends, I need to track user breadcrumbs starting from their login and stored in db. Any tag suggestions? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

XP SP2 Conflict w/CFMX

Unfortunately I had installed XP Service Pack 2 and my Coldfusion server stopped working. So I un-installed the XP SP2, and the CFMX. Then reinstalled CFMX and I am still running into some function issues, any suggestions? TIA Steve [Todays Threads] [This Message] [Subscription] [Fast

Re: XP SP2 Conflict w/CFMX

It took three uninstalls and re-installs for cfmx 6 to finally take. Each time I did a previous install, the administrator came up as a blank page. Thank you for all the insight andsupport I owe you all a round of drinks. Steve From: Steve Kahn [mailto:[EMAIL PROTECTED] Unfortunately I had

cfmx stopped working after installing XP SP2 - any ideas?

I recently installed XP service pack 2, and now coldfusion doesnt seem to work anymore. Any ideas how to fix this? Thanks Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]