This is a multi-part message in MIME format.
--------------E7774448A625D015C2801112
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Howdy --

For reasons not worth going into, I'm trying to run a CF template via a
SQL Server trigger doing an "exec master..xp_cmdshell batchfile.cmd"
where the batchfile invokes cfml.exe to run the template.

My problem is that I need to feed the template a query string with
multiple parameters.

I know that, theoretically, the way to do this is to set the
QUERY_STRING environment variable to the query string I want (e.g., "SET
QUERY_STRING=one=1&two=2&three=3") before running cfml.exe, but my
problem is that the NT cmd interpreter is picking up the ampersand as a
special character and terminating the SET at the first ampersand.

Is there some special "escape" syntax that'll let me include an
ampersand as part of the value for a SET statement?  There are no clues
in HELP SET.  I've tried backslashes, double and single quotes, and
other things, but I can't seem to find the magic combination, and I know
there must be a way to do this.

Anybody?

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]


--------------E7774448A625D015C2801112
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant Professor of Medicine
adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 
96 Jonathan Lucas Street;Charleston;SC;29425;USA
x-mozilla-cpt:;0
fn:Afrin, M.D., Lawrence
end:vcard

--------------E7774448A625D015C2801112--

------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to