Try putting double quotes around it like:
set query_string="one=1&two=2&three=3"
HTH,
Howie
----- Original Message -----
From: "Lawrence B. Afrin, M.D." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 15, 2000 4:28 PM
Subject: How to include ampersand in NT command line SET statement?
> 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]
>
------------------------------------------------------------------------------------------------
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]
